I'm running Windows 2012r2 on a new server, with Plesk 12.5 and MySQL 5.6 installed.
There's a backup script which takes a DB dump and zips website data files that runs each day. However, it brings the server to a crawl while it runs - but more confusingly even after it has finished.
There are lots of cgi-php.exe processes (for PHP 7 and 5.6 under IIS) that shoot up to consume almost all of the CPU load, and they'll stay there until I restart MySQL... That's what I find so confusing. The MySQL CPU load is very low, but it fixes the php problem when restarting.
How can I begin to troubleshoot this problem? Is there something related to MySQL that could cause a backlog with PHP?