Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

19 Million Rows in catalogsearch_results table
 
TapwellBathroom
Jr. Member
 
Total Posts:  15
Joined:  2013-03-08
 

As the title says, my catalogsearch_results table currently sits with 19 million rows in it, and taking up over 2GB of space.  Something must be seriously wrong here!

I’m unable to find much info on this table but can someone tell me is it safe to empty it.  And if so, is there anything I should look at to try and diagnose this problem?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
TapwellBathroom
Jr. Member
 
Total Posts:  15
Joined:  2013-03-08
 

First/last bump.  Going to wait 10 mins for a reply before I empty the table.

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
TapwellBathroom
Jr. Member
 
Total Posts:  15
Joined:  2013-03-08
 

I went ahead and cleared the catalogsearch_results table, no adverse affects noted, as yet.

 
Magento Community Magento Community
Magento Community
Magento Community
 
TapwellBathroom
Jr. Member
 
Total Posts:  15
Joined:  2013-03-08
 

The table is getting filled up pretty quick with already 100,000 rows within an hour of emptying it.  Any ideas of where I can find out what is causing this?

Thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
jduffin611
Jr. Member
 
Total Posts:  2
Joined:  2011-03-22
 

Hi There

I have the same problem myself

Did you solve it any bad effects on the website?

 
Magento Community Magento Community
Magento Community
Magento Community
 
serpyre
Enthusiast
 
Avatar
Total Posts:  771
Joined:  2013-05-20
 

Sounds like some bots or Google however it is normally implementation specific so difficult to tell exactly without investigation.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top