You can use pt-query-digest to process a MySQL slow query log and store historical values for review trend analysis into query_review_history table… of the attributes right away: Query_time, Lock_time, and so on. You can just look at a slow log and see them. However, there…}=\”$HOSTNAME\”" mysqld-slow-queries.log $HOSTNAME will reflect the current machine hostname. Replace $HOSTNAME with the necessary hostname if you copied slow query log from the…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
…MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical values for review trend analysis into query…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…handling the XtraDB changed page tracking log files. Bugs Fixed: Time in slow query log was displayed incorrectly when slow_query_log_microseconds_timestamp variable was set …prefix of another command line option innodb_changed_pages_limit. MySQL option handling would then shadow the former with the …
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
….2.10 | | INNODB_BUFFER_POOL_INSTANCES | 1 | 8 | | QUERY_CACHE_SIZE | 0 | 1048576 | | SLOW_QUERY_LOG_FILE | /mnt/data/sandboxes/msb_5_5_30…_metadata is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been… far as MySQL 5.6 goes – STRICT_MODE and other safer behaviors are not enabled by default. innodb_old_blocks_time now…
Post: Percona XtraDB Cluster: Multi-node writing and Unexpected deadlocks
August 17, 2012 By 17 Comments
… lock wait timeouts can happen). By the time the transaction reaches the COMMIT, it should…and all that extra network traffic would really slow down transactions. You may have already guessed,…lock(s), undo log entries 1 MySQL thread id 3972, OS thread handle 0x7fddb84e0700, query id 16408 localhost …
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… log file, it outputs the query time and lock time as floating-point numerics to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query…
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 … query execution time and lock time does not store fractions of the second. Today I’ve got some time to play with table based slow query log…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… MySQL manual, especially the option …Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log….commanual time_formatblogpercona.commanual time_zoneblogpercona.commanual timed_mutexesblogpercona….
Post: Logging MySQL queries from the client instead of the server
February 2, 2011 By 2 Comments
The “slow query log” is the single most valuable way to examine query execution on your MySQL server. Queries are logged with timing information, and in the case… the application time the queries and write a query log. I suggest writing out something in a standard logging format such as the slow-query-log format, so…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… was – I’ll just analyze queries in the slow query log generated by our mysql build running with long_query_time=0, get the slowest ones and… query optimization, is it? Well, I can still aggregate the slow query log with mk-log-parser and find routines that MySQL spends most of the time…
