…: “How to Turbocharge Your MySQL Performance Using Flash Storage” (From Virident side: Shridar Subramanian and Shirish Jamthe). Running MySQL on SSD in interesting… for the relevant MySQL workloads Price/performance advantages (ROI) when flash storage is used appropriately for MySQL workloads Approaches for scaling MySQL instances on…
Post: Webinar "How to Turbocharge Your MySQL Performance Using Flash Storage"
March 13, 2012 By 5 Comments
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these might need to… EXPLAIN phase yet making it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… new High Performance MySQL, 3rd Edition (worth $55 each), the recently released update to the popular second edition! This year’s MySQL Conference… retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your… prizes are a free copy of the new book “High Performance MySQL, 3rd Edition” which will be available for pickup at the…
Post: BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
March 22, 2012 By Leave a Comment
… to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event… miss out on this great opportunity to connect with the MySQL community at the largest community gathering in the world. To… Fires One of five copies of the new book High Performance MySQL, 3rd Edition Don’t miss this special offer – register now…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to… counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By default, I recommend…
Post: Free ticket to MySQL User Conference on SF Meetup with talk "Percona XtraDB Cluster"
March 16, 2012 By Leave a Comment
… giving a talk “Percona XtraDB Cluster” on coming San Francisco MySQL Meetup, next Wednesday, March-21, 2012. Along with talk I… + expo hall) to Percona Live MySQL User Conference 2012 and three copies our new book “High Performance MySQL, 3rd edition”. Well, I hope…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… for the best possible performance gain. This is not entirely visible in the manual either for MariaDB or MySQL, but you need to appropriately increase read_rnd_buffer_size/mrr_buffer_size because these have an impact on MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MySQL 5.6. Now let’s take a look at the status counters. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a… optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take…
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… of MySQL that suit different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL…
