MySQL Processlist Log
Logging slow mysql queries
Usage:
> python myprofiler.py [options]
Options:
-h, --help Show this help message and exit
-o OUT, --out=OUT Write raw queries to this file.
-c CONFIG, --config=CONFIG Read MySQL configuration from. (default: '~/.my.cnf'
-s SECTION, --section=SECTION Read MySQL configuration from this section. (default: '[DEFAULT]')
-i INTERVAL, --interval=INTERVAL Interval of executing show processlist [sec]. (default:2.0)
-m MINTIME, --mintime=MINTIME Minimum query execution time [sec]. (default: 10)
Config File
Default dir: '~/.my.cnf'
[DEFAULT]
host=localhost
database=processos
user=smaruki_user
password=secret
Extra Dependencies pymysql