You can use Pantheon's integrated reporting services with New Relic® Performance Monitoring to help isolate MySQL performance issues on your Drupal or WordPress sites. Review MySQL Troubleshooting with New Relic® Performance Monitoring to get a better understanding of what's happening with your queries. Next Steps Troubleshoot With New Relic® Performance Monitoring processlist WHERE user 'system user'\GĬopy the provided query in the output and run as instructed.
Mysql > SELECT GROUP_CONCAT (CONCAT ( 'KILL ' ,id, ' ' ) SEPARATOR ' ' ) 'Paste the following query to kill all processes' FROM information_schema.