diff options
| author | Arun Isaac | 2022-07-01 20:13:04 +0530 |
|---|---|---|
| committer | Arun Isaac | 2022-07-01 20:13:04 +0530 |
| commit | 0386602e96a1774ce436e0d9263d40583328da79 (patch) | |
| tree | eefde10b191cbdac9dfd236af701e951c76ba743 /issues/systems/mariadb/cleanup.gmi | |
| parent | 2f84a722e5944bd4458abbd45fd637a9286bab04 (diff) | |
| download | gn-gemtext-0386602e96a1774ce436e0d9263d40583328da79.tar.gz | |
Rescue issues lost in the topics/systems/mariadb directory.
Diffstat (limited to 'issues/systems/mariadb/cleanup.gmi')
| -rw-r--r-- | issues/systems/mariadb/cleanup.gmi | 43 |
1 files changed, 43 insertions, 0 deletions
diff --git a/issues/systems/mariadb/cleanup.gmi b/issues/systems/mariadb/cleanup.gmi new file mode 100644 index 0000000..0639e40 --- /dev/null +++ b/issues/systems/mariadb/cleanup.gmi @@ -0,0 +1,43 @@ +# Clean Up + +## Tags + +* assigned: pjotrp, robw +* status: unclear +* priority: unclear +* type: database administration +* keywords: database, mariadb + +## Description + +Find all larger tables + +``` +SELECT TABLE_SCHEMA,TABLE_NAME,DATA_LENGTH FROM information_schema.TABLES WHERE DATA_LENGTH>10000; +``` + +The following four 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 | ++--------------+----------------------+-------------+ +| db_webqtl | TraitMetadata | 16384 | +| db_webqtl | ProbeSetSE | 24177016832 | +| db_webqtl | metadata_audit | 49152 | +| db_webqtl | mytest1 | 1567621120 | +| db_webqtl | ProbeSetXRef | 2836398080 | +| db_webqtl | GeneInfo | 23642112 | +| db_webqtl | mytest2 | 56524537856 | +| mysql | transaction_registry | 16384 | +| mysql | innodb_index_stats | 16384 | +| mysql | innodb_table_stats | 16384 | +| 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 +``` |