…. I also promised more low concurrency SSB tests when Peter blogged about the importance of performance at low concurrency. The SSB… can find the individual SSB query definitions in my previous blog post. Test environment These tests were done on a relatively… will make a follow-up post about concurrency in another blog post in this series. Regardless, when the working set fits…
Comment: MySQL Partitioning - can save you or kill you
June 3, 2013 By 45 Comments
Hi Great article and had fun reading all the responses. After implementing what was suggested I have also managed to reduce my query time greatly. I will bookmark this blog for future reference. Best regards Ian
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
Here at the MySQL Performance Blog, we’ve been discussing the several new features that MySQL …
Comment: ZFS on Linux and MySQL
May 28, 2013 By 17 Comments
… in progress), if I am right, I’ll write another blog post about it.
Post: Experiences with the McAfee MySQL Audit Plugin
May 23, 2013 By 4 Comments
… attempts has been discussed on a previous post in our blog. Starting with 5.1, the new plugin API gives us…
Comment: How to calculate a good InnoDB log file size
May 21, 2013 By 38 Comments
… recovery is far cheaper in modern versions of InnoDB: https://blogs.oracle.com/mysqlinnodb/entry/innodb_recovery_is_now_faster And…
Comment: 10 years of MySQL User Conferences
April 13, 2013 By 6 Comments
… was: he was the guy I contacted to have my blog aggregated into planet.mysql.com. He wrote how he likes my blogging and that he happens to have an unused free pass…. I had a couple conversations with Roland Bouman on my blog, but that’s it. Ah! Met with an Israeli acquaintance…
Post: Rotating MySQL slow logs safely
April 18, 2013 By 7 Comments
… Wednesday, this is a cross-post from Groupon’s engineering blog. Thanks again to Kyle Oppenheim at Groupon. And one more…
Post: Is your MySQL buffer pool warm? Make it sweat!
April 16, 2013 By 6 Comments
… buffer pool is a cross-post from Groupon’s engineering blog, and is Part 1 of 2. Thank you to Kyle…
Comment: MySQL caching methods and tips
March 27, 2013 By 5 Comments
… a server which is fast enough to run my simple blog but lately it behave strangely. Sometimes it load fine and… moments. I’m thinking to Cache the Database as my blog is Database-intensive. Using Cache for page only help a…
