… its log file. MySQL has a mutex for slow log writes. Truncation can block MySQL because the OS serializes access to the inode during the truncate operation… MySQL slow logs during rotation Flushing logs takes time. Meanwhile, queries are still being executed. To prevent MySQL from filling the slow log buffer, we disable the MySQL slow logs…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
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 … come in the log file. If you used to do tail -100 log-slow.log and now change it to SELECT * FROM slow_log ORDER BY… happen if one would use storage engine for log table which does not optimize TRUNCATE ? I guess it should be blocked as…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…_truncated_…log_isamblogpercona.commanual log_outputblogpercona.commanual log_queries_not_using_indexesblogpercona.commanual log_short_formatblogpercona.commanual log_slave_updatesblogpercona.commanual log_slow_admin_statementsblogpercona.commanual log_slow_queriesblogpercona.commanual log_slow…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… slow query information to the log table, query times and lock times are truncated to to integers: sql/log.cc, Log_to_csv_event_handler::log_slow…), ‘;’ ) AS `# slow-log` FROM `mysql`.`slow_log`; GO echo “#” I host the script above in my bk-tools github project. It’s called export-slow-log-table…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… Server is the ability to enable logging atomically, not just for new connections as in MySQL. This is very helpful for measurement… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02….0767 0.9% 4 0.0192 1.00 0.00 TRUNCATE TABLE poller_time # 14 0x3E84BF7C0C2A3005 0.0624 0.8% 272…
Comment: Get Me Some Query Logs!
December 19, 2012 By 14 Comments
… gather logs from the mysql.slow_query log, but you can export the data into a format that’s compatible with file-based slow query log… full-slow-log script. The script to export the slow-query log table is called “export-slow-log-table”. Another drawback of the table-based slow query log, in addition to its high overhead, is that it truncates the values…
Post: Announcing Percona Server 5.1.66-14.2
January 15, 2013 By Leave a Comment
…from the Percona Software Repositories). Based on MySQL 5.1.66, including all the …log cache were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary log… for every query stored procedure logged to the slow query log. Bug fixed #719386 (Alexey Kopytov…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
… (buf_LRU_insert_zip_clean). Bugs Fixed: #802825 / #61341 in MySQL (Yasufumi Kinoshita). Compatibility Collations Two new collations, utf8_general50_ci…. Bugs Fixed #813587 / #51196 and #61790 in MySQL (Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev…_lazy_drop_table option led to an assertion error when truncating a table in some scenarios. Bug Fixed:#798371 (Yasufumi Kinoshita…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…stmt_reset’, ’0′ ‘Com_stmt_send_long_data’, ’0′ ‘Com_truncate‘, ’0′ ‘Com_unlock_tables’, ’102′ ‘Com_update’, ’15146253′ ‘Com_…3309 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: Announcing Percona Server 5.5.28-29.3
January 8, 2013 By 2 Comments
… from the Percona Software Repositories). Based on MySQL 5.5.28, including all the bug …log cache were not purged after transaction commit. Fixed by truncating the temporary file, if used for a binary log… be identical in the Slow Query Log. This bug was introduced when slow_extended.patch was ported …
