ALTER TABLE t1 ADD COLU...ement PRIMARY KEY FIRST 1 0 0 18.096 18.096 18.096 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 12:34:02 PM ALTER TABLE t1 DROP PRIMARY KEY 1 0 0 18.814 18.814 18.814 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 12:34:02 PM ALTER TABLE t1 ENGINE = InnoDB 1 0 0 19.609 19.609 19.609 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 12:35:01 PM COMMIT 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:35:01 PM CREATE DATABASE quan_test 2 0 0 0.000 0.000 0.000 2 1 1 0 B 0 B 0 B 12:33:05 PM CREATE TABLE T1( dt dat... , PRIMARY KEY ( dt ) ) 2 0 0 0.125 0.078 0.062 0 0 0 0 B 0 B 0 B 12:33:05 PM CREATE view v10 AS SELE...` UNION ALL SELECT NULL 2 0 0 0.078 0.062 0.039 0 0 0 0 B 0 B 0 B 12:33:05 PM CREATE view v1000 AS SE...`a` , v10 `b` , v10 `c` 2 0 0 0.031 0.016 0.016 0 0 0 0 B 0 B 0 B 12:33:05 PM CREATE view v3 AS SELEC...L UNION ALL SELECT NULL 2 0 0 0.031 0.016 0.016 0 0 0 0 B 0 B 0 B 12:33:05 PM DELETE FROM t1 WHERE id = ? OR id = ? 2 0 0 0.000 0.000 0.000 2 2 1 0 B 0 B 0 B 12:35:01 PM DROP DATABASE IF EXISTS quan_test 2 0 1 0.094 0.094 0.047 4 4 2 0 B 0 B 0 B 12:33:05 PM INSERT INTO t1 SELECT N...M v1000 `a` , v1000 `b` 2 0 0 52.603 30.264 26.302 2,000,000 1,000,000 1,000,000 0 B 0 B 0 B 12:33:05 PM REPLACE INTO t1 VALUES ( ? , NOW( ) ) 2 0 0 0.000 0.000 0.000 2 1 1 0 B 0 B 0 B 12:35:01 PM ROLLBACK 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:35:01 PM SELECT @@session . auto_increment_increment 1 0 0 0.000 0.000 0.000 1 1 1 6 B 6 B 6 B 12:33:05 PM SELECT `a` . dt FROM t1...VAL ? MINUTE AND NOW( ) 1 0 0 0.000 0.000 0.000 1,758 1,758 1,758 41.2 KB 41.2 KB 41.2 KB 12:34:02 PM SELECT dt FROM t1 WHERE...TERVAL ? DAY AND NOW( ) 2 0 0 0.000 0.000 0.000 950,329 777,569 475,164 21.75 MB 17.8 MB 10.88 MB 12:34:02 PM SET @n = ? 2 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM SET AUTOCOMMIT = FALSE 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:35:01 PM SET NAMES latin1 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM SET autocommit = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM SET character_set_results = NULL 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM SET sql_mode = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM SHOW COLLATION 1 0 0 0.000 0.000 0.000 127 127 127 4.5 KB 4.5 KB 4.5 KB 12:33:05 PM SHOW VARIABLES WHERE Va... ? OR Variable_name = ? 1 0 0 0.000 0.000 0.000 18 18 18 545 B 545 B 545 B 12:33:05 PM START TRANSACTION TRUNCATE TABLE t1 2 0 0 0.140 0.140 0.070 0 0 0 0 B 0 B 0 B 12:35:01 PM UPDATE t1 SET dt = ? WHERE id = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:35:01 PM UPDATE t1 SET id = id - ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:35:01 PM USE quan_test 2 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 12:33:05 PM