-
Notifications
You must be signed in to change notification settings - Fork 1
Open
Description
We should clear out old job logs that we no longer care about rather than retaining them forever.
These use up a significant amount of space for no reason.
mysql> SELECT table_schema as `Database`, table_name AS `Table`, round(((data_length + index_length) / 1024 / 1024), 2) `Size in MB` FROM information_schema.TABLES WHERE `table_schema` = 'dnsapi' ORDER BY (data_length + index_length) DESC;
+----------+----------------------+------------+
| Database | Table | Size in MB |
+----------+----------------------+------------+
| dnsapi | joblogs | 2467.67 |
| dnsapi | jobs | 63.58 |
| dnsapi | records | 1.70 |
| dnsapi | zonekeys | 1.53 |
| dnsapi | domains | 0.09 |
| dnsapi | userdomaincustomdata | 0.08 |
| dnsapi | twofactordevices | 0.08 |
| dnsapi | apikeys | 0.05 |
| dnsapi | usercustomdata | 0.05 |
| dnsapi | domainkeys | 0.05 |
| dnsapi | twofactorkeys | 0.05 |
| dnsapi | users | 0.03 |
| dnsapi | job_depends | 0.03 |
| dnsapi | domainhooks | 0.03 |
| dnsapi | domain_access | 0.03 |
| dnsapi | permissions | 0.02 |
| dnsapi | __MetaData | 0.02 |
| dnsapi | blockregexes | 0.02 |
| dnsapi | articles | 0.02 |
+----------+----------------------+------------+
19 rows in set (0.05 sec)
mysql>
Metadata
Metadata
Assignees
Labels
No labels