Sitolog
Registered on :
12/04/2011
Posts :
524
|
Posted :
06/19/2013 13:58:52
"Quote"
A user got this issue this morning with the latest version to date of Clone Combinations (V1.5.v).
He pressed "Clone", waited about 50 sec and got an error.
Checking what this error is about (if you are familiar with Firebug, you can do this by pressing F12 prior the cloning operation and looking at the result in the "Network" section), I realized the error what a time out from the server, during the execution of a DELETE SQL request.
This could happend when the size of the ps_product_attribute_combination table is huge (in this case, this table had 11 millions of lines), and when the database format is innodb.
Then the server may take too long to execute and reach the limit of a memory buffer called innodb_buffer_pool_size.
The solution is to edit the mysql configuration file to add a line to set the parameter innodb_buffer_pool_size to something like 50% of the total memory available on the server.
In some other cases, you may also need to increase the value of innodb_lock_wait_timeout (set to 50 sec per default).
Rgds
Franck
|
