diff options
Diffstat (limited to 'topics/systems/mariadb/cleanup.gmi')
| -rw-r--r-- | topics/systems/mariadb/cleanup.gmi | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/topics/systems/mariadb/cleanup.gmi b/topics/systems/mariadb/cleanup.gmi new file mode 100644 index 0000000..73085da --- /dev/null +++ b/topics/systems/mariadb/cleanup.gmi @@ -0,0 +1,27 @@ + + +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 | ++--------------+----------------------+-------------+ +| 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) + +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 |