Enable DELAY_KEY_WRITE?

[PatrickVeenstra]

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]

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:

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.