Bug #94537 memory leak
Submitted: 3 Mar 2019 19:22 Modified: 5 Apr 2019 13:00
Reporter: Christos Chatzaras Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.7.25 OS:FreeBSD
Assigned to: CPU Architecture:x86

[3 Mar 2019 19:22] Christos Chatzaras
Description:
One wordpress site with ~100.000 posts uses this plugin:

https://github.com/INN/Google-Analytics-Popular-Posts

The problem is that the MySQL memory usage keeps growing and after 1 or 2 days it uses more than 30-40GB of combined RAM + SWAP.

If I disable the plugin and restart MySQL then memory usage stays between 4-5GB which is within the limits defined by my.cnf

How to repeat:
If a MySQL developer needs a dump of the database let me know.
[3 Mar 2019 19:25] Christos Chatzaras
Here is output of EXPLAIN:

+----+-------------+------------+------------+--------+--------------------------+-------------+---------+----------------------+-------+----------+---------------------------------+
| id | select_type | table      | partitions | type   | possible_keys            | key         | key_len | ref                  | rows  | filtered | Extra                           |
+----+-------------+------------+------------+--------+--------------------------+-------------+---------+----------------------+-------+----------+---------------------------------+
|  1 | PRIMARY     | pg         | NULL       | ALL    | post_id                  | NULL        | NULL    | NULL                 | 36415 |   100.00 | Using temporary; Using filesort |
|  1 | PRIMARY     | pst        | NULL       | eq_ref | PRIMARY,type_status_date | PRIMARY     | 8       | creta_bug.pg.post_id |     1 |   100.00 | Using where                     |
|  1 | PRIMARY     | <derived2> | NULL       | ref    | <auto_key0>              | <auto_key0> | 4       | creta_bug.pg.id      |    10 |   100.00 | NULL                            |
|  1 | PRIMARY     | <derived3> | NULL       | ref    | <auto_key0>              | <auto_key0> | 4       | creta_bug.pg.id      |    10 |   100.00 | NULL                            |
|  3 | DERIVED     | m          | NULL       | ALL    | NULL                     | NULL        | NULL    | NULL                 |   954 |   100.00 | Using where                     |
|  2 | DERIVED     | m          | NULL       | ALL    | NULL                     | NULL        | NULL    | NULL                 |   954 |   100.00 | Using where                     |
+----+-------------+------------+------------+--------+--------------------------+-------------+---------+----------------------+-------+----------+---------------------------------+
6 rows in set, 1 warning (0.00 sec)
[4 Mar 2019 13:49] MySQL Verification Team
Hi,

Thank you for your bug report.

If I am not wrong, the plugin that makes you problems is not released by us.

If that is a case, please report this bug to the authors of that plugin.

We do not maintain nor check third-party plugins.
[5 Apr 2019 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".