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