Mysql Mangement


### /etc/my.cnf.d
```type[mysqld]socket = /var/lib/mysql/mysql.sockmax_connections = 1800wait_timeout = 300interactive_timeout = 3600```


### /etc/security/limits.conf
```type# mysql open-filesmysql soft nofile 4096mysql hard nofile 4096```

> [MySQL open_files_limit 변경하기](http://minsql.com/mysql/mysql-open_files_limit-eb-b3-80-ea-b2-bd-ed-95-98-ea-b8-b0/)

> [mysqld 시작할 때 max_open_files 경고](https://softwiz.tistory.com/entry/mysqld-%EC%8B%9C%EC%9E%91%ED%95%A0-%EB%95%8C-maxopenfiles-%EA%B2%BD%EA%B3%A0)






