We have recently encountered a problem on our Magento site because we believe that the search function of our site was overloaded by security or SPAM attacks that overcrowded useless data in our database mage_catalogsearch.
The following is the data for the following tables in phpMyAdmin:
phpMyAdmin (database teamss5_mage1)
mage_catalogsearch_query 1,782,506 InnoDB utf8_general_ci 215.5 MiB
mage_catalogsearch_result 700.538 InnoDB utf8_general_ci 47.6 MiB
You can see that these lines store a considerable amount of data. We try to keep the size of our database as small as possible to ensure optimal site performance.
When logging in to the Magento administrator, we also notice that when navigating to "Catalog> Search terms" there is 89.126 Pages and total 1,782,506 Records found. That seems to be an incredibly large amount of data.
Does anyone have any idea what this might have caused and how we can clean up these pages and records so we can streamline our Magento site? Is it possible to trim or delete these records without compromising our site and causing it to crash? And if so how?
Please tell us how to fix this. We thank you for any support!
You can also see the following screenshots with image links to better understand the problem: