Ovais, Using your test scenario against PS 5.5.28-29.1, I see the memory being released as soon as the queries using the memory are finished:
memory_usage.log ... <snip> ... 2453036 3716244 2460128 3716244 2428088 3716244 1864296 3191956 175408 1619092 175408 1619092 175408 1619092 175408 1619092 175408 1619092 175408 1619092
-- Executing FLUSH TABLES NOW 172496 1619092 172496 1619092 172496 1619092
So I am not so sure that what you saw is the same issue as being reported here unless I am misinterpreting the results.
Ovais,
Using your test scenario against PS 5.5.28-29.1, I see the memory being released as soon as the queries using the memory are finished:
memory_usage.log
... <snip> ...
2453036 3716244
2460128 3716244
2428088 3716244
1864296 3191956
175408 1619092
175408 1619092
175408 1619092
175408 1619092
175408 1619092
175408 1619092
-- Executing FLUSH TABLES NOW
172496 1619092
172496 1619092
172496 1619092
So I am not so sure that what you saw is the same issue as being reported here unless I am misinterpreting the results.