Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1

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

  2. #2
    Join Date
    May 2005
    Location
    England
    Posts
    626
    Plugin Contributions
    0

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

    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

  3. #3

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

  4. #4

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

  5. #5
    Join Date
    Oct 2006
    Posts
    5,477
    Plugin Contributions
    11

    Default 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.
    I no longer provide installation support on forum for all my modules. However, if there are real bugs with the modules please feel free to contact me

  6. #6

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

  7. #7
    Join Date
    Jun 2008
    Location
    USA
    Posts
    204
    Plugin Contributions
    1

    Default Re: Change Storage Engine ( MyISAM to/from InnoDB converter)

    Thanks for this addon!

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


  8. #8
    Join Date
    Jun 2007
    Location
    Texas, USA
    Posts
    1,400
    Plugin Contributions
    1

    Default Re: Change Storage Engine ( MyISAM to/from InnoDB converter)

    Quote Originally Posted by Meshach View Post
    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

  9. #9
    Join Date
    Jun 2008
    Location
    USA
    Posts
    204
    Plugin Contributions
    1

    Default Re: Change Storage Engine ( MyISAM to/from InnoDB converter)

    It's working great.


  10. #10
    Join Date
    Nov 2008
    Posts
    53
    Plugin Contributions
    0

    Default 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

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v155 zc_install failure: 1286: Unknown storage engine 'MyISAM'
    By lat9 in forum Installing on a Linux/Unix Server
    Replies: 10
    Last Post: 3 Jun 2016, 03:38 AM
  2. 1030 Got error 28 from storage engine in
    By cshart in forum General Questions
    Replies: 1
    Last Post: 21 Nov 2011, 04:40 AM
  3. 1030 Got error 28 from storage engine
    By jorsara in forum General Questions
    Replies: 2
    Last Post: 10 Mar 2010, 08:43 AM
  4. 1030 ERROR 127 from storage engine
    By marinaroos in forum General Questions
    Replies: 4
    Last Post: 24 Jun 2009, 01:36 PM
  5. error message 12 from storage engine
    By styrax in forum Basic Configuration
    Replies: 2
    Last Post: 4 Nov 2007, 03:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR