Help InnoDB

Discussion in 'Databases' started by khayerz, Jun 12, 2012.

0
  1. #1
    hi does anyone try convert MyIsam to Innodb on Wordpress?. how it work!!
     
    khayerz, Jun 12, 2012 IP
  2. kalseo

    kalseo Active Member

    Messages:
    733
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    80
    #2
    Back up database locally, import in your localhost phpMyAdmin and run the following commnad"

    mysql -u [USER_NAME] -p -e "SHOW TABLES IN [DATABASE_NAME];" | tail -n +2 | xargs -I '{}' echo "ALTER TABLE {} ENGINE=INNODB;" > alter_table.sql
    perl -p -i -e 's/(search_[a-z_]+ ENGINE=)INNODB/\1MYISAM/g' alter_table.sql


    Generally MyIsam consume less RAM compared to InnoDB, but InnoDB is a bit faster, I personally think that this is unnecessary operation for most blogs, keep it the way it is.
     
    kalseo, Jun 12, 2012 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    I use it on all my blogs unless the table needs full text indexing. We don't do any optimization for MyISAM so it makes sense for us to keep everything in InnoDB. Is there a specific reason you are looking to switch?
     
    jestep, Jun 13, 2012 IP
  4. khayerz

    khayerz Active Member

    Messages:
    111
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    50
    #4
    thanks mate.. this very helpful
     
    khayerz, Jun 13, 2012 IP
  5. khayerz

    khayerz Active Member

    Messages:
    111
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    50
    #5
    yes..use it on my social network site..
     
    khayerz, Jun 13, 2012 IP