Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

SQL Auto Optimize...


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.



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




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

Link to comment
Share on other sites


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

  • Create New...