← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/key_cache.test

  • Committer: Brian Aker
  • Date: 2009-05-05 00:40:45 UTC
  • mfrom: (1003.2.7 mordred)
  • Revision ID: brian@gaz-20090505004045-yns4biv63thufj1b
Tags: 2009.05.1005
Merge Monty

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/key_cache.test
71
71
# Following results differs on 64 and 32 bit systems because of different
72
72
# pointer sizes, which takes up different amount of space in key cache
73
73
 
74
 
--replace_result 837 KEY_BLOCKS_UNUSED 906 KEY_BLOCKS_UNUSED
 
74
--replace_result 837 KEY_BLOCKS_UNUSED 906 KEY_BLOCKS_UNUSED 896 KEY_BLOCKS_UNUSED
75
75
show status like 'key_blocks_unused';
76
76
 
77
77
insert into t1 values (1, 'qqqq'), (11, 'yyyy');
84
84
update t2 set i=2 where i=1;
85
85
 
86
86
show status like 'key_blocks_used';
87
 
--replace_result 833 KEY_BLOCKS_UNUSED 902 KEY_BLOCKS_UNUSED
 
87
--replace_result 833 KEY_BLOCKS_UNUSED 902 KEY_BLOCKS_UNUSED 892 KEY_BLOCKS_UNUSED
88
88
show status like 'key_blocks_unused';
89
89
 
90
90
cache index t1 key (`primary`) in keycache1;
146
146
drop table t1,t2,t3;
147
147
 
148
148
show status like 'key_blocks_used';
149
 
--replace_result 837 KEY_BLOCKS_UNUSED 906 KEY_BLOCKS_UNUSED
 
149
--replace_result 837 KEY_BLOCKS_UNUSED 906 KEY_BLOCKS_UNUSED 896 KEY_BLOCKS_UNUSED
150
150
show status like 'key_blocks_unused';
151
151
 
152
152