Optimizing or repairng MySql tables

[Lynne]

900 is the default which is 15 minutes. There are a couple of Scheduled Tasks which are supposed to be running that clear that session table based on that session timeout. So, assuming your scheduled tasks are running (which it looks like they are), I was thinking if you lower that limit, maybe your session table won't get so full. So, maybe try 600, or 10 minutes, and see if that makes a difference.

[youjoomla]

thank you much for your help , I will try that

[Dismounted]

Originally Posted by Lynne

session tables are heap/memory tables and thus you cannot repair/optimize them.

However, you can clear them.

[puertoblack2003]

Originally Posted by Dismounted

However, you can clear them.

by clearing them,you mean truncate the tables?

[Dismounted]

Yep, or you could restart the MySQL daemon, that would clear all the HEAP/MEMORY tables as well.

[youjoomla]

tried clearing few times end up with crashed table and dead forum

[Marco van Herwaarden]

I would not set the cookie timeout to a lower value then the default 900.