Today I picked up a problem with MySQL CPU usage going through the roof.
After quite a bit of testing (*panic*) I finally found that it was only when I was accessed ASL Web.
More digging revealed that my tortix database tables are rather HUGE
alerts table has 1,550,979 rows
ARCHIVE_201201_alert 28,640,493 rows
ARCHIVE_201201_data 28,640,493 rows
data table has 1,550,977 rows
The entire tortix database has 61,063,084 rows
and is now 11.2 GiB
with a 2.5GiB overhead.
I am no expert, but I am sure that something has gone horribly wrong.
I have disabled logging on events lower than 3 for now try an limit the ever increasing rows.
Filtering the logs I can see 146454 events for the following Level 2 - ID 1002
sa1 abrtd: Corrupted or bad dump /var/spool/abrt/pyhook-2012-03-26-13:38:18-29470 (res:2), deleting
which related to a recent post I made here: http://www.atomicorp.com/forum/viewtopic.php?f=1&t=5811
Spamd Level 2 - ID 1002
Spamdyke Level 2 - ID 103505
Combined have 191346 events
Any suggestions (besides Napalm
) would be greatly appreciated.