Database growing rapidly

[Guest]

Hi since 8 month my database is growing very rapidly. Previously it had around 4MB and grew by 100kB a month, now it is growing by >5MB a month and is already around 50 MB.

 

What happened?

 

Here is my Sessions settings:

Session Directory /tmp/

Force Cookie Use False

Check SSL Session ID True

Check User Agent True

Check IP Address False

Prevent Spider Sessions True

Recreate Session True

 

Is something here involved?

 

Here is my logging settings:

Store Page Parse Time false

Log Destination /var/log/www/tep/page_parse_time.log

Log Date Format %d/%m/%Y %H:%M:%S

Display The Page Parse Time false

Store Database Queries false

 

Could it have been the last statment of configure.PHP?

define('STORE_SESSIONS', 'mySQL');

 

Has anyone got a clue where the growing stuff is stored?

 

Thanks in advance

 

Michel

[♥Monika in Germany]

are you using tracking contribs like supertracker that save info in the database?

[♥Monika in Germany]

actually, log into phpmyadmin and check table sizes. On the table overview page, you should be able to see at a glance which table has grown that much.

[Guest]

actually, log into phpmyadmin and check table sizes. On the table overview page, you should be able to see at a glance which table has grown that much.

actually, log into phpmyadmin and check table sizes. On the table overview page, you should be able to see at a glance which table has grown that much.

 

I have done it with MS-Access.

It was the table Sessions. and the culprit was the "STORE SESSIONS=MySQL" in configure.php

After clearing the table and removing the MySQL from configure.php everything went right.

 

Maybe "someone" could find a way to limit the size of this Database by deleting olde records?

[♥Monika in Germany]

sessions should be cleaned up automatically ... if they do not, something's not ok