… was used MySQL 5.0.75-percona-b11 on CentOS release 4.7 MySQL setting There… options: logging turned off; logging queries which take more than a second to execute; logging every query; MySQL was run…workload even if all queries are logged. In general logging all queries can hurt MySQL and you should…
Comment: Slow Query Log analyzes tools
June 10, 2008 By 83 Comments
… trick to turn off the general query log without restarting mysql – i moved the log file aside, touched a replacement, but didn’t give the mysql user write…. while () { # datetime line if(s/^(0[0-9])([01][0-9])([0-3][0-9])\s+(1?[0-9]):([0-5][0-9]):([0-5][0-9])//) { # Convert to unix epoch – makes…
Comment: Enabling/Disabling query log without server restart in MySQL 5.0
August 31, 2010 By 13 Comments
…query log dynamically on MySQL 5.0 However I’m having the following error: Error 13. Turning logging off for the whole duration of the MySQL server process. To turn…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
… PBXT is a general purpose transactional … However, PBXT’s log-based architecture… or trade-offs that you …. This, in turn, means that …MySQL Backup API which was originally implemented in MySQL 6.0. This feature is now scheduled for an upcoming version of MySQL 5…but the first queries that access…
