My site

[Jimmie]

Just wanted to let anyone who trades with my tgp, www.unclejimsporn.com, I am having SQL problems right now so things traffic wise are gonna be jacked up till I can get it fixed.... please bear with me on this issue. :cussing:

[Dichotomy]

Hmm... Jimmie
it just hit me - TTT has this "ttt_iplog" issue - that table is very lame and never gets reset. so eventually it kills server. after quite a time of eating up resources and slowing things down.

why not try installing new traffic drive there and trying it? if youre up to, let me know - need to change one file for ya there. at least TD runs smoothly so far on our host. Meading using it - ask him about it :)

ok, that was easy part. hard part is - can you get hand on your support and do tell them following -
please EMPTY ttt_iplog database in SQL!

somehow I feel that this should solve your SQL issue.

[fresh]

Hmm... Jimmie
it just hit me - TTT has this "ttt_iplog" issue - that table is very lame and never gets reset. so eventually it kills server. after quite a time of eating up resources and slowing things down.

why not try installing new traffic drive there and trying it? if youre up to, let me know - need to change one file for ya there. at least TD runs smoothly so far on our host. Meading using it - ask him about it :)

ok, that was easy part. hard part is - can you get hand on your support and do tell them following -
please EMPTY ttt_iplog database in SQL!

somehow I feel that this should solve your SQL issue.

Have you told eskimonen about it ? Maybe he can fix it in next TTT update...

[Mathew]

Have you told eskimonen about it ? Maybe he can fix it in next TTT update...


The next TTT update - TTT Nitro - is written by PPK, not Eskimoen.

And as far as I understand it doesn't have this problem, although I cannot warranty it.

About that ttt_iplog problem - I solved it by writing a cron script which drops ttt_iplog once in an hour.

(Also, when I was over Denmark I spoke with Eskimoen about that and he agreed that it's really needed. ttt_iplog in such form as it is was written for some need Choker had).

here is this script, apply it at your own risk:


<?
include("/hosts/www.domain.com/html/ttt-mysqlvalues.inc.php");
$conn = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db);

mysql_query("DELETE FROM ttt_iplog");

mysql_close($conn);
?>


of course, don't forget to use your own path in include statement.

and in the cron you must insert something like this:

5 * * * * root /usr/local/bin/php /home/admin/checks/ttt_ips.php


Hope this helps :)