Hi, I need some help here:
I just added 450 products to my store (my database went from 1.7M to 6.2M), and now whenever I perform any search I get the MySQL error: "Error: Query execution was interrupted Error No: 1317" returned to me after a few seconds.
I thought at first that maybe my hosting company had limited the memory or max-execution-time in php.ini, but opencart has its own php.ini and I have set the relevant values to be very large:
memory_limit = 238M;
max_execution_time = 100000;
mysql.connect_timeout = 140;
--Though it could be that the hosting is set to ignore user-provided values for safety.
I have done some reading and some people have said, "This can happen when your database tables are corrupted" --I don't know what that means though. Using phpmyadmin I can see all the tables. And when I select to "repair" them (the ones being searches or joined-upon) everything says it's "ok".
Here's a sample link: http://cluster014.ovh.net/~speakengs/in ... me=pegasus
Does anybody know what's going on here? I'd greatly appreciate any help.
I have "fixed" the problem for now by removing the tag-searching out of the search queries (in catalog/model/catalog/product.php). This took the queries from an average running time of 7.5s down to 0.0058s!
However... I've lost the ability to search the tags now.
However... I've lost the ability to search the tags now.
If your OC version is <1.5.1.3 you can add an index to the tag columns that will speed up their searching
.
Web Developer ( & Firefighter)
Web Development, Web Content Management, Mobile Web Design, Android Apps
www.webdesign-plus.co.uk
Who is online
Users browsing this forum: Mike Guenther and 137 guests