On Friday I gave a presentation on “MySQL Query Patterns, Optimized” for Percona MySQL Webinars. If you missed it, you can still register… another column, and reinitializing the sequence after making certain insert/update/delete operations. If you have a dataset that changes infrequently…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
…schema presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets …=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool…=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe] log-error=/var/log…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT queries in the AUTOCOMMIT mode… cause much confusion. Even though the read-only transactions optimization in MySQL 5.6 virtually eliminates contention on the mutex protecting the… –oltp-read-only=off –oltp-index-updates=0 –oltp-non-index-updates=0 run POINT_SELECT + UPDATE QPS test sysbench –num-threads=<1…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing… MySQL 5.5.30-30.2 are available in our online documentation. Bugs can be reported on the launchpad bug tracker. UPDATE…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
… to accelerate that trend. The MySQL ecosystem is far from fragmenting, but 451 Research’s updated survey of database users indicates that… sessions including presentations on Oracle MySQL, Percona Server, and MariaDB during the Percona Live MySQL Conference. Percona Live MySQL Conference Keynotes Tuesday Peter… 10.0 & What’s New With the Project” Sergei Petrunia, Optimizer Developer, and Colin Charles, Chief Evangelist, MariaDB, for Monty Program…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… after the upgrade was completed regardless of its state before updating. This caused some problems for some users, especially if automatic… secondary keys from deferred key creation optimization. Bug fixed #1081016 (Alexey Kopytov). Percona Server for MySQL was built with YaSSL which could…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… written once long ago and not updated since. Now that we have four base versions of MySQL (5.0, 5.1, 5…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2… updates, but it’s also more: it’s a free service from Percona that advises when certain programs (Percona Toolkit tools, MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…amazing MySQL manual, especially the option and …tablesblogpercona.commanual optimizer_prune_levelblogpercona.commanual optimizer_search_depthblogpercona.commanual optimizer_switchblogpercona…..commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…implement delayed table update as explained below. At this point we’ve optimized update complexity significantly however sheer volume of updates may be very…efficiently pushing few updates back to MySQL server. If you rather use existing solutions you can use memcache + another mysql instance (or …
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
An InnoDB table statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a… slow query log until InnoDB again updates the statistics. But when does InnoDB perform the updates aside from the first opening of… to update all the tables’ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats_auto_update (from MySQL…
