[ZBXNEXT-2381] too frequent updates of sessions table Created: 2014 Jul 11  Updated: 2015 Dec 10

Status: Confirmed
Project: ZABBIX FEATURE REQUESTS
Component/s: API (A)
Affects Version/s: 2.2.4
Fix Version/s: None

Type: Change Request Priority: Trivial
Reporter: Alberto Díaz Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: database, performance, sessions, update
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

LAMP


 Description   

From my db log:
UPDATE sessions SET lastaccess=1405069441 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069446 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069451 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069461 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069471 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069481 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069491 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'
UPDATE sessions SET lastaccess=1405069501 WHERE userid=4 AND sessionid='eee0e08926a92d31c0b4b5a7ee4dc948'

I think that updating sessions may be done only if the last update was XXX seconds ago. This should lower the DB usage. XXX could be configurable.

 Comments   
Comment by Aleksandrs Saveljevs [ 2014 Jul 30 ]

Related issue: ZBX-8462.

zalex_ua I'd not agree

Comment by Oleksii Zagorskyi [ 2015 Dec 10 ]

That 10 seconds interval is hardcoded interval of global zabbix server status checks.
My detailed comment https://support.zabbix.com/browse/ZBX-8051#comment-139807 talks almost about the same.

Comment by Oleksii Zagorskyi [ 2015 Dec 10 ]

Confirmed.

Generated at Sat Apr 20 05:52:20 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.