MySQL Connection


# Check Connection
```typeshow status like '%CONNECT%';```
### Check process
```typeshow processlist;```
### check variable
```typeshow 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
```typeulimit -H -n4096ulimit -S -n4096```
### monitoring
```typemysqladmin -u root -p -i 1 processlistmysqladmin -u root -p -i 1 status```


![](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F9bb0a94a-5042-406f-bfef-b0197392612b%2FUntitled.png?table=block&id=2a57e04e-27d5-45ab-a769-d6bb99fd1e43&cache=v2)
> ![](https://www.notion.so/image/https%3A%2F%2Fs3-us-west-2.amazonaws.com%2Fsecure.notion-static.com%2F42f2154b-5f0e-4195-9d2d-00f3d5ef0299%2FUntitled.png?table=block&id=f0b05169-a6ae-44a7-8a9b-ade006fecbbe&cache=v2)

> - host 에서 monitoring
> - auto refreshing 도 가능
> 





