database myisam instead of innodb

[maniot]

Hello

 

I've an old db running under ps 1.5.4.0. I noticed that it is myisam where all my other databases are innodb. Is this a problem or could it be problem when i want to upgrade to 1.5.6.2 or in the near future to 1.6.x ?

If so, is there anyone who can explain how change the database to innodb?

 

Reagards

 

maniot

[vekia]

 

If you want to convert a MyISAM table to InnoDB, the process is fairly easy, but you can do something extra to speed things up. Before converting the table, adjust its order so that the primary key column is in order:

 

ALTER TABLE tablename ORDER BY 'primary_key_column';

This will pre-arrange the table so that it can be converted quickly without a lot of re-arranging required in MySQL. Then, simply change the table engine:

 

ALTER TABLE tablename ENGINE = INNODB;

If your table is large, then it may take a while to convert it over. There will probably be a fair amount of CPU usage and disk I/O in the process.

[maniot]

Thanks Vekia,

 

I will try it out.

 

Regards,

 

Maniot

[Melinda]

Hi,

 

Is there any problem to converting all of the MyISAM tables to InnoDB after upgrading 1.5.0.6 to 1.6.0.5?

 

I know I would need to change the settings.inc file to InnoDB but how would I change all the tables to InnoDB in a database?

 

Thanks!