MySQL DELAY_KEY_WRITE Option Updated on November 10, 2023 By Pete Freitag Another performance option in MySQL is the DELAY_KEY_WRITE option. According to the MySQL documentation the option makes index updates faster because they are not flushed to disk until the table is closed. Note that this option applies only to MyISAM tables, You can enable it on a table by table basis using the following SQL