Xampp,mysql 每次启动时都会崩溃

Xampp,mysql 每次启动时都会崩溃

当我尝试启动 mysql 时,它关闭:

Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies, 
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums

日志内容如下:

019-12-30 11:38:45 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions

2019-12-30 11:38:45 0 [Note] InnoDB: Uses event mutexes

2019-12-30 11:38:45 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

2019-12-30 11:38:45 0 [Note] InnoDB: Number of pools: 1

2019-12-30 11:38:45 0 [Note] InnoDB: Using SSE2 crc32 instructions

2019-12-30 11:38:45 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M

2019-12-30 11:38:45 0 [Note] InnoDB: Completed initialization of buffer pool

2019-12-30 11:38:45 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2019-12-30 11:38:45 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-12-30 11:38:45 0 [Note] InnoDB: Setting file 

'D:\a\dec8\xammp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2019-12-30 11:38:45 0 [Note] InnoDB: File 'D:\a\dec8\xammp\mysql\data\ibtmp1' size is now 12 MB.

2019-12-30 11:38:45 0 [Note] InnoDB: Waiting for purge to start

2019-12-30 11:38:45 0 [Note] InnoDB: 10.4.10 started; log sequence number 113890; transaction id 9

2019-12-30 11:38:45 0 [Note] InnoDB: Loading buffer pool(s) from D:\a\dec8\xammp\mysql\data\ib_buffer_pool

2019-12-30 11:38:45 0 [Note] Plugin 'FEEDBACK' is disabled.

2019-12-30 11:38:45 0 [Note] InnoDB: Buffer pool(s) load completed at 191230 11:38:45

2019-12-30 11:38:45 0 [Note] Server socket created on IP: '::'.

我看了多个视频,但没有一个能告诉我如何解决这个问题。我以前也遇到过这种情况,我只是重新安装了 xammp,一切正常。但是这次我不想这样做,而是重新创建我的数据库。我想知道如何修复它。另外,如果有更好的地方可以问这个问题,请告诉我。

答案1

ibtmp1' 的大小为 12 MB。物理上写入文件完整

增加该文件的设置。

寻找需要巨大临时表的复杂查询。

缓冲池,总大小 = 16M

这个值太小了。你有多少 RAM?

相关内容