Pima Posted January 5, 2009 Share Posted January 5, 2009 I just noticed that the table "tblticketmaillog" has over 2 million records. while actual real tickets are only about 50,000. I am supposing that as I have it set to only receive ticket opens from registered users that the excess is from those that are attempting to SPAM the support@ and other addresses. Questions: 1. Have I missed some config setting to prevent these from being logged? 2. How can I effectively prune this table to only retain those that are vaild? Any insight is appreciated 0 Quote Link to comment Share on other sites More sharing options...
Redsign Posted January 5, 2009 Share Posted January 5, 2009 From your admin area: Utilities -> System Cleanup 0 Quote Link to comment Share on other sites More sharing options...
Gears Posted January 5, 2009 Share Posted January 5, 2009 Wow 2 million. Redsign is right though, just wanted to comment on your 2 million records. 0 Quote Link to comment Share on other sites More sharing options...
Pima Posted January 5, 2009 Author Share Posted January 5, 2009 Thank You Redsign I will do this and see what it get reduced to... Ace, Yeah so was I surprised to see that many!!!! 0 Quote Link to comment Share on other sites More sharing options...
VicToMeyeZR Posted January 5, 2009 Share Posted January 5, 2009 even if just spam, thats imppressive for shear numbers of people even wanted to specifically spam your site. 0 Quote Link to comment Share on other sites More sharing options...
Pima Posted January 6, 2009 Author Share Posted January 6, 2009 (edited) Thanks to Redsign's post and pointer I have cheked this table(tblticketmaillog), and it just contains a "log" of emails and the emails themselves. Clearing this table has reduced it to "0" for the time being and I will now know to monitor this in the future. As I have this set for only registered client email addresses I do not deal with the SPAM yet they auto hit the addy's by script I suppose And yes we are hit constantly by off-shore IP's trying to gain shell access among other unauthorized access. Fortunate that we have an appliance ahead of the servers to interceede these attempts Edited January 6, 2009 by Pima 0 Quote Link to comment Share on other sites More sharing options...
mtk Posted June 25, 2009 Share Posted June 25, 2009 From your admin area: Utilities -> System Cleanup is the data in that table important to something? my table got crashed, and we have far less users/tickets than that... after 30min of mysql-server work, the table got repaired and showed 3.5GB of size!!! 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.