Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Database growing rapidly


Guest

Recommended Posts

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

Link to comment
Share on other sites

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

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

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.

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

:-)

Monika

 

addicted to writing code ... can't get enough of databases either, LOL!

 

my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum

 

Interactive Media Award July 2007 ~ category E-Commerce

my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ...

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...