Home › Building Your Website › Web Database Development

MySQL - different table types?

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...

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

druagord's picture

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

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.