…query-log-stdin –dispatcher-plugin thread-pool –thread-pool-threads-count 100 –session-init-query \”set innodb_fake_changes=1\” > /var/log/playback.log…necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…we removed –lock-wait-timeout which set innodb_lock_wait_timeout because that now …log now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query… MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was …
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… for something else.. say an innodb data file, and writing part of your slow query log as an innodb page will not end in hugs… MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log): 8 seconds So…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…: 984 InnoDB_IO_r_bytes: 16121856 InnoDB_IO_r_wait: 0.001414 # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000 # InnoDB_pages…. 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…
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…_db # Hosts localhost # InnoDB trxID 1153145C (2/0%), 11531626 (2/0%)… 43 more # Last errno 0 # Users prod # Query_time distribution # 1us… 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… slow query log: # Time: 120911 17:18:05 # User@Host: root[root] @ localhost [] # Thread_id: 65005 Schema: sbtest Last_errno: 0 Killed: 0 # Query…_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0 # InnoDB_trx_id: 12F24 SET timestamp=1347399108; select count(*) from sbtest…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… might see queries which previously performed well suddenly show up on slow query log until InnoDB again updates the statistics. But when does InnoDB perform the… and InnoDB plugin’s manual: Metadata commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from…
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
…-resolve is easy to miss, as is the absence of innodb_log_file_size. I won’t give you a full rundown… 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
…/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=…innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout=60 innodb_log_buffer_size = 32M innodb_log_file_size = 512M innodb…
