ALTER TABLE t1 ADD COLU...ement PRIMARY KEY FIRST (1) 1 0 0 4:20.792 4:20.792 4:20.792 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 1:03:08 PM ALTER TABLE t1 DROP PRIMARY KEY (1) 1 0 0 4:22.783 4:22.783 4:22.783 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 1:03:08 PM ALTER TABLE t1 ENGINE = InnoDB (1) 1 0 0 4:31.482 4:31.482 4:31.482 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 1:03:08 PM COMMIT (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:03:08 PM CREATE DATABASE quan_test (1) 1 0 0 0.217 0.217 0.217 1 1 1 0 B 0 B 0 B 1:02:08 PM CREATE TABLE T1( dt dat... , PRIMARY KEY ( dt ) ) (1) 1 0 0 0.852 0.852 0.852 0 0 0 0 B 0 B 0 B 1:02:08 PM CREATE view v10 AS SELE...` UNION ALL SELECT NULL (1) 1 0 0 0.485 0.485 0.485 0 0 0 0 B 0 B 0 B 1:02:08 PM CREATE view v1000 AS SE...`a` , v10 `b` , v10 `c` (1) 1 0 0 0.234 0.234 0.234 0 0 0 0 B 0 B 0 B 1:02:08 PM CREATE view v3 AS SELEC...L UNION ALL SELECT NULL (1) 1 0 0 0.236 0.236 0.236 0 0 0 0 B 0 B 0 B 1:02:08 PM DELETE FROM t1 WHERE id = ? OR id = ? (1) 2 0 0 0.011 0.009 0.006 2 2 1 0 B 0 B 0 B 1:03:08 PM DROP DATABASE IF EXISTS quan_test (1) 1 0 0 0.246 0.246 0.246 4 4 4 0 B 0 B 0 B 1:02:08 PM INSERT INTO t1 SELECT N...M v1000 `a` , v1000 `b` (1) 1 0 0 6:02.984 6:02.984 6:02.984 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 1:02:08 PM REPLACE INTO t1 VALUES ( ? , NOW( ) ) (1) 2 0 0 0.005 0.003 0.002 2 1 1 0 B 0 B 0 B 1:03:08 PM ROLLBACK (1) SELECT @@session . auto_increment_increment (1) 1 0 0 0.003 0.003 0.003 1 1 1 6 B 6 B 6 B 1:02:08 PM SELECT `a` . dt FROM t1...VAL ? MINUTE AND NOW( ) (1) 1 0 0 0.066 0.066 0.066 1,761 1,761 1,761 41.27 KB 41.27 KB 41.27 KB 1:03:08 PM SELECT dt FROM t1 WHERE...TERVAL ? DAY AND NOW( ) (1) 2 0 0 0.034 0.017 0.017 950,338 777,575 475,169 21.75 MB 17.8 MB 10.88 MB 1:03:08 PM SET @n = ? (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:02:08 PM SET AUTOCOMMIT = FALSE (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:03:08 PM SET NAMES latin1 (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:02:08 PM SET autocommit = ? (1) 1 0 0 0.001 0.001 0.001 0 0 0 0 B 0 B 0 B 1:02:08 PM SET character_set_results = NULL (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:02:08 PM SET sql_mode = ? (1) 1 0 0 0.001 0.001 0.001 0 0 0 0 B 0 B 0 B 1:02:08 PM SHOW COLLATION (1) 1 0 0 0.009 0.009 0.009 127 127 127 4.5 KB 4.5 KB 4.5 KB 1:02:08 PM SHOW VARIABLES WHERE Va... ? OR Variable_name = ? (1) 1 0 0 0.017 0.017 0.017 18 18 18 545 B 545 B 545 B 1:02:08 PM START TRANSACTION (1) 1 0 0 0.001 0.001 0.001 0 0 0 0 B 0 B 0 B 1:03:08 PM TRUNCATE TABLE t1 (1) 2 0 0 2.006 1.995 1.003 0 0 0 0 B 0 B 0 B 1:03:08 PM UPDATE t1 SET dt = ? WHERE id = ? (1) 1 0 0 0.003 0.003 0.003 0 0 0 0 B 0 B 0 B 1:03:08 PM UPDATE t1 SET id = id - ? (1) 1 0 0 0.002 0.002 0.002 0 0 0 0 B 0 B 0 B 1:03:08 PM USE quan_test (1) 1 0 0 0.003 0.003 0.003 0 0 0 0 B 0 B 0 B 1:02:08 PM