MySQL Forums
Forum List  »  InnoDB

Switching to InnoDB, what I need to know?
Posted by: Funkr Jox
Date: January 01, 2016 12:18AM

So, I got this job as a sysadmin/dba and among other things I need to change a DB's engine from MyISAM to InnoDB.

I would be really greatful if somebody with more experience could outline or link to important things I need to know. This is a rather large DB (2.4GB) running on a VPS. I need to do:

1. Switch to InnoDB without messing things up
2. Optimize the server and DB for InnoDB

I can ofc read and google, but i'd love to have something like a checklist to make sure i'm not forgetting anything important.

Thanks a lot

Proud DBA at AHS

Options: ReplyQuote


Subject
Views
Written By
Posted
Switching to InnoDB, what I need to know?
1247
January 01, 2016 12:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.