itnifl
asked on
Rotating log information that gets stored in a mysql database
I set up an rsyslog server that logs to mysql using this guide:
http://www.unixmen.com/install-and-configure-rsyslog-in-centos-6-4-rhel-6-4/
The database is stored on a 10GB Logical Volume that got filled up. I have added another disk to the Volume Group and extended the logical volume. Space is no longer an issue, but I would like to rotate the logging information logged in the mysql database so that the disk does not fill up again. What is the best approach in doing so?
This is how it looks like:
mysql> show tables;
+------------------------+
| Tables_in_rsysdb |
+------------------------+
| SystemEvents |
| SystemEventsProperties |
| logcon_charts |
| logcon_config |
| logcon_dbmappings |
| logcon_fields |
| logcon_groupmembers |
| logcon_groups |
| logcon_savedreports |
| logcon_searches |
| logcon_sources |
| logcon_users |
| logcon_views |
+------------------------+
13 rows in set (0.00 sec)
mysql>
http://www.unixmen.com/install-and-configure-rsyslog-in-centos-6-4-rhel-6-4/
The database is stored on a 10GB Logical Volume that got filled up. I have added another disk to the Volume Group and extended the logical volume. Space is no longer an issue, but I would like to rotate the logging information logged in the mysql database so that the disk does not fill up again. What is the best approach in doing so?
This is how it looks like:
mysql> show tables;
+------------------------+
| Tables_in_rsysdb |
+------------------------+
| SystemEvents |
| SystemEventsProperties |
| logcon_charts |
| logcon_config |
| logcon_dbmappings |
| logcon_fields |
| logcon_groupmembers |
| logcon_groups |
| logcon_savedreports |
| logcon_searches |
| logcon_sources |
| logcon_users |
| logcon_views |
+------------------------+
13 rows in set (0.00 sec)
mysql>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER