mysql> set global general_log=on;
Query OK, 0 rows affected (0.00 sec)
mysql> set global log_output='file';
Query OK, 0 rows affected (0.00 sec)
mysql> set global general_log_file='/home/bos/mysql/data/general_log.log';
Query OK, 0 rows affected (0.01 sec)
mysql>
'Database > MySQL' 카테고리의 다른 글
purge binary logs statement (0) | 2020.11.17 |
---|---|
@@GLOBAL.GTID_PURGED cannot be changed: the added gtid set must not overlap with @@GLOBAL.GTID_EXECUTED (0) | 2020.11.06 |
MySQL Procedure Privileges (0) | 2020.11.04 |
HAProxy 를 이용한 read / write split 및 failover (0) | 2020.06.03 |
replication 관련 명령어 모음 (1) | 2020.05.07 |