I moved a db from a personal machine to a VPS, mariadb to mysql, and now -
select count(*) from table_name;
calls are taking like 9 seconds.
Also a lot of other calls that used to take like 0.5 seconds now take 10. They're all calls that are under an index...
Can anyone please tell do you know are there any settings that are likely to alleviate this? I'm finding it hard to believe just 2.5 million records are causing this much slow down just because it's a VPS (4 gb ram, 2 cpus, should be respectable enough hd access)?
chrimony 0 points 11 months ago
Could be the VPS you are on is oversubscribed or just slow as fuck. Some things to try:
o Rent a machine for an hour or two from one of the cloud providers.
o Move to a dedicated host.
If you get the same performance by following the same steps as your original move, then it's a "you" problem.