… can use this data to estimate capacity of MySQL system ? We can look at CPU and IO consumption per Query and compare…. How to get CPU consumption per query ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc… #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (This is pretty idle…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO …| Linux Release | Ubuntu 12.04.1 LTS (precise) Kernel | 3.2.0-35-generic Architecture | CPU = 64-bit… of innodb_data_reads (values over 100 second intervals) | Innodb_data_reads | 54561 | | Innodb_…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… Linux Release | Ubuntu 10.04.2 LTS (lucid) Kernel | 2.6.32-31-server Architecture | CPU = 64-… ports Cache | 128MB Memory, BBU Present BBU | 100% Charged, Temperature 34C, isSOHGood= VirtualDev Size… alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings…
Post: Impact of the number of idle connections in MySQL
December 17, 2010 By 21 Comments
… = 32768 The desktop is running Ubuntu 10.04, has 8GB of RAM and a Core i5 CPU (dual core with HT enabled… 15` do numconn=$((i*100)) echo “Doing $numconn idle connections” php ./make_conn.php $numconn & cat dbt2.sql | mysql -h 10.2…%. I also hacked a bit the “run_mysql.sh” script to allow more processing threads (100) instead of the max of 20…
