最近使用docker搭建了一個mysql資料庫進行測驗,發現總是出現如下問題,甚是苦惱,調整引數好久也不見好,不知道為什么,來求助一下,是哪方面的原因,如何解決?
mysql57 | 2020-05-14T04:07:24.151431Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4252ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:38.309338Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4156ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:45.676443Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4367ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:07:55.043402Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4366ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:05.352199Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4307ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:12.785909Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4434ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:20.211744Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4426ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:41.410495Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4197ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:46.895191Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4484ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:08:55.280145Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4384ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
mysql57 | 2020-05-14T04:09:00.556009Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4275ms. The settings might not be optimal. (flushed=2000 and evicted=0, during the time.)
另外誰有好用的生產環境的mysql的docker-compose檔案,發一個學習學習。謝謝。
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/18263.html
標籤:MySQL
上一篇:Unknown column 'goods_id' in 'field list'] with root cause
下一篇:資料庫
