![mysql slow query 설정](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbmpP7d%2FbtrQZc4i2nP%2F98Pxs174MeKNhyQ6KQ1de1%2Fimg.jpg)
# DataBase/Mysql(MariaDB)2022. 11. 11. 08:05mysql slow query 설정
영구적적용 my.cnf 위치확인 [darksharavim]mysql --verbose --help | grep 'my.cnf' /etc/my.cnf ~/.my.cnf my.cnf설정 [mysqld] # slow query on = 1, slow query off = 0 slow_query_log = 1 # n초이상 걸렷을 경우 query_long_time = 5 # file이 아닌 table도 가능하며 # table로 할 경우 logfile경로 옵션 주석처리 log_output = file # defualt name = host_name-slow.log slow_query_log_file = /var/log/mysql/slowquery.log mysql service restart 한시적 적용 sessi..