Translation of chapter 5 which describes alternate methods for searching problem query just published. It starts like:
Chapter 5. Alternate methods for finding problem query.
I already wrote about using of general query log requires resources.
Part of the problem can be solved if use new feature of MySQL 5.1:
online logging which allows to turn general query log to on or to off
without stopping the MySQL server.
Unfortunately this doesn't always work: you can have old
version of MySQL server which has not such a feature, general query log
can contain very large amount of information, so you can just miss the
problem in thousands of correct queries, you can have some other own
But what to do if you can not use general query log?
One of[Read more...]