…–query-log-stdin command-line option for accepting a never-ending stream of queries to playback. Read-only playback Using the –session-init-query …is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored a…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…. It also reads every type of log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run… pt-query-digest 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed…
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 … I’ve got some time to play with table based slow query log in production while tuning one of the systems. It is… from it (or do any write queries) only read access is possible, with exception of TRUNCATE query. Which just recreates table which should…
Post: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… to microsecond scale: sql/log.cc, MYSQL_QUERY_LOG::write(): 1945 /* For slow query log */ 1946 sprintf(query_time_buff, “%.6f”, ulonglong2double(query_utime)/1000000.0);…imprecise. But pt-query-digest and similar tools don’t read the query log table—they only read the query log file. To account for…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…. Using pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can be pretty CPU and memory consuming, so ideally you would want to download the “slow query log… that less data is read and sent. Let’s analyze another query, this time query ranked #4 by pt-query-digest. # Query 4: 0.12…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
… today – I had a slow query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query log patch), I knew some… 2 0 1 0.00 0 0.06 0 # Rows read 1 2.01M 0 250.47k 3.96k 1.96… into a slow query log that lists all the queries that were executed during this session in the order they were executed: mk-query-digest…
Post: How to find MySQL queries worth optimizing ?
September 11, 2012 By 6 Comments
… find out queries which should be optimized. By looking at pt-query-digest report it is easy to find slow queries or queries which cause…: 0 # Query_time: 9.031233 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 10000000 Rows_affected: 0 Rows_read: 0 # Bytes… slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query_log…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… audit itself is generally a single person, with another person reading all the notes and generally keeping in touch with what… slow /path/to/slow.log By default, this outputs the top 10 most expensive queries, in total execution time. By the way, the slow query logs in… logging and additional information in the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…home/mysqld/mdmp/tmp slow_query_log=mdmp_slow_queries.log # binary logging and replication binlog_cache_size=1M binlog_format=MIXED log-slave-updates log-bin=mdmp_freehold_binlog sync_binlog=1 relay-log=mdmp_freehold_relaylog max_relay_log_size=100M #read-…
