PatrickVeenstra

Well-Known Member
Feb 12, 2012
169
3
68
Barcelona
cPanel Access Level
Root Administrator
I just saw the option DELAY_KEY_WRITE in phpMyAdmin so I thought, let's see what that's about. After reading a bit it looks like a great feature, but then I saw this: MySQL :: MySQL 5.5 Reference Manual :: 5.1.7 Server System Variables

If DELAY_KEY_WRITE is enabled for a table, the key buffer is not flushed for the table on every index update, but only when the table is closed. This speeds up writes on keys a lot, but if you use this feature, you should add automatic checking of all MyISAM tables by starting the server with the --myisam-recover-options option (for example, --myisam-recover-options=BACKUP,FORCE).
How can I enable that in CPanel?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello @PatrickVeenstra,

MySQL documents how to enable that option at the link below (for MySQL 5.6):

MySQL :: MySQL 5.6 Reference Manual :: 5.1.6 Server Command Options

Thus, you'd add an entry like the following to the /etc/my.cnf file and then restart MySQL to enable the change:

Code:
myisam-recover-options = BACKUP,FORCE
Keep in mind this type of change is unsupported, so it's a good idea to consult with a system administrator or MySQL expert before implementing such a change.

Thank you.