summaryrefslogtreecommitdiff
path: root/topics
diff options
context:
space:
mode:
authorPjotr Prins2022-02-02 05:03:52 -0600
committerGitHub2022-02-02 05:03:52 -0600
commit74c7a963771a558ad051906c7aebf3d3a975847e (patch)
treea0488fa16352a19207c311f92d3e45962e00ecc9 /topics
parent0dfd2f44154b7676daaefaaa032da0dd835d8ccc (diff)
downloadgn-gemtext-74c7a963771a558ad051906c7aebf3d3a975847e.tar.gz
Update cleanup.gmi
Diffstat (limited to 'topics')
-rw-r--r--topics/systems/mariadb/cleanup.gmi6
1 files changed, 6 insertions, 0 deletions
diff --git a/topics/systems/mariadb/cleanup.gmi b/topics/systems/mariadb/cleanup.gmi
index 73085da..2222654 100644
--- a/topics/systems/mariadb/cleanup.gmi
+++ b/topics/systems/mariadb/cleanup.gmi
@@ -2,10 +2,13 @@
Find all larger tables
+```
SELECT TABLE_SCHEMA,TABLE_NAME,DATA_LENGTH FROM information_schema.TABLES WHERE DATA_LENGTH>10000;
+```
The following 4 mysql tables live in
+```
MariaDB [mysql]> SELECT TABLE_SCHEMA,TABLE_NAME,DATA_LENGTH FROM information_schema.TABLES WHERE ENGINE = 'InnoDB';
+--------------+----------------------+-------------+
| TABLE_SCHEMA | TABLE_NAME | DATA_LENGTH |
@@ -23,5 +26,8 @@ MariaDB [mysql]> SELECT TABLE_SCHEMA,TABLE_NAME,DATA_LENGTH FROM information_sch
| mysql | gtid_slave_pos | 16384 |
+--------------+----------------------+-------------+
11 rows in set (0.008 sec)
+```
+```sh
for x in innodb_index_stats innodb_table_stats gtid_slave_pos transaction_registry ; do echo $x ; mysqldump -u webqtlout -pwebqtlout mysql $x > /export3/$x.sql ; done
+```