I have a website that has some traffic.
My current issue is that MySQL consumes 100% CPU all the time, sometimes even more(from top -c).
Even tho the machine load is not high, mysql process shows as using 100% CPU.
I have upgraded the machine and even isolated Web Server and MySQL. Web Server is now on a dedicated server. MySQL is on another.
I have upgraded the hardware and both are now on SSD Discs, so it is now a hardware issue.
I have changed from mysql to mariadb, myisam to innodb and tried a lot of different settings on my.cnf. Ramdisk for tmp tables. Ran the mysql tuner perl script and all good. Load still high.
I need some *really* expert in MySQL to optimize the settings so it does not use so much CPU. I need find the root cause.
I also want to have nginx (php-fpm) optimized to my reality, basically a check on what might be possibly wrong on any nginx settings, because after the migration, I had to change some settings on php-fpm as the website sometimes used to hang.
But my main issue is on the MySQL(MariaDB). The Nginx is more to optimize, but it doesnt really look to have an issue.
Typo: it is NOT a hardware issue
29 freelancers are bidding on average $159 for this job
Hi The most likely the issue is in indexes. Queries optimization might be needed as well. I can do both. See my feedbacks from the previous projects in this field. All the best Alexei
Please provide some more details (is it custom software or some open source based? slow queries log? etc.) so then I could estimate time and effort needed for this task and adjust my bid accordingly.