宝塔用户_vsnujw 发表于 昨天 10:45

【待反馈】修改了mysql的innodb_buffer_pool_size和innodb_log_buffer_s...


修改了mysql的innodb_buffer_pool_size和innodb_log_buffer_size导致mysql...
相关截innodb_图(日志、错误):
2025-07-11T01:37:53.633892Z 0 Event Scheduler: Purging the queue. 0 events
2025-07-11T01:37:53.634186Z 0 Binlog end
2025-07-11T01:37:53.801045Z 0 Shutting down plugin 'ngram'
2025-07-11T01:37:53.801093Z 0 Shutting down plugin 'partition'
2025-07-11T01:37:53.801098Z 0 Shutting down plugin 'BLACKHOLE'
2025-07-11T01:37:53.801110Z 0 Shutting down plugin 'ARCHIVE'
2025-07-11T01:37:53.801114Z 0 Shutting down plugin 'PERFORMANCE_SCHEMA'
2025-07-11T01:37:53.801152Z 0 Shutting down plugin 'MRG_MYISAM'
2025-07-11T01:37:53.801172Z 0 Shutting down plugin 'MyISAM'
2025-07-11T01:37:53.801194Z 0 Shutting down plugin 'INNODB_SYS_VIRTUAL'
2025-07-11T01:37:53.801205Z 0 Shutting down plugin 'INNODB_SYS_DATAFILES'
2025-07-11T01:37:53.801209Z 0 Shutting down plugin 'INNODB_SYS_TABLESPACES'
2025-07-11T01:37:53.801213Z 0 Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2025-07-11T01:37:53.801217Z 0 Shutting down plugin 'INNODB_SYS_FOREIGN'
2025-07-11T01:37:53.801220Z 0 Shutting down plugin 'INNODB_SYS_FIELDS'
2025-07-11T01:37:53.801224Z 0 Shutting down plugin 'INNODB_SYS_COLUMNS'
2025-07-11T01:37:53.801228Z 0 Shutting down plugin 'INNODB_SYS_INDEXES'
2025-07-11T01:37:53.801232Z 0 Shutting down plugin 'INNODB_SYS_TABLESTATS'
2025-07-11T01:37:53.801235Z 0 Shutting down plugin 'INNODB_SYS_TABLES'
2025-07-11T01:37:53.801239Z 0 Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2025-07-11T01:37:53.801243Z 0 Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2025-07-11T01:37:53.801246Z 0 Shutting down plugin 'INNODB_FT_CONFIG'
2025-07-11T01:37:53.801250Z 0 Shutting down plugin 'INNODB_FT_BEING_DELETED'
2025-07-11T01:37:53.801254Z 0 Shutting down plugin 'INNODB_FT_DELETED'
2025-07-11T01:37:53.801257Z 0 Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2025-07-11T01:37:53.801261Z 0 Shutting down plugin 'INNODB_METRICS'
2025-07-11T01:37:53.801264Z 0 Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2025-07-11T01:37:53.801268Z 0 Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2025-07-11T01:37:53.801295Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2025-07-11T01:37:53.801299Z 0 Shutting down plugin 'INNODB_BUFFER_PAGE'
2025-07-11T01:37:53.801303Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2025-07-11T01:37:53.801306Z 0 Shutting down plugin 'INNODB_CMP_PER_INDEX'
2025-07-11T01:37:53.801309Z 0 Shutting down plugin 'INNODB_CMPMEM_RESET'
2025-07-11T01:37:53.801312Z 0 Shutting down plugin 'INNODB_CMPMEM'
2025-07-11T01:37:53.801315Z 0 Shutting down plugin 'INNODB_CMP_RESET'
2025-07-11T01:37:53.801319Z 0 Shutting down plugin 'INNODB_CMP'
2025-07-11T01:37:53.801322Z 0 Shutting down plugin 'INNODB_LOCK_WAITS'
2025-07-11T01:37:53.801325Z 0 Shutting down plugin 'INNODB_LOCKS'
2025-07-11T01:37:53.801329Z 0 Shutting down plugin 'INNODB_TRX'
2025-07-11T01:37:53.801332Z 0 Shutting down plugin 'InnoDB'
2025-07-11T01:37:53.801497Z 0 InnoDB: FTS optimize thread exiting.
2025-07-11T01:37:53.801750Z 0 InnoDB: Starting shutdown...
2025-07-11T01:37:53.902061Z 0 InnoDB: Dumping buffer pool(s) to /www/server/data/ib_buffer_pool
2025-07-11T01:37:53.903510Z 0 InnoDB: Buffer pool(s) dump completed at 2507119:37:53
2025-07-11T01:37:55.272432Z 0 InnoDB: Shutdown completed; log sequence number 1975116141
2025-07-11T01:37:55.304604Z 0 InnoDB: Removed temporary tablespace data file: "ibtmp1"
2025-07-11T01:37:55.304642Z 0 Shutting down plugin 'MEMORY'
2025-07-11T01:37:55.304669Z 0 Shutting down plugin 'CSV'
2025-07-11T01:37:55.304675Z 0 Shutting down plugin 'sha256_password'
2025-07-11T01:37:55.304679Z 0 Shutting down plugin 'mysql_native_password'
2025-07-11T01:37:55.304830Z 0 Shutting down plugin 'binlog'
2025-07-11T01:37:55.305922Z 0 /www/server/mysql/bin/mysqld: Shutdown complete

阿珂 发表于 昨天 14:23

请将问题描述清晰一点
上面的日志也是正常的
页: [1]
查看完整版本: 【待反馈】修改了mysql的innodb_buffer_pool_size和innodb_log_buffer_s...