Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
22.08.4
-
None
Description
After some time since start, all queries going through the write service (see config below) become slow, even a show create table can take over 100ms.
A process restart fixes the issue.
While this happens, there is one thread using an entire CPU even in absence of traffic.
Attaching core file.
|
|
[maxscale]
|
threads=auto
|
writeq_high_water=32M
|
writeq_low_water=512k
|
log_info=false
|
|
|
|
|
[db-rep02]
|
type=server
|
address=<REDACTED>
|
port=3306
|
protocol=MariaDBBackend
|
|
|
[db-rep05]
|
type=server
|
address=<REDACTED>
|
port=3306
|
protocol=MariaDBBackend
|
|
|
[MariaDB-Monitor]
|
type=monitor
|
module=mariadbmon
|
servers=db-rep02,db-rep05
|
user=maxscale
|
password=<REDACTED>
|
monitor_interval=2000ms
|
auto_failover=true
|
auto_rejoin=false
|
replication_user=db02replication
|
replication_password=<REDACTED>
|
enforce_read_only_slaves=true
|
cooperative_monitoring_locks = majority_of_running
|
|
|
[Read-Only-Service]
|
type=service
|
router=readconnroute
|
servers=db-rep02,db-rep05
|
user=maxscale
|
password=<REDACTED>
|
router_options=slave
|
connection_timeout=0s
|
connection_keepalive=200s
|
|
|
[Write-Service]
|
type=service
|
router=readconnroute
|
servers=db-rep02,db-rep05
|
user=maxscale
|
password=<REDACTED>
|
router_options=master
|
enable_root_user=1
|
connection_timeout=0s
|
connection_keepalive=200s
|
|
|
[Read-Write-Service]
|
type=service
|
router=readwritesplit
|
use_sql_variables_in=master
|
servers=db-rep02,db-rep05
|
user=maxscale
|
password=<REDACTED>
|
prune_sescmd_history=true
|
disable_sescmd_history=false
|
max_sescmd_history=100
|
causal_reads=global
|
causal_reads_timeout=1s
|
max_slave_replication_lag=5s
|
connection_timeout=0s
|
connection_keepalive=200s
|
|
|
|
|
[Read-Only-Listener]
|
type=listener
|
service=Read-Only-Service
|
protocol=MariaDBClient
|
address=0.0.0.0
|
port=4008
|
|
|
[Write-Listener]
|
type=listener
|
service=Write-Service
|
protocol=MariaDBClient
|
address=0.0.0.0
|
port=4006
|
|
|
[Read-Write-Listener]
|
type=listener
|
service=Read-Write-Service
|
protocol=MariaDBClient
|
address=0.0.0.0
|
port=4007
|
|
Attachments
Issue Links
- duplicates
-
-
- Closed
-