Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.19
-
OC: Cloulinux/CentOS 7.5
mysql Ver 15.1 Distrib 10.2.19-MariaDB, for Linux (x86_64) using readline 5.1
Description
The bug similar to https://bugs.launchpad.net/percona-server/+bug/1380895
Sometimes after execution requests to INFORMATION_SCHEMA.TABLES mysql use more and more memory.
SELECT TABLE_SCHEMA as DB,SUM(DATA_LENGTH)+SUM(INDEX_LENGTH) AS SPACEUSED from information_schema.tables WHERE TABLE_TYPE NOT LIKE '%view%' GROUP BY TABLE_SCHEMA; |
Memory usage before request. pmap out before request in attach before_pmap.log
/bin/ps -ylC mysqld | /bin/awk '{x += $8;y += 1} END {print "Memory Usage (MB): "x/1024, "\n\n"}' |
Memory Usage (MB): 51782.2
|
Execution request.
Memory usage after request. pmap out after request in attach after_pmap.log
/bin/ps -ylC mysqld | /bin/awk '{x += $8;y += 1} END {print "Memory Usage (MB): "x/1024, "\n\n"}' |
Memory Usage (MB): 51865.5
|
Increasing of memory usage happens not every request.
Unfortunately i don't know exact conditions to reproduce memory leak, but if sometimes run this request on working server where running another sql requests, creates and dropping databases/tables, memory leak happens.