DB table mrbs_sessions

[jberanek]

Hi

The table mrbs_sessions is around 400 mb, can I just empty this table?
Is there a setting so it doesn´t get taht big?

Version 1.7.3

/Bruno S

Reported by: *anonymous

Original Ticket: mrbs/support-requests/1945

[jberanek]

Yes, it's OK to empty it, but it shouldn't normally be getting that big. What have you got

session.gc_probability
session.gc_divisor session.gc_maxlifetime

set to in your php.ini file?

Original comment by: campbell-m

[jberanek]

Hi

The php.ini look like this

asp_tags = Off display_errors = Off max_execution_time = 1000 max_input_time = 1000 max_input_vars = 10000 memory_limit = 4096M post_max_size = 5120M session.gc_maxlifetime = 1440 session.save_path = "/var/cpanel/php/sessions/ea-php56" upload_max_filesize = 5120M zlib.output_compression = Off

Original comment by: *anonymous

[jberanek]

Could you run the attached test program pleae which will output the values of session.gc_probability, session.gc_divisor and session.gc_maxlifetime?

Original comment by: campbell-m

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/048384cb80/d3d9/attachment/test_ini.php

[jberanek]

session.gc_probability: string(1) "0" session.gc_divisor: string(1) "0" session.gc_maxlifetime: string(4) "1440"

Original comment by: *anonymous

[jberanek]

Ah, thanks, that explains it. You have the garbage collection probability set to 0, and so session garbage collection will never happen, resulting in the sessions table in the database growing and growing. I suggest you modify your php.ini file and set session.gc_probability and session.gc_divisor to their default values, ie 1 and 100 respectively.

Original comment by: campbell-m

[jberanek]

ok thanks

Original comment by: *anonymous