FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » InnoDB instead of MyISAM
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
InnoDB instead of MyISAM [message #161069] Thu, 12 November 2009 16:04 Go to next message
eclipsewebmaster is currently offline  eclipsewebmaster   Canada
Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada
Karma: 0
Member
add to buddy list
ignore all messages by this user
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
Re: InnoDB instead of MyISAM [message #161070 is a reply to message #161069] Thu, 12 November 2009 16:09 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I've converted my forum's 'fud30_ses' table to InnoDB and it works quite well. This is documented in the Performance tuning guide.
Re: InnoDB instead of MyISAM [message #161071 is a reply to message #161070] Thu, 12 November 2009 16: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
add to buddy list
ignore all messages by this user
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).
Re: InnoDB instead of MyISAM [message #161073 is a reply to message #161071] Thu, 12 November 2009 16:29 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
None that I'm aware off.
Re: InnoDB instead of MyISAM [message #161074 is a reply to message #161073] Thu, 12 November 2009 16: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
add to buddy list
ignore all messages by this user
Great, thanks for your help!

Would you know if support for MySQL database slaves is planned?
Re: InnoDB instead of MyISAM [message #161083 is a reply to message #161074] Fri, 13 November 2009 00:02 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Thu Dec 14 23:31:23 EST 2017

Total time taken to generate the page: 0.00732 seconds