Mysql

Xampp,mysql每次啟動時都會崩潰

  • February 20, 2021

當我嘗試啟動 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 並且效果很好。但是這次我不想這樣做並重新創建我的數據庫。我想知道如何解決它。另外,如果有更好的地方問這個問題,請告訴我。

ibtmp1’ 大小為 12 MB。物理寫入文件已滿

增加該文件的設置。

尋找需要巨大臨時表的複雜查詢。

緩衝池,總大小 = 16M

這是一個非常小的值。你有多少記憶體?

引用自:https://serverfault.com/questions/997159