I have a dedicated server, and my WHM says the server resources used is less than 15% for both CPU and memory. I am running a PHP/MySQL script that takes about an hour or two to run, and when I run it I can't use any other pages that use MySQL since that script is using all the MySQL resources.
I am wondering why MySQL isn't running the server resources to near 100%, and if that is as fast as MySQL can work, then does anyone know if it's possible to run multiple MySQL instances or do something to use more server resources?
My host suggested MySQL tuner, which I'll check out, but I'm really more interested in why the server resources aren't maxed out.
EDIT: I added a screenshot of my mysqltuner output. Might as well be in spanish lol.