…Created_tmp_tablesblogpercona.commanual datadirblogpercona.commanual date_formatblogpercona.commanual datetime_formatblogpercona.commanual debugblogpercona.commanual debug_syncblogpercona.commanual debug_sync_timeoutblogpercona.commanual default…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…boolean values (yes/now or something similar) in the table…CREATE TABLE `cbool` ( `c1` char(0) default NULL, `c2` char(0) default NULL, `c3` char(0) default NULL, `c4` char(0) default NULL, `c5` char(0) default…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…boolean mode) group by group_id order by score desc limit 0,10; TABLE DESC ——————– CREATE TABLE `bp_search` ( `BOOK_ID` int(11) NOT NULL default ’0′, `GROUP_ID` varchar(128) default NULL, `IDENTIFIER` varchar(64) default…
Comment: Multiple column index vs multiple indexes
September 8, 2008 By 13 Comments
…table: CREATE TABLE `yellow_pages` ( `bid` int(11…default NULL, `website` varchar(50) default NULL, `phone` varchar(10) default NULL, `fax` varchar(10) default NULL, `latitude` decimal(10,6) default…des) against(‘”hotel*” ‘ in boolean mode) and ( longitude BETWEEN ….2) to connect to mysql(v5.02) but it…
