….g. pt-query-digest, pt-upgrade, and pt-online-schema-change). Here are some highlights: Official support for MySQL 5.6 and… simpler pt-query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs…). This feature is still in development while we determine the optimal JSON structure. Version check is on by default In 2…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL… join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
… the webinar: “Learn How MySQL 5.6 Makes Query Optimization Easier” for more tips on the 5.6 optimizer[/caption] While preparing the webinar… optimization strategies. Even row-level operation counters are sometimes not enough. Do you want to know more about the MySQL 5.6 query optimization…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… sparkline to see whether the query is likely to be possible to optimize. It finds queries or groups of queries that add too much load to the system by grouping queries into classes… the timestamp when the query executed, not merely the duration the query executed for, which has been available in MySQL for years. This…
Post: MySQL: Followup on UNION for query optimization, Query profiling
August 14, 2006 By 14 Comments
… you do not have to use the union. So changing query to: mysql> SELECT sql_no_cache name FROM people WHERE age… there are really different types of ranges in MySQL. IN range allows to optimize lookups on the second key part, while BETWEEN… queries to see what exactly happens during query execution – very helpful for MySQL Performance optimization: mysql> flush status; Query OK, 0 rows affected (0.00 sec) mysql…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… hitting MySQL Support Team at Oracle. For a number of simple workloads I would expect to see some slowdown – MySQL 5.6 Optimizer got a lot smarter and the more plans have to be considered for the query the more time the query optimization… advantage of any of new MySQL 5.6 optimizations so it is geared towards worse case scenario for MySQL 5.6 performance. Here…
Post: Percona Live MySQL Conference and Expo 2013 – News from the Committee – Tutorial Selection Complete
December 3, 2012 By 1 Comment
… afternoon follow up to Rick’s talk might be: Advanced query optimizer tuning and analysis This 3 hour session is being given… from the Monty Program and focuses in on how the query optimizer does what it does, why it does it, and how… when this was not the case at a MySQL conference. There are several MySQL HA related tutorials: Using Tungsten Replicator to solve…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… – 64K or even more would be good default. query_cache_size = 1M Query cache remains off by default but default size is… have in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard 
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… can simply run: mysql> pager Default pager wasn’t set, using stdout. Using edit When you try to optimize a query, it often involves manipulating the text of the query, and sometimes it would be…, pretty much like the Unix tee command: mysql> tee queries.log Logging to file ‘queries.log’ mysql> use sakila Reading table information for completion…
Post: An update on Percona Live MySQL Conference & Expo 2012
November 30, 2011 By 2 Comments
… to do super-advanced and extreme things with MySQL, how to use MySQL for a Ruby on Rails application with MongoDB and… a cadre of the core MySQL developers to submit talks about what is new in MySQL, the MySQL roadmap for the future, and bread-and-butter talks about topics such as how replication works, new features in the query optimizer…
