Optimizing or repairng MySql tables

[youjoomla]

Hello , I have tested on live server for few months and where never able to go live with transfering 30000 users since my DB is crashing and every attempt to repair or optimize the tables in question( all sessions tables) results in

The storage engine for the table doesn't support optimization or
The storage engine for the table doesn't support repair ,
php 5.2.8
Mysql 5.0.67

yesterday I downloaded the latest Vb version installed on local server wamp , brand new install no posts , and same issue

php 5.2.8
Mysql 5.0.51b

could you please advise ,

thnx

[Lynne]

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

[youjoomla]

so if the host has a limit on Mysql DB overage there is nothing I could do the site will kepp crashing untill I change host correct ?

thank you for the imfo

[Lynne]

You are reaching your size limit for you mysql database and that is causing your site to go down? Why don't you ask your host about increasing the size of the database limit?

[youjoomla]

the limit is on table overage only and they do not increase it , I must go dedicated

[Lynne]

What do you have your session timeout set to (vboptions > cookies > session timeout)?

[youjoomla]

900

[Lynne]

You may want to lower that limit.

Are you sure the cron jobs are running and are emptying the session tables?

[youjoomla]

I think that corns are disabled , where do I go again to enable them , did this 6 months ago, what should I lower the limit to ?

--------------- Added 1233950573 at 1233950573 ---------------

fund them , all these are enabled

05 * * * * Hourly Cleanup
This script performs various cleanup tasks once per hour.
Today
08:05 PM

05 * * * * vBSEO Update Service
Update services with new threads.
Today
08:05 PM

10 * * * * Attachment Views
This script updates attachment views once an hour if the delayed attachment views option is enabled. This is suggested for forums with a large number of attachments or users.
Today
08:10 PM

15 * * * * Restore Temporarily Banned Users
This script restores the access of temporarily banned users once an hour.
Today
08:15 PM

20, 50 * * * * Infractions Cleanup
Removes expired infractions twice an hour.
Today
08:20 PM

20 * * * * Hourly Cleanup #2
This script performs various cleanup tasks once per hour.
Today
08:20 PM

25 * * * * User Promotions
This script performs usergroup promotions once per hour.
Today
08:25 PM

56 * * * * Thread Views
This script updates thread views once per hour. This option is suggested for forums with large numbers of threads or users.
Today
08:56 PM

00 0 * * * Daily Statistics Log
This script updates forum stats once per day. These are the stats that are accessed from the Admin Control Panel (New Users, New Threads, New Posts, Active Users).
02-07-2009
07:00 AM

02 0 * * * Daily Digest
This script sends out new post and new thread digests once per day.
02-07-2009
07:02 AM

10 0 * * * Daily Cleanup

[puertoblack2003]

What do you have your session timeout set to (vboptions > cookies > session timeout)?


what's your best setting to allow lynne?

[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]

session tables are heap/memory tables and thus you cannot repair/optimize them.
However, you can clear them. :)

[puertoblack2003]

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.