diff options
Diffstat (limited to 'mysql-test/suite/percona/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result')
| -rw-r--r-- | mysql-test/suite/percona/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/suite/percona/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result b/mysql-test/suite/percona/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result new file mode 100644 index 00000000000..f951428abc7 --- /dev/null +++ b/mysql-test/suite/percona/query_cache_enhance.patch/percona_status_wait_query_cache_mutex.result @@ -0,0 +1,27 @@ +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); +SELECT number from t where id > 0; +number +2 +3 +SET SESSION debug="+d,status_wait_query_cache_mutex_sleep"; +SELECT number from t where id > 0; +SET SESSION debug="+d,status_wait_query_cache_mutex_sleep"; +SELECT number from t where id > 0; +SET SESSION debug="+d,status_wait_query_cache_mutex_sleep"; +SHOW PROCESSLIST; +Id User Host db Command Time State Info Rows_sent Rows_examined Rows_read +Id root localhost test Sleep Time NULL Rows_sent Rows_examined Rows_read +Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0 Rows_sent Rows_examined Rows_read +Id root localhost test Query Time Waiting on query cache mutex SELECT number from t where id > 0 Rows_sent Rows_examined Rows_read +Id root localhost test Query Time NULL SHOW PROCESSLIST Rows_sent Rows_examined Rows_read +DROP TABLE t; +set GLOBAL query_cache_size=0; |