Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a PHP website, which is using the third-party software ResourceSpace, that when I installed it, it used my default storage engine to create the tables, which at the time was MyISAM. Now that the site has grown very large in size, I have started to see performance on my MySQL server slow down, and due to the intense queries that ResourceSpace runs, the site will start having issues loading pages due to very long running queries. When I login to MySQL, I will see multiple of the same queries running for very long amounts of time (300+ seconds), with most having the state of 'Waiting on table level lock'. The queries will never finish, and I either have to kill them, kill MySQL, or MySQL itself will completely crash. Has anyone ever seen behavior like this with this particular software or any PHP website in general?

Also, I am considering converting the engine on the tables over to InnoDB. I was wondering if there is any considerable risk with altering the tables and setting the engine to InnoDB?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

I altered each of the tables that was using MyISAM as the engine, and the query time greatly decreased. My site has also stopped locking up and responds much quicker during peek usage times.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.