Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.3.20, 2.4.13
-
None
-
Centos 7.6.181
-
MXS-SPRINT-111, MXS-SPRINT-112, MXS-SPRINT-113, MXS-SPRINT-114, MXS-SPRINT-115, MXS-SPRINT-116, MXS-SPRINT-117, MXS-SPRINT-118, MXS-SPRINT-120, MXS-SPRINT-121, MXS-SPRINT-122, MXS-SPRINT-123
Description
we are facing memory leak by maxscale
here is the conf:
cat /etc/maxscale.cnf
|
# Globals
|
[maxscale]
|
threads=auto
|
log_augmentation=1
|
ms_timestamp=1
|
syslog=1
|
admin_host=0.0.0.0
|
admin_port=8989
|
writeq_high_water=32M
|
writeq_low_water=512K
|
# Servers
|
[te-db01]
|
type=server
|
address=10.5.0.11
|
port=3306
|
protocol=mariadbbackend
|
persistpoolmax=10000
|
persistmaxtime=3600
|
[te-db02]
|
type=server
|
address=10.5.0.12
|
port=3306
|
protocol=mariadbbackend
|
persistpoolmax=10000
|
persistmaxtime=3600
|
[te-db03]
|
type=server
|
address=10.5.0.13
|
port=3306
|
protocol=mariadbbackend
|
persistpoolmax=10000
|
persistmaxtime=3600
|
# Monitoring for the servers
|
[Galera-Monitor]
|
type=monitor
|
module=galeramon
|
servers=te-db01,te-db02,te-db03
|
user=maxscale
|
password=**
|
monitor_interval=1000
|
available_when_donor=true
|
disable_master_failback=true
|
# Galera router service
|
[Galera-Service]
|
type=service
|
router=readwritesplit
|
servers=te-db01,te-db02,te-db03
|
user=maxscale
|
password=**
|
master_failure_mode=fail_on_write
|
#disable_sescmd_history=true
|
master_reconnection=true
|
max_sescmd_history=1000
|
prune_sescmd_history=true
|
# Galera cluster listener
|
[Galera-Listener]
|
type=listener
|
service=Galera-Service
|
protocol=mariadbclient
|
port=3306
|
and:
cat global-options.cnf
|
[maxscale]
|
auth_connect_timeout=3
|
auth_read_timeout=1
|
auth_write_timeout=2
|
admin_auth=true
|
passive=0
|
and
cat Galera-Service.cnf
|
[Galera-Service]
|
type=service
|
servers=te-db01,te-db02,te-db03
|
router=readwritesplit
|
user=maxscale
|
password=**
|
master_failure_mode=fail_on_write
|
master_reconnection=true
|
max_sescmd_history=500
|
prune_sescmd_history=true
|
enable_root_user=false
|
max_retry_interval=3600
|
max_connections=0
|
connection_timeout=500
|
auth_all_servers=false
|
strip_db_esc=true
|
localhost_match_wildcard_host=true
|
log_auth_warnings=true
|
retry_on_failure=true
|
session_track_trx_state=false
|
retain_last_statements=-1
|
use_sql_variables_in=all
|
slave_selection_criteria=LEAST_CURRENT_OPERATIONS
|
max_slave_replication_lag=-1
|
max_slave_connections=255
|
retry_failed_reads=true
|
disable_sescmd_history=false
|
strict_multi_stmt=false
|
strict_sp_calls=false
|
master_accept_reads=false
|
connection_keepalive=250
|
causal_reads=false
|
causal_reads_timeout=10
|
delayed_retry=false
|
delayed_retry_timeout=10
|
transaction_replay=false
|
transaction_replay_max_size=1Mi
|
optimistic_trx=false
|
session_trace=0
|
and
cat global-options.cnf
|
[maxscale]
|
auth_connect_timeout=3
|
auth_read_timeout=1
|
auth_write_timeout=2
|
admin_auth=true
|
passive=0
|
and
[te-db01]
|
type=server
|
persistpoolmax=13000
|
priority=200
|
address=10.5.0.11
|
port=3306
|
protocol=mariadbbackend
|
persistmaxtime=3600
|
extra_port=0
|
proxy_protocol=false
|
ssl=false
|
ssl_version=MAX
|
ssl_cert_verify_depth=9
|
ssl_verify_peer_certificate=true
|
priority=200
|
[te-db02]
|
type=server
|
persistpoolmax=13000
|
priority=100
|
address=10.5.0.12
|
port=3306
|
protocol=mariadbbackend
|
persistmaxtime=3600
|
extra_port=0
|
proxy_protocol=false
|
ssl=false
|
ssl_version=MAX
|
ssl_cert_verify_depth=9
|
ssl_verify_peer_certificate=true
|
priority=100
|
[te-db03]
|
type=server
|
persistpoolmax=13000
|
priority=300
|
address=10.5.0.13
|
port=3306
|
protocol=mariadbbackend
|
persistmaxtime=3600
|
extra_port=0
|
proxy_protocol=false
|
ssl=false
|
ssl_version=MAX
|
ssl_cert_verify_depth=9
|
ssl_verify_peer_certificate=true
|
priority=300
|
Attachments
Issue Links
- is duplicated by
-
MXS-3253 Maxscale uses half of my server memory
- Closed