[Short Mission] MySQL slow with innoDB

[Revlyukd]

Hello,

 

We have an issue with our website, we use multi-sites, multi-currencies options and when we create an order or view a page sometime is very slow. Apparently it is a MySQL issue, because i installed localy the website, with a light database some requests are about 0.05 sec, with the production database we are around 50 sec ! Specially with sub-requests. We use partially innoDB and the issue must be with indexes not optimised. We are under the PS version 1.6.0.8. Migrate everything to MySAM can be an option.

 

Thank you to contact me to do this job to repair the database with private messages.

[ExpertoPrestaShop]

Hello:

 

DB tables engine should not be the problem. If you have big table with many inserted/updated rows could result in a not balanced index tree, so this could be the problem. Anyway, a reindexation of all your tables could be done and a full use of engine in all tables should be uniform to analize if problem is related with this or not.

 

Regards 

[Revlyukd]

Thanks

The table is innoDB how can i reindex eveything?

[ExpertoPrestaShop]

You could defragment or optimize tables in your phpMyAdmin.

[Scully]

Optimize tables is a good start. If this doesn't help, further investigation would be required.

 

Btw: we run optimize table on all major tables every night by cron.