Change Storage Engine ( MyISAM to/from InnoDB converter)

[data_digger]

With this contribution You can with just one click change storage engine of Your database (well, not really database, but all tables in it) from MyISAM or InnoDB to InnoDB or MyISAM.

Change? Why the hell anyone would like to change MyISAM to InnoDB?
Good question. Because it's faster. You can read more here:
http://www.data-diggers.com/innodb_vs_myisam

You can download this contribution from:
http://www.data-diggers.com/contribs...ne_current.zip
It's not yet available from www.zen-cart.com since I just submitted it and it has not yet been reviewed.

Installation Instructions
Installation is very easy. This contribution does not overwrite any files, so You just have to copy&paste 'admin' directory.

[HeathenMagic]

Hello there,

This contribution looks really good. I noticed on our site, that we get the following error, at which point it stops doing its thing. Not sure if I can just change the FULLTEXT entries manually to get rid of the error.

1214 The used table type doesn't support FULLTEXT indexes
in:
[ALTER TABLE zen_configuration ENGINE = InnoDB]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Regards,

Heathenmagic

[data_digger]

I'm sorry, I completely forgot that InnoDB tables don't allow FULLTEXT indexes. I'll try to upload tomorrow new version of this contribution that will ignore tables with FULLTEXT indexes.

[data_digger]

Ok, v.1.1 is available from the same address:
Change Storage Engine v1.1

It'll ignore MyISAM tables with FULLTEXT indexes.

[yellow1912]

http://www.mikebernat.com/blog/MySQL_-_InnoDB_vs_MyISAM

Note note note: innodb uses 5 or 6 times more space than myisam

myisam is usually faster for "select", so some tables should stay the way they are now. Log tables etc should be converted to myisam.

[data_digger]

At least so it is said. In practice, all recent test I've seen show that InnoDB is faster in selects then MyISAM.
Have You found any tests that suggest that myisam outperforms innodb?
Also, I'm curious about this '5 or 6 more space' thing. I've checked my tables and innodb usually takes up to 50% more space.

As for log tables, one should consider Archive storage engine (introduced in MySQL 5) instead of MyISAM.

[Meshach]

Thanks for this addon!

It seems the site runs faster, possibly just psychological though.

[shrimp-gumbo-mmmhhh]

Originally Posted by Meshach

Thanks for this addon!

It seems the site runs faster, possibly just psychological though.

How is this working for you Meshack? Have you run into any problems? Anybody else convert over?

Shrimp

[Meshach]

It's working great.

[karimm]

Hello,

I recieve the following error when i click "change storage engine"

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLES WHERE Table_type LIKE 'BASE TABLE'' at line 1
in:
[SHOW FULL TABLES WHERE Table_type LIKE 'BASE TABLE']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

It this because the script is not compatible with my sql version ?

I use mysql 4.1.22
PHP 5.2.11

Any suggestions ?

Regards,

Martijn