Check out the SMF Function DB!
Started by [Unknown], September 20, 2005, 04:31:53 PM
Quote from: Overseer on April 17, 2008, 04:38:27 PMyou shouldnt convert all.. didnt you read the post?
Quote from: AleXit on April 17, 2008, 03:22:19 PMI converted all my tables to InnoDB... everything goes ok except one bug:The order of my board are completely reverted, and I can NOT change it anymore.
Quote from: AleXit on April 17, 2008, 04:51:13 PMQuote from: Overseer on April 17, 2008, 04:38:27 PMyou shouldnt convert all.. didnt you read the post?Yes I read them but I would like to have better performances ...No one report corruption table issue, at most slowness...
Quote from: IchBin™ on April 17, 2008, 05:34:04 PMWhy not just restore to a backup before you made the changes? You did back up right?
Quote from: Motoko-chan on April 17, 2008, 06:17:15 PMYou can try converting back to MyISAM and doing what I suggested previously.
Quote from: Ben_S on April 17, 2008, 06:47:51 PMPretty much any not in the suggested list for InnoDB.
Quote from: groundup on September 20, 2005, 09:31:51 PMShould really use ENGINE instead of TYPE.
Quote from: Motoko-chan on January 26, 2008, 06:57:42 PMIt all depends on your board access patterns and your traffic. Heavy posting needs different optimization than heavy viewing.In general, INNODB works best for tables that have a lot of insertions, MyISAM is faster for tables that get a lot of SELECTs. Also, once you get heavier traffic, you need to increase the buffers for INNODB or you'll lose the advantage it gives.
Quote from: Sverre on April 25, 2008, 07:03:28 AMIf you are on a MySQL version which supports it, should all tables, whether you've converted them to InnoDB or not, be changed to use ENGINE?
QuoteI think I speak for a lot of SMF admins out there, or at least I hope I'm not the only one, when I say that a more detailed guide to help us identify the need to convert tables to InnoDB would be greatly appreciated.
Quote from: Ben_S on August 01, 2006, 05:57:38 AMEntirely upto you, you should do the search ones at the very least though.
Quote from: evgenydeep on September 07, 2008, 06:10:58 AMand for big forums this is MUST HAVE.