MySQL Bugs: #94537: memory leak

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

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.

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)

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.

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".