…two three purposes: It limits the amount of delay any node in the cluster might have …the transactions, which translates into number of unique key lookups into the certification index, which is …be the slaves with no writes coming from them. However, with multi-node writing, larger queues will make…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…than the non-partition equivalent. Even single-row writes are likely to be slower in PARTITIONed tables…a single row based on a UNIQUE/PRIMARY key and it can prune, the delete involves (1)… indexes are also BTrees, so they need updating (although delayed). Yes, their BTrees may be one level shallower…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…delay_key_writeblogpercona.commanual Delayed_errorsblogpercona.commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona.commanual delayed_queue_sizeblogpercona.commanual Delayed_writesblogpercona.commanual des_key…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…. delay_key_write Delay updating indexes for MyISAM tables. Good for performance but tables will be badly corrupted on crash. delayed_insert_limit, delayed_insert_timeout, delayed_queue_size Delayed inserts configuration. Technically it is not storage…
Comment: How to decrease InnoDB shutdown times
April 16, 2009 By 20 Comments
… support team. delay_key_write=ON http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld_delay-key-write This global configuration variable can be used (delay_key_writes=ALL) to stop writes from the MySQL key buffer to disk…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… is often not accounted for and people think – “OK. I write my script so it does short updates so it will… wipe OS cache which you hoped for causing unexpected slowdowns. delay_key_writes Whatever way you enable this option – globally, for table or… been running for years survining many crashes. If you enable delay_key_writes it drastically changes. Now in case of crash your index…
Post: MySQL MyISAM Active Active Clustering - looking for trouble ?
March 15, 2007 By 4 Comments
… certain rules like enabling external locking, disabling query cache and delayed key writes etc. This is as far as many articles on this… overhead you get from external locking. Plus key cache have to be invalidated with remote writes which makes even less efficient. So…
Comment: Hacking to make ALTER TABLE online for certain changes
October 30, 2007 By 26 Comments
… need a rebuild didn’t do one. For example, setting DELAY_KEY_WRITE should not require a table rebuild. Likewise, a change of…
Comment: Why MySQL could be slow with large tables ?
April 6, 2007 By 141 Comments
…_chains_999 ORDER BY endingpoint ASC” I found that setting delay_key_write to 1 on the table stops this from happening. Now…
Comment: Using MyISAM in production
June 19, 2006 By 36 Comments
Kevin, Yes Idea of using delay_key_write on slave servers is good one. You want to do …
