Optimizing or repairng MySql tables
 

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

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

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

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?

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

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

900

You may want to lower that limit.

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

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 [DATE]1233950573[/DATE] at [TIME]1233950573[/TIME] ---------------

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

what's your best setting to allow lynne?