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…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…. 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: 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: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
Manish, Blog post comment is not the best place for asking questions specific to your case. I’d encourage you to ask the question on our forums instead http://www.percona.com/forums/questions-discussions/percona-xtradb-cluster
Comment: Is Synchronous Replication right for your app?
May 16, 2013 By 18 Comments
@Serge – I’m starting to put together some ways to analyze query workloads with pt-query-digest that can start to answer some of these questions. Stay tuned for a future blog post on the subject.
Comment: MySQL and Percona Server in LinkBench benchmark
May 15, 2013 By 18 Comments
I used maxid1=1B for my tests. That might be 100X given the terminology used in this blog post. Databases were several hundred GB on disk.
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… actually much worse than Galera. As I illustrated in a blog post last year, semi-sync must serialize all transactions and…
