SQL Auto Optimize...

[♥monte22]

Lately I have been having some problems with my sessions table. It seems after awhile it gets "full" and then causes errors on the site. When I go into PHP Admin and optimize it, it will work again.

 

So my question is, is there a way to have MySQL auto optimize the table so i dont have to keep doing it? Or is there something else wrong here that i am not seeing.

 

Any help would be appreciated.

 

James

[mattice]

if you have access to cronjobs (scheduled tasks on Windows I think?) you could have a simple

 

OPTIMIZE sessions;
REPAIR sessions;

 

executed every nn hours/days/whatever

 

Regards

Mattice

[♥monte22]

I can't do cron jobs with my server, is there any other way.

[defender39]

I would also be really interested in this.

 

Maybe it can be added to a file thats called or an if statement can be added somewhere that checks to see if the DB is not optimized. I would like to hear more on this subject.

[♥yesudo]

James - how long does optimising the table take ?

[defender39]

would this help if it was put into the /includes/sessions.php somehow?

 

http://us3.php.net/manual/en/function.dba-optimize.php

[♥yesudo]

http://www.oscommerce.com/forums/index.php?act=ST&f=20&t=90015

[♥monte22]

Thanks a lot!