LabTech Support Forums

Event Logs and Table Size

This forum is for discussion of MySQL database related issues.

Moderator: jware.connectwise

Event Logs and Table Size

Postby markr.comcity » Thu Feb 13, 2014 5:50 am

I ran into an issue where only 2 days were showing on my clients servers logs (in Labtech) although i have set the software to keep 31 days.

Labtech looked into it and found the EVENT.LOGS table has 100 Million Rows and about 50Gb, so this caused things not to work.

The Fix was to Truncate the table and then monitor for the most noise from a possible rogue client and go from there.


OK

All that is done, and we have noticed after 2 days, the Database has 10 million rows and is 5gb in size.

Anyone have a similar issue?

We are going to setup a template not to collect security logs on workstations, however it seems to defeat the purpose that the system cant handle the logs it needs.

after 2 days we have about 100 agents producing 20,000 logs and most of that is Security followed by System
markr.comcity
Newbie
Newbie
 
Posts: 17
Joined: Thu Jan 02, 2014 9:06 pm

Re: Event Logs and Table Size

Postby jmetzler.labtechsoftware » Mon Mar 10, 2014 11:05 am

Mark,

There are a lot of variables that could be in play in regards to eventlogs and table size, I will create a support ticket and review this matter with you.
jmetzler.labtechsoftware
Newbie
Newbie
 
Posts: 2
Joined: Thu May 30, 2013 12:01 pm


Return to MySQL Database

Who is online

Users browsing this forum: No registered users and 2 guests