… at table_cache sizing which showed larger table cache does not always provides the … file may be open or closed. Furthermore besides MySQL table_cache Innodb maintains its own (called data… buffer… InnoDB: Doing recovery: scanned up to log sequence number 12682768136 091118 18:47:44 InnoDB: …
Comment: Adaptive checkpointing
November 14, 2008 By 9 Comments
John, We can check the checkpoint age even if we use normal MySQL. From the output of SHOW INNODB STATUS, =========================== — LOG — Log sequence number 0 1059494372
Post: Can Innodb Read-Ahead reduce read performance ?
June 26, 2007 By 2 Comments
… IO requests to the disk. Lets look at SHOW INNODB STATUS: ——– FILE I/O ——– I/O thread …s, 532.42 non-hash searches/s — LOG — Log sequence number 586 10447960 Log flushed up to 586 …was doing (I was adviseor in this project from MySQL AB side) – to improve how Innodb read-ahead …
Comment: To UUID or not to UUID ?
March 14, 2007 By 28 Comments
… few key points. One. UUIDs are about as pointless as sequence generators for my goals. UUIDs don’t have to be… to build larger clustered databases. I just with MySQL had support for showing varbinary values on the console without screwing it up…
