台灣最大程式設計社群網站
線上人數
685
 
會員總數:245596
討論主題:189303
歡迎您免費加入會員
討論區列表 >> MySQL >> MySQL Server 5.0 inndb
[]  
[我要回覆]
回應主題 加入我的關注話題 檢舉此篇討論 將提問者加入個人黑名單
MySQL Server 5.0 inndb
價值 : 50 QP  點閱數:320 回應數:0

樓主

小島上的男人
初學者
92 79
1527 152
發送站內信

各位專家好

Website innoDB 時常會不定時自動開始關閉,因有設定會自動開啟,所以InnoDB會於關閉後自動開啟,但這個問題很不尋常,不知該如何排除

可否提供小弟方法,可以排除這個問題,謝謝各位大大。

error log 如下:
190725 23:48:06 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
190725 23:48:08 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 4317779.
InnoDB: Doing recovery: scanned up to log sequence number 0 4317779
190725 23:48:09 InnoDB: Started; log sequence number 0 4317779
190725 23:48:10 [Note] D:\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
190726 1:48:51 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
190726 1:48:54 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 4317789.
InnoDB: Doing recovery: scanned up to log sequence number 0 4317789
190726 1:48:55 InnoDB: Started; log sequence number 0 4317789
190726 1:48:55 [Note] D:\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
190726 8:36:48 [Note] D:\MySQL Server 5.0\bin\mysqld-nt: Normal shutdown

190726 8:36:48 InnoDB: Starting shutdown...
190726 8:36:50 InnoDB: Shutdown completed; log sequence number 0 4317799
190726 8:36:50 [Note] D:\MySQL Server 5.0\bin\mysqld-nt: Shutdown complete

190726 8:37:24 InnoDB: Started; log sequence number 0 4317799
190726 8:37:25 [Note] D:\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.27-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL)





搜尋相關Tags的文章: [ MySQL Server 5.0 inndb ] ,
本篇文章發表於2019-07-26 10:15
別忘捐VP感謝幫助你的人 新手會員瞧一瞧
目前尚無任何回覆
   

回覆
如要回應,請先登入.