…CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name : Intel(R) Xeon(R) CPU 5130 @ 2.00GHz stepping : 6 cpu…MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 7 Comments
…) CPU 5150 @ 2.66GHz, 32GB RAM. There are 8 disks in RAID10(a mirror of 4+4 striped disks). Software It was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There were two cases considered CPU… was run with 1, 20 and 100 database connections Results To reduce random error the test was run 3 times per each…
Post: table_cache negative scalability
November 16, 2009 By 23 Comments
… logic. MySQL Sandbox helped me to test this with different servers easily. I did test on CentOS 5.3… 50 times slower. Wow. This is the slow down. We can see the load becomes very CPU bound …MySQL 5.0.85. So the problem is not fixed in MySQL 5.1, lets see how MySQL 5.4 behaves. MySQL 5.4.2 MySQL 5.4…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
… Linux to profile not CPU-bound load (for CPU-bound there is OProfile…CentOS 5.3 (it crashed and hung every so often). Latest updated RedHat 5.4…: stap -v lsprob.stp Pass 1: parsed user script and 52 library… you can intersect internal MySQL function and script (measure time, count of call, statistics)…
