mysql slave sql multi thread memory leak

Bug #1303619 reported by Noel on 2014-04-07
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server
Undecided
Unassigned

Bug Description

Im using Percona 5.6.14

Master shows im using 82% of Memory and Slave shows im using 91% Memory.
More over Slave is just idle and only accepts replication queries and no other application query.

stop slave;
set global slave_parallel_workers=4;
start slave;

while true
do
  date >> ps.log
  ps aux | grep mysqld >> ps.log
  sleep 60
done

when I execute stop slave sql_thread, the memory become normal to some extent;

Please, send my.cnf file content from this slave.

Can you try to upgrade slave to 5.6.16 to check if the problem remains?

Changed in percona-server:
status: New → Incomplete
Noel (noelc) wrote :

I wonder if commenting out slave_parallel_workers setting and restarting MySQL server helps in any way. I ask because of the following upstream bugs:

http://bugs.mysql.com/bug.php?id=69066
http://bugs.mysql.com/bug.php?id=69075
http://bugs.mysql.com/bug.php?id=71197

Noel (noelc) wrote :

According to Oracle Mysql Bug, they have fixed in 5.6.17. Have Percona done the same fix?????

Percona Server 5.6.17 is not yet released, but the fix should be merged from upstream surely.

Would you mind to check if there is a leak without multi-threaded slave, to prove it's the same bug actually?

Noel (noelc) wrote :

any timeline set for 5.6.17 release date????

We have a policy that a Percona Server release should follow no later than one month after a corresponding Oracle MySQL release.

Noel (noelc) wrote :

Hi Valerii.

Percona 5.6.17 is released and i cant see upstream bug fix in this
http://www.percona.com/doc/percona-server/5.6/upstream-bug-fixes.html

Oracle Mysql Bug: http://bugs.mysql.com/bug.php?id=71197

Changed in percona-server:
status: Incomplete → Fix Released
status: Fix Released → Incomplete
Noel (noelc) wrote :
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers

Bug attachments

Remote bug watches

Bug watches keep track of this bug in other bug trackers.