Author: arekm Date: Wed Dec 14 17:40:17 2011 GMT Module: packages Tag: HEAD ---- Log message: - rel 2; update percona patches
---- Files affected: packages/mysql: mysql.spec (1.561 -> 1.562) , query_cache_enhance.patch (1.9 -> 1.10) , response_time_distribution.patch (1.8 -> 1.9) , slow_extended.patch (1.9 -> 1.10) ---- Diffs: ================================================================ Index: packages/mysql/mysql.spec diff -u packages/mysql/mysql.spec:1.561 packages/mysql/mysql.spec:1.562 --- packages/mysql/mysql.spec:1.561 Sat Nov 19 16:13:38 2011 +++ packages/mysql/mysql.spec Wed Dec 14 18:40:12 2011 @@ -37,7 +37,7 @@ Summary(zh_CN.UTF-8): MySQL数据库服务器 Name: mysql Version: 5.5.17 -Release: 1 +Release: 2 License: GPL + MySQL FLOSS Exception Group: Applications/Databases # Source0Download: http://dev.mysql.com/downloads/mysql/5.5.html#downloads @@ -1263,6 +1263,9 @@ All persons listed below can be reached at <cvs_login>@pld-linux.org $Log$ +Revision 1.562 2011/12/14 17:40:12 arekm +- rel 2; update percona patches + Revision 1.561 2011/11/19 15:13:38 arekm - up to 5.5.17 ================================================================ Index: packages/mysql/query_cache_enhance.patch diff -u packages/mysql/query_cache_enhance.patch:1.9 packages/mysql/query_cache_enhance.patch:1.10 --- packages/mysql/query_cache_enhance.patch:1.9 Sat Nov 19 16:13:39 2011 +++ packages/mysql/query_cache_enhance.patch Wed Dec 14 18:40:12 2011 @@ -267,22 +267,20 @@ #ifdef EMBEDDED_LIBRARY #include "emb_qcache.h" #endif -@@ -454,7 +629,14 @@ +@@ -454,7 +629,12 @@ Query_cache_wait_state wait_state(thd, __func__, __FILE__, __LINE__); DBUG_ENTER("Query_cache::try_lock"); + const char* old_proc_info= thd->proc_info; + thd_proc_info(thd,"Waiting on query cache mutex"); ++ DEBUG_SYNC(thd, "before_query_cache_mutex"); mysql_mutex_lock(&structure_guard_mutex); -+ DEBUG_SYNC(thd, "status_waiting_on_query_cache_mutex"); -+ DBUG_EXECUTE_IF("status_waiting_on_query_cache_mutex_sleep", { -+ sleep(1); -+ }); ++ DEBUG_SYNC(thd, "after_query_cache_mutex"); + thd->proc_info = old_proc_info; while (1) { if (m_cache_lock_status == Query_cache::UNLOCKED) -@@ -1274,6 +1456,8 @@ +@@ -1274,6 +1454,8 @@ unlock(); DBUG_VOID_RETURN; } @@ -291,7 +289,7 @@ /* Key is query + database + flag */ if (thd->db_length) -@@ -1451,6 +1635,9 @@ +@@ -1451,6 +1633,9 @@ Query_cache_block_table *block_table, *block_table_end; ulong tot_length; Query_cache_query_flags flags; @@ -301,7 +299,7 @@ DBUG_ENTER("Query_cache::send_result_to_client"); /* -@@ -1472,21 +1659,103 @@ +@@ -1472,21 +1657,103 @@ { uint i= 0; @@ -418,7 +416,7 @@ if ((my_toupper(system_charset_info, sql[i]) != 'S' || my_toupper(system_charset_info, sql[i + 1]) != 'E' || my_toupper(system_charset_info, sql[i + 2]) != 'L') && -@@ -1521,6 +1790,12 @@ +@@ -1521,6 +1788,12 @@ goto err_unlock; Query_cache_block *query_block; @@ -431,7 +429,7 @@ tot_length= query_length + thd->db_length + 1 + QUERY_CACHE_FLAGS_SIZE; if (thd->db_length) -@@ -1587,6 +1862,8 @@ +@@ -1587,6 +1860,8 @@ (uchar*) &flags, QUERY_CACHE_FLAGS_SIZE); query_block = (Query_cache_block *) my_hash_search(&queries, (uchar*) sql, tot_length); @@ -2785,32 +2783,6 @@ +SET GLOBAL query_cache_size= default; +set global query_cache_strip_comments=OFF; --- /dev/null -+++ b/mysql-test/r/percona_status_wait_query_cache_mutex.result -@@ -0,0 +1,23 @@ -+SET GLOBAL query_cache_size=1355776; -+flush query cache; -+flush query cache; -+reset query cache; -+flush status; -+DROP TABLE IF EXISTS t; -+CREATE TABLE t(id INT, number INT); -+INSERT INTO t VALUES (0,1); -+INSERT INTO t VALUES (1,2); -+INSERT INTO t VALUES (2,3); -+SET SESSION debug="+d,status_waiting_on_query_cache_mutex_sleep"; -+SET DEBUG_SYNC='status_waiting_on_query_cache_mutex SIGNAL thread_ready'; -+SELECT number from t where id > 0; -+SHOW PROCESSLIST; -+Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read -+### root ### test Query ### NULL SHOW PROCESSLIST ### ### ### -+### root ### test Query ### Waiting on query cache mutex SELECT number from t where id > 0 ### ### ### -+SELECT id, info, state FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; -+id info state -+### SELECT id, info, state FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id executing -+### SELECT number from t where id > 0 Waiting on query cache mutex -+DROP TABLE t; -+SET GLOBAL query_cache_size=0; ---- /dev/null +++ b/mysql-test/t/percona_query_cache_with_comments.test @@ -0,0 +1,5 @@ +--disable_ps_protocol @@ -3062,37 +3034,41 @@ +set global query_cache_strip_comments=OFF; --- /dev/null +++ b/mysql-test/t/percona_status_wait_query_cache_mutex.test -@@ -0,0 +1,31 @@ +@@ -0,0 +1,35 @@ +--source include/have_query_cache.inc +--source include/have_debug.inc +--source include/have_debug_sync.inc +SET GLOBAL query_cache_size=1355776; +--source include/percona_query_cache_with_comments_clear.inc ++--let try_lock_mutex_query=SELECT "try_lock_mutex_query" as action + -+-- disable_warnings -+DROP TABLE IF EXISTS t; -+-- enable_warnings -+CREATE TABLE t(id INT, number INT); -+INSERT INTO t VALUES (0,1); -+INSERT INTO t VALUES (1,2); -+INSERT INTO t VALUES (2,3); -+ -+--connect (conn,localhost,root,,) -+ -+--connection conn -+SET SESSION debug="+d,status_waiting_on_query_cache_mutex_sleep"; -+SET DEBUG_SYNC='status_waiting_on_query_cache_mutex SIGNAL thread_ready'; -+SEND SELECT number from t where id > 0; ++--connect (mutex_locked_conn, localhost, root,,) ++--connect (try_mutex_lock_conn, localhost, root,,) ++ ++--connection mutex_locked_conn ++SET DEBUG_SYNC='after_query_cache_mutex SIGNAL mutex_locked WAIT_FOR unlock_mutex'; ++send SELECT "mutex_locked_query" as action; + +--connection default -+--replace_column 1 ### 3 ### 6 ### 9 ### 10 ### 11 ### -+SHOW PROCESSLIST; ++SET DEBUG_SYNC='now WAIT_FOR mutex_locked'; ++ ++--connection try_mutex_lock_conn ++SET DEBUG_SYNC='before_query_cache_mutex SIGNAL try_lock_mutex'; ++send_eval $try_lock_mutex_query; + -+--replace_column 1 ### -+SELECT id, info, state FROM INFORMATION_SCHEMA.PROCESSLIST ORDER BY id; ++--connection default ++SET DEBUG_SYNC='now WAIT_FOR try_lock_mutex'; ++eval SELECT SQL_NO_CACHE state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info='$try_lock_mutex_query'; ++SET DEBUG_SYNC='now SIGNAL unlock_mutex'; ++ ++--connection mutex_locked_conn ++reap; ++--connection try_mutex_lock_conn ++reap; + -+--disconnect conn -+DROP TABLE t; ++--connection default ++--disconnect mutex_locked_conn ++--disconnect try_mutex_lock_conn +SET GLOBAL query_cache_size=0; --- a/mysql-test/r/mysqld--help-notwin.result +++ b/mysql-test/r/mysqld--help-notwin.result @@ -3115,3 +3091,26 @@ query-cache-type ON query-cache-wlock-invalidate FALSE query-prealloc-size 8192 +--- /dev/null ++++ b/mysql-test/r/percona_status_wait_query_cache_mutex.result +@@ -0,0 +1,20 @@ ++SET GLOBAL query_cache_size=1355776; ++flush query cache; ++flush query cache; ++reset query cache; ++flush status; ++SET DEBUG_SYNC='after_query_cache_mutex SIGNAL mutex_locked WAIT_FOR unlock_mutex'; ++SELECT "mutex_locked_query" as action; ++SET DEBUG_SYNC='now WAIT_FOR mutex_locked'; ++SET DEBUG_SYNC='before_query_cache_mutex SIGNAL try_lock_mutex'; ++SELECT "try_lock_mutex_query" as action; ++SET DEBUG_SYNC='now WAIT_FOR try_lock_mutex'; ++SELECT SQL_NO_CACHE state FROM INFORMATION_SCHEMA.PROCESSLIST WHERE info='SELECT "try_lock_mutex_query" as action'; ++state ++Waiting on query cache mutex ++SET DEBUG_SYNC='now SIGNAL unlock_mutex'; ++action ++mutex_locked_query ++action ++try_lock_mutex_query ++SET GLOBAL query_cache_size=0; ================================================================ Index: packages/mysql/response_time_distribution.patch diff -u packages/mysql/response_time_distribution.patch:1.8 packages/mysql/response_time_distribution.patch:1.9 --- packages/mysql/response_time_distribution.patch:1.8 Sat Nov 19 16:13:39 2011 +++ packages/mysql/response_time_distribution.patch Wed Dec 14 18:40:12 2011 @@ -297,10 +297,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -343,10 +343,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -448,10 +448,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -494,10 +494,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -572,7 +572,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -588,7 +588,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -666,7 +666,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -685,7 +685,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -753,7 +753,7 @@ + 1.000000 34 12.250000 + 156.000000 33 77.099997 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -762,7 +762,7 @@ + 1.000000 34 12.250000 + 156.000000 33 77.099997 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -829,7 +829,7 @@ + 0.001000 0 0.000000 + 1.000000 34 12.250000 + 1000.000000 33 77.099997 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -837,7 +837,7 @@ + 0.001000 0 0.000000 + 1.000000 34 12.250000 + 1000.000000 33 77.099997 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -906,7 +906,7 @@ + 0.001000 0 0.000000 + 1.000000 34 12.250000 + 1000.000000 33 77.099997 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -914,7 +914,7 @@ + 0.001000 0 0.000000 + 1.000000 34 12.250000 + 1000.000000 33 77.099997 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_RANGE_BASE=default; +SET GLOBAL QUERY_RESPONSE_TIME_STATS=default; @@ -972,10 +972,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1018,10 +1018,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; +SET SESSION query_exec_time=0.31; @@ -1158,10 +1158,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1204,10 +1204,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET SESSION query_exec_time=default; +SET SESSION query_exec_time=0.1; @@ -1255,10 +1255,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1301,10 +1301,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; +SET SESSION query_exec_time=0.31; @@ -1441,10 +1441,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1487,10 +1487,10 @@ + 131072.000000 0 0.000000 + 262144.000000 0 0.000000 + 524288.000000 0 0.000000 -+ 1048576.00000 0 0.000000 -+ 2097152.00000 0 0.000000 -+ 4194304.00000 0 0.000000 -+ 8388608.00000 0 0.000000 ++1048576.000000 0 0.000000 ++2097152.000000 0 0.000000 ++4194304.000000 0 0.000000 ++8388608.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET SESSION query_exec_time=default; +SET SESSION query_exec_time=0.1; @@ -1511,7 +1511,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1527,7 +1527,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; +SET SESSION query_exec_time=0.31; @@ -1637,7 +1637,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1653,7 +1653,7 @@ + 1000.000000 0 0.000000 + 10000.000000 0 0.000000 + 100000.000000 0 0.000000 -+ 1000000.00000 0 0.000000 ++1000000.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET SESSION query_exec_time=default; +SET SESSION query_exec_time=0.1; @@ -1677,7 +1677,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1696,7 +1696,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; +SET SESSION query_exec_time=0.31; @@ -1809,7 +1809,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1828,7 +1828,7 @@ + 16807.000000 0 0.000000 + 117649.000000 0 0.000000 + 823543.000000 0 0.000000 -+ 5764801.00000 0 0.000000 ++5764801.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET SESSION query_exec_time=default; +SET SESSION query_exec_time=0.1; @@ -1842,7 +1842,7 @@ + 1.000000 0 0.000000 + 156.000000 0 0.000000 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1851,7 +1851,7 @@ + 1.000000 0 0.000000 + 156.000000 0 0.000000 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET GLOBAL QUERY_RESPONSE_TIME_STATS=1; +SET SESSION query_exec_time=0.31; @@ -1954,7 +1954,7 @@ + 1.000000 11 4.050000 + 156.000000 11 25.699999 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SELECT * FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME; +time count total @@ -1963,7 +1963,7 @@ + 1.000000 11 4.050000 + 156.000000 11 25.699999 + 24336.000000 0 0.000000 -+ 3796416.00000 0 0.000000 ++3796416.000000 0 0.000000 +TOO LONG 0 TOO LONG +SET SESSION query_exec_time=default; <<Diff was trimmed, longer than 597 lines>> ---- CVS-web: http://cvs.pld-linux.org/cgi-bin/cvsweb.cgi/packages/mysql/mysql.spec?r1=1.561&r2=1.562&f=u http://cvs.pld-linux.org/cgi-bin/cvsweb.cgi/packages/mysql/query_cache_enhance.patch?r1=1.9&r2=1.10&f=u http://cvs.pld-linux.org/cgi-bin/cvsweb.cgi/packages/mysql/response_time_distribution.patch?r1=1.8&r2=1.9&f=u http://cvs.pld-linux.org/cgi-bin/cvsweb.cgi/packages/mysql/slow_extended.patch?r1=1.9&r2=1.10&f=u _______________________________________________ pld-cvs-commit mailing list [email protected] http://lists.pld-linux.org/mailman/listinfo/pld-cvs-commit
