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)

____________
Out of Order

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.

____________
TheSteffen
Often SEARCH is the quickest way to get support.
IcyPhoenix German Support

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

well that was last time i fixed some problems for him

____________
Out of Order

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...

____________
Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON