@Stevan

Thanks ;-) you're trying LOLZ and spending time.. My mistake was - it was actually Evan Winslow who made that one little comment that was ringing in me head that could have saved me valuable time. I did eventually find the post the hard way - search and search and search. However.. You win 1/2 hour of free consulting time from me. Just PM me your techie problem questions ;-)

ok ... i am not getting it right but to make this topic the last one on the Zillion series to give Descoop a break :)), i may explain a little about it.

i went to my Database using phpMyAdmin i found a lot off tables called ( elgg_system_log_1234567890 ) , actually 36 of them!

i asked is they are necessary ( as they are the Events logged by the system ) , or i can drop those tables from database, as they were making my database huge ( 57 mb ).

thanx to Descoophe replay that i can drop those table that have numbers after ( Like elgg_system_log_1234567890 BUT NOT elgg_system_log table ) to free some space in my database.

i guess it must be deleted in Automated bases, but its not !!!

@ Clyde K , i guess you are facing the problem , were your elgg site suddenly can not make a connection to the database, i face this twice, if that the case, i went to my phpmyadmin when that happen and try to login but it give me an error " too many connections " i asked my host ( godaddy ) he told me that i need to upgrade and that i am using " too many connections ". which i didn't understand, it fixed by it self two days later, i am not sure if this was a bug or hacking, i looked for answer here but i didn't find any myself.

@ alysami Yes...'too many processes running at the same time' (25 in my case) was the problem I found with not one single member logged in...and 2 MySQLs running also...more than I am allowed to have without switching to a more expense 'business class' of service.

After much searching, with no solution found, I finally posted a topic here and just got the same answers of "if you don't need them just get rid of them" and then no other answers about how to prevent it from happening over and over.  I posted in this topic because I saw another person with the same problem and said:

1) useful for what?

2) where do you delete them from?

3) how often?

and so far have not gotten an answer here either (although I think I'll be able to locate the files from what you have said) and the link listed above by Steven is just another one of those I found before with discussion but NOT ONE SINGLE PIECE OF ADVICE OR A SOLUTION.

So...The questions: Why would 2 MySQLs be running at all? and What for? Delete From Where? and How Often? regarding the log tables all still go unanswered (and my friends site still won't open).

(Sure seems someone would have made a plugin to get rid of those tables automatically by now .)

There are not currently plans to do this.  In general, I would only consider something planned if it is in Trac and slated for a particular milestone.

I should also add that I think this is a great idea, but we could also probably get away with throwing up the Elgg throbber.  A much easier fix that deals with 80% of the cases.

Tidypics 1.7 beta has it.

This comment was removed by an administrator because it contained advertising.