General query logging can be very handy in MySQL on profuction server for various debugging needs. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0. What can you do in MySQL 5.0 and below ? Use Our Patch – With this patch you can get all queries logged as slow [...]
InnoDB in self-compiled MySQL 5.1
September 13, 2007 By 8 Comments
If you like to compile MySQL from sources by yourself, for different needs, like debugging, testing etc, you probably can face this issue. What I usually do to fast compile and test is ./configure –prefix=/dir/to/mysql make make install and then, for example, load the dump of InnoDB from previous version: mysql testdatabase < dump.sql I [...]
