Icy Phoenix

Old Support Topics - Reduce The Numer Of Rows Of A Table

sebas_acci [ Mon 06 Feb, 2012 16:08 ]
Post subject: Reduce The Numer Of Rows Of A Table

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

spydie [ Mon 06 Feb, 2012 19:36 ]
Post subject: Re: Reduce The Numer Of Rows Of A Table

you could clean the referers table via acp

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

sebas_acci [ Mon 06 Feb, 2012 20:04 ]
Post subject: Re: Reduce The Numer Of Rows Of A Table

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

TheSteffen [ Thu 09 Feb, 2012 12:28 ]
Post subject: Re: Reduce The Numer Of Rows Of A Table

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.

spydie [ Thu 09 Feb, 2012 17:25 ]
Post subject: Re: Reduce The Numer Of Rows Of A Table

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

well that was last time i fixed some problems for him

Mighty Gorgon [ Tue 14 Feb, 2012 22:43 ]
Post subject: Re: Reduce The Numer Of Rows Of A Table

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