diff options
| author | unknown <igor@rurik.mysql.com> | 2003-06-19 02:34:33 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2003-06-19 02:34:33 -0700 |
| commit | 32ddd42736b4399ed1ac5baabfafc91d4f0b84ca (patch) | |
| tree | f087d5382ea1b5ddd9c0b03a6059bb9c71006ec9 /mysql-test/r/preload.result | |
| parent | 4a83fca1d7fcd5155b45350b90f0f220d3379aa6 (diff) | |
| download | mariadb-git-32ddd42736b4399ed1ac5baabfafc91d4f0b84ca.tar.gz | |
preload.result, preload.test:
Removed non-generic info (key used blocks)
preload.result, preload.test, lex.h, sql_yacc.yy:
Syntax change for preload statement
sql/sql_yacc.yy:
Syntax change for preload statement
sql/lex.h:
Syntax change for preload statement
mysql-test/t/preload.test:
Removed non-generic info (key used blocks)
mysql-test/r/preload.result:
Removed non-generic info (key used blocks)
Diffstat (limited to 'mysql-test/r/preload.result')
| -rw-r--r-- | mysql-test/r/preload.result | 87 |
1 files changed, 20 insertions, 67 deletions
diff --git a/mysql-test/r/preload.result b/mysql-test/r/preload.result index 0afd95b6fb8..4d9293c7929 100644 --- a/mysql-test/r/preload.result +++ b/mysql-test/r/preload.result @@ -46,169 +46,122 @@ count(*) 20672 flush tables; flush status; -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 select count(*) from t1 where b = 'test1'; count(*) 4181 -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 217 Key_reads 45 -Key_write_requests 0 -Key_writes 0 select count(*) from t1 where b = 'test1'; count(*) 4181 -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 434 Key_reads 45 -Key_write_requests 0 -Key_writes 0 flush tables; flush status; select @@preload_buffer_size; @@preload_buffer_size 32768 -preload t1 keys; +load index into cache t1 keys; Table Op Msg_type Msg_text test.t1 preload_keys status OK -show status like "preload_%"; +show status like "key_read%"; Variable_name Value -show status like "key_%"; -Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 select count(*) from t1 where b = 'test1'; count(*) 4181 -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 217 Key_reads 45 -Key_write_requests 0 -Key_writes 0 flush tables; flush status; -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 set session preload_buffer_size=256*1024; select @@preload_buffer_size; @@preload_buffer_size 262144 -preload t1 keys ignore leaves; +load index into cache t1 keys ignore leaves; Table Op Msg_type Msg_text test.t1 preload_keys status OK -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 select count(*) from t1 where b = 'test1'; count(*) 4181 -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 217 Key_reads 45 -Key_write_requests 0 -Key_writes 0 flush tables; flush status; -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 set session preload_buffer_size=1*1024; select @@preload_buffer_size; @@preload_buffer_size 1024 -preload t1 keys, t2 keys (primary,b) ignore leaves; +load index into cache t1 keys, t2 keys (primary,b) ignore leaves; Table Op Msg_type Msg_text test.t1 preload_keys status OK test.t2 preload_keys status OK -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 select count(*) from t1 where b = 'test1'; count(*) 4181 select count(*) from t2 where b = 'test1'; count(*) 2584 -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 351 Key_reads 73 -Key_write_requests 0 -Key_writes 0 flush tables; flush status; -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 -preload t3 keys, t2 keys (primary,b) ; +load index into cache t3 keys, t2 keys (primary,b) ; Table Op Msg_type Msg_text test.t3 preload_keys error Table 'test.t3' doesn't exist test.t2 preload_keys status OK -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 flush tables; flush status; -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 -preload t3 keys (b), t2 keys (c) ; +load index into cache t3 keys (b), t2 keys (c) ; Table Op Msg_type Msg_text test.t3 preload_keys error Table 'test.t3' doesn't exist test.t2 preload_keys error Key column 'c' doesn't exist in table test.t2 preload_keys status Operation failed -show status like "key_%"; +show status like "key_read%"; Variable_name Value -Key_blocks_used 918 Key_read_requests 0 Key_reads 0 -Key_write_requests 0 -Key_writes 0 drop table t1, t2; |