diff options
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 +``` |