One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times… need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
Many backup tools including Percona Xtrabackup, MyLVMBackup and others use FLUSH TABLES WITH READ LOCK to temporary make MySQL read only. In… problem is. As of MySQL 5.5 FLUSH TABLES WITH READ LOCK does not work as optimally as you could think it… list” operation to be blocked too, which among other tools used by mysql client, so you might get a feel you can…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 13 Comments
…mysql> optimize table a; +——–+———-+———-+——————————————————————-+ | Table | Op | Msg_type | Msg_text | +——–+———-+———-+——————————————————————-+ | test.a | optimize… or tools (like …
Post: Optimize Your SQL With Percona's Online Query Advisor!
February 15, 2012 By 23 Comments
…’s a tool to help you find them. This is the second addition to our online suite of tools for MySQL users. You… if you were right. That demonstrates another feature of the tool: you can share queries so they’re public, and other… can see them. The tool uses the same account that you might have already created for our online MySQL Configuration Wizard, which…
Post: How to Identify Bad Queries in MySQL
January 10, 2011 By 16 Comments
… is a big part of optimization. A scientific optimization process can be simplified to “can anything be…working implementation of most of this in a tool, Maatkit’s mk-query-digest. Here’s how:…query executed for, which has been available in MySQL for years. This is necessary for determining whether…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… pmp-check-mysql-deadlocks plugin can help you detect such problems, in conjunction with Percona Toolkit’s pt-deadlock-logger tool. Open…-heartbeat tool, if you choose), and actual failure. The pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql… allocating too much memory. A runaway server process, or poorly optimized queries, can consume too much memory and cause the server…
Post: Why not make a tool to improve existing configurations?
February 10, 2012 By 4 Comments
A couple of users of our very popular MySQL Configuration Wizard have submitted feedback such as “I’d love … risk of de-optimizing a server so it performs worse than before. So in the end, although our tool is excellent for…, my old blog post about the ultimate my.cnf tuner tool, which claims that an expert human is the only safe…
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
…most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in…to do with the task you’re trying to optimize or analyze. You might also be interested in …can analyze it easily with tools such as Maatkit’s mk-query-digest. These tools can do a lot …
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
… tool for generating an optimal my.cnf is not a tool. It’s a human with many years of experience, deep knowledge of MySQL… tuning primer or question-and-answer script that spits out “optimal” parameters for my.cnf. Most of the time these servers… as easy as writing a tool to do this, don’t you think Maatkit would have mk-optimal-mycnf already? In my…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T 0.5 -R… take most time to execute combined. There is a tool mysqldumpslow in MySQL distribution which kind of does the thing – unfortunately being… on constants. How to use this tool set ? First be aware this patch to MySQL is not official and should be used…
