Similar to: T349362
librenms database lives in m1
The syslog table is more than 800GB:
-rw-rw---- 1 mysql mysql 864G Jan 22 14:56 syslog.ibd
Approximate number of rows:
cumin2024@db2160.codfw.wmnet[mysql]> select n_rows from innodb_table_stats where table_name='syslog'; +------------+ | n_rows | +------------+ | 2787667314 | +------------+
Can we please truncate or delete things from it? We probably shouldn't be using a relational database for this sort of thing, but if we do, we should regularly clean up things? Maybe a cronjob or an alert for when it goes over...100GB?
At T349362#9267648 we discussed having just 15 days of retention, is that still the case? If it is, maybe we need to reduce it a bit further?