Check out the SMF Function DB!
Started by [Unknown], September 20, 2005, 04:31:53 PM
Quote from: groundup on September 20, 2005, 09:31:51 PMShould really use ENGINE instead of TYPE.Probably would make log_online MEMORY/HEAP too (with some slight modifications)
Quote from: That's The Hacker to you on October 05, 2005, 09:36:59 PMI asked my host about InnoDB and he apparently has it disabled and said "it causes problems"... What's up with that?
Quote from: Bonk on October 11, 2005, 12:30:11 PMProbably the dramatically increased memory use and detailed configuration necessary in my.ini (my.cnf).
ALTER TABLE smf_attachmentsTYPE=MyISAM;ALTER TABLE smf_collapsed_categoriesTYPE=MyISAM;ALTER TABLE smf_log_actionsTYPE=MyISAM;ALTER TABLE smf_log_boardsTYPE=MyISAM;
DROP TABLE smf_log_floodcontrol;CREATE TABLE smf_log_floodcontrol ( ip char(16) NOT NULL, logTime int(10) unsigned NOT NULL default '0', PRIMARY KEY (ip), KEY logTime (logTime)) TYPE=HEAP;
Quote from: Webrunner on October 16, 2005, 06:35:41 AMThge same query but Type - MyIsam