Page 1 of 1

Databse getting really big what can I do about it?

Posted: Sat Jan 05, 2008 1:51 pm
by GenT
Hello,

I have been using UTstats for quite some time now and the database i getting very big. Its now 614 MB. And i do not have that mutch space left on the server.

Is it possible to delte the oldest stats or do I have to reinitialize the database completely. Starting with a clean one.

Hope there is a easy solution.

greetz,

Re: Databse getting really big what can I do about it?

Posted: Sat Jan 05, 2008 11:09 pm
by Panther

Re: Databse getting really big what can I do about it?

Posted: Sun Jan 06, 2008 2:10 am
by GenT
Its really not a problem with my operating system or anything..just a short and I think easy question.. And you did help others with easy questions without posting this :cry:.

Butt anyways here goes:

UTStatsDB version: utstatsdb-3.01 (I know old version butt again it runs and I have no problems with this version)
Operating system and version: Linux (donno what version... Butt again not the problem, because UTstats does run fine...)
Database type and version: MySQL versie 5.0.45
PHP version: PHP versie 5.2.4
Web server and version: ?? (No idea what you mean. Again it all works and I guess its standerd??)

Can i delete some things in the ut_gevents table? are these the parsed logs? And they start with match 1 all the way to 120.000 and more.. And also perhaps the ut_gscores table? These 2 are the biggest tables in the database.

Re: Databse getting really big what can I do about it?

Posted: Sun Jan 06, 2008 9:20 am
by Panther
For one thing different versions of UTStatsDB are configured differently.
Simply set "Max Matches" in your main config options to how many matches you want to keep and UTStatsDB will remove all older matches.

Re: Databse getting really big what can I do about it?

Posted: Sun Jan 06, 2008 9:32 am
by GenT
OK thank you found it, and works great thanks again :D