← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/key_cache.result

  • Committer: Brian Aker
  • Date: 2009-02-18 14:41:12 UTC
  • mfrom: (869.1.17 pointing-is-rude)
  • Revision ID: brian@tangent.org-20090218144112-o1kdtje1uy5xv34w
Merge Stewart

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/key_cache.result
90
90
Key_blocks_used 0
91
91
show status like 'key_blocks_unused';
92
92
Variable_name   Value
93
 
Key_blocks_unused       837
 
93
Key_blocks_unused       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');
111
111
Key_blocks_used 4
112
112
show status like 'key_blocks_unused';
113
113
Variable_name   Value
114
 
Key_blocks_unused       833
 
114
Key_blocks_unused       KEY_BLOCKS_UNUSED
115
115
cache index t1 key (`primary`) in keycache1;
116
116
Table   Op      Msg_type        Msg_text
117
117
test.t1 assign_to_keycache      status  OK
273
273
Key_blocks_used 4
274
274
show status like 'key_blocks_unused';
275
275
Variable_name   Value
276
 
Key_blocks_unused       837
 
276
Key_blocks_unused       KEY_BLOCKS_UNUSED
277
277
set global keycache2.key_buffer_size=0;
278
278
set global keycache3.key_buffer_size=100;
279
279
Warnings: