write_through 寫效能下降
保持預設的 WRITE BACK 模式 既有斷電保障，還比直接落盤寫效率高很多
有人遇到電池沒電後會導致wb自動切換成為 wt 導致應用不能很好的使用資料庫，我們還是繼續保持預設WB 模式為好
WT 的 mysql 報錯 ，而 WB 模式並無任何報錯
2017-09-30T13:36:20.536364-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27226ms. The settings might not be optimal. (flushed=41258, during the time.)
2017-09-30T14:08:55.105845-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30465ms. The settings might not be optimal. (flushed=44276, during the time.)
2017-09-30T14:48:29.466910-05:00 3215215 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (338 search iterations)! 0 failed attempts to flush a page! Consider increasing the buffer pool size. It is also possible that in your Unix version fsync is very slow, or completely frozen inside the OS kernel. Then upgrading to a newer version of your operating system may help. Look at the number of fsyncs in diagnostic info below. Pending flushes (fsync) log: 1; buffer pool: 0. 202176437 OS file reads, 311019931 OS file writes, 54744485 OS fsyncs. Starting InnoDB Monitor to print further diagnostics to the standard output.
2017-09-30T15:04:54.379878-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8135ms. The settings might not be optimal. (flushed=13398, during the time.)
2017-09-30T15:08:54.445348-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4078ms. The settings might not be optimal. (flushed=9818, during the time.)
2017-09-30T15:09:10.136169-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5531ms. The settings might not be optimal. (flushed=9268, during the time.)
2017-09-30T15:09:33.459816-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=8834, during the time.)
2017-09-30T15:09:42.485105-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5093ms. The settings might not be optimal. (flushed=8987, during the time.)
2017-09-30T15:10:02.070489-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4618ms. The settings might not be optimal. (flushed=9218, during the time.)
2017-09-30T15:10:15.758585-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4656ms. The settings might not be optimal. (flushed=8517, during the time.)
2017-09-30T15:10:32.225959-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5723ms. The settings might not be optimal. (flushed=9218, during the time.)
2017-09-30T15:10:44.975026-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4025ms. The settings might not be optimal. (flushed=8680, during the time.)
2017-09-30T15:10:57.038398-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4318ms. The settings might not be optimal. (flushed=8341, during the time.)
2017-09-30T15:11:10.056846-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4102ms. The settings might not be optimal. (flushed=7860, during the time.)
2017-09-30T15:11:28.768481-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4701ms. The settings might not be optimal. (flushed=8098, during the time.)
2017-09-30T15:11:45.506375-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4196ms. The settings might not be optimal. (flushed=7940, during the time.)
2017-09-30T15:11:52.828816-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4255ms. The settings might not be optimal. (flushed=7772, during the time.)
2017-09-30T15:12:09.973874-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4597ms. The settings might not be optimal. (flushed=7995, during the time.)
2017-09-30T15:12:22.056560-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4266ms. The settings might not be optimal. (flushed=7740, during the time.)
2017-09-30T15:12:38.725646-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4412ms. The settings might not be optimal. (flushed=8123, during the time.)
2017-09-30T15:12:46.209293-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4741ms. The settings might not be optimal. (flushed=7839, during the time.)
2017-09-30T15:13:03.163932-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4172ms. The settings might not be optimal. (flushed=7719, during the time.)
2017-09-30T15:13:35.192250-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4195ms. The settings might not be optimal. (flushed=7822, during the time.)
2017-09-30T15:14:04.030744-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4026ms. The settings might not be optimal. (flushed=8047, during the time.)
2017-09-30T15:14:44.999564-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4084ms. The settings might not be optimal. (flushed=7735, during the time.)
2017-09-30T15:49:28.538883-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4205ms. The settings might not be optimal. (flushed=8259, during the time.)
2017-09-30T15:49:53.059162-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4222ms. The settings might not be optimal. (flushed=8248, during the time.)
2017-09-30T15:51:20.537326-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4177ms. The settings might not be optimal. (flushed=8281, during the time.)
2017-09-30T15:51:32.638340-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4243ms. The settings might not be optimal. (flushed=8231, during the time.)
2017-09-30T15:52:11.712412-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4183ms. The settings might not be optimal. (flushed=8303, during the time.)
2017-09-30T15:52:23.142132-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4355ms. The settings might not be optimal. (flushed=8313, during the time.)
2017-09-30T15:52:42.382894-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4214ms. The settings might not be optimal. (flushed=8239, during the time.)
2017-09-30T15:52:50.100106-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4142ms. The settings might not be optimal. (flushed=8210, during the time.)
2017-09-30T15:53:01.685696-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4019ms. The settings might not be optimal. (flushed=8202, during the time.)
2017-09-30T15:53:31.652008-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4036ms. The settings might not be optimal. (flushed=8437, during the time.)
2017-09-30T15:53:39.785651-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4334ms. The settings might not be optimal. (flushed=8674, during the time.)
2017-09-30T15:53:52.625224-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4210ms. The settings might not be optimal. (flushed=8936, during the time.)
2017-09-30T15:54:01.414010-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4872ms. The settings might not be optimal. (flushed=8965, during the time.)
2017-09-30T15:54:15.390619-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4651ms. The settings might not be optimal. (flushed=9237, during the time.)
2017-09-30T15:54:37.822601-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4473ms. The settings might not be optimal. (flushed=9743, during the time.)
2017-09-30T15:55:10.800287-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4873ms. The settings might not be optimal. (flushed=10321, during the time.)
2017-09-30T15:55:26.264774-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5606ms. The settings might not be optimal. (flushed=10707, during the time.)
2017-09-30T15:55:53.103691-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4843ms. The settings might not be optimal. (flushed=11236, during the time.)
2017-09-30T15:56:43.406587-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6169ms. The settings might not be optimal. (flushed=12213, during the time.)
2017-09-30T15:58:31.431497-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6298ms. The settings might not be optimal. (flushed=13812, during the time.)
2017-09-30T16:09:44.172752-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37696ms. The settings might not be optimal. (flushed=44330, during the time.)
2017-09-30T16:42:32.123322-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22239ms. The settings might not be optimal. (flushed=42505, during the time.)
2017-09-30T17:36:48.148870-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7156ms. The settings might not be optimal. (flushed=20004, during the time.)
有人遇到電池沒電後會導致wb自動切換成為 wt 導致應用不能很好的使用資料庫，我們還是繼續保持預設WB 模式為好
WT 的 mysql 報錯 ，而 WB 模式並無任何報錯
/opt/MegaRAID/MegaCli/MegaCli64 -LDSetProp -WT -Lall -aALL
2017-09-30T13:36:20.536364-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27226ms. The settings might not be optimal. (flushed=41258, during the time.)
2017-09-30T14:08:55.105845-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30465ms. The settings might not be optimal. (flushed=44276, during the time.)
2017-09-30T14:48:29.466910-05:00 3215215 [Warning] InnoDB: Difficult to find free blocks in the buffer pool (338 search iterations)! 0 failed attempts to flush a page! Consider increasing the buffer pool size. It is also possible that in your Unix version fsync is very slow, or completely frozen inside the OS kernel. Then upgrading to a newer version of your operating system may help. Look at the number of fsyncs in diagnostic info below. Pending flushes (fsync) log: 1; buffer pool: 0. 202176437 OS file reads, 311019931 OS file writes, 54744485 OS fsyncs. Starting InnoDB Monitor to print further diagnostics to the standard output.
2017-09-30T15:04:54.379878-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8135ms. The settings might not be optimal. (flushed=13398, during the time.)
2017-09-30T15:08:54.445348-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4078ms. The settings might not be optimal. (flushed=9818, during the time.)
2017-09-30T15:09:10.136169-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5531ms. The settings might not be optimal. (flushed=9268, during the time.)
2017-09-30T15:09:33.459816-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4303ms. The settings might not be optimal. (flushed=8834, during the time.)
2017-09-30T15:09:42.485105-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5093ms. The settings might not be optimal. (flushed=8987, during the time.)
2017-09-30T15:10:02.070489-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4618ms. The settings might not be optimal. (flushed=9218, during the time.)
2017-09-30T15:10:15.758585-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4656ms. The settings might not be optimal. (flushed=8517, during the time.)
2017-09-30T15:10:32.225959-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5723ms. The settings might not be optimal. (flushed=9218, during the time.)
2017-09-30T15:10:44.975026-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4025ms. The settings might not be optimal. (flushed=8680, during the time.)
2017-09-30T15:10:57.038398-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4318ms. The settings might not be optimal. (flushed=8341, during the time.)
2017-09-30T15:11:10.056846-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4102ms. The settings might not be optimal. (flushed=7860, during the time.)
2017-09-30T15:11:28.768481-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4701ms. The settings might not be optimal. (flushed=8098, during the time.)
2017-09-30T15:11:45.506375-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4196ms. The settings might not be optimal. (flushed=7940, during the time.)
2017-09-30T15:11:52.828816-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4255ms. The settings might not be optimal. (flushed=7772, during the time.)
2017-09-30T15:12:09.973874-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4597ms. The settings might not be optimal. (flushed=7995, during the time.)
2017-09-30T15:12:22.056560-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4266ms. The settings might not be optimal. (flushed=7740, during the time.)
2017-09-30T15:12:38.725646-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4412ms. The settings might not be optimal. (flushed=8123, during the time.)
2017-09-30T15:12:46.209293-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4741ms. The settings might not be optimal. (flushed=7839, during the time.)
2017-09-30T15:13:03.163932-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4172ms. The settings might not be optimal. (flushed=7719, during the time.)
2017-09-30T15:13:35.192250-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4195ms. The settings might not be optimal. (flushed=7822, during the time.)
2017-09-30T15:14:04.030744-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4026ms. The settings might not be optimal. (flushed=8047, during the time.)
2017-09-30T15:14:44.999564-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4084ms. The settings might not be optimal. (flushed=7735, during the time.)
2017-09-30T15:49:28.538883-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4205ms. The settings might not be optimal. (flushed=8259, during the time.)
2017-09-30T15:49:53.059162-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4222ms. The settings might not be optimal. (flushed=8248, during the time.)
2017-09-30T15:51:20.537326-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4177ms. The settings might not be optimal. (flushed=8281, during the time.)
2017-09-30T15:51:32.638340-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4243ms. The settings might not be optimal. (flushed=8231, during the time.)
2017-09-30T15:52:11.712412-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4183ms. The settings might not be optimal. (flushed=8303, during the time.)
2017-09-30T15:52:23.142132-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4355ms. The settings might not be optimal. (flushed=8313, during the time.)
2017-09-30T15:52:42.382894-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4214ms. The settings might not be optimal. (flushed=8239, during the time.)
2017-09-30T15:52:50.100106-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4142ms. The settings might not be optimal. (flushed=8210, during the time.)
2017-09-30T15:53:01.685696-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4019ms. The settings might not be optimal. (flushed=8202, during the time.)
2017-09-30T15:53:31.652008-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4036ms. The settings might not be optimal. (flushed=8437, during the time.)
2017-09-30T15:53:39.785651-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4334ms. The settings might not be optimal. (flushed=8674, during the time.)
2017-09-30T15:53:52.625224-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4210ms. The settings might not be optimal. (flushed=8936, during the time.)
2017-09-30T15:54:01.414010-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4872ms. The settings might not be optimal. (flushed=8965, during the time.)
2017-09-30T15:54:15.390619-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4651ms. The settings might not be optimal. (flushed=9237, during the time.)
2017-09-30T15:54:37.822601-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4473ms. The settings might not be optimal. (flushed=9743, during the time.)
2017-09-30T15:55:10.800287-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4873ms. The settings might not be optimal. (flushed=10321, during the time.)
2017-09-30T15:55:26.264774-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5606ms. The settings might not be optimal. (flushed=10707, during the time.)
2017-09-30T15:55:53.103691-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4843ms. The settings might not be optimal. (flushed=11236, during the time.)
2017-09-30T15:56:43.406587-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6169ms. The settings might not be optimal. (flushed=12213, during the time.)
2017-09-30T15:58:31.431497-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6298ms. The settings might not be optimal. (flushed=13812, during the time.)
2017-09-30T16:09:44.172752-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37696ms. The settings might not be optimal. (flushed=44330, during the time.)
2017-09-30T16:42:32.123322-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22239ms. The settings might not be optimal. (flushed=42505, during the time.)
2017-09-30T17:36:48.148870-05:00 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7156ms. The settings might not be optimal. (flushed=20004, during the time.)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29291882/viewspace-2145660/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- MySQL 偶爾抽風，效能突然下降MySql
- Delete大量資料後SQL Server效能下降deleteSQLServer
- MySQL 缺少主鍵的表的效能下降的原因MySql
- 【案例】BNL演算法導致效能下降一則演算法
- MYSQL 寫效能測試MySql
- MongoDB 分片叢集均衡器導致的效能下降MongoDB
- 叢集寫效能優化優化
- ES寫入效能優化優化
- 編寫高效能JavaScriptJavaScript
- 遊戲效能下降15%，Win11首次更新讓AMD CPU受挫遊戲
- 效能下降的不定時炸彈_過舊的sql_profileSQL
- 10g ALL_SYNONYMS同義詞查詢效能下降
- Spring Boot 微服務效能下降九成！使用 Arthas 定位根因Spring Boot微服務
- 一次資料庫上雲遷移效能下降的排查資料庫
- 編寫高效能的JavaScriptJavaScript
- 如何寫出高效能SQLSQL
- 如何寫出效能好的sqlSQL
- 座標下降與梯度下降梯度
- 升級win10 1903系統後效能下降如何解決Win10
- 效能測試報告編寫技巧測試報告
- 自己上手寫效能測試工具（二）
- 編寫高效能的JavaScript事件JavaScript事件
- 非索引列直方圖的丟失導致sql效能急劇下降索引直方圖SQL
- HP probook 系列筆記本Only電池效能下降的問題說明筆記
- 梯度下降梯度
- 編寫高效能的Java程式碼Java
- 編寫高效能的 Swift 程式碼Swift
- 編寫高效能的 Lua 程式碼
- 如何寫出高效能SQL語句SQL
- Android 效能優化（十二）之我為什麼寫效能優化Android優化
- linux 下filesystemio_options disk_asynch_io 導致的I/O效能下降Linux
- 10203升級到10205後個別SQL效能下降SQL
- MySQL效能優化之簡單sql改寫MySql優化
- 編寫高效能React元件-傳值篇React元件
- Android 高效能日誌寫入方案Android
- Flink實戰之寫Hive效能問題Hive
- 對提高HBase寫效能的一些思考
- 效能測試: 編寫一個 Locust 檔案