1. 1
2. 2
3. 3
4. 4
5. 5
6. 6
7. 7
8. 8
9. 9
10. 10
11. 11
12. 12
13. 13
14. 14
15. 15
16. 16
17. 17
18. 18
19. 19
20. 20
21. 21
22. 22
23. 23
24. 24
25. 25
26. 26
27. 27
28. 28
29. 29
30. 30

//exit;

define("CACHE_USE", false);

require("/usr/home/<path_to_config>/config.php");
require_once(PATH_CLASSES . "/DB.Class.php");

DB::connect(DBHOST, DBUSERNAME, DBPASSWORD, DBNAME);

checkLongProcesses();
sleep(30);
checkLongProcesses();

function checkLongProcesses() {
	$pslist = DB::query("SHOW PROCESSLIST");

	if (sizeof($pslist) > 25) {

		mail("mysqlmonitor@some.domain", "SQL Processes Monitor Report", print_r($pslist, true));

		echo "Killing long queries...\n\n";
		foreach ($pslist as $el) {
			if ($el['Time']>10) {
				echo "Killing process: " . $el['Id'] . "\n";
				echo $el['Info'] . "\n\n";
				DB::query("KILL " . $el['Id']);
			}
		}
	}
}