Centova Technologies Forum

Centova Cast v3 => General discussion => Topic started by: kahfluie on March 27, 2020, 12:16:16 pm

Title: Database Size
Post by: kahfluie on March 27, 2020, 12:16:16 pm

As time goes on I noticed the database file gets very large.

Is there a way to trim that down... perhaps remove some of the older information?

We've already had a problem where our MYSQL crashed because there was not enough room on the server. There was plenty, but I guess wherever the database stores itself was at its limit.

This resulted in some parts of the database needing repair.

So - can the file size be trimmed down without hurting anything? If yes, how?

Thank,
Louis

Title: Re: Database Size
Post by: scysys on April 02, 2020, 06:04:53 am

Quote from: kahfluie on March 27, 2020, 12:16:16 pm

As time goes on I noticed the database file gets very large.

Is there a way to trim that down... perhaps remove some of the older information?

We've already had a problem where our MYSQL crashed because there was not enough room on the server. There was plenty, but I guess wherever the database stores itself was at its limit.

This resulted in some parts of the database needing repair.

So - can the file size be trimmed down without hurting anything? If yes, how?

Thank,
Louis

Really to large or an error with your database itself? I have an installation here with more than 1 million listeners a month. Sure the database gets bigger over the time, but theire is nothing thats crash! The only thing is that the reports are not loading on first access. But thats an other error which i already have reported.

If you want to trim your database size, you can delete anything that has to do with statistics. But only do this when you know what you are doing and always make backups before you working on your installation.

Title: Re: Database Size
Post by: Dr Bunsen on May 07, 2020, 04:31:17 pm

Quote from: kahfluie on March 27, 2020, 12:16:16 pm

As time goes on I noticed the database file gets very large.

Is there a way to trim that down... perhaps remove some of the older information?

We've already had a problem where our MYSQL crashed because there was not enough room on the server. There was plenty, but I guess wherever the database stores itself was at its limit.

This resulted in some parts of the database needing repair.

So - can the file size be trimmed down without hurting anything? If yes, how?

Thank,
Louis

The bulk of that data is listener statistics. And personally I purge all old records from that table from 12am 1st January each yeah. Good luck.