MySQL Connection

Check Connection

show status like '%CONNECT%';

Check process

show processlist;

check variable

show global variables like 'max_connections';
show global variables like 'open_files_limit';
show global variables like 'table_open_cache';
show global variables like '%timeout';
# global 안넣으면 console 에서 interactive로 나옴

check os nofile limit

ulimit -H -n
4096
ulimit -S -n
4096

monitoring

mysqladmin -u root -p -i 1 processlist
mysqladmin -u root -p -i 1 status

• host 에서 monitoring

• auto refreshing 도 가능