user online sometimes disapear

[geevest.com]

hello,i have a problems with my users that was already online in my forum.and the problem is like this :
for example : right now the members that was online is totally ( 50members and 25guests ). sometimes i see in a few second that all my member online was dissapear / gone.and become just only for example = ( 2members and 1guests ).
everytime is always like this.is there anyone who can help my problems?
for the cookies time setting i setup to 3000. is there any problem / connecting with this?

thanks

[Lynne]

I had that problem at one time and it turns out the mysql was restarting itself and thus the session table was cleared. Have you looked at your logs to see if that is the case?

[geevest.com]

Lynne i must repair my database forum or what?

[Marco van Herwaarden]

Most likely cause is what is mentioned in post #2: The MySQL server was restarted. contact your host to find more information on this.

[Lynne]

geevest.com, it was not a matter of repairing the database. I had just moved our forums over to a new mysql server running mysql 5 and apparently there were some changes made where it did not like it if some values were set incorrectly. Here is what was in my mysql error log:

blah blah blah
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.

key_buffer_size=402653184
read_buffer_size=2093056
max_used_connections=361
max_connections=800
threads_connected=25
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 3666809 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

blah blah blah

I had to play around with the values for key_buffer_size, read_buffer_size, etc until that 'equation' was satisfied for our amount of memory (which at that time was only 2 GB).

You may want to go to vb.com and post in their Server forum for eva to take a look and make suggestions on what values to use. There is a thread at the top of the forum telling you all the necessary information, but also make sure you tell him what the symptoms are. I would look in your logs though to see if mysql is restarting itself though.

[geevest.com]

lynne can u help me i want check log my sql in where? thx

[Lynne]

I don't know how much I can help you to find your logs, I just know where mine are. I have a separate mysql server and the log is located in /var/lib/mysql and is named "www.mysite.org.err".

[geevest.com]

from my hosting.

Dear Customer,

Please note that since you are on shared hosting, we are forced to restart MySQL as soon as there is a threat for the server's stability. However, we do not restart it very often.

Also, as a shared server customer, you will not be able to edit the values for key_buffer_size, read_buffer_size, etc.

All this will be possible for you on a dedicated server.

Also, please let us know why you chose to set your cookies time setting to 3000? Was this a recommendation of vbulletin support?



Best regards,

Kate
Customer Support
Velcom.com

[Lynne]

You should be able to set your cookie setting within vbulletin. I'm not sure what cookie setting you are asking your host to reset.

Did you ask your host if there is a way for you to find out if/when they restart mysql? If they are restarting it, then there is nothing you can do about it (well, except have your own dedicated server where *you* get to decide when it is restarted). I got the impression from your first post that this was happening often.