title: What could cause a MySQL database to be extremely slow?
body: <p>I'm trying to figure out why a MySQL database is abnormally slow on a live server. Deleting a row from a table (with only less than 100 rows) can take anywhere between 1 second and 20 seconds. I've checked the running processes and cannot see anything that would take out all the CPU or memory.</p>
  
  <p>Also the website is not launched yet so there's just me on it.</p>
  
  <p>In these conditions, what could be the reason for the database to be so slow? Is there any way to diagnose this kind of problem?</p>