Icy Phoenix

Hi all,
From my server wrote me that I have to do this but honestly i have no idea how to do it :S

We found that the following tables have large numbers of rows:

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
elarte_detorear
ip_sessions_keys 55722
ip_topic_view 443563
ip_referrers 465171
ip_search_wordmatch 594896
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Please reduce these to less than 50k rows and either throttle or disable the software that is adding to them.

Can someone please help me?

Thank you very much!! :)

you could clean the referers table via ACP

search wordmatch table can be reconstructed aswell by ACP-DB maintenence ( search index)

spydie wrote: [View Post]

you could clean the referers table via ACP

search wordmatch table can be reconstructed aswell by ACP-DB maintenence ( search index)

Thank you very much for your answer spydie!

I'm gonna try :)

EDIT:
I've tried to clean the table "ip_sessions_keys" in ACP - DB maintenance > DB maintenance : Restart all sessions and I can't see any difference :( It has the same size as before... 55722 :S

First of all, what version of IcyPhoenix are you using?

ACP - DB maintenance > IP MySQLAdmin

Check "ip_referrers" and select empty at the buttom of this page.
You can do the same with ip_sessions_keys

Give this a try and tell me.
Dont touch the other both... they are more complex.

I will explain later.

he´s running on 1.3.0.53b as far i know.

well that was last time i fixed some problems for him

The best you can do is empty referers and topic_views table... you can do manually in phpMyAdmin and you should then disable those features in ACP to prevent tables to be filled again.

Other tables you need them and I would not force them to be empty...