… to assert that XFS is the way to go for MySQL, but I’m not sure how frequently they benchmark XFS… ext4: http://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html So we built all our MySQL DBs with ext4…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… a Debian Squeeze system where I have to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size…_buffer_pool_size). According to my previous posts in this blog a dynamic innodb log file RECREATE did NOT seem to…
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… contact the winners privately to confirm, and then post another blog entry here to announce the results. Make sure we (or…
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 and MariaDB 5.5. This blog post is aimed at the optimizer enhancement Multi Range Read (MRR). Its available in both MySQL 5.6 and…
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 is targeted at the join related optimizations introduced in the optimizer. These optimizations are available in both 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…
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… as a first-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places… more choice than ever — there are three great versions of MySQL that suit different needs and personalities, with different characteristics, and…
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… 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
… Drizzle 7.1 stable release. The announcement on the Drizzle blog covers some of the major improvements in this release over…_DICTIONARY tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ, regex policy, logging to syslog, authentication via LDAP. This …
Comment: MariaDB 5.3 is released as GA!
March 6, 2012 By 17 Comments
… microsecond timestamp support in version 5.6, yes. MySQL is unlikely to be a usable solution for GIS anytime … to consider for some applications, though. I should write a blog post on the differences between MariaDB and Percona Server. They… adding it in. I’ll update the text of the blog post.
