…to analyze over 300.000 of rows which is relatively fast…to trick around equity propagation to make it work) mysql> explain select… to get better performance by joining data to yet…to learn about MySQL Optimizer gotchas 
At the same time I figured out how to make MySQL Optimizer to do what we want to…
Post: How adding another table to JOIN can improve performance ?
August 1, 2008 By 12 Comments
Post: How to debug long-running transactions in MySQL
March 8, 2011 By 6 Comments
…fast queries that you can’t capture them in the processlist. The steps I use to…mysql -ss -e ‘SELECT…to make sure you haven’t caught a false-positive). I also like to…data, unless you make them commit between iterations. And watch your server to…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…makes it hard to understand how exactly MySQL Query Cache is working in many cases. This however can be improved and data…to Query Cache to make it cool again. The question is whenever anyone from “MySQL…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 28 Comments
…to load this data on many servers without putting it into the binary log. While this is generally a fast way to load data…SELECT queries might have to scan through lots of obsolete, but not-yet-purged, row versions. Later, the purge thread will have to clean these up. This is how you make…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
…data out of memcached to make room for new records I am reading from the database. Remember memcached needs repeatability to…MySQL to using MySQL + Memcached, and then to…to memcached to be successful. This application selects…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…to know how many physical spindles are under the box, and how fast…how to read these, there’s a full explanation in our book, High Performance MySQL…SELECT…how to interpret what we’re showing, and why the proposed modifications are better. If the client approves it, we may make…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…mysql> INSERT INTO t(c) SELECT…makes any difference: mysql> SET expand_fast_index_creation=OFF; Query OK, 0 rows affected (0.00 sec) mysql…to the number of indexes, with fast index creation the time required to copy the data to…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 12 Comments
…much more convenient than trying to read from the dictionary directly to determine the contents of the view. mysql> select flexviews.get_sql( -> … data. I hope this helps you understand how Flexviews can help you ensure fast response times in your application by making access to summary data…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…data size forces it to. This goes back to what data you really need to make…to think about how to avoid enormous tables that are hard to … INSERT..SELECT queries, it will propagate to the …MySQL doesn’t tend to perform well on a data warehousing workload. The nested-loop joins are not all that fast…
Post: How fast can MySQL Process Data
April 9, 2008 By 3 Comments
…data processing limitations of current systems. This raises valid question how fast can MySQL process (filter) data using it current architecture ? I decided to…to make timing easier: mysql> DELIMITER // mysql…
