One nice feature added for EXPLAIN statement in MySQL 4.1 is EXTENDED keyword which provides you with some helpful additional information on query optimization. It should be used together with SHOW WARNINGS to get information about how query looks after transformation as well as what other notes optimizer […]Read more
Running EXPLAIN for problematic queries is very powerful tool for MySQL Performance optimization. If you’ve been using this tool a lot you probably noticed it is not always provide adequate information. Here is list of things you may wish to watch out.
EXPLAIN can be wrong – […]
We are going to release several patches which are not included in official MySQL releases.
First one is automatically stack trace for x86_64 systems. Currently MySQL resolves stack in crash only for x86 boxes.
You can download patch for 5.0.22 source tree here.
How to use: place stack64.diff into main source dir; execute patch -p1 < stack64.diff. One [...]
Many people asked me to publish a walk through SHOW INNODB STATUS output, showing what you can learn from SHOW INNODB STATUS output and how to use this info to improve MySQL Performance.
What is SHOW INNODB STATUS
To start with basics, SHOW INNODB STATUS is a command which prints out a lot of internal […]