Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL Auto Optimize...


monte22

Recommended Posts

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

Link to comment
Share on other sites

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

"Politics is the art of preventing people from taking part in affairs which properly concern them"

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...