As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous versions. … should tell log table implementation in MySQL is well though of in regards to avoiding trouble. For example you can’t ALTER log table while query is…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… to disable binary logging with SET SQL_BIN_LOG=0 before you run ALTER TABLE query. Replication Overload Many …queries being replicated. Unfortunately MySQL Slow Query Log does not log replication queries. Though this is one of few slow query logging improvements you can get with our Slow Query Log…
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
…’ ‘Com_admin_commands’, ’76′ ‘Com_alter_db’, ’0′ ‘Com_alter_table‘, ’7′ ‘Com_analyze’, ’0′ ‘Com_backup_table‘, ’0′ ‘Com_begin’, ’0′… socket=/tmp/mysql.sock pid-file=/var/run/mysql/mysql.pid datadir=/db/disk2/mysql/data log-bin=/var/log/mysql/log log-slow-queries=/var/log/mysql/slow-queries.log max_…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…alter…slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
…your ALTER TABLE or OPTIMIZE TABLE now locks small table for few seconds rather than giant 100GB table…Read more in my Why MySQL Could be slow with Large Tables article. 5. The n…queries, especially if you see them in slow query log. If you have trouble understanding EXPLAIN or optimizing your queries…
Post: Advanced index analysis with mk-index-usage
November 11, 2010 By 2 Comments
…prints out ALTER statements for … -p XXXX slow_query.log \ –save-…tables: mysql> show tables; +———————–+ | Tables_in_index_usage | +———————–+ | index_alternatives | | index_usage | | indexes | | queries | | tables | +———————–+ Now let’s run some queries…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…from the Percona Software Repositories). Based on MySQL 5.5.16, including all the …Kopytov). The Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow-admin-statements… specifications and then adding them back in ALTER TABLE doesn’t work for them. mysqldump –…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the…error instead. Bug Fixed: #704216 (Laurynas Biveinis). Querying INNODB_SYS_TABLES after an ALTER TABLE statement leaded to a server crash. …
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… choice. 2) Use full slow query log and mk-query-digest. This method is…queries MySQL server ran with their times and run mk-query-digest with filter to only check queries from replication thread: mk-query-digest slow-log… load – if you push heavy ALTER TABLE through replication they will surely…
