FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » General » Database discussions » Turn off mysql statisk
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Turn off mysql statisk [message #160735] Sun, 18 October 2009 15:16 Go to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
Why turn off registered anonymous users in mysql table?

Report message to a moderator

Re: Turn off mysql statisk [message #160738 is a reply to message #160735] Sun, 18 October 2009 17:32 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Not sure what you're asking. Can you please provide more info?

Report message to a moderator

Re: Turn off mysql statisk [message #160795 is a reply to message #160738] Sat, 24 October 2009 11:26 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
Mysql table fud_ses is very large. I need alternative method count statictic anonimous users Rolling Eyes

Report message to a moderator

Re: Turn off mysql statisk [message #160801 is a reply to message #160795] Sat, 24 October 2009 13:43 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
FUDforum will automatically clean-up this table based on your SESSION_TIMEOUT and COOKIE_TIMEOUT settings (see Global Settings Manager).

Report message to a moderator

Re: Turn off mysql statisk [message #160803 is a reply to message #160801] Sat, 24 October 2009 13:49 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
I known after procedure "Forum Consistency", but this table very big and sql qwery to complite long time.

Report message to a moderator

Re: Turn off mysql statisk [message #160810 is a reply to message #160803] Sat, 24 October 2009 22:00 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
The table is cleaned-up every time a user logs in. Look at the code in login.php.t. To reduce the number of rows, you need to change SESSION_TIMEOUT and/or COOKIE_TIMEOUT to smaller values.

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: MSSQL to MySQL
Next Topic: the table file of mysql distroy 2 times in a week
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 10:47:55 GMT 2024

Total time taken to generate the page: 0.02188 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software