… EC2 instance type that I used. EC2 Configuration I chose m2.4xlarge instance as that’s the instance type with highest… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I…
Post: MySQL 5.5-m2 scalability
February 28, 2010 By 17 Comments
Oracle recently announcent MySQL-5.5.2-m2 milestone, and I have a predition that MySQL-5.5 will be announced as GA on MySQL UC 2010 in…
Comment: MySQL 5.5-m2 scalability
March 3, 2010 By 17 Comments
…/2010/02/28/mysql-5-5-m2-scalability/ sysbench –test=oltp –oltp-table-size=10000000 –mysql-user=sbtest –mysql-password=yourpasswd \ –mysql-socket=/var/lib/mysql/mysql.sock –init… –test=oltp –oltp-table-size=10000000 –mysql-user=sbtest –mysql-password=yourpasswd \ –mysql-socket=/var/lib/mysql/mysql.sock –init-rng=1 –num-threads=$i…
Post: MySQL and PostgreSQL SpecJAppServer benchmark results
July 25, 2007 By 13 Comments
… use Sun Fire X4200 M2 available in September 2006, using AMD Opteron 2220 SE. We can see some 5% difference in CPU… big issue is using MySQL 5.0.27 which has Innodb scalability issues, which were a lot improved in 5.0.37 which… slower at connection creation and MySQL is very fast, while SubSelect optimization is very bad in MySQL for many cases until MySQL 5.2
