I just installed AMP stack on a VPS. I logged in to mysql console and found out that queries were incredibly slow. A single update query, targeting 1 row in a table with ~200 rows took 0.5 seconds to complete (same query takes 0.001s to complete on my windows laptop).
I thought it's related to VPS not having enough resources, but after doing some benchmarks, namely I/O:
1073741824 bytes (1.1 GB) copied, 14.207 s, 75.6 MB/s avg-cpu: %user %nice %system %iowait %steal %idle 0.01 0.00 0.00 0.03 0.00 99.96
and a PHP benchark script, it seems there are no problems with resources. PHP benchmark script completed in 5 seconds, whereas it took my i7 laptop with SSD 17 seconds to complete.
Any ideas what might be wrong?