[Commits] Rev 3392: Update handler status variables after the last commit. in file:///home/psergey/dev2/5.3-look48/

Sergey Petrunya psergey at askmonty.org
Wed Jan 25 16:27:38 EET 2012


At file:///home/psergey/dev2/5.3-look48/

------------------------------------------------------------
revno: 3392
revision-id: psergey at askmonty.org-20120125142734-kwwse8mrr74zwkhf
parent: psergey at askmonty.org-20120123193552-oxbf2q6p7k1kqioo
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 5.3-look48
timestamp: Wed 2012-01-25 18:27:34 +0400
message:
  Update handler status variables after the last commit.
=== modified file 'mysql-test/r/myisam_mrr.result'
--- a/mysql-test/r/myisam_mrr.result	2012-01-23 19:35:52 +0000
+++ b/mysql-test/r/myisam_mrr.result	2012-01-25 14:27:34 +0000
@@ -628,9 +628,9 @@
 1230
 show status like 'handler_mrr%';
 Variable_name	Value
-Handler_mrr_extra_key_sorts	1
-Handler_mrr_extra_rowid_sorts	1
-Handler_mrr_init	2
+Handler_mrr_extra_key_sorts	1or2
+Handler_mrr_extra_rowid_sorts	1or2
+Handler_mrr_init	1or2
 set join_cache_level= @join_cache_level_save;
 set join_buffer_size= @join_buffer_size_save;
 drop table t0, t1;

=== modified file 'mysql-test/r/status.result'
--- a/mysql-test/r/status.result	2012-01-13 12:35:49 +0000
+++ b/mysql-test/r/status.result	2012-01-25 14:27:34 +0000
@@ -275,6 +275,9 @@
 Handler_commit	0
 Handler_delete	0
 Handler_discover	0
+Handler_mrr_extra_key_sorts	0
+Handler_mrr_extra_rowid_sorts	0
+Handler_mrr_init	0
 Handler_prepare	0
 Handler_read_first	0
 Handler_read_key	4
@@ -297,7 +300,7 @@
 Created_tmp_tables	2
 Handler_tmp_update	2
 Handler_tmp_write	7
-Rows_tmp_read	35
+Rows_tmp_read	38
 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);
@@ -310,6 +313,9 @@
 Handler_commit	0
 Handler_delete	0
 Handler_discover	0
+Handler_mrr_extra_key_sorts	0
+Handler_mrr_extra_rowid_sorts	0
+Handler_mrr_init	0
 Handler_prepare	0
 Handler_read_first	0
 Handler_read_key	2

=== modified file 'mysql-test/r/status_user.result'
--- a/mysql-test/r/status_user.result	2012-01-13 12:35:49 +0000
+++ b/mysql-test/r/status_user.result	2012-01-25 14:27:34 +0000
@@ -100,6 +100,9 @@
 Handler_commit	19
 Handler_delete	1
 Handler_discover	0
+Handler_mrr_extra_key_sorts	0
+Handler_mrr_extra_rowid_sorts	0
+Handler_mrr_init	0
 Handler_prepare	18
 Handler_read_first	0
 Handler_read_key	3

=== modified file 'mysql-test/t/myisam_mrr.test'
--- a/mysql-test/t/myisam_mrr.test	2012-01-23 19:35:52 +0000
+++ b/mysql-test/t/myisam_mrr.test	2012-01-25 14:27:34 +0000
@@ -313,6 +313,7 @@
 explain select sum(t1.b) from t0,t1 where t0.a=t1.a;
 flush status;
 select sum(t1.b) from t0,t1 where t0.a=t1.a;
+--replace_result 1 1or2 2 1or2
 show status like 'handler_mrr%';
 
 set join_cache_level= @join_cache_level_save;



More information about the commits mailing list