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 並且效果很好。但是這次我不想這樣做並重新創建我的數據庫。我想知道如何解決它。另外,如果有更好的地方問這個問題,請告訴我。
ibtmp1’ 大小為 12 MB。物理寫入文件已滿
增加該文件的設置。
尋找需要巨大臨時表的複雜查詢。
緩衝池,總大小 = 16M
這是一個非常小的值。你有多少記憶體?