My biggest problem was the mysql server running on windows platform and absence of nice utilities. On my luck windows has FindFirstChangeNotification Win32 API function. I have created small tool which listens a directory for changes and execute
SHOW FULL PROCESSLIST SHOW OPEN TABLES SHOW ENGINE INNODB STATUSResults will be written to console.
Usage MySql_Monitor.exe -h HOST -u USERNAME -pSOMEPASS -d DBNAME c:\tmp\WATCHED_DIR\
Example: MySql_Monitor.exe -h localhost -u root -p -d somedb c:\tmp\log\ > output.txt
You can take exe file or sources here.