… about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — LOG — Log sequence number 9682004056 Log… still useful if you can use Linux native AIO. These can also be rendered useless by filesystems that don’t allow parallel…. In any case, if you run any kind of production MySQL server, you should be monitoring your Checkpoint age and your…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
Post: Percona is hiring a consultant
December 16, 2009 By 7 Comments
…. We are looking for the following qualifications: Expert knowledge of MySQL. Not just “certified” — years of production experience with it. You… solve that. Expert knowledge of Linux systems administration. You need to know how to solve issues with filesystems, hardware, and networking. You…
Post: EC2/EBS single and RAID volumes IO benchmark
August 6, 2009 By 14 Comments
…-devices=2 /dev/md0 /dev/md1 And also in Linux you can create tricky RAID10,f2 (you can …I tested IO on single volume. I used xfs filesystem mounted with noatime,nobarrier options and for benchmark I…benefit from multi-threading IO in MySQL you need to use XtraDB or MySQL 5.4 ® However there may be…
