…, `comment_karma` int(11) NOT NULL default ’0′, `comment_approved` enum(’0′,’1′,’spam’) NOT NULL default ’1′, `comment_agent` varchar…`), UNIQUE KEY `rajidx` (`rajid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> btw, if there is a smaller secondary index on the table, innodb is smart enough to use…
Comment: Innodb usability and ease of use.
October 4, 2007 By 14 Comments
The plug-in system available in MySQL 5.1+ permits the declaration of system variables as an ENUM which would easily allow defining variables, such as innodb_flush_logs_at_trx_commit, in a more human friendly way instead of just a number.
