diff options
Diffstat (limited to 'mysql-test/r/key_cache.result')
| -rw-r--r-- | mysql-test/r/key_cache.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/key_cache.result b/mysql-test/r/key_cache.result index b83a226776d..eeb838dc72c 100644 --- a/mysql-test/r/key_cache.result +++ b/mysql-test/r/key_cache.result @@ -85,6 +85,14 @@ select @@key_cache_block_size; set global keycache1.key_buffer_size=1024*1024; create table t1 (p int primary key, a char(10)) delay_key_write=1; create table t2 (p int primary key, i int, a char(10), key k1(i), key k2(a)); +show status like 'key_blocks_used'; +Variable_name Value +Key_blocks_used 0 +show status like 'The below may fail on 64-bit systems (ingo)'; +Variable_name Value +show status like 'key_blocks_unused'; +Variable_name Value +Key_blocks_unused 1812 insert into t1 values (1, 'qqqq'), (11, 'yyyy'); insert into t2 values (1, 1, 'qqqq'), (2, 1, 'pppp'), (3, 1, 'yyyy'), (4, 3, 'zzzz'); @@ -100,6 +108,14 @@ p i a 4 3 zzzz update t1 set p=2 where p=1; update t2 set i=2 where i=1; +show status like 'key_blocks_used'; +Variable_name Value +Key_blocks_used 4 +show status like 'The below may fail on 64-bit systems (ingo)'; +Variable_name Value +show status like 'key_blocks_unused'; +Variable_name Value +Key_blocks_unused 1808 cache index t1 key (`primary`) in keycache1; Table Op Msg_type Msg_text test.t1 assign_to_keycache status OK @@ -256,6 +272,14 @@ Table Op Msg_type Msg_text test.t1 assign_to_keycache status OK test.t2 assign_to_keycache status OK drop table t1,t2,t3; +show status like 'key_blocks_used'; +Variable_name Value +Key_blocks_used 4 +show status like 'The below may fail on 64-bit systems (ingo)'; +Variable_name Value +show status like 'key_blocks_unused'; +Variable_name Value +Key_blocks_unused 1812 set global keycache2.key_buffer_size=0; set global keycache3.key_buffer_size=100; set global keycache3.key_buffer_size=0; |