… 8 x 200G EBS volumes in software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5… that I am using “estimate” flushing method available only on Percona Server. The “estimate” method reduces the impact of traditional InnoDB log… THAN MAXVALUE ENGINE = InnoDB) */ Also, I ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
… Percona 5.5 server) I have a complex query w. joins on a table with 10+ million rows. Results are Data & Count Query = 1.8…
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… 5.5 server dirty page flushing respects the innodb_io_capacity setting, Percona server flushing doesn’t. Set innodb_io_capacity too low and MySQL server…% or 85% of the InnoDB log file space used, while Percona server won’t. You’ll also normally benefit from setting innodb… doing lots of multithreading, setting innodb_buffer_pool_instances to 8 as a starting point and adjusting from there. Views are…
Post: MySQL 5.5.8 and Percona Server on Fast Flash card (Virident tachIOn)
December 21, 2010 By 11 Comments
… results: 13GB: MySQL 5.5.8 – 23,513 NOTPM, Percona Server – 30,436 NOTPM, advantage: 1.29x 52GB: MySQL 5.5.8 – 71,774 NOTPM, Percona Server – 88,792 NOTPM, advantage: 1.23x 144GB: MySQL 5.5.8 – 78,091 NOTPM, Percona Server – 109,631 NOTPM…
Post: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
Percona Server release 5.5.10-20.1 is now available for download. This is a release candidate for the Percona Server 5.5 series. In addition to MySQL 5.5.10 now being the base version, here are the changes that have been made since Percona Server beta release 5.5.8-20…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
… blog post, Analyzing Percona‘s TPCC-like Workload on MySQL 5.5, which was a response to my post, MySQL 5.5.8 and Percona Server: being adaptive… other tests I used Percona Server based on 5.5.8. Addressing a complaint to my previous post, I am sharing the percona-server-5.5.8.tar.gz I…
Post: Find where your data is replicated, win a Percona Live ticket
October 21, 2011 By Leave a Comment
… the series of free-Percona-Live tickets we’ll give away. But first — have you ever wondered what servers are in your…, ages ago before I even worked at Percona). It automatically detects and connects to every server in the replication hierarchy, and prints… 1.0.6-unknown +- 10.153.116.5 Version 5.1.57-rel12.8-log Server ID 1165 Uptime 20+09:44:46 (started…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… is a plethora of useful information reported by Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not… timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server with log_slow_verbosity=full: # Time: 111229 3:11:26… 1.00 0.00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film…
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… here! Percona Server Percona Server 5.5.8-20.0 is now available for download. This is a beta release of Percona‘s enhancements to the MySQL 5.5.8 server. Here are some highlights: Performance and scalability improvements throughout the server and storage…
Post: Scaling problems still exist in MySQL 5.5 and Percona Server 5.5
May 20, 2011 By 11 Comments
… memory in this test. I have compared Percona Server 5.1.56-12.7 and Percona Server 5.5.11-20.2 with former being configured with… we see the number is 2.3 for Percona Server 5.1 and around 6 for Percona Server 5.5 which is way too little for what… where you still can’t get use of more than 8 cores effectively (which would correspond to single CPU socket these…
