From: Inaam Rana Date: July 26 2010 4:17pm Subject: bzr commit into mysql-next-mr-innodb branch (inaam.rana:3245) List-Archive: http://lists.mysql.com/commits/114364 Message-Id: <20100726161732.6CC7CC41BE@bling> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============2132388046==" --===============2132388046== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/inaam/w/page_hash/ based on revid:jimmy.yang@stripped 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 === 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; --===============2132388046== MIME-Version: 1.0 Content-Type: text/bzr-bundle; charset="us-ascii"; name="bzr/inaam.rana@stripped" Content-Transfer-Encoding: 7bit Content-Disposition: inline # Bazaar merge directive format 2 (Bazaar 0.90) # revision_id: inaam.rana@stripped # target_branch: file:///home/inaam/w/page_hash/ # testament_sha1: 85c067db425e2a7da41ac5c7fda2b4509b817656 # timestamp: 2010-07-26 12:17:32 -0400 # base_revision_id: jimmy.yang@stripped\ # rehf27v4ov468se6 # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWd6ScFUAAl7fgAAwWPP//37n 32C////wUAXPUABxJaBoKACURSep6ajMkyeptTyaGUGQZA09AhptNIMcwBGCYgGATBNGQ0MAmCMT CJRT0hJ4p5RkA0P1IG1AZGTTJ6ajE8oBzAEYJiAYBME0ZDQwCYIxMJJAg0ABAmSaaaRqeTEQYGjI 01HqU94sx7keZWX02UEJJ0SXnz+5LYqq4/XRrkK12pAKDQJdScoJsCp/WFI1kXe4ZqCL2clD5hwN V8vgoZSeXH21mrBp4wqRj6U9qc6U9LvMlMc4NrH6ONeCxceVZ0d5Q3KihxgQcokZnI4RB5O8/1eD 7maYa9OBcep8Ly6v2A9hHYVaR5J6ZM1bdzBELA67S4JgYD4lJ9qzi8/m7zreiIGho7MFzPlwVpeg 3iNNalMnuLif3SVurvH4rIgASKFQ5JPxxLnrUoIjJL0DLoMqgkr5DoNMCo1L1Ta5POFjN2rSVXiy 4Gl3PIfCqim/3ZGYZcQ/zlgfO1xWcVY8Ee/fgbyLR55guNDCY239gcskA1XMsKODz3nnYikuawpY xcim7JzTmd4F3MiRMqLYVhv3Wvg8tW9IcSye47E6ch5jiOjcjfU6XkSNZKnEgVf9VFgEtSqh7OV5 27f2VrYvpPAuynxwt2Wa3DRG8jSGozy4fY/WMGRFVGQDq0wMCYC0YDIp2YrW1+AU5lxkrw0ac1oQ QFsSM5hkcQMQwoxrHDwHQYmay5lhSUwJtZSrD6GKppMcZx0dLIxLsSu72NgEFKLsHOgxXJjmW6Pg q2uqEwy5xJiunvu0khCg0l545ptukvO41IQMQb31NOPcD7N7voUNYdZ5NhHpesqvUcOTRISSdgfk Oo+9XG0aHYbDDqcbuu02m01BmI/RDL5lQPVRjLUKginiGDdGRNJipbKJJZKCcDJyzFcxAyKFUZlS Lz8QqTio2WacWqpwFTQQq+Y7wrfD0EHWiwfoi2rYLBPlJMzwBYb/j7t/Ch7YJ/tQJr5gdAZ6itUs aBEvI/O0uETAz4ViM/yUrUqlWhgX56CSuWrmEWEiy+pCMMw0YgiVCEExqKJbYIS3SKdJHFFzjVFD v9mNrnS6lHdif+/5PkueF/gGbmBP+AKi8DcsdIlBOY0qyJhOgIg0HolsMhLU9mNUJ+g8FVD4Fx5j vrGR+oMQ8LOIcogtmOj+nOg/KUGorW32F4u+Z0ZqxJVHochwr1h+piQAw6db8mpqXXO6bX/RxoBS FKxTBTpnEJcFz+oaAMkcmEdONCCodY8LRyICSg83CxYmr2PUaECGQ5PXEtX1OJ5HFl40CgUzlXgB DAnS+szbyLIPCK4tc3MFg2B2VhAVqH0HFCIJo9ZoaOq7g2E8+SywP8JjHXOPpRk4Ni+mpmiUS+KQ 4HBA+tc6NAVwMULshvA80DP7ipe0D+gO47BojUDuDwJqbwgeJ6xUlQJigYeKQDAYBRnj6xDTriux 3py9iSZA0w8EngaXG0nKEFMzQlJRkggAyCQj4QQXGcgUwSRLRKMMlWgreuUVmUawI+0PPiIkJBgj FCkIPXO4iin0guqHJetyv49VzFvXqhLgOGB6oq4Q94HtAiHHxecV7gIoDyQd9cQtWyrSlZ3xUARL CtLTUH47qQSBg4pg9LCFTwpB+xPqrgL70cjEgEkJRyYrHwCgcpouYYGIlp6mKrkKtDN3BUwUwHsd n18tw7UMe0JSHWX40oE4K+Q4r34YDwsRaEGC3xM5i50PPAB0+SEmXktwLwXAL7kxulQKIOElItwY atNqbGywLAspM1P/4u5IpwoSG9JOCqA= --===============2132388046==--