…to improve the response time of their top slow query according to pt-query-digest’s report. This query…to know more about how MySQL executes this query…queries. The best solution was simply to turn off the query cache. Conclusions: Once again, the query…
Post: Impact of logging on MySQL’s performance
February 10, 2009 By 8 Comments
…question arises how much logging impacts on performance. When we do performance audit often we log every query to find not only slow queries. A query …case had three options: logging turned off; logging queries which take more than a second to execute; logging every query; MySQL was run with default …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…turned off ICP because I would like to see the affect of BKA on the query times. But I also had to turn on…10; In-memory workload Now let’s see how effective are the join optimizations when the … because of this that the query on MariaDB 5.5 is slow as compared to MySQL 5.6. Next interesting thing…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 28 Comments
…to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL…. “I have a query I know is slow and is a problem for… appears to work — so we turn into little Pavlovian DBAs and try to …on most systems I work on. So there you have it — yet another surrogate measure. How to…
Post: Sell-an-Elephant-to-your-Boss-HOWTO
August 28, 2012 By 3 Comments
…How many conversions are we loosing because users turn away due to slow service during registration? It may be hard to…(and if) the optimization is going to pay off. When you have the two…to better hardware, optimizing indexes or queries, tuning MySQL etc. which we can offload 80-90% from the team. On…
Post: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL
June 22, 2012 By 33 Comments
…to mention quickly, that how drop table in MySQL < 5.5.23 used to work. When dropping the table, a mutex on…queries were captured in the slow log by setting long_query_time to 0. Then for analysis purposes the queries in the slow…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…on 32 bit we cannot turn up the innodb_buffer_pool higher than 1.8G right? 2.4 kernel (cannot change to…OFF‘ ‘Slow_launch_threads’, ’0′ ‘Slow_queries…mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…how performance is affected when turning expand_fast_index_creation on. Here and in later examples I’m extending the VARCHAR column to…to approximately 1/10th of the dataset: mysql> SET expand_fast_index_creation=OFF; Query OK, 0 rows affected (0.00 sec) mysql…
