Change Storage Engine ( MyISAM to/from InnoDB converter)
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.
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
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.
Quote:
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:smile:
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
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.
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
Ok, v.1.1 is available from the same address:
Change Storage Engine v1.1
It'll ignore MyISAM tables with FULLTEXT indexes.
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
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.
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
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.
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
Thanks for this addon!
It seems the site runs faster, possibly just psychological though. :P
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
Quote:
Originally Posted by
Meshach
Thanks for this addon!
It seems the site runs faster, possibly just psychological though. :P
How is this working for you Meshack? Have you run into any problems? Anybody else convert over?
Shrimp
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
It's working great. :smile:
Re: Change Storage Engine ( MyISAM to/from InnoDB converter)
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