… the query was taking far too long to execute, ~11 hours in case of MySQL 5.5 and ~5 hours in case of MySQL… query time for MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL…. Note also that query time for MariaDB is still a little higher by a couple of seconds, when compared to MySQL 5.6. Now…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
…second in sysbench; NewOrder transactions Per Minute in tpcc-mysql). However, like Mark Callaghan mentioned in comments, response time… an end user is response time, that is how long the user has to wait…, if our target is arrival rate 2 queries per second, then exponential distribution will give us…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…query blocks any READ queries to execute on the table. mysql> show processlist; +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ | Id | User | Host | db | Command | Time…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…Secondly, remember that our support contracts cover MariaDB as a first-class member of the MySQL family of databases. Finally, High Performance MySQL…Microsecond time resolution for DATETIME and similar time-based … log enabled Faster queries through speedier joins, … has come a long way. I remember…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… 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… were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02:26…
Post: Slow Query Log analyzes tools
September 6, 2006 By 83 Comments
… 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 patch is adapted version of patch by Georg Richter which was made to run with recent MySQL version…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… long_query_time value as seconds. In effect one could only choose to log all queries to see those which take less than 1s. Now long_query_time….3s! # Query_time: 0.503016 Lock_time: 0.000048 Rows_sent: 56 Rows_examined: 1113 LOGGING OF THE REPLICATED STATEMENTS Normally MySQL will not…
Post: How to use tcpdump on very busy hosts
April 18, 2011 By 17 Comments
… “mk-query-digest –filter ‘$event->{time} && $event->{time} > 1′” to exclude all queries which it believes took longer than the servers long-query-time of 1 second tcpdump… has an obvious flaw — if your long-query-time is 1 second, and mkqd believes that a query which actually took 10ms instead took 0…
Post: Optimizing slow web pages with mk-query-digest
April 7, 2011 By 14 Comments
…time for some random user requests, you are usually interested in queries that are consuming most MySQL time and that’s how mk-query…query log (captured with long_query_time=0 and all the eXtra benefits from Percona slow query… queries were run during that session which took 148s seconds overall: # …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… happen at inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file …is getting stuck, has long-running transactions, or other problems. The pmp-check-mysql-innodb plugin checks … in a variable such as Queries and alert on a queries-per-second threshold. (I don’t …
