MySQL 5.1

Hi,
I have DB on production where all tables are belongs to Myisam engine, I want to change them
to innodb engine. but i little hesitate to change them on production.
What are the things needs to be taken under consideration while performing this
activity on live. Are there some variables need to adjust.

Please advice.
Thanks
sitgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Bruce SmithSoftware Engineer IICommented:
Don't hesitate, just use precaution. Back-up your database and warn your users of a short downtime. Check out this article here (http://highervisibilitywebsites.com/convert-your-mysql-database-myisam-innodb-and-get-ready-drupal-7-same-time) as there are a few helpful tidbits for enhancing possible performance. I have altered a couple of databases recently and have not run into any problems. Just make sure you back the thing up in case you do happen to run into any issues.

Cheers
wolfgang_93Commented:
I would practice first on a development copy of the database on another server or
worse case would be on the production server. I would want to do a bit of performance
testing as well unless your users won't mind being a guinea pig.

Other notes:
-  I would not convert anything that is in the mysql database as that belongs to the
   system.
-  Not all MyISAM tables can be converted, particularly if a full text search index is
   associated with the table.
-  If you have large tables involved, the conversion will take some time. Make sure you
   plan an appropriately long enough conversion time.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sitgAuthor Commented:
This was really helpful
wolfgang_93Commented:
That you for the points. Just one comment to add. To convert from MyISAM to InnoDB
is easy. Just issue a command like this:
    alter table <tablename> engine=InnoDB

and MySQL will take care of all the rest, including dealing with any indexes associated
with the table. If you are not allowed to convert (remember my comment above that
not all MyISAM tables can be converted), MySQL will display a warning and will not
convert. Its that simple :-)
Bruce SmithSoftware Engineer IICommented:
Thanks, hopefully the transition went smoothly!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
MySQL Server

From novice to tech pro — start learning today.