FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » General » Database discussions » Turn off mysql statisk
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 		 Switch to threaded view of this topic Create a new topic Submit Reply
Turn off mysql statisk [message #160735] Sun, 18 October 2009 11:16 Go to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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 13:32 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
 add to buddy list
ignore all messages by this user
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 07:26 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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 09:43 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
 add to buddy list
ignore all messages by this user
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 09:49 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Germany
Messages: 70
Registered: June 2005
Karma: 0
Member
 add to buddy list
ignore all messages by this user
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 18:00 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3663
Registered: December 2004
Karma: 19
Senior Member
Administrator
Core Developer
 add to buddy list
ignore all messages by this user
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

Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Mon Jul 23 02:11:41 EDT 2018

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

Powered by: FUDforum 3.0.8.
Copyright ©2001-2018 FUDforum Bulletin Board Software