MyISAM is the default storage engine for MySQL. Unfortunately it doesn't support transactions or foreign keys (but it has some other nice features like compression). However, because InnoDB does support transactions and foreign keys you might want to change your tables from MyISAM to InnoDB storage-Engine

If you are not sure which storage engine you should use you should also have a look at this great site: http://www.mysqlperformanceblog.com/2009/01/12/should-you-move-from-myisam-to-innodb/ 

Step 1: check your my.cnf configfile

change this line

skip-innodb 

to

 
# skip-innodb 

now restart mysql:

# /etc/init.d/mysql restart

the location of the mysql start script depends on your Linux distribution and  mysql implementation.

Step 2: convert the table to InnodB

start the MySQL command-line interface, switch to your database and alter the table you want to convert:

mysql> ALTER table mytable ENGINE=Innodb;

• Add New
• Search

Comments (0)

Write comment

Your Contact Details:

Name:

Email: do not notifynotify

Website:

Comment:

Title:

UBBCode:         -color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge

Message:

Security

Please input the anti-spam code that you can read in the image.

Powered by !JoomlaComment 4.0 beta1

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."