…an index lookup is performed on the second table. This means many point queries, say for example if table1 …is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5 the query time decreases…4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 …
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 10 Comments
…0.000003 | 0.00 | 1 | 0.0000030000 | | executing | 0.000002 | 0.00 | 2 | 0.0000010000 | | end | 0.000002 | 0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1 | 0…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
MySQL has simple but quite handy feature – slow query log, which allows you to log all queries which took over define number of seconds to… to specify slow query time in microseconds rather than seconds and allows you to log all queries in slow query log by setting long_query_time=0 This… | mysql_slow_log_filter -T 0.5 -R 1000″ will look at queries as they come and will print out queries taking more than 0.5 seconds…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… enabled slow query logging and set a low enough value for long_query_time. We normally use a value of long_query_time=0, because if you set it to some other value say 0.1 seconds, it will miss all queries shorter than… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…0 0 17 0 0 0 0 0 0 The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second…0 0 0 0 0 0 0 0 # Tmp tables 0 0 0 0 0 0 0 0 # Tmp disk tbl 0 0 0 0 0 0 0 0 # Tmp tbl size 0 0 0 0 0 0 0 0 # Query…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 11 Comments
… the second one. Doing this on Master-Master setup do not forget to disable binary logging with SET SQL_BIN_LOG=0… execution time of 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…
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…0 on October 14, 2011 (Downloads are available here and from the Percona Software Repositories). Based on MySQL…. If a transaction is idle for more seconds than the threshold specified, it will be… Slow Query Log did not log the error number correctly. #830199 (Oleg Tsarev). Variable log-slow-…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…| 216162991863 | 7796961 | | Com_admin_commands | 255868807 | 11893 | | Com_alter_db | 0 | 0 | …snip This output is very useful when writing the …the slow query log output. The stock MySQL server’s limitation of one-second granularity makes it hide problem queries that are faster than one second…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… is 0.3s! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not write into slow log any queries executed… the time (in seconds) query had to wait on row locks. InnoDB_queue_wait is the time (in seconds) query spent either waiting to…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
… in the slow query log, and extended statistics in the same log. I logged a couple gigabytes of queries at 0-second threshold (all queries) and… the slow query log: there are just places where the log is full of these queries all taking 0.24 seconds, or all taking 0.30 seconds… done about it — and that’s where improvements to the MySQL source code are necessary. But in many cases something can…
