I'm going to truncate the logs to get 12G back, but the real question is: how do I prevent this from happening? I have four very active cameras recording to an SSD (which has burned through about 30% of it's life in two years) and this has happened twice.
I would like to know how to configure zone minder to not eat the disk alive.
I thought I turned off mysql logging, btw, I'll have to change that option again...
Any help would be greatly appreciated.
Update: also, my event directory contains 307G of data, but according to the GUI, almost all recordings are gone... Is there a way to clean this up without blowing away my saved recordings?
Code: Select all
server /usr/share/zoneminder/www # du -h --max-depth=1 | sort -hr
307G ./events
307G .
120M ./temp
15M ./api
2.0M ./skins
1.1M ./lang
540K ./tools
520K ./images
280K ./includes
224K ./fonts
136K ./css
68K ./ajax
20K ./js
16K ./graphics
12K ./views
Code: Select all
MariaDB [zm]> SELECT TABLE_NAME, table_rows, data_length, index_length, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES WHERE table_schema = "zm";
+----------------+------------+-------------+--------------+------------+
| TABLE_NAME | table_rows | data_length | index_length | Size in MB |
+----------------+------------+-------------+--------------+------------+
| Config | 215 | 196608 | 0 | 0.19 |
| ControlPresets | 0 | 16384 | 0 | 0.02 |
| Controls | 19 | 16384 | 0 | 0.02 |
| Devices | 0 | 16384 | 0 | 0.02 |
| Events | 199 | 1064960 | 1540096 | 2.48 |
| Filters | 1 | 16384 | 0 | 0.02 |
| Frames | 77849389 | 3493855232 | 3437232128 | 6610.00 |
| Groups | 0 | 16384 | 0 | 0.02 |
| Logs | 62878423 | 11308892160 | 1315962880 | 12040.00 |
| MonitorPresets | 67 | 16384 | 0 | 0.02 |
| Monitors | 4 | 16384 | 0 | 0.02 |
| Servers | 0 | 16384 | 0 | 0.02 |
| States | 1 | 16384 | 49152 | 0.06 |
| Stats | 38715859 | 3074965504 | 1968701440 | 4810.02 |
| TriggersX10 | 0 | 16384 | 0 | 0.02 |
| Users | 1 | 16384 | 16384 | 0.03 |
| ZonePresets | 7 | 16384 | 0 | 0.02 |
| Zones | 5 | 16384 | 16384 | 0.03 |
+----------------+------------+-------------+--------------+------------+
18 rows in set (0.00 sec)