View Single Post
  #21  
Old 10-29-2018, 12:32 AM
 
aim aim is offline
Advanced Staff Users
 

X-Cart team
  
Join Date: Dec 2008
Posts: 928
 

Default Re: X-Cart 4.7.10 released

Quote:
Originally Posted by Sembroidery
On a store updated from older versions some (a few) tables show InnoDB while others are MyISAM. Would it be recommended to switch all tables to InnoDB?

Hello,

It is definitely recommended in 3 cases.

1) You are using the newest MySQL/MariaDB version.

or
2) You are experiencing the loss of productivity due to the Meltdown Fix.
https://forums.mysql.com/read.php?21,664350,664350#msg-664350

or
3) You are experiencing the MySQL error 'MySQL table is marked as crashed and should be repaired'
https://confluence.atlassian.com/confkb/mysql-table-is-marked-as-crashed-and-should-be-repaired-151519802.html

In other cases, it is recommended to measure the BEFORE/AFTER performance on a dev server.

Thank you.
__________________
Sincerely yours,
Ildar Amankulov
Head of Maintenance group
Reply With Quote