当我尝试启动 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?