…, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to load IO subsystem very… users, load average: 0.00, 0.01, 0.05 System | Supermicro; PDSMi; v0123456789 (Other) Service Tag | 0123456789 Platform | Linux Release | Ubuntu 12.04…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1… average examines 20 rows, which means about 1 IO per 40 rows… which amounts to pretty IO bound load for me. But average is only average. It is a lot more interesting to…
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… quick and dirty tinkering. I threw up an Ubuntu 9.04 small server on Amazon. (I used …query a few times, discarded the first run, and averaged the next three together. Notes on Infobright A … MySQL. It’s a complete server with a different optimizer, etc. This point was hammered home during the LOAD…
