2022-04-19 17:48:20 0 [Note] InnoDB: Uses event mutexes
2022-04-19 17:48:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-04-19 17:48:20 0 [Note] InnoDB: Number of pools: 1
2022-04-19 17:48:20 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-04-19 17:48:20 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2022-04-19 17:48:20 0 [Note] InnoDB: Completed initialization of buffer pool
2022-04-19 17:48:20 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-04-19 17:48:20 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-04-19 17:48:20 0 [Note] InnoDB:
2022-04-19 17:48:20 0 [Note] InnoDB: File 'C:\Programs\xampp\mysql\data\ibtmp1' size is now 12 MB.
2022-04-19 17:48:20 0 [Note] InnoDB: Waiting for purge to start
2022-04-19 17:48:20 0 [Note] InnoDB: 10.4.22 started; log sequence number 64561191; transaction id 22574
2022-04-19 17:48:20 0 [Note] InnoDB: Loading buffer pool(s) from C:\Programs\xampp\mysql\data\ib_buffer_pool
2022-04-19 17:48:20 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-04-19 17:48:20 0 [Note] Server socket created on IP: '::'.
解决方案
This one helped for me:
Open shell from from control panel and start mysql with this command:
mysqld –-console –-skip-grant-tables –-skip-external-locking
Open another shell from control panel and repair database with this command:
mysqlcheck -r --databases mysql --use-frm
Stop mysql, close shells and restart mysql normally.
这是一段关于MySQL数据库启动过程的日志记录。日志显示了InnoDB引擎的详细状态,包括使用了event mutexes,压缩表使用了zlib1.2.11,初始化了16M大小的缓冲池,创建了共享表空间用于临时表,并完成了其他关键设置。此外,还提供了在控制面板中修复数据库的命令行方法。

1759

被折叠的 条评论
为什么被折叠?



