…MySQL …use_native_aioblogpercona.commanual innodb_use…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
…set key buffer to 128M ? 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…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…and a bunch of other benefits (non-blocking ALTER TABLE, for example). The benefit is… etc. In reality, it can be completely unusable for a long time. To measure …part of mk-query-digest. A simple key lookup ran in tens of milliseconds … have to be the tools I used — it could be MySQL Proxy or a TCP …
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_writes’, ’1346′ ‘Max_used…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… they are pretty much unusable. To be honest I …MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2) Foreign key…inside InnoDB 166 mysql tables in use 1, locked 0 MySQL thread id… Old stale uncommitted transactions may block purge process eating up resources…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…oft-unused parameter innodb_concurrency_tickets that seems widely misunderstood…: foreign keys mysql> CREATE TABLE parent (id INT NOT NULL, -> PRIMARY KEY (id) -> ) ENGINE=INNODB; — 0 Tickets Used Query…, then ALL of the PK lookups would be blocked until the 900-row-SELECT statements complete …
