← 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: 2010-08-09 16:50:51 UTC
  • mto: (1698.1.1 drizzle)
  • mto: This revision was merged to the branch mainline in revision 1699.
  • Revision ID: brian@gaz-20100809165051-wd7cjrnjn65b3zdc
Use local key_Cache, global now goes away.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/key_cache.result
63
63
INSERT INTO t1 VALUES (1);
64
64
SELECT @@myisam_key_cache_block_size;
65
65
@@myisam_key_cache_block_size
66
 
1536
 
66
1024
67
67
CHECK TABLE t1;
68
68
Table   Op      Msg_type        Msg_text
69
69
test.t1 check   status  OK
95
95
4181
96
96
SELECT @@myisam_key_cache_block_size;
97
97
@@myisam_key_cache_block_size
98
 
1536
 
98
1024
99
99
CHECK TABLE t1;
100
100
Table   Op      Msg_type        Msg_text
101
101
test.t1 check   status  OK
125
125
test.t1 check   status  OK
126
126
SHOW VARIABLES LIKE 'myisam_key_cache_block_size';
127
127
Variable_name   Value
128
 
myisam_key_cache_block_size     1536
 
128
myisam_key_cache_block_size     1024
129
129
SET GLOBAL myisam_key_cache_block_size= @save_myisam_key_cache_block_size;
130
130
DROP TABLE t1,t2;
131
131
SET GLOBAL myisam_key_cache_division_limit= 0;
133
133
Error   1292    Truncated incorrect key_cache_division_limit value: '0'
134
134
SELECT @@myisam_key_cache_division_limit;
135
135
@@myisam_key_cache_division_limit
136
 
1
 
136
100
137
137
SET GLOBAL myisam_key_cache_division_limit= 101;
138
138
Warnings:
139
139
Error   1292    Truncated incorrect key_cache_division_limit value: '101'
145
145
Error   1292    Truncated incorrect key_cache_age_threshold value: '98'
146
146
SELECT @@myisam_key_cache_age_threshold;
147
147
@@myisam_key_cache_age_threshold
148
 
100
 
148
300
149
149
SET GLOBAL myisam_key_cache_age_threshold= 5000000000;
150
150
Warnings:
151
151
Error   1292    Truncated incorrect key_cache_age_threshold value: '5000000000'
152
152
SELECT @@myisam_key_cache_age_threshold;
153
153
@@myisam_key_cache_age_threshold
154
 
4294967295
 
154
300