Post by carolina » Thu Dec 22, 2011 11:58 pm

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.

Newbie

Posts

Joined
Thu Nov 24, 2011 8:17 am

Post by carolina » Fri Dec 23, 2011 1:18 am

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.

Newbie

Posts

Joined
Thu Nov 24, 2011 8:17 am

Post by uksitebuilder » Fri Dec 23, 2011 4:49 pm

If your OC version is <1.5.1.3 you can add an index to the tag columns that will speed up their searching

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by Jez D » Thu May 17, 2012 5:15 am

.

Web Developer ( & Firefighter)
Web Development, Web Content Management, Mobile Web Design, Android Apps

www.webdesign-plus.co.uk


New member

Posts

Joined
Mon Nov 14, 2011 5:20 pm
Location - United Kingdom

Post by Kayram » Thu Apr 17, 2014 9:53 pm

uksitebuilder wrote:If your OC version is <1.5.1.3 you can add an index to the tag columns that will speed up their searching
how can I add an index the tag columns. sorry I don't have any php or mysql knowledge...

Newbie

Posts

Joined
Mon Jul 18, 2011 4:12 pm
Who is online

Users browsing this forum: No registered users and 6 guests