Notice
Recent Posts
Recent Comments
Link
«   2024/12   »
일 월 화 수 목 금 토
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
Tags more
Archives
Today
Total
관리 메뉴

투덜이 개발자

mysql log 로그 추적 본문

DataBase/MySQL

mysql log 로그 추적

엠투 2022. 1. 19. 12:48
반응형

mysql 로그 추적

MariaDB [(none)]> 
MariaDB [(none)]> show variables where Variable_name in ('version','log','general_log');
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| general_log   | OFF             |
| version       | 10.1.43-MariaDB |
+---------------+-----------------+
2 rows in set (0.00 sec)

MariaDB [(none)]> show variables like 'general%';
+------------------+------------+
| Variable_name    | Value      |
+------------------+------------+
| general_log      | OFF        |
| general_log_file | gmedia.log |
+------------------+------------+
2 rows in set (0.00 sec)

활성화 하기

MariaDB [(none)]> set global general_log=ON;
Query OK, 0 rows affected (0.02 sec)

MariaDB [(none)]> show variables where Variable_name in ('version','log','general_log');
+---------------+-----------------+
| Variable_name | Value           |
+---------------+-----------------+
| general_log   | ON              |
| version       | 10.1.43-MariaDB |
+---------------+-----------------+
2 rows in set (0.00 sec)

MariaDB [(none)]> show variables like 'general%';
+------------------+------------+
| Variable_name    | Value      |
+------------------+------------+
| general_log      | ON         |
| general_log_file | gmedia.log |
+------------------+------------+
2 rows in set (0.00 sec)

 

mysql 재시작

[root@gmedia sbin]# systemctl stop mysqld
[root@gmedia sbin]# ps aux | grep mysql
root     15454  0.0  0.0 112716   964 pts/2    R+   13:01   0:00 grep --color=auto mysql
root     28327  0.0  0.1 161244  4272 pts/0    S+   10:14   0:00 mysql -p
[root@gmedia sbin]# systemctl start mysqld
[root@gmedia sbin]# ps aux | grep mysql
mysql    15563 10.0  2.4 814940 94356 ?        Ssl  13:02   0:00 /usr/sbin/mysqld
root     15598  0.0  0.0 112716   960 pts/2    S+   13:02   0:00 grep --color=auto mysql
root     28327  0.0  0.1 161244  4272 pts/0    S+   10:14   0:00 mysql -p
반응형
저작자표시

'DataBase > MySQL' 카테고리의 다른 글

Mysql 프로시저,함수 생성 권한 주기  (0) 2022.02.03
MariaDB 윈도우10 설치  (0) 2022.02.03
mysqldump Unknown table 'COLUMN_STATISTICS' in information_schema (1109)  (0) 2021.12.07
[Mysql] 테이블 용량 확인  (0) 2021.12.02
[Ubuntu] MySQL 외부접속 설정하기  (0) 2021.06.04
'DataBase/MySQL' Related Articles more