FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » General » Database discussions » InnoDB instead of MyISAM
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
InnoDB instead of MyISAM [message #161069] Thu, 12 November 2009 21:04 Go to next message
eclipsewebmaster is currently offline  eclipsewebmaster   Canada
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
My MySQL database server defaults to creating MyISAM tables. This doesn't work well for a very busy forum for all the table locks. Does anyone know if fud will work properly if I convert all the tables to InnoDB?

I Googled it up and couldn't find anything interesting about this.

Thanks

Report message to a moderator

Re: InnoDB instead of MyISAM [message #161070 is a reply to message #161069] Thu, 12 November 2009 21:09 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
I've converted my forum's 'fud30_ses' table to InnoDB and it works quite well. This is documented in the Performance tuning guide.

Report message to a moderator

Re: InnoDB instead of MyISAM [message #161071 is a reply to message #161070] Thu, 12 November 2009 21:13 Go to previous messageGo to next message
eclipsewebmaster is currently offline  eclipsewebmaster   Canada
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
Indeed, I already had converted my _ses table to InnoDB... I'm just wondering if there are any adverse effects to converting all the others (or, at the least, the ones that are always causing table locks).

Report message to a moderator

Re: InnoDB instead of MyISAM [message #161073 is a reply to message #161071] Thu, 12 November 2009 21:29 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
None that I'm aware off.

Report message to a moderator

Re: InnoDB instead of MyISAM [message #161074 is a reply to message #161073] Thu, 12 November 2009 21:34 Go to previous messageGo to next message
eclipsewebmaster is currently offline  eclipsewebmaster   Canada
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
Great, thanks for your help!

Would you know if support for MySQL database slaves is planned?

Report message to a moderator

Re: InnoDB instead of MyISAM [message #161083 is a reply to message #161074] Fri, 13 November 2009 05:02 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Currently, no. However, if we get a patch, it will definitely be added.

PS: It should be easy to implement. Here's an example implementation: http://bakery.cakephp.org/articles/view/master-slave-support-also-with-mult iple-slave-support

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: the table file of mysql distroy 2 times in a week
Next Topic: Index command denied
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Nov 10 19:49:44 GMT 2024

Total time taken to generate the page: 0.05987 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software