· 8 years ago · Aug 26, 2018, 08:40 PM
1Why is this table creation statement not resulting in the specified type?
2CREATE TABLE IF NOT EXISTS `mydb`.`mytable` (
3 `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
4 `updated` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
5 `created` DATETIME,
6 `deleted` TINYINT DEFAULT 0,
7 `notes` TEXT DEFAULT '',
8 `description` VARCHAR(100),
9 INDEX `deleted` (`deleted`)
10) TYPE=innodb;
11
12innodb additional mem pool size 1,048,576
13innodb autoextend increment 8
14innodb buffer pool awe mem mb 0
15innodb buffer pool size 8,388,608
16innodb checksums ON
17innodb commit concurrency 0
18innodb concurrency tickets 500
19innodb data file path
20innodb data home dir
21innodb doublewrite ON
22innodb fast shutdown 1
23innodb file io threads 4
24innodb file per table OFF
25innodb flush log at trx commit 1
26innodb flush method
27innodb force recovery 0
28innodb lock wait timeout 50
29innodb locks unsafe for binlog OFF
30innodb log arch dir
31innodb log archive OFF
32innodb log buffer size 1,048,576
33innodb log file size 5,242,880
34innodb log files in group 2
35innodb log group home dir
36innodb max dirty pages pct 90
37innodb max purge lag 0
38innodb mirrored log groups 1
39innodb open files 300
40innodb rollback on timeout OFF
41innodb support xa ON
42innodb sync spin loops 20
43innodb table locks ON
44innodb thread concurrency 8
45innodb thread sleep delay 10,000
46
47skip-innodb