Percona Server 5.7 memory leak when enabled performance_schema and thread pool
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
New
|
Undecided
|
Unassigned |
Bug Description
When i enable performance_schema and thread pool, Percona Server 5.7 will memory leak, and then lead to be oom-killed.
Although i upgrade the version from 5.7.17-11 to 5.7.18-16 this problem still happens.
My settiongs:
innodb_
innodb_
...
performance_schema = 1
performance_
...
thread_handling = "pool-of-threads"
thread_
thread_pool_size = 2
thread_
thread_
extra_port = 3307
the memory of mysqld process will grow from 173MB to 903MB within 20min.
ps -ef | grep mysqld
> 925624 ./bin/mysqld --defaults-
mysql -e "select event_name,
event_name SUM_NUMBER_
memory/
memory/
memory/
memory/
memory/
memory/sql/TABLE 425176683
memory/
memory/mysys/MY_DIR 237420552
memory/
memory/
mysql -e "select thread_id, event_name, SUM_NUMBER_
>>
thread_id event_name SUM_NUMBER_
1 memory/
1 memory/
1 memory/
1 memory/
2206 memory/
2518 memory/
1988 memory/
3775 memory/
2692 memory/
328 memory/
104 memory/
1920 memory/
1 memory/sql/XID 19924544
1 memory/
1 memory/
1209 memory/
1 memory/
1988 memory/
2518 memory/
2206 memory/
Changed in percona-server: | |
status: | Incomplete → New |
Thank you for the report.
Do you experience this on idle server of after some load? If yes, could you please provide details on what kind of load. Please also send us output of mysql -e "select thread_id, event_name, SUM_NUMBER_ OF_BYTES_ ALLOC from memory_ summary_ by_thread_ by_event_ name order by SUM_NUMBER_ OF_BYTES_ ALLOC desc limit 20" performance_schema after running same load, but with Thread Plugin not used.