FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » General » Database discussions » InnoDB instead of MyISAM
Show: Today's Messages :: Unread Messages :: 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
 remove from 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

Report message to a moderator

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: 3775
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
 remove from 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.

Report message to a moderator

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
 remove from 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).

Report message to a moderator

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: 3775
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
 remove from buddy list
ignore all messages by this user
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 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
 remove from buddy list
ignore all messages by this user
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 00:02 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3775
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
 remove from 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

Report message to a moderator

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 Apr 17 23:48:56 EDT 2025

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

Powered by: FUDforum 3.2.0.
Copyright ©2001-2025 FUDforum Bulletin Board Software