通过1Panel安装的MySQL 5.7 ,服务器增加内存后,MySQL启动非常耗内存,启动缓慢,整个服务器都拖慢,无法正常操作,已经连续两台服务器如此。约10分钟后MySQL启动完成,但是占用内存为整个服务器90%。
你机器内存多大?
8G的时候MySQL仅仅占用300M左右。升级内存是为别的项目扩容的。这样的情况,已经连续两台机器了,只要变动内存,MySQL就启动非常缓慢,非常占用资源。yum,rpm独立安装没有这个问题.
看一下日志呢
你需要看哪些日志,我明天统一截图给你!麻烦列出来下呢!
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
重启了一下服务器,然后就挂了,再次进入无限重启
什么操作系统和架构