… think with this performance SATA is getting closer to level of PCIe cards. Of course PCIe still provides better numbers, but the question is how much MySQL can use. In his keynote Mark Callaghan… the performance variance we see it is a good question how does it affect MySQL performance, and I am going to run some MySQL…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
…that XFS is the way to go for MySQL, but I’m not sure how frequently they… the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation),… is that, to my great surprise, changing the number of allocation groups, setting the correct sunit/swidth…
Comment: Make your file system error resilient
April 26, 2012 By 8 Comments
…Number of blocks reserved for root. [...] MySQL server is only one doing writes on this partition anyway … block count: 0″ is nearly full, this generates file fragmentation, performance issues, unless you manually apply e2defrag regularily. Not a good…
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… number of tables. I was wondering if 0 is automatic selection why do we have value of 62 being default in MySQL…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…. 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… with MRR are performing badly. The interesting thing is that though both MariaDB and MySQL 5.6 are reporting high numbers for Innodb…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… been changed to become sequential. The two other most important numbers are values for Innodb_buffer_pool_reads and Innodb_data… 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…
Post: Announcing Percona XtraBackup 2.0.0 GA
April 4, 2012 By 11 Comments
… the version number has changed. New since 1.6: Percona XtraBackup can now save Galera replication information while performing a backup when… supports streaming incremental backups. In previous versions streaming backups were performed by the innobackupex script but incremental backups were done by… be part of the topics at the upcoming Percona Live MySQL Conference and Expo (register now!). Specifically, there are the following…
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: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
….1 as we are using the 1.9.x version numbers for betas of 2.0 to clearly differentiate beta releases… will enable a server restored from backup to give excellent performance without a lengthy “warm up” time. If provisioning a slave…. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed…
Comment: Should you move from MyISAM to Innodb ?
March 10, 2012 By 53 Comments
Many in the MySQL community are snobbish about using MyISAM (not using it that … MyISAM. If you have a huge number of concurrent writes and selects and query performance must be consistently fast in this use…
