Mariadb transaction log

1 files changed, 35 insertions, 0 deletions

diff --git a/topics/systems/mariadb.gmi b/topics/systems/mariadb.gmi
new file mode 100644
index 0000000..c2c927b
--- /dev/null
+++ b/topics/systems/mariadb.gmi
@@ -0,0 +1,35 @@
+# MariaDB
+
+Here we capture some common actions
+
+## Tags
+
+* info
+
+## 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"
+```