MySQL - different table types?

You are viewing this site as a guest. Join our community to get your questions answered and share knowledge. Active members may advertise and ask for a website critique.

critical posted this at 15:45 — 29th May 2003.

They have: 46 posts

Joined: May 2002

Hi,

I'm in the process of teaching myself MySQL - running on a Red Hat Linux 7.3 server - using Perl scripts to interact with the database.

When should I use something other than the default table type? (which I believe is MyISAM)

When should I use an INNODB table? (which I believe has locking features)

Are the any real life examples you can mention of when you used something other than the default table type?

Thanks...

Web Database Development

druagord posted this at 13:17 — 30th May 2003.

He has: 335 posts

Joined: May 2003

if you really need locking then use INNODB if you need fast tables you can use HEAP tables since they are kept in memory but you can loose data if the server crash. rest of the time use default. There are some advice on this in the mysql manual at mysql.com

IF , ELSE , WHILE isn't that what life is all about