I am looking to work with someone in fine tuning a dedicated server running mysql 5.
Right now, I am doing a load data in file database import / dump.
My server has a lot of RAM & hard drive space, good CPU too. However, I am only utilizing 3% of CPU resources. Therefore my MySQL commands to load a are taking too long to load. I am also suffering timeouts where the mysql data load in file command is hanging or taking too long.
I would like to utilize 90% of my server's resources for mysql.
I am experienced with mysql's regular commands if you'd like to walk me through the optimizations, or I can give access to the server for you to tweak it.
I would also like help with a simple mysql compare & search function, after we workout the CPU usage issues.