mysql slave sql multi thread memory leak

[Noel]

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;

[Valerii Kravchuk (valerii-kravchuk)]

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?

[Valerii Kravchuk (valerii-kravchuk)]

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)]

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

[Valerii Kravchuk (valerii-kravchuk)]

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)]

any timeline set for 5.6.17 release date????

[Laurynas Biveinis (laurynas-biveinis)]

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

[Noel (noelc)]

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

[Noel (noelc)]

Release Note of Oracle Mysql 5.6.17:
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-17.html

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3120