1panel mysql问题

通过1Panel安装的MySQL 5.7 ,服务器增加内存后,MySQL启动非常耗内存,启动缓慢,整个服务器都拖慢,无法正常操作,已经连续两台服务器如此。约10分钟后MySQL启动完成,但是占用内存为整个服务器90%。

你机器内存多大?


如果限制dockermysql内存为8G,就卡在如上截图,无法启动。mysql为测试空库,没有负载!

8G的时候MySQL仅仅占用300M左右。升级内存是为别的项目扩容的。这样的情况,已经连续两台机器了,只要变动内存,MySQL就启动非常缓慢,非常占用资源。yum,rpm独立安装没有这个问题.



机器内存16G,之前8G升级到16G后,MySQL直接占满整个机器的内存!

看一下日志呢

你需要看哪些日志,我明天统一截图给你!麻烦列出来下呢!

mysql 容器日志

2024-07-10T10:24:32.261380Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-07-10T10:24:32.261709Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.2.0)  MySQL Community Server - GPL.
2024-07-10T10:24:32.263899Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-07-10 18:24:34+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
2024-07-10 18:24:40+08:00 [Note] [Entrypoint]: Switching to dedicated user 'mysql'
2024-07-10 18:24:40+08:00 [Note] [Entrypoint]: Entrypoint script for MySQL Server 8.2.0-1.el8 started.
ln: failed to create symbolic link '/var/lib/mysql/mysql.sock': Permission denied
2024-07-10T10:24:41.717720Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-10T10:24:42.298162Z 0 [Warning] [MY-011068] [Server] The syntax '--skip-host-cache' is deprecated and will be removed in a future release. Please use SET GLOBAL host_cache_size=0 instead.
2024-07-10T10:24:42.326412Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2024-07-10T10:24:42.326659Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.
2024-07-10T10:24:42.326737Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.2.0) starting as process 1
2024-07-10T10:24:42.340207Z 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.
2024-07-10T10:24:42.374696Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test
2024-07-10T10:24:42.375475Z 0 [Warning] [MY-010091] [Server] Can't create test file /var/lib/mysql/mysqld_tmp_file_case_insensitive_test.lower-test

重启了一下服务器,然后就挂了,再次进入无限重启



我应该知道什么原因了,初始不应该是65535吗?怎么会变成这么大?这个通过1panel应该怎么改呢?

1Panel-mysql-R0Wp-20240711102214.log (12.6 KB)
这是启动日志,非常缓慢,几乎占用全部内存!

什么操作系统和架构

X86架构 Rockylinux 9
今天把内存从16G恢复到8G,MySQL恢复正常。
1720670843156
下面这个是升级后的