List:Commits« Previous MessageNext Message »
From:Inaam Rana Date:July 26 2010 4:17pm
Subject:bzr push into mysql-next-mr-innodb branch (inaam.rana:3244 to 3245)
View as plain text  
 3245 Inaam Rana	2010-07-26
      Add basic test case for innodb_page_hash_mutexes

    added:
      mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result
      mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test
 3244 Jimmy Yang	2010-07-26
      Fix a test failure for innodb_monitor.test on sparc64 platform. monitor id
      needs to be extract to a ulint type before casting to monitor_id_t datatype.

    modified:
      storage/innobase/handler/ha_innodb.cc
=== added file 'mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result'
--- a/mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/sys_vars/r/innodb_page_hash_mutexes_basic.result	revid:inaam.rana@stripped
@@ -0,0 +1,21 @@
+select @@global.innodb_page_hash_mutexes;
+@@global.innodb_page_hash_mutexes
+256
+select @@session.innodb_page_hash_mutexes;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a GLOBAL variable
+show global variables like 'innodb_page_hash_mutexes';
+Variable_name	Value
+innodb_page_hash_mutexes	256
+show session variables like 'innodb_page_hash_mutexes';
+Variable_name	Value
+innodb_page_hash_mutexes	256
+select * from information_schema.global_variables where variable_name='innodb_page_hash_mutexes';
+VARIABLE_NAME	VARIABLE_VALUE
+INNODB_PAGE_HASH_MUTEXES	256
+select * from information_schema.session_variables where variable_name='innodb_page_hash_mutexes';
+VARIABLE_NAME	VARIABLE_VALUE
+INNODB_PAGE_HASH_MUTEXES	256
+set global innodb_page_hash_mutexes=1;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a read only variable
+set session innodb_page_hash_mutexes=1;
+ERROR HY000: Variable 'innodb_page_hash_mutexes' is a read only variable

=== added file 'mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test'
--- a/mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/sys_vars/t/innodb_page_hash_mutexes_basic.test	revid:inaam.rana@stripped
@@ -0,0 +1,20 @@
+--source include/have_innodb.inc
+
+#
+# show the global and session values;
+#
+select @@global.innodb_page_hash_mutexes;
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+select @@session.innodb_page_hash_mutexes;
+show global variables like 'innodb_page_hash_mutexes';
+show session variables like 'innodb_page_hash_mutexes';
+select * from information_schema.global_variables where variable_name='innodb_page_hash_mutexes';
+select * from information_schema.session_variables where variable_name='innodb_page_hash_mutexes';
+
+#
+# show that it's read-only
+#
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+set global innodb_page_hash_mutexes=1;
+--error ER_INCORRECT_GLOBAL_LOCAL_VAR
+set session innodb_page_hash_mutexes=1;


Attachment: [text/bzr-bundle] bzr/inaam.rana@oracle.com-20100726161648-v60qjun2q1r7jnod.bundle
Thread
bzr push into mysql-next-mr-innodb branch (inaam.rana:3244 to 3245) Inaam Rana26 Jul