At my company we have a web application that deal with a lot of I/O within a second.
But as we installed new servers, I’m facing some real slowness on these queries that are being selected when it reaches above 100k+ records, which if I take a look at the process the database uses around 250% of it, which is pretty high. I tried configuring the my.cnf, but no luck again.
I would really appreciate if someone could help me on configuring on the right way the percona database.
Our server specs are:
Linux 2.6.32-5-amd64 on x86_64
Common KVM processor, 16 cores (VPS)
20 GB of RAM
The strange thing is that in our older server with more data in it, it selects faster, which is an older mysql version as well (not percona)
Thanks in advance.