I need some help with resolving some mysql issues. My website had been running slow since last week and after contacting my host I found out that some queries were taking too long mainly because of table locks. I am a developer but no mysql/database expert. My host suggested that I either delete and/or change the two tables in question to innoDB. So as these tables had a lot of junk data I decided to delete a bunch of records. I would say that these two tables are about 25% of the size when this problem started. Problem is that, it still has not made any difference. So my questions:
- Do I need to clear cache or optimize table in order to see the effects? My host is still suggesting I change those tables to innoDB which is fine but I'm not sure why deleting that many records have not made a difference.
- Also I have read that it is better to recreate the table than just optimizing? If needed I can hire a database admin to help me but I would like to at least try a few things if this is something simple. Can someone please guide me through this.
One more important thing to add, it is a legacy website running on php 5.4 and mysql 5.6