Good Day,
I have reviewed your problem and I am certain I can handle this. MySql is a resource hungry application but when optimized properly, it can be managed without tempering with your server configuration but first of, I will start by examining your server configuration to be very sure that the task in which the server is required to handle can actually be handle by your current configuration.
If you are interested, contact me and I will get on it