MySQL: Innodb or MyIsam?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
kengreer Members Profile Find Members Posts Newbie Joined: 12 December 2006 Location: United States Status: Offline Points: 1	Post Options Post Reply Quote kengreer Report Post Thanks(0) Quote Reply Topic: MySQL: Innodb or MyIsam? Posted: 13 December 2006 at 12:10am
	The database initialization script for mySQL does not include a database table type, leaving it up to whatever the default is. What should I use? MyISAM or InnoDB?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 13 December 2006 at 9:05am
	I would use myIsam
	Web Wiz Forums Hosting ASP.NET Web Hosting

Skeever Members Profile Find Members Posts Newbie Joined: 25 February 2003 Location: Norway Status: Offline Points: 9	Post Options Post Reply Quote Skeever Report Post Thanks(0) Quote Reply Posted: 13 December 2006 at 2:48pm
	Borg, while on the subject of innodb and myisam. The SMF forum recommends to their users to convert some of the tables to innodb while leaving the others as myisam. To achieve best performance out of WWF it could be wise to create a list of what tables should be in innodb and etc... You can read more about this on the smf forum.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.