diff options
Diffstat (limited to 'mysql-test/main/status.result')
-rw-r--r-- | mysql-test/main/status.result | 36 |
1 files changed, 18 insertions, 18 deletions
diff --git a/mysql-test/main/status.result b/mysql-test/main/status.result index d25cde89ee1..cf6bc493b5c 100644 --- a/mysql-test/main/status.result +++ b/mysql-test/main/status.result @@ -191,7 +191,7 @@ Created_tmp_tables 0 Handler_tmp_delete 0 Handler_tmp_update 0 Handler_tmp_write 0 -Rows_tmp_read 5 +Rows_tmp_read 0 show status like 'hand%write%'; Variable_name Value Handler_tmp_write 0 @@ -204,12 +204,12 @@ Created_tmp_tables 0 Handler_tmp_delete 0 Handler_tmp_update 0 Handler_tmp_write 0 -Rows_tmp_read 14 +Rows_tmp_read 0 show status like 'com_show_status'; Variable_name Value Com_show_status 8 rnd_diff tmp_table_diff -30 8 +0 8 disconnect con1; connection default; flush status; @@ -308,9 +308,9 @@ g count(*) 3 1 show status like 'Row%'; Variable_name Value -Rows_read 12 +Rows_read 0 Rows_sent 10 -Rows_tmp_read 14 +Rows_tmp_read 0 show status like 'Handler%'; Variable_name Value Handler_commit 0 @@ -324,31 +324,31 @@ Handler_mrr_key_refills 0 Handler_mrr_rowid_refills 0 Handler_prepare 0 Handler_read_first 0 -Handler_read_key 9 +Handler_read_key 0 Handler_read_last 0 Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 -Handler_read_rnd 7 +Handler_read_rnd 0 Handler_read_rnd_deleted 0 -Handler_read_rnd_next 23 +Handler_read_rnd_next 0 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_tmp_delete 0 -Handler_tmp_update 2 -Handler_tmp_write 7 +Handler_tmp_update 0 +Handler_tmp_write 0 Handler_update 0 -Handler_write 4 +Handler_write 0 show status like '%tmp%'; Variable_name Value Created_tmp_disk_tables 1 Created_tmp_files 0 Created_tmp_tables 2 Handler_tmp_delete 0 -Handler_tmp_update 2 -Handler_tmp_write 7 -Rows_tmp_read 44 +Handler_tmp_update 0 +Handler_tmp_write 0 +Rows_tmp_read 0 drop table t1; CREATE TABLE t1 (i int(11) DEFAULT NULL, KEY i (i) ) ENGINE=MyISAM; insert into t1 values (1),(2),(3),(4),(5); @@ -369,20 +369,20 @@ Handler_mrr_key_refills 0 Handler_mrr_rowid_refills 0 Handler_prepare 0 Handler_read_first 0 -Handler_read_key 2 +Handler_read_key 0 Handler_read_last 0 -Handler_read_next 2 +Handler_read_next 0 Handler_read_prev 0 Handler_read_retry 0 Handler_read_rnd 0 Handler_read_rnd_deleted 1 -Handler_read_rnd_next 2 +Handler_read_rnd_next 0 Handler_rollback 0 Handler_savepoint 0 Handler_savepoint_rollback 0 Handler_tmp_delete 0 Handler_tmp_update 0 -Handler_tmp_write 2 +Handler_tmp_write 0 Handler_update 0 Handler_write 0 drop table t1; |