79
79
select @@key_buffer_size;
82
82
select @@key_cache_block_size;
85
85
set global keycache1.key_buffer_size=1024*1024;
87
create table t2 (p int primary key, i int, a char(10), key k1(i), key k2(a));
87
create table t2 (p int primary key, i int, a char(10), key k1(i), key k2(a)) ENGINE=myisam;
88
88
show status like 'key_blocks_used';
91
91
show status like 'key_blocks_unused';
94
94
insert into t1 values (1, 'qqqq'), (11, 'yyyy');
95
95
insert into t2 values (1, 1, 'qqqq'), (2, 1, 'pppp'),
96
96
(3, 1, 'yyyy'), (4, 3, 'zzzz');