Tables Conversion from MyISAM to INNODB

  • Hi Team,

    Need someone’s help / suggestion here to convert my wordpress website’s Database tables from MyISAM to INNODB.

    Currently I can see that only a few tables are INNODB & most of them are MyISAM.

    Is it any rule that few particular tables being used for Woocommerce / WordPress should be on MyISAM?

    I would like to take a backup of the entire database & convert each table through WP OPTIMIZE plugin & see if that helps.

    I have read somewhere that INNODB is much better than the MyISAM in terms of performance.

    Currently the website seems to be pretty slow even though we are using cloudflare.

    Thanks
    Shashikant

Viewing 6 replies - 1 through 6 (of 6 total)

  • Hello,

    Currently the website seems to be pretty slow even though we are using cloudflare.

    Converting MyISAM tables to InnoDB will not be a miracle, you can be sure of that.
    If your web hosting plan is very limited in terms of disk space, I recommend that you continue with MyISAM because InnoDB tables are usually larger.

    In any case, InnoDB is usually the most valued option. I would recommend that before making the change, you make a backup copy of your database in case you need to recover it after the change.

    • This reply was modified 3 years, 1 month ago by stfrosty.
    Thread Starter shashikant91

    (@shashikant91)

    Hi @stfrosty

    Thanks for your revert.

    Currently we are on a VPS with below specs.

    1. 8GB RAM
    2. 4 Core CPU
    3. 120GB SSD

    Website is on Woocommerce + Elementor with around 3000 products.

    Hello,

    So, try it.
    Each database engine has its advantages, however, InnoDB has proven to be more effective in recent years.
    Remember to make a backup copy of the database and files, in case you have any problems.

    Have a good day ??

    Thread Starter shashikant91

    (@shashikant91)

    Ok Thank you.

    Once last thing. If at all we face any issues after conversion, can we restore it with MyISAM again? Or do we need to restore the complete database backup?

    Hello,

    The most recommended option would be to use the backup.
    Anyway, I don’t think you will have any problem.

    Let me know if you need anything else or if you have problems ??

    Thread Starter shashikant91

    (@shashikant91)

    Sure. Thank you so much.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Tables Conversion from MyISAM to INNODB’ is closed to new replies.