sessions, whos online and databases

[Rachael w.]

I have a couple of oscommerce sites. I am finding that the sessions and whos online tables are filling up and boiling over compacity. Is there a way to alter these tables so they dump every so often?

 

Thanks in advance for any assistance!

[Rachael w.]

Has anyone used this code suggested here?

 

http://www.oscommerce.com/forums/index.php?showtopic=146031

 

"Clean Up Sessions Table, Remove old sessions from database"

 

I think this may help, does anyone use this or some modification of this?

[Rachael w.]

I guess I'll try this code and see if it helps. I'm still very interested in how others have dealt with this problem.

[Rachael w.]

Well, this is what my whos online table looks like...notice the overhead. Is this something I should worry about? I checked this after deleting the contents of the table and these results are after just a couple visitors and some spiders.

 

Space usage:

Type Usage

Data 4,124 Bytes

Index 1,024 Bytes

Overhead 2,320 Bytes

Effective 2,828 Bytes

Total 5,148 Bytes

[sheepiedog]

Where did you add the code in includes/application_top ?

tep_db_query("delete from " . TABLE_SESSIONS . " where expiry < '" . (time()-2592000) . "'");

 

I am not really familiar with this, but it seems it should maybe have a bit of code before and after like a } or something ? Where in the file did you add it ?

[Rachael w.]

You are probably correct, I tried adding that line and then replacing the code and had errors.

 

I ended up just replacing the code and didnt put that extra line in.