XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Big size mysql session
Register
1
verdult
Big size mysql session

  • 2010/6/30 15:25

  • verdult

  • Just popping in

  • Posts: 32

  • Since: 2008/11/29


my total mysql database is 77.7 MB and the sessions table is over 62,8 MB.

The sess_date is filled with protector_last_ip|s"xx.xxx.xx.xxx." Can I empty the sessions table? and how is it possible that this table is so big.
2
Peekay
Re: Big size mysql session

  • 2010/6/30 16:11

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Xoops version?

Protector version?
A thread is for life. Not just for Christmas.
3
Catzwolf
Re: Big size mysql session

  • 2010/6/30 17:03

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Yes you can empty the session table, there shouldn't be any problems doing so.
4
Peekay
Re: Big size mysql session

  • 2010/6/30 17:56

  • Peekay

  • XOOPS is my life!

  • Posts: 2335

  • Since: 2004/11/20


Thx Catzwolf. However, I would be interested to know if this is a possible problem with Xoops or Protector.

That kind of issue could freeze up a site if the host's DB size limit is exceeded.
A thread is for life. Not just for Christmas.
5
Catzwolf
Re: Big size mysql session

  • 2010/6/30 18:43

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Xoops should clear out old sessions when the time has expired, so I would point to this being an Xoops bug/issue. But, without having a proper look at this I couldn't be 100% positive that protector might not deal with its own sessions somewhere.

I will do some testing over the next few days and let you know one way or another.

ATB

John
6
ghia
Re: Big size mysql session

  • 2010/6/30 19:02

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


I think one reason can be an extended session time setting in the preferences for custom sessions.
Standard is 15 minutes, 1 hour should be a maximum.

Protector saves some high visibility data in the session variables, which then shows up in the data field of the table, but AFAIK does not create sessions.
7
verdult
Re: Big size mysql session

  • 2010/7/1 16:34

  • verdult

  • Just popping in

  • Posts: 32

  • Since: 2008/11/29


this is some info

XOOPS Version XOOPS 2.4.4
PHP Version 5.2.13
mySQL Version 5.1.44-log
Server API apache2handler
OS Linux
safe_mode Off
register_globals Off
magic_quotes_gpc On
allow_url_fopen On
fsockopen On
allow_call_time_pass_reference On
post_max_size 8M
max_input_time 60
output_buffering
max_execution_time 30
memory_limit 128M
file_uploads On
upload_max_filesize 8M


and protector version = 3.4


I cleared out the sessions table

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

221 user(s) are online (149 user(s) are browsing Support Forums)

Members: 0

Guests: 221

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits