Skip to content

Comments

fix/6830#6850

Merged
fdurand merged 38 commits intodevelfrom
fix/6830
Feb 11, 2022
Merged

fix/6830#6850
fdurand merged 38 commits intodevelfrom
fix/6830

Conversation

@jrouzierinverse
Copy link
Member

@jrouzierinverse jrouzierinverse commented Jan 27, 2022

Description

Improve the performance of the bandwidth accounting cleanup process

Impacts

Bandwidh accounting.

Issue

fixes #6830

Delete branch after merge

YES

Checklist

(REQUIRED) - [yes, no or n/a]

  • Document the feature
  • Add unit tests
  • Add acceptance tests (TestLink)

NEWS file entries

Enhancements

  • Improved the performance of the bandwidth accounting cleanup process

ALTER TABLE pki_revoked_certs
ADD COLUMN IF NOT EXISTS `subject` varchar(255) AFTER crl_reason;

DELIMITER /
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Add comment like ! echo "blablabla"

END /
DELIMITER ;

DELIMITER /
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Add comment like ! echo "blablabla"

END/
DELIMITER ;

DELIMITER /
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Add comment like ! echo "blablabla"

END/
DELIMITER ;

DELIMITER /
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Add comment like ! echo "blablabla"

Copy link
Member

@fdurand fdurand left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Remove the procedure and fix the missing admin gui parameters and we will be good to merge.

#
# How many session to clean up at a time
batch=100
session_batch=100
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

needs to be visible from the admin gui

#
# How long a session cleanup job can run
timeout=5s
session_timeout=5s
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

needs to be visible from the admin gui

#
# How long to keep a session open
window=24h
session_window=24h
Copy link
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

needs to be visible from the admin gui

@fdurand fdurand merged commit 807fdd6 into devel Feb 11, 2022
fdurand added a commit that referenced this pull request Feb 11, 2022
@fdurand fdurand deleted the fix/6830 branch October 31, 2022 17:35
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

pfacct: closed sessions aren't being put in bandwidth_accounting_history

2 participants