blob: 0cbd0e78668831e6bef35a4831274cd9021c124c (
plain)
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
32
33
34
35
36
|
# MariaDB
Here we capture some common actions
## Tags
* type: info, documentation
* keywords: mariadb, systems
## Check the transaction logs
Start the client and:
```
MariaDB [db_webqtl]> show binary logs;
+-----------------------+-----------+
| Log_name | File_size |
+-----------------------+-----------+
| gn0-binary-log.000012 | 374532448 |
| gn0-binary-log.000013 | 933672549 |
| gn0-binary-log.000014 | 12774545 |
+-----------------------+-----------+
3 rows in set (0.001 sec)
```
To get a log
```
mysql -p -u webqtlout db_webqtl -e "SHOW BINLOG EVENTS IN 'gn0-binary-log.000014';"
```
To get a log with some stuff filtered out try
```
mysql -p -u webqtlout db_webqtl -e "SHOW BINLOG EVENTS IN 'gn0-binary-log.000014';" -r -s |grep -v -e "Access\|GTID\|INSERT_ID\|COMMIT\|Temp\|lastlogin\|LITERA\|flush\|ROLLBACK"
```
|
