From 39af4b498376a837131d6cb3478ba610eb6f36b8 Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Tue, 28 Dec 2021 09:10:24 +0100 Subject: Move file --- topics/systems/mariadb.gmi | 35 ----------------------------------- topics/systems/mariadb/mariadb.gmi | 35 +++++++++++++++++++++++++++++++++++ 2 files changed, 35 insertions(+), 35 deletions(-) delete mode 100644 topics/systems/mariadb.gmi create mode 100644 topics/systems/mariadb/mariadb.gmi (limited to 'topics') diff --git a/topics/systems/mariadb.gmi b/topics/systems/mariadb.gmi deleted file mode 100644 index c2c927b..0000000 --- a/topics/systems/mariadb.gmi +++ /dev/null @@ -1,35 +0,0 @@ -# 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" -``` diff --git a/topics/systems/mariadb/mariadb.gmi b/topics/systems/mariadb/mariadb.gmi new file mode 100644 index 0000000..c2c927b --- /dev/null +++ b/topics/systems/mariadb/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" +``` -- cgit v1.2.3