… XFS, on a RAID10 of spinning drives. Many DBAs like to assert that XFS is the way to go for MySQL, but… ext4: http://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4… array, or using nobarrier, all have no statistically significant impact on performance, which seems to indicate that XFS had some bottleneck…
Comment: Joining many tables in MySQL - optimizer_search_depth
April 23, 2012 By 5 Comments
… ago, when I was just hired at MySQL. The assumptions about what are typical MySQL may have been true then in 2004… in turn means “choose depth 7″. Is this what your blog boils down to? At the time when I implemented the… pruning in MySQL 5.6. Ideally, the server should analyze the query and should determine the search depth based on some syntactic…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… “MB” string) This works on my site on a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make… the MySQLDB performance cracks like Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always…_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… the third blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. This blog post… following changes were made on MySQL 5.6 config: optimizer_switch=’index_condition_pushdown=off’ optimizer_switch=’mrr=on‘ optimizer_switch=’mrr_cost…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the second blog post in the series of blog posts leading up to the talk comparing the optimizer enhancements in MySQL 5.6…_sort_keys=on‘ (only on MariaDB 5.5) optimizer_switch=’mrr_cost_based=off’ read_rnd_buffer_size=4M (only on MySQL 5.6) mrr_buffer_size=4M (only on MariaDB 5.5) We have turned off…
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… full conference passes (worth $995 each) to the Percona Live MySQL Conference and Expo, and you can win one simply by… retweet us when we mention this contest Tweet “My favorite #MySQL conference session” with a link to your favorite “Like” your… winner’s announcement blog post You acknowledge that this contest is for a conference in Santa Clara, California on April 10th-12th…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… meeting last week, so we are a little slow to blog about this and acknowledge the great work that has gone…. 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…
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… way this blog post is aimed at a new optimizer enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6… such as range scans, where index parts after the part on which range condition is applied cannot be used for filtering…
Post: A Book-Signing Opportunity for Technical Authors
March 13, 2012 By Leave a Comment
Have you authored a technical book that’s relevant to MySQL users? Want to get great visibility for yourself and your…? We’re planning a book-signing session for the upcoming MySQL conference, and you can participate in it. In brief, we… able to promote yourself, i.e. post an update on your blog and tell people to bring their book to the table…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… the first Drizzle 7.1 stable release. The announcement on the Drizzle blog covers some of the major improvements in this release…_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to…
