Jump to content

converting to innoDB and optimization

Recommended Posts

To cut to the chase: if I wanted to convert my MariaDB to innoDB and optimize all my tables, is this something I would ask my VPS provider to do?  I thought I read somewhere that upgrading MariaDB would automatically switch to innoDB, but I find the whole matter slightly confusing so I thought I'd ask those in the know here. :)

I've already backed up my site so I'm ready to go with any changes.

Link to comment
Share on other sites

Hello :)

If your vps provider offer such support they may be able to help you but in most cases they don't offer software support....

For your tables you must convert them using a command like:

ALTER TABLE tablenamehere ENGINE = InnoDB;

Always get a backup before you do such operations :)

Then after that you must optimize your my.cnf config file for your new Innodb tables like the pool buffers and instances e.t.c

Keep in mind that Innodb is performing much better but you will need more space on your disk and for sure more ram also :)

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...