…) 1690 GB of instance storage 64-bit platform I/O Performance: High API name: m2.4xlarge As for the IO configuration I… 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… MiB/sec. I am still interesting in asynchronous IO, as MySQL 5.5 uses async IO for writes. Maybe 8 threads in the… much MySQL can use. In his keynote Mark Callaghan mentioned that Fusion-io cards they use are highly underutilized. With the performance variance we see it is a good question how does it affect MySQL performance, and I…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… performed, on the hash table we created earlier. This step is known as probe step. This join algorithm works best for highly… for MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5… counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer_size=6M MariaDB 5.5 MariaDB 5.5 w/ join_buffer…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5… see from the status counters above that both MySQL 5.6 and MariaDB 5.5 are reporting high numbers for Innodb_buffer_pool_read_ahead…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places, so… 5.3 isn’t the only exciting thing, however. MariaDB 5.3 is based on MySQL 5.1, but MariaDB 5.5 will be based on MySQL 5.5, so it will inherit a lot of the great improvements Oracle has made to the MySQL 5.5…
Comment: Percona Toolkit 2.1 with New Online Schema Change Tool
April 22, 2012 By 9 Comments
… MySQL (that is what Percona does, isn’t it?)? 2. Secondly, I read here that you are the lead author of High Performance MySQL. Is that the same title as the O’Reilly “High Performance MySQL” by Jeremy Zawodny & Derek Balling… ideas on what is happening here? It seems as if MySQL 5.5 has been getting much slower (in terms of qps) with…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… high-performance systems to do this work. Let’s see some ways you can build the functionality you need and get the performance… lifecycle of your application in advance. What about partitioning in MySQL 5.1? I know there are some cases when it… can save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing the work…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
…result and performance regressions when performance (in a broad sense) is negatively affected. In general even minor MySQL … MySQL 5.0.30 to 5.0.32 is generally likely to expose less issues than 5.0.30 to 5… of scalability bugs in MySQL history when issues would only happen at high load. You can …
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… with many nice features: Works with MySQL 5.1 and MariaDB 5.1. The latest is more …Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve following problems: A Real High … than an average MySQL master-slave setup. Potential performance penalty: Although to have performance numbers I am …
Post: MySQL Life Cycle. Your Feedback is needed.
November 18, 2011 By 6 Comments
… running on MySQL or Percona Server 5.1 than 5.5 Facebook also sticks with MySQL 5.1 even though their highly patched and improved version. MySQL 5.0… when you see old MySQL versions are used is typically when application is not overly demanding so performance improvements in recent releases…
