I am trying to optimize our database tables. I have some sql skills, but complete newbie at db administration. Our db operations are pretty slow, and I have been assigned to review the storage engines and create indexes. So, here's the thing... Most of our tables are MyISAM. And most of the tables are used for both read and write, constantly. The tables are also very related, and most selects pull from at least 4 or 5 tables. After hours spent reading recent blog posts and stack exchange answers - looks like InnoDB would be the way to go.
But, our db is hosted, and after discussing briefly with our host about switching to InnoDB, he came up with the following complaints
- InnoDB is slower at most things
- InnoDB is hard to backup
- InnoDB only shines when you have complex joins on tables with udpates and inserts.
So here is my question - are his complaints valid? Should I only select a chosen few tables to convert to InnoDB, the ones with really complex joins?
Thanks
UDPATE
is my favourite SQL command, I use it every now and then :) 2. What does hard mean? Backing up InnoDB has its tools AFAIK.