| Oracle/MySQL 관련 게시판 |
|---|
| 2020/06/15(20:37) from 116.67.28.78 | |
| 작성자 : 주인장 | 조회수 : 2031 , 줄수 : 36 |
| [MySQL] general_log 설정 |
|---|
|
1. 실시간 설정 mysql> show variables like '%general%'; +------------------+--------------------------------------------+ | Variable_name | Value | +------------------+--------------------------------------------+ | general_log | OFF | | general_log_file | D:\APM_Setup\Server\MySQL5\data\Galaxy.log | +------------------+--------------------------------------------+ 2 rows in set (0.00 sec) mysql> set global general_log=on; Query OK, 0 rows affected (0.00 sec) mysql> show variables like '%general%'; +------------------+--------------------------------------------+ | Variable_name | Value | +------------------+--------------------------------------------+ | general_log | ON | | general_log_file | D:\APM_Setup\Server\MySQL5\data\Galaxy.log | +------------------+--------------------------------------------+ 2 rows in set (0.00 sec) mysql> set global general_log=1; Query OK, 0 rows affected (0.00 sec) mysql> set global general_log=off; Query OK, 0 rows affected (0.00 sec) 2. 영구적 설정 my.cnf (my.ini) 편집 general_log = 1 |
|
|