116 lines
2.4 KiB
Plaintext
116 lines
2.4 KiB
Plaintext
DROP TABLE IF EXISTS t1;
|
|
FLUSH STATUS;
|
|
CREATE TABLE t1 (id INT PRIMARY KEY, a VARCHAR(100), b INT,
|
|
INDEX b(b)) ENGINE=xengine;
|
|
INSERT INTO t1 (id,a,b) VALUES (1,'foobar',100),(2,'z',0),(3,'bar',50);
|
|
SHOW SESSION STATUS LIKE 'Handler_write%';
|
|
Variable_name Value
|
|
Handler_write 11
|
|
UPDATE t1 SET b=1000 WHERE id=1;
|
|
SHOW SESSION STATUS LIKE 'Handler_update%';
|
|
Variable_name Value
|
|
Handler_update 9
|
|
DELETE FROM t1 WHERE id=2;
|
|
SHOW SESSION STATUS LIKE 'Handler_delete%';
|
|
Variable_name Value
|
|
Handler_delete 1
|
|
INSERT INTO t1 (id,b) VALUES(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
|
|
SHOW SESSION STATUS LIKE 'Handler_write%';
|
|
Variable_name Value
|
|
Handler_write 18
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id=8;
|
|
id a b
|
|
8 NULL 8
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 0
|
|
Handler_read_key 1
|
|
Handler_read_last 0
|
|
Handler_read_next 0
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 0
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE b=6;
|
|
id a b
|
|
6 NULL 6
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 0
|
|
Handler_read_key 1
|
|
Handler_read_last 0
|
|
Handler_read_next 1
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 0
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1;
|
|
id a b
|
|
1 foobar 1000
|
|
10 NULL 10
|
|
3 bar 50
|
|
4 NULL 4
|
|
5 NULL 5
|
|
6 NULL 6
|
|
7 NULL 7
|
|
8 NULL 8
|
|
9 NULL 9
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 0
|
|
Handler_read_key 0
|
|
Handler_read_last 0
|
|
Handler_read_next 0
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 10
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 FORCE INDEX(b) WHERE b <=5 ORDER BY b;
|
|
id a b
|
|
4 NULL 4
|
|
5 NULL 5
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 0
|
|
Handler_read_key 1
|
|
Handler_read_last 0
|
|
Handler_read_next 2
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 0
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id >=8 ORDER BY id;
|
|
id a b
|
|
8 NULL 8
|
|
9 NULL 9
|
|
10 NULL 10
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 0
|
|
Handler_read_key 1
|
|
Handler_read_last 0
|
|
Handler_read_next 3
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 0
|
|
FLUSH STATUS;
|
|
SELECT * FROM t1 WHERE id < 8 ORDER BY id;
|
|
id a b
|
|
1 foobar 1000
|
|
3 bar 50
|
|
4 NULL 4
|
|
5 NULL 5
|
|
6 NULL 6
|
|
7 NULL 7
|
|
SHOW SESSION STATUS LIKE 'Handler_read%';
|
|
Variable_name Value
|
|
Handler_read_first 1
|
|
Handler_read_key 0
|
|
Handler_read_last 0
|
|
Handler_read_next 6
|
|
Handler_read_prev 0
|
|
Handler_read_rnd 0
|
|
Handler_read_rnd_next 0
|
|
DROP TABLE t1;
|