Hi
how can I decrease database
/var/lib/mysql/zm/Frames.ibd: 34G
/var/lib/mysql/zm/Logs.ibd: 584M
Just use Video Writer and no log
I have 2to of video with 2 mins longer
Is it normal ?
thanks
database very large Frames.ibd: 34G Logs.ibd: 584M
Re: database very large Frames.ibd: 34G Logs.ibd: 584M
Did you upgrade from 1.28 or earlier? See https://wiki.zoneminder.com/MySQL#IBData_files_Large
Having ibd files too large can be from having the earlier DB format, MyISAM. Starting from 1.32, ZM uses innoDB which should avoid this issue.
Having ibd files too large can be from having the earlier DB format, MyISAM. Starting from 1.32, ZM uses innoDB which should avoid this issue.
Code: Select all
In ZoneMinder 1.28, I had an issue with the ibdata1 file in /var/lib/mysql/ growing too large. It includes some database
information and in my 10GB root partition, was taking up 8GB. This was because the DB was not in InnoDB format.
Zoneminder 1.32 and newer, defaults to InnoDB, and this section can be ignored.
The solutions I found were:
backup zm database, delete zm db, delete ibdata file, then restore database How to Shrink/Purge Ibdata1 file
OR
Move the ibdata file to another partition
OR
Change DB type to InnoDB (requires backup, deletion, and restoring db, per first solution)
fastest way to test streams:
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl
If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide
ffmpeg -i rtsp://<user>:<pass>@<ipaddress>:554/path ./output.mp4 (if terminal only)
ffplay rtsp://<user>:<pass>@<ipaddress>:554/path (gui)
find paths on ispydb or in zm hcl
If you are new to security software, read:
https://wiki.zoneminder.com/Dummies_Guide