… amazing MySQL manual, especially the option and …Key_blocks_not_flushedblogpercona.commanual Key_blocks_unusedblogpercona.commanual Key_blocks_usedblogpercona.commanual key_buffer_sizeblogpercona.commanual key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… ? mysql> show global status like “key%”; +————————+———+ | Variable_name | Value | +————————+———+ | Key_blocks_not_flushed | 49361 | | Key_blocks_unused | 61201 | | Key_blocks_used | 49361 | | Key_read_requests | 4007329 | | Key_reads | 49361 | | Key_write…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…Key_blocks_not_flushed’, ’0′ ‘Key_blocks_unused‘, ’28987′ ‘Key_blocks_used’, ’1332′ ‘Key_read_requests’, ’1552507′ ‘Key_reads’, ’1654′ ‘Key_write_requests’, ’114303′ ‘Key…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… over in both directions. Aside from MySQL Cluster, which is more special-purpose,… a bunch of other benefits (non-blocking ALTER TABLE, for example). The benefit…. In reality, it can be completely unusable for a long time. To measure…of mk-query-digest. A simple key lookup ran in tens of milliseconds…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood… interesting scenario: foreign keys mysql> CREATE TABLE parent (id INT NOT NULL, -> PRIMARY KEY (id) -> ) ENGINE=INNODB; — …, then ALL of the PK lookups would be blocked until the 900-row-SELECT statements complete …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…0 or 1 second they are pretty much unusable. To be honest I do not really …MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key…potentially needing them. Old stale uncommitted transactions may block purge process eating up resources. By looking at…
