Bug #112696 mysql memory/sql/sql_acl_memex value increase every day

Submitted: 12 Oct 2023 5:29 Modified: 13 Oct 2023 1:17
Reporter: harry harry Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.7.34 OS:CentOS
Assigned to: CPU Architecture:Any

[12 Oct 2023 5:29] harry harry
Description:
mysql memory/sql/sql_acl_memex value  increase every day

2023-09-20:

mysql> select event_name, current_alloc, high_alloc from sys.memory_global_by_current_bytes where current_count > 0;
+--------------------------------------------------------------------------------+---------------+-------------+
| event_name                                                                     | current_alloc | high_alloc  |
+--------------------------------------------------------------------------------+---------------+-------------+
| memory/innodb/buf_buf_pool                                                     | 16.38 GiB     | 16.38 GiB   |
| memory/sql/sql_acl_memex                                                       | 4.06 GiB      | 4.06 GiB    |
| memory/sql/sql_acl_mem                                                         | 1.76 GiB      | 1.76 GiB    |

2023-10-12:
mysql>  select event_name, current_alloc, high_alloc from sys.memory_global_by_current_bytes where current_count > 0;
+--------------------------------------------------------------------------------+---------------+-------------+
| event_name                                                                     | current_alloc | high_alloc  |
+--------------------------------------------------------------------------------+---------------+-------------+
| memory/innodb/buf_buf_pool                                                     | 16.38 GiB     | 16.38 GiB   |
| memory/sql/sql_acl_memex                                                       | 9.36 GiB      | 9.36 GiB    |
| memory/sql/sql_acl_mem                                                         | 4.06 GiB      | 4.06 GiB    |

you can see the  memory/sql/sql_acl_memex and memory/sql/sql_acl_mem have increase, what is the reason for this, and how can I do to solve

How to repeat:
see above
[12 Oct 2023 10:29] MySQL Verification Team
Hi Mr. chen,

Thank you for your bug report.

However, as of the October 1st , 5.7 is no longer supported.

Also, in 8.0 and further versions sql_acl_memex is no longer used.

So, please upgrade to 8.0. Follow the instructions from the Manual.

Unsupported.
[13 Oct 2023 1:17] harry harry
what is reason cause the sql_acl_memex and sql_acl_mem value increase。
Are there any other ways to solve this besides upgrading to the MySQL version 8.0

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.050 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.