ALTER TABLE t1 ADD COLU...ement PRIMARY KEY FIRST 1 0 0 10.251 10.251 10.251 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 11:18:07 AM ALTER TABLE t1 DROP PRIMARY KEY 1 0 0 1.279 1.279 1.279 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 11:18:07 AM ALTER TABLE t1 ENGINE = InnoDB 1 0 0 16.656 16.656 16.656 1,000,000 1,000,000 1,000,000 0 B 0 B 0 B 11:18:07 AM COMMIT 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:18:07 AM CREATE DATABASE quan_test 2 0 0 0.005 0.004 0.002 2 1 1 0 B 0 B 0 B 11:17:09 AM CREATE TABLE T1( dt dat... , PRIMARY KEY ( dt ) ) 2 0 0 0.008 0.005 0.004 0 0 0 0 B 0 B 0 B 11:17:09 AM CREATE view v10 AS SELE...` UNION ALL SELECT NULL 2 0 0 0.008 0.006 0.004 0 0 0 0 B 0 B 0 B 11:17:09 AM CREATE view v1000 AS SE...`a` , v10 `b` , v10 `c` 2 0 0 0.015 0.009 0.007 0 0 0 0 B 0 B 0 B 11:17:09 AM CREATE view v3 AS SELEC...L UNION ALL SELECT NULL 2 0 0 0.007 0.005 0.003 0 0 0 0 B 0 B 0 B 11:17:09 AM DELETE FROM t1 WHERE id = ? OR id = ? 2 0 0 0.044 0.043 0.022 2 2 1 0 B 0 B 0 B 11:18:07 AM DROP DATABASE IF EXISTS quan_test 2 0 0 0.021 0.015 0.010 8 4 4 0 B 0 B 0 B 11:17:09 AM INSERT INTO t1 SELECT N...M v1000 `a` , v1000 `b` [2 Table Scans] 2 0 0 1:03.180 53.375 31.590 2,000,000 1,000,000 1,000,000 0 B 0 B 0 B 11:17:09 AM REPLACE INTO t1 VALUES ( ? , NOW( ) ) 2 0 0 0.001 0.000 0.000 2 1 1 0 B 0 B 0 B 11:18:07 AM ROLLBACK SELECT @@session . auto_increment_increment 1 0 0 0.000 0.000 0.000 1 1 1 6 B 6 B 6 B 11:17:09 AM SELECT `a` . dt FROM t1...VAL ? MINUTE AND NOW( ) 1 0 0 0.012 0.012 0.012 1,769 1,769 1,769 41.46 KB 41.46 KB 41.46 KB 11:18:07 AM SELECT dt FROM t1 WHERE...TERVAL ? DAY AND NOW( ) 2 0 0 0.057 0.054 0.028 950,363 777,591 475,182 21.75 MB 17.8 MB 10.88 MB 11:18:07 AM SET @n = ? 2 0 0 0.001 0.001 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM SET AUTOCOMMIT = FALSE 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:18:07 AM SET NAMES latin1 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM SET autocommit = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM SET character_set_results = NULL 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM SET sql_mode = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM SHOW COLLATION [1 Table Scan] 1 0 0 0.001 0.001 0.001 126 126 126 4.32 KB 4.32 KB 4.32 KB 11:17:09 AM SHOW VARIABLES WHERE Va... ? OR Variable_name = ? [1 Table Scan] 1 0 0 0.002 0.002 0.002 18 18 18 545 B 545 B 545 B 11:17:09 AM START TRANSACTION 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:18:07 AM TRUNCATE TABLE t1 2 0 0 0.640 0.526 0.320 1,000,279 1,000,278 500,140 0 B 0 B 0 B 11:18:07 AM UPDATE t1 SET dt = ? WHERE id = ? 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:18:07 AM UPDATE t1 SET id = id - ? [1 Table Scan] 1 0 0 0.000 0.000 0.000 0 0 0 0 B 0 B 0 B 11:18:07 AM USE quan_test 2 0 0 0.001 0.001 0.000 0 0 0 0 B 0 B 0 B 11:17:09 AM