Monyog Disk Space

[egezon]

I’m very new to MONyog.

 

I installed MONyog 3 days ago, but the sniffer.data file is about 24G, I think that is a lot. 

How do I purge the sniffer data manually? While MONyog is up and running, let’s say I decided to delete everything older than 8 hrs, is there any way to do that manually, not wait for ‘retention timeframe’?

 

I setup the ‘Data retention timeframe’ for sniffer from 3 days to 1 day, but the size didn’t go down. I’m expecting the MONyog to purge the data automatically after 1 day (if retention is set to 1 days), or is this something that we need to do it manually.

 

It’s very annoying to delete the server and re-add the server again just because I want to purge old data.

 

 

 

[egezon]

I tried 

 

PRAGMA integrity_check;

 

VACUUM;

 

The file size went down only 2G.

[egezon]

Any advice for disk space or mem/cpu requirements for up to 50 servers would be appreciated. 

 

I’m thinking to have poll time every 15-30sec, for 4-7 days of retention. 

For sniffer, every 1 sec, with 3 day retention.

[siddhant]

Hi,

 

MONyog purges data older than mentioned timeframe there. However, SQLite might have empty rows after purging, which can be fixed by clicking on the dropdown button next to the server in question and then clicking Rebuild database (ref. screenshot), where we use VACUUM for the said server’s data in the corresponding SQLite database. Since, you have already used VACUUM, it is only fair to assume that you are monitoring a very busy MySQL server.

 

The disk space taken up by the sniffer.data solely depends on your monitoring goals, environment, settings and application. To keep a check on the disk space used by sniffer.data file, you can increase the sniffing time interval and reduce the data retention timeframe. But still, this you will have to test/measure/profile yourself on your own environment.

 

 

You can visit the following link to MONyog Documentation for more information on data maintenance.

https://static.webyog.com/docs/MONyog/MONyog.htm#MONyog_MySQL_Monitor_Data_Maintenance.htm

 

If you have any other query please write back to us at [email protected]

[egezon]

Cool thank you very much!

 

Another quick question. Is there any way to add server automatically, is there any template/file that I can edit. Let’s say I want to add up to 50 servers, and onyl few variables are different (port, error log, etc). Can I script that somehow, to add those automatically. Or I need to add them on the GUI one by one?

 

Thanks alot!

[siddhant]

Hi,

 

Yes. You can easily do this using the MONyog API. Please follow the links below to understand on how to use the MONyog API.

 

https://static.webyog.com/docs/MONyog/The_MONyog_API.htm

 

https://static.webyog.com/docs/MONyog/Using_MONyog_MySQL_Monitor_API.htm

 

https://static.webyog.com/docs/MONyog/Additional_Parameters_for_API.htm

[Author]

Posts