1--source include/have_rocksdb.inc 2 3# 4# Basic HANDLER counts 5# 6 7FLUSH STATUS; 8CREATE TABLE t1 (id INT PRIMARY KEY, a VARCHAR(100), b INT, 9INDEX b(b)) ENGINE=ROCKSDB; 10INSERT INTO t1 (id,a,b) VALUES (1,'foobar',100),(2,'z',0),(3,'bar',50); 11SHOW SESSION STATUS LIKE 'Handler_write%'; 12 13UPDATE t1 SET b=1000 WHERE id=1; 14SHOW SESSION STATUS LIKE 'Handler_update%'; 15 16DELETE FROM t1 WHERE id=2; 17SHOW SESSION STATUS LIKE 'Handler_delete%'; 18 19INSERT INTO t1 (id,b) VALUES(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10); 20SHOW SESSION STATUS LIKE 'Handler_write%'; 21 22FLUSH STATUS; 23SELECT * FROM t1 WHERE id=8; 24SHOW SESSION STATUS LIKE 'Handler_read%'; 25 26FLUSH STATUS; 27SELECT * FROM t1 WHERE b=6; 28SHOW SESSION STATUS LIKE 'Handler_read%'; 29 30FLUSH STATUS; 31--sorted_result 32SELECT * FROM t1; 33SHOW SESSION STATUS LIKE 'Handler_read%'; 34 35FLUSH STATUS; 36SELECT * FROM t1 FORCE INDEX(b) WHERE b <=5 ORDER BY b; 37SHOW SESSION STATUS LIKE 'Handler_read%'; 38 39FLUSH STATUS; 40SELECT * FROM t1 WHERE id >=8 ORDER BY id; 41SHOW SESSION STATUS LIKE 'Handler_read%'; 42 43FLUSH STATUS; 44SELECT * FROM t1 WHERE id < 8 ORDER BY id; 45SHOW SESSION STATUS LIKE 'Handler_read%'; 46 47# Cleanup 48DROP TABLE t1; 49