老师,mysql 我使用了 docker,但是启动后内存不断上涨,最后崩溃退出,我加了配置:
max_allowed_packet=1G
expire_logs_days=3

performance_schema_max_table_instances=4000
performance_schema=off
这样的配置,在 mysql 容器刚启动时由原来的300-400M的占用,到现在100-200M 的占用,起始内存占用确实少了很多

但是我这边发现占用的内存还是内存在不断上涨,最后崩溃退出,容器日志:

mysql_1                         | 2021-04-13T01:28:57.844669Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 15  user: 'default'.
mysql_1                         | 2021-04-13T01:28:57.844794Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 31  user: 'default'.
mysql_1                         | 2021-04-13T01:28:58.718668Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.23)  MySQL Community Server - GPL.
mysql_1                         | 2021-04-13 01:28:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.23-1debian10 started.
mysql_1                         | 2021-04-13 01:28:59+00:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
mysql_1                         | 2021-04-13 01:28:59+00:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.0.23-1debian10 started.
mysql_1                         | 2021-04-13T01:28:59.663072Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
mysql_1                         | 2021-04-13T01:28:59.663099Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
mysql_1                         | 2021-04-13T01:28:59.663181Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.23) starting as process 1
mysql_1                         | 2021-04-13T01:28:59.664142Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
mysql_1                         | 2021-04-13T01:28:59.670232Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
mysql_1                         | 2021-04-13T01:28:59.920948Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
mysql_1                         | 2021-04-13T01:29:00.039495Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
mysql_1                         | 2021-04-13T01:29:00.166127Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
mysql_1                         | 2021-04-13T01:29:00.166285Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
mysql_1                         | 2021-04-13T01:29:00.169952Z 0 [Warning] [MY-011810] [Server] Insecure configuration for --pid-file: Location '/var/run/mysqld' in the path is accessible to all OS users. Consider choosing a different directory.
mysql_1                         | 2021-04-13T01:29:00.237767Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.23'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  MySQL Community Server - GPL.
mysql_1                         | mbind: Operation not permitted
mysql_1                         | mbind: Operation not permitted
mysql_1                         | mbind: Operation not permitted
mysql_1                         | mbind: Operation not permitted
mysql_1                         | mbind: Operation not permitted
laradock_mysql_1 exited with code 137

我查了最大链接数:

mysql> show global variables like '%max_connections%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| max_connections        | 151   |
| mysqlx_max_connections | 100   |
+------------------------+-------+
2 rows in set (0.00 sec)

还有单个链接的占用内存

mysql> show global variables like '%sort_buffer_size%';
+-------------------------+---------+
| Variable_name           | Value   |
+-------------------------+---------+
| innodb_sort_buffer_size | 1048576 |
| myisam_sort_buffer_size | 8388608 |
| sort_buffer_size        | 262144  |
+-------------------------+---------+
3 rows in set (0.01 sec)

一些其它配置

mysql> show status like  'threads%';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| Threads_cached    | 5     |
| Threads_connected | 26    |
| Threads_created   | 45    |
| Threads_running   | 2     |
+-------------------+-------+
4 rows in set (0.00 sec)

mysql> show variables like 'thread_cache_size';
+-------------------+-------+
| Variable_name     | Value |
+-------------------+-------+
| thread_cache_size | 9     |
+-------------------+-------+
1 row in set (0.00 sec)

值都不大

现在内存的占用已经到了 866MiB:

CONTAINER ID   NAME                                      CPU %     MEM USAGE / LIMIT     MEM %     NET I/O           BLOCK I/O         PIDS
2bec50570db1   laradock_mysql_1                          0.57%     866.3MiB / 7.775GiB   10.88%    755MB / 910MB     6.93GB / 11.1GB   70

请问老师,这种情况是哪方面问题造成的呢?该如何解决这个问题呢?