… to force MySQL to use a different index. Imagine our surprise when we tried a FORCE INDEX on (bar) or an IGNORE INDEX(uid) and…: CREATE TABLE `foo` ( `i` int(11) NOT NULL AUTO_INCREMENT, `update_date` datetime NOT NULL, PRIMARY KEY (`i`), KEY `i` (`i`,`update_date`) ) ENGINE=InnoDB…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Created_tmp_disk_tablesblogpercona.commanual Created_tmp_filesblogpercona.commanual Created_tmp_tablesblogpercona.commanual datadirblogpercona.commanual date_formatblogpercona.commanual datetime…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…date` datetime NOT NULL default ’0000-00-00 00:00:00′, `comment_date_gmt` datetime…InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) mysql> btw, if there is a smaller secondary index on the table, innodb…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
… MySQL‘s InnoDB becomes close to on par with the competition – in…, order_date datetime not null, last_updated timestamp not null default current_timestamp on …MySQL will create the following indexes: unique index on order_id index on item_type_id index on locale_id index on currency_id index on…
