knott Posted November 5, 2007 Posted November 5, 2007 Which I would be really happy with if I had loads of orders or I was adding lots of products - but neither! In 4 days my database backup has grown from 15mb to 19mb... a month ago my database was only 3mb. should I be concerned? If so, any clues as to whats causing this explosion in growth? many thanks
Jan Zonjee Posted November 5, 2007 Posted November 5, 2007 Which I would be really happy with if I had loads of orders or I was adding lots of products - but neither! In 4 days my database backup has grown from 15mb to 19mb... a month ago my database was only 3mb. should I be concerned? If so, any clues as to whats causing this explosion in growth? Aren't you the one who can take a look at that database? I have read once that someone had a very large table with session data. One way or another the old ones were not purged (is supposed to happen automatically). Don't know why that happened though.
♥geoffreywalton Posted November 5, 2007 Posted November 5, 2007 Hi Try useing phpmyadmin to see what is in each table. One of the database level displays shows the individual table sizes, so the problem one should stand out a mile. Enjoy Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>.
Avec Posted November 6, 2007 Posted November 6, 2007 One offending table is supertracker. If you use that contribution, your db will swell quickly.
knott Posted November 6, 2007 Author Posted November 6, 2007 Ah... found it - your right its sessions table... 14mb!! so what causes that - where is the code that is supposed to clear it down? is this being caused by search engines - I've been reading around but have come across confilicting advice as to whether I need osid killer
knott Posted November 13, 2007 Author Posted November 13, 2007 can anyone answer? I'm still unsure of where to look for a the faulty code for clearing up the session table. many thanks
and Posted February 14, 2010 Posted February 14, 2010 can anyone answer? I'm still unsure of where to look for a the faulty code for clearing up the session table. many thanks well, you question is pretty old, but maybe someone finds it helpful. Here a link for purging the sessions table: http://www.oscommerce.com/forums/topic/146031-clean-up-sessions-table/
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.