Changed limits: max_open_files: 1024

最新推荐文章于 2021-02-26 10:10:04 发布
转载 最新推荐文章于 2021-02-26 10:10:04 发布 · 4.7k 阅读 · 0

本文介绍了解决MySQL启动时出现的关于max_open_files、max_connections及table_open_cache警告的方法。通过编辑limits.conf文件和mysqld.service配置文件，可以有效地解决这些问题。

如果mysql数据库启动的时候，出现如下的错误

2016-07-22 15:01:43 26283 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5010

2016-07-22 15:01:43 26283 [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 1000)

2016-07-22 15:01:43 26283 [Warning] Buffered warning: Changed limits: table_open_cache: 400 (requested 2000)

除了修改/etc/security/limits.conf

加上

* hard nofile 65535
* soft nofile 65535

还需要在  /usr/lib/systemd/system/mysqld.service 

加上如下的话

LimitNOFILE=65535

mysql的错误信息就消失了。


mysql提示Changed limits: max_open_files: 2048 max_connections: 1910 table_cache: 64的解决
09-10
MySQL数据库在运行过程中可能会遇到资源限制的问题，这些限制在错误日志中通常表现为"Changed limits: max_open_files: 2048 max_connections: 1910 table_cache: 64"这样的提示。这个提示意味着MySQL服务器在启动时...
mysql日志报：Changed limits: max_open_files: 1024
随风潜入夜，不白头
12-31 2820
linux 上的数据库 mysql 突然挂掉了 重启mysql（systemctl restart mysqld）， 出现类似下面的情况： /system.slice/mysqld.service └─control ├─2571 /bin/bash /usr/bin/mysql-systemd-start post └─3541 sleep 1 最后查看 mysql.log 发现不知道错误的错误： ...
MySQL启动报“[Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 15000)”
热门推荐
liyuming0000的专栏
04-20 1万+
启动MySQL服务的时候，报下面警告： [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 15000) [Warning] Buffered warning: Changed limits: max_connections: 214 (requested 3000) [Warning]
linux mysql changed limits_ubuntu下mysql提示Changed limits: max_open_files:1024解决办法
weixin_36243860的博客
02-03 755
在配置我的md5解密网站cmd5.la的时候，mysql5.7出现了max_open_files: 1024， max_connections: 214，warning: Changed limits: max_connections: 214等一系列提示。根据网上各种配置都不行，最后研究发现，原来是ubuntu下还有一个操作。第一步，先搞定系统的max_open_files限制。vi/etc/...
Mysql—— [Warning] Changed limits: max_open_files: 2048 max_connections:800 table_cache: 619
weixin_33964094的博客
04-11 237
问题： [Warning] Changed limits: max_open_files: 2048 max_connections: 800 table_cache: 619 MySQL服务器 WINDOWS下执行二进制安装后WINDOWS服务中默认的调用的是mysqld-nt服务器，我们可以在WINDOWS的MySql服务的属性中看到： "C:\Program Files\...
执行 systemctl start mysql 提示如下mysqld_safe Starting mysqld daemon with databases from /data/apps/mysql/data 2025-04-29T04:54:56.637668Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8510) 2025-04-29T04:54:56.637672Z 0 [Warning] [MY-010141] [Server] Changed limits: max_connections: 214 (requested 500) 2025-04-29T04:54:56.637676Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 400 (requested 4000) 2025-04-29T04:54:56.811512Z 0 [System] [MY-010116] [Server] /data/apps/mysql/bin/mysqld (mysqld 8.0.40) starting as process 16049 2025-04-29T04:54:56.817217Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-04-29T04:54:56.959653Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2025-04-29T04:54:57.074011Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-04-29T04:54:57.074049Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are
04-30
- `[Warning] [MY-010311] [Server] Could not increase number of max_open_files to more than 1024` ➜ 文件描述符限制 - `[ERROR] [MY-000061] [Server] Error message: Too many connections` ➜ 连接数溢出...
[root@localhost ~]# head -100 /var/log/mysqld.log 250922 00:47:45 mysqld_safe Logging to '/var/log/mysqld.log'. 250922 00:47:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2025-09-22 00:47:45 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-09-22 00:47:45 0 [Note] /usr/sbin/mysqld (mysqld 5.6.51) starting as process 41577 ... 2025-09-22 00:47:45 41577 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2025-09-22 00:47:45 41577 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2025-09-22 00:47:45 41577 [Note] Plugin 'FEDERATED' is disabled. 2025-09-22 00:47:45 41577 [Note] InnoDB: Using atomics to ref count buffer pool pages 2025-09-22 00:47:45 41577 [Note] InnoDB: The InnoDB memory heap is disabled 2025-09-22 00:47:45 41577 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-09-22 00:47:45 41577 [Note] InnoDB: Memory barrier is not used 2025-09-22 00:47:45 41577 [Note] InnoDB: Compressed tables use zlib 1.2.11 2025-09-22 00:47:45 41577 [Note] InnoDB: Using Linux native AIO 2025-09-22 00:47:45 41577 [Note] InnoDB: Using CPU crc32 instructions 2025-09-22 00:47:45 41577 [Note] InnoDB: Initializing buffer pool, size = 128.0M 2025-09-22 00:47:45 41577 [Note] InnoDB: Completed initialization of buffer pool 2025-09-22 00:47:45 41577 [Note] InnoDB: Highest supported file format is Barracuda. 2025-09-22 00:47:45 41577 [Note] InnoDB: 128 rollback segment(s) are active. 2025-09-22 00:47:45 41577 [Note] InnoDB: Waiting for purge to start 2025-09-22 00:47:45 41577 [Note] InnoDB: 5.6.51 started; log sequence number 1625987 2025-09-22 00:47:45 41577 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 482452ca-976f-11f0-a3ab-000c2932bbd7. 2025-09-22 00:47:45 41577 [Note] RSA private key file not found: /var/lib/mysql//private_key.pem. Some authentication plugins will not work. 2025-09-22 00:47:45 41577 [Note] RSA public key file not found: /var/lib/mysql//public_key.pem. Some authentication plugins will not work. 2025-09-22 00:47:45 41577 [Note] Server hostname (bind-address): '*'; port: 3306 2025-09-22 00:47:45 41577 [Note] IPv6 is available. 2025-09-22 00:47:45 41577 [Note] - '::' resolves to '::'; 2025-09-22 00:47:45 41577 [Note] Server socket created on IP: '::'. 2025-09-22 00:47:45 41577 [Note] Event Scheduler: Loaded 0 events 2025-09-22 00:47:45 41577 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.51' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2025-09-22 02:09:26 41577 [Note] /usr/sbin/mysqld: Normal shutdown 2025-09-22 02:09:26 41577 [Note] Giving 0 client threads a chance to die gracefully 2025-09-22 02:09:26 41577 [Note] Event Scheduler: Purging the queue. 0 events 2025-09-22 02:09:26 41577 [Note] Shutting down slave threads 2025-09-22 02:09:26 41577 [Note] Forcefully disconnecting 0 remaining clients 2025-09-22 02:09:26 41577 [Note] Binlog end 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'partition' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_DELETED' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_METRICS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMPMEM' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP_RESET' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_CMP' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_LOCKS' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'INNODB_TRX' 2025-09-22 02:09:26 41577 [Note] Shutting down plugin 'InnoDB' 2025-09-22 02:09:26 41577 [Note] InnoDB: FTS optimize thread exiting. 2025-09-22 02:09:26 41577 [Note] InnoDB: Starting shutdown... 2025-09-22 02:09:27 41577 [Note] InnoDB: Shutdown completed; log sequence number 1625997 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'BLACKHOLE' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'ARCHIVE' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MRG_MYISAM' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MyISAM' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'MEMORY' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'CSV' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'sha256_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'mysql_old_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'mysql_native_password' 2025-09-22 02:09:27 41577 [Note] Shutting down plugin 'binlog' 2025-09-22 02:09:27 41577 [Note] /usr/sbin/mysqld: Shutdown complete 250922 02:09:27 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 250922 02:09:28 mysqld_safe Logging to '/var/log/mysqld.log'. 250922 02:09:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 2025-09-22 02:09:28 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2025-09-22 02:09:28 0 [Note] /usr/sbin/mysqld (mysqld 5.6.51) starting as process 41965 ... 2025-09-22 02:09:28 41965 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000) 2025-09-22 02:09:28 41965 [Warning] Buffered warning: Changed limits: table_open_cache: 431 (requested 2000) 2025-09-22 02:09:28 41965 [Note] Plugin 'FEDERATED' is disabled. 2025-09-22 02:09:28 41965 [Note] InnoDB: Using atomics to ref count buffer pool pages 2025-09-22 02:09:28 41965 [Note] InnoDB: The InnoDB memory heap is disabled 2025-09-22 02:09:28 41965 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2025-09-22 02:09:28 41965 [Note] InnoDB: Memory barrier is not used 2025-09-22 02:09:28 41965 [Note] InnoDB: Compressed tables use zlib 1.2.11
09-23
用户提到了三个主要问题：TIMESTAMP隐式默认值弃用、max_open_files和table_open_cache更改限制。我们结合引用和MySQL知识来解答。 1. TIMESTAMP隐式默认值弃用警告： 在MySQL 5.6版本中，TIMESTAMP列如果没有...
[root@hadoop01 ~]# sudo tail -n 100 /var/log/mysqld.log 2025-12-02T14:13:28.410454Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2025-12-02T14:13:28.410458Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2025-12-02T14:13:28.583282Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.44) starting as process 65834 2025-12-02T14:13:28.594255Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-12-02T14:13:28.713877Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-12-02T14:13:28.777402Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-12-02T14:13:28.777565Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.777718Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.777852Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.778004Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.778085Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.778166Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.778273Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.808642Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:28.838087Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:28.839451Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-12-02T14:13:28.839574Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-12-02T14:13:28.840577Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:28.840795Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-12-02T14:13:28.840819Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-12-02T14:13:28.841176Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2025-12-02T14:13:28.841219Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2025-12-02T14:13:28.841296Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-12-02T14:13:30.374465Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.44) MySQL Community Server - GPL. 2025-12-02T14:13:35.661712Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2025-12-02T14:13:35.661716Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2025-12-02T14:13:35.843134Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.44) starting as process 66049 2025-12-02T14:13:35.854339Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-12-02T14:13:35.973987Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-12-02T14:13:36.033573Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-12-02T14:13:36.034113Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034247Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034350Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034533Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034624Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034705Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.034781Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.063137Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:36.100853Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:36.101984Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-12-02T14:13:36.102015Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-12-02T14:13:36.102787Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:36.102948Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-12-02T14:13:36.102970Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-12-02T14:13:36.103260Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2025-12-02T14:13:36.103301Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2025-12-02T14:13:36.103340Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-12-02T14:13:37.627999Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.44) MySQL Community Server - GPL. 2025-12-02T14:13:42.913845Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2025-12-02T14:13:42.913850Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2025-12-02T14:13:43.086588Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.44) starting as process 66251 2025-12-02T14:13:43.098653Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-12-02T14:13:43.228109Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-12-02T14:13:43.300670Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-12-02T14:13:43.300835Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.300998Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.301133Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.301485Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.301641Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.301760Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.301925Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.342364Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:43.408956Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:43.410772Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-12-02T14:13:43.410806Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-12-02T14:13:43.411877Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:43.412025Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-12-02T14:13:43.412045Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-12-02T14:13:43.412387Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2025-12-02T14:13:43.412434Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2025-12-02T14:13:43.412476Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-12-02T14:13:44.940061Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.44) MySQL Community Server - GPL. 2025-12-02T14:13:50.162267Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2025-12-02T14:13:50.162273Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2025-12-02T14:13:50.333321Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.44) starting as process 66445 2025-12-02T14:13:50.344078Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2025-12-02T14:13:50.504900Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. mysqld: Table 'mysql.plugin' doesn't exist 2025-12-02T14:13:50.572866Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure. 2025-12-02T14:13:50.573146Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573292Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573402Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573639Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573739Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573826Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.573907Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.603968Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:50.633321Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened. 2025-12-02T14:13:50.634588Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2025-12-02T14:13:50.634617Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel. 2025-12-02T14:13:50.635987Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables 2025-12-02T14:13:50.636162Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist 2025-12-02T14:13:50.636188Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition. 2025-12-02T14:13:50.636490Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist 2025-12-02T14:13:50.636525Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual. 2025-12-02T14:13:50.636559Z 0 [ERROR] [MY-010119] [Server] Aborting 2025-12-02T14:13:52.165356Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.44) MySQL Community Server - GPL.
最新发布
12-03
我们面对的是MySQL系统表(mysql.plugin, mysql.component, mysql.user)丢失的问题，这会导致MySQL无法正常启动。以下是解决步骤： ### 问题分析 从错误日志中我们可以推断`mysql`系统数据库中的核心表丢失或损坏。...
mysql报错Changed limits: max_open_files: 5000
weixin_34248705的博客
04-29 930
2019独角兽企业重金招聘Python工程师标准>>> ...
ubuntu下mysql出现 warning: Changed limits: max_connections: 214 问题
piikee的专栏-萍客小居
11-28 1039
在配置我的md5解密网站cmd5.la的时候，mysql5.7出现了max_open_files: 1024， max_connections: 214，warning: Changed limits: max_connections: 214等一系列提示。根据网上各种配置都不行，最后研究发现，原来是ubuntu下还有一个操作。 第一步，先搞定系统的max_open_files限制。
max open files mysql_MySQL 重启提示超出可打开文件数限制|Buffered warning: Changed limits: max_open_files: 1024...
weixin_30978959的博客
01-27 332
Linux 服务器经常一段时间就会出现这样的问题，一个月半个月的样子。每次都重启服务器临时性解决，昨晚仔细看了看报的错误。先看应用的日志提示连不上 MySQL 服务器。"Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"再看看 MySQL 的日志，发现原来超过限制了。190314 1...
linux mysql changed limits_mysql提示Changed limits:
weixin_35924719的博客
02-06 468
...用方式分两种* 1.直接调用法* 普通大小* $.mypage(id,now,max,fn);* 大尺寸* $.mypagelg(id,now,max,fn);* 小尺寸* $.mypagesm(id,now,max,fn);** 参数说明：id为放置分页容器的ID，now为当前页，max为最大页，fn为回掉函数，回掉函数有一个...在windows下安装Mysql系统日志出现...
[Warning] Buffered warning: Changed limits: max_connections: 214 (requested 2000)
渔夫数据库笔记
01-08 4630
1.版本 1)操作系统  cat /etc/issue Red Hat Enterprise Linux Server release 5.5 (Tikanga) Kernel \r on an \m  cat /proc/version Linux version 2.6.32-504.el6.x86_64 (mockbuild@c6b9.bsys.dev.cento
linux mysql changed limits_mysql提示Changed limits: max_open_files: 2048 max_connections:
weixin_33109551的博客
02-26 317
在windows下安装Mysql系统日志出现max_open_files: 2048 max_connections: 510 table_cache: 764 类似错误是因为 max_connections 最大连接数和max_open_files、table_cache 不匹配。适当的降低max_connections 或调整其他两个数值解决办法在 mysql bin > 中输入 mys...
解决mysql crash问题
weixin_33811961的博客
06-08 410
2019独角兽企业重金招聘Python工程师标准>>> ...
max_open_files table_open_cache
weixin_34310785的博客
11-17 482
服务器mysql 报警：2017-11-17T04:02:34.400257Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)2017-11-17T04:02:34.400333Z 0 [Warning] Changed limits: table_open_cache: 431 (reque...
ubuntu mysql 二进制安装_ubuntu18.04手动安装二进制MySQL8.0
weixin_31346703的博客
01-30 352
wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.13-linux-glibc2.12-x86_64.tar.xztar xvJf mysql-8.0.13-linux-glibc2.12-x86_64.tar.xzsudo mv mysql-8.0.13-linux-glibc2.12-x86_64 /var/mysql然后新建一...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值