PDA

View Full Version : Online visitors count gets restarted!


quitsmoking
18 Jun 2008, 22:22
I have a weird problem which is that between 22:00 and 01:00, the number of online visitors gets restarted like twice. It stays around 2000 but suddenly I get kicked out of the admin area and the online counter starts over from zero!

Any idea what the possible reasons could be? There are no mysql or apache error logs during this period at all.

Thank you.

ssslippy
19 Jun 2008, 02:49
Would you happen to have a repair or optimize tables running on cron?

geevest.com
19 Jun 2008, 03:13
quitsmoking ur problem like me :)
u can check my thread in general vbulletin discuss.

hope u can fixed ur issue.

quitsmoking
19 Jun 2008, 07:35
Would you happen to have a repair or optimize tables running on cron?
Yes I did. And this did not stop the problem.

@geevest.com: I am at liquidweb too :)

Dismounted
19 Jun 2008, 08:45
MySQL could have been restarted, which would have dumped the session database. Check the MySQL uptime.

quitsmoking
19 Jun 2008, 09:03
mysql was not restarted. The uptime shows the same uptime of the server!
Thank you.

--------------- Added 1213864283 at 1213864283 ---------------

I investigated for a while and I found that the type of these tables:
session
cpsession
is different from the other tables. They are HEAP (MEMORY) so that they run faster. What could be happening to them or their files? I need a mysql guru I guess.

Marco van Herwaarden
19 Jun 2008, 10:31
As stated before, HEAP (in memory tables) are emptied when MySQL is restarted.

quitsmoking
19 Jun 2008, 11:12
OK but since mysql uptime is not different from the server's, then mysql was not restarted. In fact, I investigated even more and I found that there is a reported bug that could be the same as my situation:
http://bugs.mysql.com/bug.php?id=19138

Therefore, I asked my server's company to upgrade mysql. I will see if it solves the problem and update you.