Очень сильно стал тормозить форум

Danik_com · 16 Июл 2018

Всем привет, возникла большая проблема, страницы форума периодически то вообще не грузятся, то приходится ждать по 20 секунд, ЦП грузится по максимуму, было подозрение на ddos, перевел ДНС на cloudflare, перевел в режим "я под атакой", но это не помогло, можно ли сделать вывод, что проблема не в ддос атаке?
Проблема начиналась плавно, а достигла своего максимума после установки шлюза вебмани (возможно совпадение), в конце установки выбило ошибку 404, могло ли что-то не до конца установится и теперь из-за этого какой-то скрипт шлет кучу запросов в секунду? в логах есть вот такое:

Код:

#0 /var/www/html/forum/src/XF/Db/Mysqli/Adapter.php(28): XF\Db\Mysqli\Adapter->makeConnection(Array)
#1 /var/www/html/forum/src/XF/Db/AbstractAdapter.php(51): XF\Db\Mysqli\Adapter->getConnection()
#2 /var/www/html/forum/src/XF/Db/Mysqli/Adapter.php(113): XF\Db\AbstractAdapter->connect()
#3 /var/www/html/forum/src/XF/Db/AbstractAdapter.php(410): XF\Db\Mysqli\Adapter->escapeString('options')
#4 /var/www/html/forum/src/XF/Db/AbstractAdapter.php(388): XF\Db\AbstractAdapter->quote('options')
#5 /var/www/html/forum/src/XF/DataRegistry.php(137): XF\Db\AbstractAdapter->quote(Array)
#6 /var/www/html/forum/src/XF/DataRegistry.php(82): XF\DataRegistry->readFromDb(Array, Array)
#7 /var/www/html/forum/src/XF/DataRegistry.php(225): XF\DataRegistry->get(Array)
#8 /var/www/html/forum/src/XF/App.php(1439): XF\DataRegistry->offsetGet('options')
#9 /var/www/html/forum/src/XF" while reading response header from upstream, client: 172.68.239.63, server: "айпи сервера", request: "GET /forum/admin.php HTTP/1.1", upst$

Буду благодарен за любые советы и помощь, к хостеру обращался, он тоже делает всё что в его силах, но пока безуспешно.

Mirovinger · 16 Июл 2018

Приветствую.
Дополнение шлюза проблему не могло вызвать, а вот на список дополнений и лог ошибок на хосте, я бы посмотрел.

Danik_com · 16 Июл 2018

Mirovinger написал(а):
Приветствую.
Дополнение шлюза проблему не могло вызвать, а вот на список дополнений и лог ошибок на хосте, я бы посмотрел.

Вот ошибки сервера

И вот появилось какое-то окно требующее перестроения - нажимал, долго грузится и заканчивается 404

2 файла с неожиданным содержимым - это я редактировал давно

IlyaPep · 16 Июл 2018

У вас проблемы с бд, их не должно быть, возможно эти проблемы и вызывают такие нагрузки. Ещё возможно хостинг плохой, не выдерживает нагрузок и это отображается на скорости работы форума

Danik_com · 16 Июл 2018

Dikers написал(а):
У вас проблемы с бд, их не должно быть, возможно эти проблемы и вызывают такие нагрузки. Ещё возможно хостинг плохой, не выдерживает нагрузок и это отображается на скорости работы форума

С бд да, вы правы, есть ошибки по mysql, но что их могло вызвать?
Сервер вчера повысил в 3 раза, изменений не дало.
Еще заметил странность - не могу войти в админку используя ру прокси (до этого всегда входил), ввожу пароль, нажимаю войти, долго грузится и всё, остаюсь на форме входа. Меняю айпи на украинский- заходит.

IlyaPep · 16 Июл 2018

Danik_com написал(а):
С бд да, вы правы, есть ошибки по mysql, но что их могло вызвать?
Сервер вчера повысил в 3 раза, изменений не дало.
Еще заметил странность - не могу войти в админку используя ру прокси (до этого всегда входил), ввожу пароль, нажимаю войти, долго грузится и всё, остаюсь на форме входа. Меняю айпи на украинский- заходит.

OFFTOP

а почему вы с впн сидите?

Mirovinger · 16 Июл 2018

Я бы рекомендовал просто перейти на ВПС.

Danik_com · 16 Июл 2018

Mirovinger написал(а):
Я бы рекомендовал просто перейти на ВПС.

у меня и стоит vds, насколько я знаю, это тоже самое. Или вы имеете ввиду полностью выделенный сервер?

Mirovinger · 16 Июл 2018

Хм, с этого и нужно было начинать, тогда настройки ВПС смотреть.

Danik_com · 16 Июл 2018

Понимаю, что вариант глупый, но напишу:

Я заметил, что на всех форумах xenforo пишут, чтобы загружали картинки на их сервер, а я копировал в темы много статей целиком, со всеми картинками, то есть не загружая их отдельно, а просто копи пастом, не могло ли это вызывать проблемы в БД и есть ли минусы у такого способа загрузки картинок?

Mirovinger · 16 Июл 2018

Нет, это не является причиной проблемы, здесь проблемы с транзакциями в БД, список дополнений можно.

Danik_com · 16 Июл 2018

Mirovinger написал(а):
Нет, это не является причиной проблемы, здесь проблемы с транзакциями в БД, список дополнений можно.

Вот поэтому и было подозрение на шлюз вебмани, кроме него дополнений не устанавливалось, сейчас висит только один плагин - Metro Theme Management 1.0.0, устанавливалась вместе с форумом и всё.

Mirovinger · 16 Июл 2018

Платёжный шлюз вообще на работу базы не влияет таким образом.

Danik_com написал(а):
Metro Theme Management 1.0.0

Что-то я такого не припоминаю, а если проблемы с БД есть, то смотреть логи сервера.

Sanar · 16 Июл 2018

Возможно на хост сильно большие нагрузки - попробуйте увеличить параметры

Mirovinger · 16 Июл 2018

Ага, давайте от балды параметры увеличим, логи в первую очередь смотреть.

Danik_com · 16 Июл 2018

Mirovinger написал(а):
Ага, давайте от балды параметры увеличим, логи в первую очередь смотреть.

Прикрепил код с логами из папки log/mysql

Код:

2018-07-15T04:31:52.120894Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5240ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T04:46:28.617639Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4384ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T04:46:42.165698Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5060ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T04:47:18.587672Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9525ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T04:47:53.648132Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4156ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T04:48:55.005897Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8561ms. The settings might not be optimal. (flushed=146 and evicted=0, during the time.)
2018-07-15T04:49:33.041302Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8511ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T04:49:47.705532Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7659ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T04:49:57.248233Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4983ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T04:50:31.393423Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13039ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T04:51:07.211427Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8520ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T04:56:20.251176Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4982ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T04:57:15.996432Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23281ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:08:43.080072Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4546ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T05:08:58.204352Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7695ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T05:09:30.202028Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5094ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T05:14:46.373557Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7576ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T05:24:24.840126Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11252ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T05:26:41.995817Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5292ms. The settings might not be optimal. (flushed=118 and evicted=0, during the time.)
2018-07-15T05:27:02.481488Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9222ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T05:27:14.626194Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4389ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:27:26.822863Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7225ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:32:10.156148Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6273ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T05:37:25.041100Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15005ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T05:37:47.937423Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9047ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T05:41:10.739991Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15808ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T05:41:34.937305Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4609ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T05:45:23.997139Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9818ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T05:45:59.574031Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23351ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T05:46:14.063408Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4392ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:46:22.712785Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5607ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:46:33.946055Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10234ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T05:51:04.052705Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16120ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T05:51:24.862409Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7105ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T05:51:40.132655Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6768ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T05:51:54.309067Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13176ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T05:52:08.470113Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5042ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T05:58:44.406916Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6247ms. The settings might not be optimal. (flushed=135 and evicted=0, during the time.)
2018-07-15T05:59:05.142441Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9354ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:59:15.724771Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4581ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T05:59:22.082036Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4358ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T06:28:54.671026Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10961ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T06:29:05.365071Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5859ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T06:29:33.496084Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4336ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T06:29:57.522397Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7550ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T06:30:20.422434Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9779ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T06:30:45.899554Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21313ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T06:30:58.236490Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10337ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T06:31:21.290023Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8763ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T06:39:33.657225Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4768ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T06:39:51.303964Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15646ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T06:39:58.458037Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6154ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T06:40:14.853629Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5893ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:01:22.030872Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12902ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T07:01:58.683301Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26495ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:02:12.590723Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11906ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T07:02:35.989798Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11901ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:11:28.244406Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 35129ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T07:11:54.059176Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18693ms. The settings might not be optimal. (flushed=135 and evicted=0, during the time.)
2018-07-15T07:13:22.446678Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12255ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T07:13:38.262915Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5709ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:14:00.642049Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6248ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:18:49.742993Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13046ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T07:19:03.098419Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5332ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:20:20.069977Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4566ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T07:20:45.481413Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17132ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T07:21:23.124051Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13923ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T07:21:38.057041Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8366ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T07:22:02.935247Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10669ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T07:22:15.956394Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12021ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T07:22:35.339913Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14398ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T07:23:03.364826Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5470ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:23:08.480597Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4116ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T07:23:25.642142Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8157ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T07:23:30.942682Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4300ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:24:08.710996Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9911ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T07:24:14.247921Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4537ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:24:23.002315Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6754ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T07:24:38.880135Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4841ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T07:24:58.669522Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15185ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T07:25:10.262781Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6218ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T07:26:12.532008Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4804ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T07:26:33.446283Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7653ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T07:26:53.319648Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7753ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T07:27:11.109607Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6498ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T07:27:16.889839Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4780ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T07:27:36.918400Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7964ms. The settings might not be optimal. (flushed=100 and evicted=0, during the time.)
2018-07-15T07:37:41.287556Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14417ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:37:49.100481Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6813ms. The settings might not be optimal. (flushed=28 and evicted=0, during the time.)
2018-07-15T07:38:05.837944Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4728ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T07:40:44.641322Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25920ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T07:41:05.705269Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6802ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:44:48.429318Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4682ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T07:45:13.606308Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11723ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:45:21.043201Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6437ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T07:45:30.148340Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8105ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:46:22.541269Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5387ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T07:46:47.964923Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5732ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:49:34.260416Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5268ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T07:49:47.060785Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5074ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T07:51:40.628840Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6610ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T07:51:59.241178Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13295ms. The settings might not be optimal. (flushed=34 and evicted=0, during the time.)
2018-07-15T07:52:08.048367Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7807ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:52:13.972150Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4924ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T07:52:37.252792Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17769ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T07:53:08.286261Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20968ms. The settings might not be optimal. (flushed=182 and evicted=0, during the time.)
2018-07-15T07:57:06.711237Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12820ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T07:57:41.401769Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13625ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T07:57:51.797369Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9395ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:57:58.046344Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4249ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T07:58:11.744880Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4268ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T07:58:31.546943Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18801ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T07:58:47.005346Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4738ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T07:59:04.123456Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13988ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:03:10.258154Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12090ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T08:03:37.539313Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4920ms. The settings might not be optimal. (flushed=36 and evicted=0, during the time.)
2018-07-15T08:05:10.281153Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12820ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:11:14.240075Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9058ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T08:11:45.628663Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16958ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T08:14:24.433925Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8697ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T08:19:44.305864Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8580ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T08:20:25.798795Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20819ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:20:37.368822Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5797ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T08:20:49.171479Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4158ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:27:18.019530Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4732ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:42:54.416195Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4219ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T08:43:36.399238Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 33309ms. The settings might not be optimal. (flushed=151 and evicted=0, during the time.)
2018-07-15T08:43:54.670847Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5158ms. The settings might not be optimal. (flushed=49 and evicted=0, during the time.)
2018-07-15T08:44:09.778929Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8183ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:44:38.033090Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8420ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T08:45:50.647794Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31065ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T08:46:05.584862Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4729ms. The settings might not be optimal. (flushed=68 and evicted=0, during the time.)
2018-07-15T08:49:21.770523Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10983ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T08:50:12.123823Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18570ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T08:50:23.860931Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4214ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T08:50:37.534986Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12673ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T08:50:45.775471Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5238ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T08:51:20.426565Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27441ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T08:51:45.527379Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10447ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T08:52:33.144723Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15638ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:52:54.095253Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16457ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:53:59.552928Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8630ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T08:54:16.536111Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8377ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T08:54:58.119093Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8638ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T08:55:39.077093Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 34626ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T08:56:20.228712Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27689ms. The settings might not be optimal. (flushed=170 and evicted=0, during the time.)
2018-07-15T09:00:44.809443Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4026ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:00:51.977291Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4131ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:01:04.106178Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6062ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:03:24.243602Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6106ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T09:03:50.003709Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6444ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:12:27.494114Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5398ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T09:13:02.911569Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19853ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:13:11.334034Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7423ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T09:13:22.811214Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4261ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T09:13:44.853622Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7316ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T09:14:06.035194Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4709ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:14:17.751438Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8872ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:14:30.070213Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6558ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T09:14:46.059310Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5731ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:19:08.808155Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5704ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T09:19:43.155930Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4211ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:21:56.187320Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8948ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T09:22:24.135372Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11594ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T09:22:54.524308Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9631ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:23:02.494252Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4099ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:23:24.541729Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17297ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T09:26:26.615612Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13721ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T09:27:01.694137Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20716ms. The settings might not be optimal. (flushed=144 and evicted=0, during the time.)
2018-07-15T09:27:20.971053Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10637ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:27:26.947260Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4976ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T09:27:43.249072Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4103ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T09:32:51.091655Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6004ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T09:33:20.774587Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19103ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T09:33:39.196522Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7701ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:37:42.490984Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12245ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T09:37:56.304919Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4772ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T09:38:05.855705Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5500ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T09:38:33.100921Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5662ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:38:44.752644Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4202ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:39:08.053456Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12276ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T09:39:23.361270Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12650ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T09:44:10.390380Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8460ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T09:46:26.253028Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6246ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T09:46:47.867240Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11555ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T09:46:57.539251Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8672ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:50:39.962731Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6760ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T09:51:55.913306Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6767ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:00:34.673052Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21259ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T10:00:52.007274Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5271ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T10:01:14.917049Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8484ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T10:01:34.399029Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18481ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:07:08.175266Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24875ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T10:07:47.302105Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7036ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T10:08:09.813357Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6495ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T10:17:58.022440Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23353ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T10:18:35.067162Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10232ms. The settings might not be optimal. (flushed=186 and evicted=0, during the time.)
2018-07-15T10:19:21.424541Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19875ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T10:19:46.964200Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16340ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T10:20:04.700696Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10634ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T10:21:19.231311Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22572ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T10:21:39.902681Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5068ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:21:53.091936Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7765ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:22:21.626411Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14243ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T10:22:47.120212Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5544ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T10:23:12.112261Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17657ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T10:23:30.061399Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4884ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:23:43.460087Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12399ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:24:57.478952Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10010ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:25:16.095406Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4379ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T10:25:33.774069Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13033ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T10:26:23.656325Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20316ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:28:42.303319Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4613ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:29:29.453724Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8145ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T10:31:44.154012Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23285ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:32:10.359226Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11039ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T10:32:54.039446Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6828ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T10:34:52.624357Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12324ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T10:35:15.806544Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17758ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T10:35:50.936650Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12998ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T10:36:21.793538Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10344ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T10:39:48.220221Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11452ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:40:00.778406Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10558ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T10:40:42.924559Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31491ms. The settings might not be optimal. (flushed=36 and evicted=0, during the time.)
2018-07-15T10:41:18.179672Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8955ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T10:42:13.437448Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17856ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T10:42:38.598363Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18780ms. The settings might not be optimal. (flushed=151 and evicted=0, during the time.)
2018-07-15T10:43:10.582576Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15382ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T10:43:51.402976Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30451ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T10:44:06.851695Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4916ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:44:18.671938Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10719ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:44:34.253638Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13573ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T10:45:07.075947Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19315ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:45:29.327745Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10833ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T10:46:16.425821Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18986ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T10:47:05.615802Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16137ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:47:41.278821Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18737ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T10:47:57.401161Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6478ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T10:48:25.498090Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8697ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T10:49:09.638533Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5085ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:51:09.260197Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25602ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T10:52:03.186453Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25451ms. The settings might not be optimal. (flushed=42 and evicted=0, during the time.)
2018-07-15T10:52:46.864619Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7098ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:54:23.003774Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 33130ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T10:54:51.994890Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18907ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T10:55:32.997424Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12389ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T10:58:02.202580Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11176ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T10:58:18.458614Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5858ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T10:58:35.140384Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4537ms. The settings might not be optimal. (flushed=35 and evicted=0, during the time.)
2018-07-15T11:02:38.690662Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13395ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T11:05:55.976040Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12767ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T11:06:25.945682Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15455ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T11:06:58.174059Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4252ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:07:06.615844Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6441ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T11:07:37.990115Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12187ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:13:10.227311Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10185ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T11:13:26.193400Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9256ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T11:14:00.069558Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14214ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:14:20.798498Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19729ms. The settings might not be optimal. (flushed=156 and evicted=0, during the time.)
2018-07-15T11:16:59.277218Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9191ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T11:17:33.872719Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28299ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T11:18:04.440727Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6051ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T11:18:49.374452Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31610ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T11:19:13.189065Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10948ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T11:19:28.137101Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5141ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:19:53.554063Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18417ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T11:20:14.749213Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14986ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T11:20:26.579229Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10830ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:20:54.774042Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26195ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T11:21:01.531350Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5757ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:21:26.032862Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11853ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:21:47.364891Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19331ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T11:22:13.410537Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9276ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:26:46.948090Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12492ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T11:27:10.908038Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13102ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T11:27:40.070848Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8433ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T11:27:53.530304Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9369ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T11:28:16.528641Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16071ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T11:28:50.135879Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15238ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:29:04.663951Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12528ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T11:29:30.226653Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6903ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T11:29:36.314357Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5088ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:32:49.801815Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13460ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T11:33:09.458974Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16156ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T11:33:42.780161Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17766ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:34:13.572159Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 29792ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T11:34:57.564891Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27731ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:35:13.743996Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15178ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T11:35:52.186608Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18436ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T11:36:31.387235Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20374ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T11:36:49.417229Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17030ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:43:24.802095Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23329ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T11:43:44.496660Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12044ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:43:51.379835Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4883ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T11:44:43.879763Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10637ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:45:03.835894Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15371ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:45:11.386570Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6550ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T11:45:56.989830Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18176ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T11:46:13.528983Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8941ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T11:46:40.850969Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16204ms. The settings might not be optimal. (flushed=34 and evicted=0, during the time.)
2018-07-15T11:47:18.015569Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15897ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:47:38.794725Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13816ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:47:59.086134Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13265ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:48:22.149162Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6151ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T11:49:04.045291Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10322ms. The settings might not be optimal. (flushed=45 and evicted=0, during the time.)
2018-07-15T11:49:29.918689Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9328ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T11:49:53.433532Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10801ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T11:50:18.804739Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9735ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T11:51:19.507875Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12898ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T11:53:41.870668Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 66106ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T11:53:47.104142Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4234ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T11:54:20.107776Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23638ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T11:56:56.362321Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17424ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T11:57:03.763612Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6401ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T11:57:28.339565Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6673ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T11:58:22.438120Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27698ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T11:59:07.210761Z 1014 [Note] Aborted connection 1014 to db: 'xenforo' user: 'xenfor' host: 'localhost' (Got an error writing communication packets)
2018-07-15T11:59:10.310387Z 0 [Note] Giving 4 client threads a chance to die gracefully
2018-07-15T11:59:10.310477Z 0 [Note] Shutting down slave threads
2018-07-15T12:03:38.970202Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T12:03:39.005116Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T12:03:41.339511Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T12:03:42.412284Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 631 ...
2018-07-15T12:03:48.607064Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T12:03:48.607130Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T12:03:48.607144Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T12:03:48.607154Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T12:03:48.607174Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T12:03:48.607184Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T12:03:48.695700Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T12:03:49.407038Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T12:03:49.414300Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T12:03:50.189869Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T12:03:50.198746Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T12:03:51.404644Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T12:03:54.047741Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 297348212
2018-07-15T12:03:54.047844Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 297383071
2018-07-15T12:03:55.708277Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-07-15T12:03:55.708325Z 0 [Note] InnoDB: Starting crash recovery.
2018-07-15T12:03:55.732194Z 0 [Warning] InnoDB: Page 16 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=9]
2018-07-15T12:03:55.732247Z 0 [Warning] InnoDB: Page 17 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=10]
2018-07-15T12:03:55.732258Z 0 [Warning] InnoDB: Page 18 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=11]
2018-07-15T12:03:55.732286Z 0 [Warning] InnoDB: Page 19 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=12]
2018-07-15T12:03:55.732296Z 0 [Warning] InnoDB: Page 20 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=13]
2018-07-15T12:03:55.732307Z 0 [Warning] InnoDB: Page 21 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=14]
2018-07-15T12:03:55.732318Z 0 [Warning] InnoDB: Page 22 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=15]
2018-07-15T12:03:55.732327Z 0 [Warning] InnoDB: Page 23 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=16]
2018-07-15T12:03:55.732337Z 0 [Warning] InnoDB: Page 24 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=17]
2018-07-15T12:03:55.732347Z 0 [Warning] InnoDB: Page 25 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=18]
2018-07-15T12:03:55.732356Z 0 [Warning] InnoDB: Page 26 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=19]
2018-07-15T12:03:55.732440Z 0 [Warning] InnoDB: Page 27 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=20]
2018-07-15T12:03:55.732452Z 0 [Warning] InnoDB: Page 28 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=21]
2018-07-15T12:03:55.732461Z 0 [Warning] InnoDB: Page 29 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=22]
2018-07-15T12:03:55.732470Z 0 [Warning] InnoDB: Page 30 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=23]
2018-07-15T12:03:55.732479Z 0 [Warning] InnoDB: Page 31 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=24]
2018-07-15T12:03:55.732488Z 0 [Warning] InnoDB: Page 32 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=25]
2018-07-15T12:03:55.732496Z 0 [Warning] InnoDB: Page 33 in the doublewrite buffer is not within space bounds: page [page id: space=160, page number=26]
2018-07-15T12:04:01.602850Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
2018-07-15T12:04:02.240761Z 0 [Note] InnoDB: Apply batch completed
2018-07-15T12:05:03.168406Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T12:05:03.168551Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T12:05:03.168649Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T12:05:19.158012Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T12:05:19.162440Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T12:05:19.162490Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T12:05:19.166832Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 297383071
2018-07-15T12:05:19.166969Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 88968ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:05:19.177039Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T12:05:20.738011Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T12:05:32.787754Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T12:05:32.787800Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T12:05:32.787822Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T12:05:32.787871Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T12:06:06.543692Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T12:06:06.544366Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T12:06:06.704867Z 3 [ERROR] /usr/sbin/mysqld: Table './xenforo/xf_session' is marked as crashed and should be repaired
2018-07-15T12:06:06.705195Z 3 [Warning] Checking table:   './xenforo/xf_session'
2018-07-15T12:06:16.132333Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 14:06:16
2018-07-15T12:06:52.687227Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22019ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:09:46.055590Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 167059ms. The settings might not be optimal. (flushed=26 and evicted=0, during the time.)
2018-07-15T12:10:42.447831Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 53734ms. The settings might not be optimal. (flushed=38 and evicted=0, during the time.)
2018-07-15T12:11:31.117331Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13605ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:12:25.806222Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14409ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T12:13:12.735451Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12130ms. The settings might not be optimal. (flushed=40 and evicted=0, during the time.)
2018-07-15T12:13:42.197785Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4433ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T12:13:55.136882Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11939ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T12:14:42.187814Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5805ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T12:16:56.769075Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7052ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T12:17:32.983719Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12688ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:17:51.784244Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10928ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:19:33.593862Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22165ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:19:49.829197Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5077ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:20:00.098660Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5228ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:20:26.148014Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25049ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T12:20:46.106450Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11772ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T12:21:21.228610Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7976ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:21:30.115775Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7887ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:21:42.171490Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11056ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T12:22:07.003454Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9354ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T12:22:25.749436Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7398ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T12:22:49.642938Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5176ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T12:23:12.023137Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18588ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T12:23:35.125188Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5823ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:23:57.028539Z 67 [ERROR] /usr/sbin/mysqld: Table './xenforo/xf_session_admin' is marked as crashed and should be repaired
2018-07-15T12:23:57.028768Z 67 [Warning] Checking table:   './xenforo/xf_session_admin'
2018-07-15T12:24:10.339561Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4031ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:24:38.005070Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18775ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T12:24:46.977896Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5023ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:24:56.875342Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5354ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:25:09.189366Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10314ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T12:25:31.768798Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6930ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T12:25:50.463394Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6987ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T12:26:48.818399Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 36269ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
2018-07-15T12:29:57.956609Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6998ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T12:30:17.049496Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6651ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:30:53.816015Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22152ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T12:31:11.723493Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9128ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T12:31:44.625673Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4244ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:31:53.738828Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7365ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:32:37.613020Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15096ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T12:33:30.849622Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10215ms. The settings might not be optimal. (flushed=52 and evicted=0, during the time.)
2018-07-15T12:34:21.932168Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18974ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T12:34:50.478068Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16367ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T12:35:21.330966Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15516ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T12:36:07.870379Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23104ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:36:17.690431Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7820ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T12:36:44.680477Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4583ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T12:37:17.536939Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9875ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T12:37:23.116013Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4578ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:46:42.573123Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16352ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T12:47:09.762919Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6924ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T12:47:34.559123Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4188ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T12:47:41.555063Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5996ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:51:17.894037Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10164ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:52:02.380383Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20156ms. The settings might not be optimal. (flushed=28 and evicted=0, during the time.)
2018-07-15T12:52:33.537597Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22738ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:54:01.004269Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 85467ms. The settings might not be optimal. (flushed=43 and evicted=0, during the time.)
2018-07-15T12:55:12.549227Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 48288ms. The settings might not be optimal. (flushed=201 and evicted=0, during the time.)
2018-07-15T12:55:46.497161Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23737ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T12:56:43.387677Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40545ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T12:58:39.101731Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4504ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T12:58:49.444927Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4176ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T12:59:14.232408Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23787ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T12:59:32.870142Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13512ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T13:00:05.955053Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4437ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:00:39.344348Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30811ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:00:48.138760Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7794ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T13:00:54.466671Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5328ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:01:12.808996Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16341ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T13:02:05.299991Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32159ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T13:02:17.426062Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4504ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T13:03:06.555973Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24576ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T13:03:51.702112Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 29468ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T13:04:10.200843Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5849ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T13:04:31.079090Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19879ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:13:04.829623Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25661ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T13:13:57.565185Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 36576ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T13:14:28.629216Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13860ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T13:14:47.185297Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17556ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:15:03.558133Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12372ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T13:15:41.397309Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20467ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T13:17:06.565335Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 59626ms. The settings might not be optimal. (flushed=29 and evicted=0, during the time.)
2018-07-15T13:17:44.459139Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9131ms. The settings might not be optimal. (flushed=26 and evicted=0, during the time.)
2018-07-15T13:18:08.310178Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6160ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:21:42.545653Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23199ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T13:22:25.393496Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23682ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T13:22:43.601338Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17207ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:29:43.508501Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 61432ms. The settings might not be optimal. (flushed=162 and evicted=0, during the time.)
2018-07-15T13:30:20.826779Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28895ms. The settings might not be optimal. (flushed=33 and evicted=0, during the time.)
2018-07-15T13:32:40.852586Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10030ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T13:32:53.669616Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7635ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T13:33:34.458267Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12345ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:33:49.800107Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14342ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T13:34:10.504989Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9356ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:36:45.104200Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30579ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T13:37:19.708090Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21502ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:37:42.924320Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21216ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T13:38:18.707500Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20841ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T13:38:25.954121Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6246ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:40:32.460239Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11479ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T13:40:57.541185Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14240ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T13:41:17.046664Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18505ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T13:41:56.800168Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18702ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T13:42:19.608401Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18104ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T13:42:29.228111Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8620ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T13:45:50.303533Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9018ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T13:46:23.566125Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15573ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T13:47:31.369443Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19797ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T13:47:55.681564Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13585ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:48:04.151283Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6470ms. The settings might not be optimal. (flushed=37 and evicted=0, during the time.)
2018-07-15T13:48:53.462388Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11485ms. The settings might not be optimal. (flushed=32 and evicted=0, during the time.)
2018-07-15T13:49:19.873159Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6118ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T13:49:42.796612Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21923ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T13:49:59.728210Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9842ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T13:50:51.051087Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15819ms. The settings might not be optimal. (flushed=28 and evicted=0, during the time.)
2018-07-15T13:51:51.576157Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 39780ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T13:52:40.340663Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21569ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T13:53:00.655396Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19315ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T13:53:32.700143Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 29045ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T13:54:08.677911Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22593ms. The settings might not be optimal. (flushed=28 and evicted=0, during the time.)
2018-07-15T13:54:46.142366Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24224ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T13:55:09.270895Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12363ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T13:55:23.815319Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13544ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:05:36.193978Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 29253ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T14:06:02.221702Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9189ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T14:06:51.998589Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 47774ms. The settings might not be optimal. (flushed=199 and evicted=0, during the time.)
2018-07-15T14:07:38.326995Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16990ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T14:08:38.279610Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11014ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T14:08:47.920110Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8641ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:10:43.223775Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25285ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:11:18.262824Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26041ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:11:26.616775Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7353ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T14:11:53.763930Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13522ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T14:12:07.392420Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6190ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T14:12:50.263078Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20796ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:13:02.385866Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6311ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:13:08.939875Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5553ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:15:52.705053Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19093ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:16:19.385884Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15736ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T14:17:24.239021Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7528ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:17:37.828336Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4392ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T14:18:25.086030Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23900ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T14:19:14.111934Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 48025ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T14:20:01.401642Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11859ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:20:37.543167Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 34141ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T14:21:00.229497Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6619ms. The settings might not be optimal. (flushed=47 and evicted=0, during the time.)
2018-07-15T14:21:36.023055Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8592ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T14:22:36.111121Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21159ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T14:23:39.610399Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21130ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T14:25:01.588698Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6205ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:25:51.390990Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 38339ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T14:26:13.171071Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5747ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T14:26:55.454980Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12404ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T14:27:34.188282Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24129ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T14:28:05.316504Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11458ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T14:28:34.396910Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11620ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T14:28:57.026837Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8137ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:30:26.528157Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10488ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T14:30:41.107300Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4997ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T14:31:15.079356Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31971ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T14:32:03.158635Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23331ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T14:33:05.879992Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 35349ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T14:33:22.417160Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6885ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T14:34:34.632536Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12297ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:34:48.421017Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11787ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T14:34:59.300106Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9880ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:35:29.462956Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21162ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:35:52.656756Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16362ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T14:36:41.460289Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8095ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:37:21.589765Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12567ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:42:05.668427Z 0 [Note] Giving 0 client threads a chance to die gracefully
2018-07-15T14:42:05.668479Z 0 [Note] Shutting down slave threads
2018-07-15T14:42:05.668487Z 0 [Note] Forcefully disconnecting 0 remaining clients
2018-07-15T14:42:05.668498Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-07-15T14:42:05.967423Z 0 [Note] Binlog end
2018-07-15T14:42:05.980655Z 0 [Note] Shutting down plugin 'ngram'
2018-07-15T14:42:05.980679Z 0 [Note] Shutting down plugin 'partition'
2018-07-15T14:42:05.980686Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-07-15T14:42:05.980694Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-07-15T14:42:05.980700Z 0 [Note] Shutting down plugin 'MyISAM'
2018-07-15T14:42:05.980725Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-07-15T14:42:05.980761Z 0 [Note] Shutting down plugin 'MEMORY'
2018-07-15T14:42:05.980775Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-07-15T14:42:05.980782Z 0 [Note] Shutting down plugin 'CSV'
2018-07-15T14:42:05.980789Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-07-15T14:42:05.980797Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-07-15T14:42:05.980803Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-07-15T14:42:05.980810Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-07-15T14:42:05.980815Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-07-15T14:42:05.980821Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-07-15T14:42:05.980827Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-07-15T14:42:05.980833Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-07-15T14:42:05.980839Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-07-15T14:42:05.980898Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-07-15T14:42:05.980905Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-07-15T14:42:05.980911Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-07-15T14:42:05.980918Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-07-15T14:42:05.980923Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-07-15T14:42:05.980929Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-07-15T14:42:05.980935Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-07-15T14:42:05.980941Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-07-15T14:42:05.980946Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-07-15T14:42:05.980952Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-07-15T14:42:05.980974Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-07-15T14:42:05.980981Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-07-15T14:42:05.980986Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-07-15T14:42:05.980992Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-07-15T14:42:05.980997Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-07-15T14:42:05.981002Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-07-15T14:42:05.981008Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-07-15T14:42:05.981014Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-07-15T14:42:05.981020Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-07-15T14:42:05.981025Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-07-15T14:42:05.981031Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-07-15T14:42:05.981036Z 0 [Note] Shutting down plugin 'InnoDB'
2018-07-15T14:42:05.981256Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-07-15T14:42:05.985711Z 0 [Note] InnoDB: Starting shutdown...
2018-07-15T14:42:06.087176Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-07-15T14:42:06.088494Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180715 16:42:06
2018-07-15T14:42:30.027217Z 0 [Note] InnoDB: Shutdown completed; log sequence number 299395037
2018-07-15T14:42:30.030518Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T14:42:30.030557Z 0 [Note] Shutting down plugin 'sha256_password'
2018-07-15T14:42:30.030578Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-07-15T14:42:30.030742Z 0 [Note] Shutting down plugin 'binlog'
2018-07-15T14:42:30.031540Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-07-15T14:42:30.121295Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T14:42:30.121409Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T14:42:30.320225Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T14:42:30.322660Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 1634 ...
2018-07-15T14:42:30.333224Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T14:42:30.333274Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T14:42:30.333282Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T14:42:30.333290Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T14:42:30.333298Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T14:42:30.333305Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T14:42:30.333800Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T14:42:30.333982Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T14:42:30.336509Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T14:42:30.352863Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T14:42:30.363310Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T14:42:30.378188Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T14:42:34.215158Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T14:42:34.215294Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T14:42:40.830095Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T14:42:40.831301Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T14:42:40.831330Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T14:42:40.833690Z 0 [Note] InnoDB: Waiting for purge to start
2018-07-15T14:42:40.883994Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 299395037
2018-07-15T14:42:40.884471Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T14:42:40.885809Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10522ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:42:40.886653Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T14:42:40.906212Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T14:42:40.906248Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T14:42:40.906264Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T14:42:40.906307Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T14:42:40.933261Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 16:42:40
2018-07-15T14:42:40.946027Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T14:42:40.946443Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T14:42:43.533389Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T14:46:45.268525Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6332ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:47:09.375925Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5230ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T14:47:43.698135Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9763ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T14:48:03.076658Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4938ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T14:48:41.043293Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10165ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T14:49:25.936709Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10609ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:49:35.857164Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7920ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T14:50:32.485125Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28956ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T14:50:54.479915Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4384ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:51:49.134852Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 39648ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T14:52:26.829968Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21799ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T14:55:48.195561Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5385ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:02:30.030769Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26711ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T15:03:00.470317Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5959ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T15:03:25.618208Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15643ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T15:03:54.709809Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9678ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:06:03.579006Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27854ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T15:06:36.199482Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15924ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:06:54.245704Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16046ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T15:08:00.481931Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19593ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T15:08:20.529186Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10349ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T15:09:27.812721Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26244ms. The settings might not be optimal. (flushed=30 and evicted=0, during the time.)
2018-07-15T15:10:05.180660Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14358ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T15:10:50.566630Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11655ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T15:11:57.391325Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4173ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:13:17.672489Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26275ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T15:13:40.606490Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15428ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T15:14:17.448360Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7210ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:14:37.026998Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13546ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:15:29.213812Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6181ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:15:52.975128Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4670ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:16:00.883732Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4378ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:16:30.167520Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4663ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:17:01.415734Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5924ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:17:58.819740Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28694ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T15:18:41.814348Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26861ms. The settings might not be optimal. (flushed=29 and evicted=0, during the time.)
2018-07-15T15:20:04.517882Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 36677ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T15:20:45.978681Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13121ms. The settings might not be optimal. (flushed=71 and evicted=0, during the time.)
2018-07-15T15:20:55.946100Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5577ms. The settings might not be optimal. (flushed=94 and evicted=0, during the time.)
2018-07-15T15:22:03.126395Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 48006ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T15:22:45.881896Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23255ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T15:23:40.948040Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24401ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T15:24:53.683837Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 50186ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T15:25:58.102569Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 39442ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T15:26:41.381898Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8791ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T15:33:49.545083Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32803ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T15:34:54.077744Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40393ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T15:36:13.948820Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22491ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:41:04.177744Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4143ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T15:41:22.486712Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13779ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T15:41:39.131261Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10289ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T15:42:28.804584Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28882ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T15:43:36.749632Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 45797ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T15:44:07.525179Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10456ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T15:45:04.292203Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20889ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T15:45:32.780878Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14308ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T15:46:25.827276Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20375ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T15:48:06.262458Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40022ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T15:57:12.318179Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9020ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T15:58:03.325849Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37529ms. The settings might not be optimal. (flushed=26 and evicted=0, during the time.)
2018-07-15T15:58:34.916849Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4407ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T15:59:15.402956Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11092ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T15:59:36.359557Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10455ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T15:59:58.762107Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8704ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:01:14.015441Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 29379ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T16:01:52.481322Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22971ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T16:02:28.109874Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8164ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:03:08.106714Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14988ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T16:03:34.971691Z 0 [Note] Giving 1 client threads a chance to die gracefully
2018-07-15T16:03:34.971768Z 0 [Note] Shutting down slave threads
2018-07-15T16:03:36.971885Z 0 [Note] Forcefully disconnecting 1 remaining clients
2018-07-15T16:03:36.971940Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 177  user: 'xenfor'

2018-07-15T16:03:36.971995Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-07-15T16:03:42.548862Z 0 [Note] Binlog end
2018-07-15T16:03:42.549998Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27653ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T16:03:42.557097Z 0 [Note] Shutting down plugin 'ngram'
2018-07-15T16:03:42.557134Z 0 [Note] Shutting down plugin 'partition'
2018-07-15T16:03:42.557154Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-07-15T16:03:42.557163Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-07-15T16:03:42.557170Z 0 [Note] Shutting down plugin 'MyISAM'
2018-07-15T16:03:42.557180Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-07-15T16:03:42.557214Z 0 [Note] Shutting down plugin 'MEMORY'
2018-07-15T16:03:42.557234Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-07-15T16:03:42.557243Z 0 [Note] Shutting down plugin 'CSV'
2018-07-15T16:03:42.557252Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-07-15T16:03:42.557268Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-07-15T16:03:42.557274Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-07-15T16:03:42.557280Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-07-15T16:03:42.557286Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-07-15T16:03:42.557292Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-07-15T16:03:42.557298Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-07-15T16:03:42.557304Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-07-15T16:03:42.557309Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-07-15T16:03:42.557315Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-07-15T16:03:42.557321Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-07-15T16:03:42.557327Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-07-15T16:03:42.557332Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-07-15T16:03:42.557338Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-07-15T16:03:42.557344Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-07-15T16:03:42.557349Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-07-15T16:03:42.557355Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-07-15T16:03:42.557367Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-07-15T16:03:42.557373Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-07-15T16:03:42.557379Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-07-15T16:03:42.557385Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-07-15T16:03:42.557391Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-07-15T16:03:42.557397Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-07-15T16:03:42.557402Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-07-15T16:03:42.557408Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-07-15T16:03:42.557414Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-07-15T16:03:42.557420Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-07-15T16:03:42.557425Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-07-15T16:03:42.557451Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-07-15T16:03:42.557459Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-07-15T16:03:42.557465Z 0 [Note] Shutting down plugin 'InnoDB'
2018-07-15T16:03:42.557652Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-07-15T16:03:42.560211Z 0 [Note] InnoDB: Starting shutdown...
2018-07-15T16:03:42.660603Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-07-15T16:03:53.948666Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180715 18:03:53
2018-07-15T16:05:13.822604Z 0 [Note] InnoDB: Shutdown completed; log sequence number 299614878
2018-07-15T16:05:13.828021Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T16:05:13.828062Z 0 [Note] Shutting down plugin 'sha256_password'
2018-07-15T16:05:13.828071Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-07-15T16:05:13.828245Z 0 [Note] Shutting down plugin 'binlog'
2018-07-15T16:05:13.829164Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-07-15T16:14:22.877859Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T16:14:22.906834Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T16:14:25.556399Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T16:14:25.629392Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 649 ...
2018-07-15T16:14:37.148829Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T16:14:37.148901Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T16:14:37.148912Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T16:14:37.148923Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T16:14:37.148933Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T16:14:37.148943Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T16:14:38.327043Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T16:14:39.930998Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T16:14:39.933986Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T16:14:40.050549Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T16:14:40.081416Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T16:14:41.459096Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T16:15:12.371968Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T16:15:12.372087Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T16:15:18.804002Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T16:15:18.808674Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T16:15:18.808728Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T16:15:18.812865Z 0 [Note] InnoDB: Waiting for purge to start
2018-07-15T16:15:18.863108Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 299614878
2018-07-15T16:15:18.863427Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 38782ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:15:18.876190Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T16:15:19.001334Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T16:15:22.122259Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T16:15:22.122307Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T16:15:22.122324Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T16:15:22.122371Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T16:15:31.262976Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T16:15:31.263389Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T16:16:05.677832Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 18:16:05
2018-07-15T16:16:42.762058Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17103ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:16:57.946832Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14184ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T16:17:32.234998Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26227ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T16:18:34.698483Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30767ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:18:55.751112Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20053ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T16:19:59.258092Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 62507ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T16:20:16.362251Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8937ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T16:21:30.716002Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24966ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T16:22:37.240679Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19231ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:23:01.470079Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21230ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T16:23:53.344522Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19828ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:24:33.188592Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 37843ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T16:25:40.489115Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15870ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:27:08.238616Z 30 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T16:31:44.277646Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7721ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T16:32:09.200561Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11321ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T16:32:43.234751Z 0 [Note] Giving 1 client threads a chance to die gracefully
2018-07-15T16:32:43.234809Z 0 [Note] Shutting down slave threads
2018-07-15T16:32:45.152973Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22199ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T16:32:45.235051Z 0 [Note] Forcefully disconnecting 1 remaining clients
2018-07-15T16:32:45.235103Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 41  user: 'xenfor'

2018-07-15T16:32:45.235169Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-07-15T16:32:47.176773Z 0 [Note] Binlog end
2018-07-15T16:32:47.179283Z 0 [Note] Shutting down plugin 'ngram'
2018-07-15T16:32:47.179312Z 0 [Note] Shutting down plugin 'partition'
2018-07-15T16:32:47.179321Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-07-15T16:32:47.179329Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-07-15T16:32:47.179336Z 0 [Note] Shutting down plugin 'MyISAM'
2018-07-15T16:32:47.179413Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-07-15T16:32:47.179467Z 0 [Note] Shutting down plugin 'MEMORY'
2018-07-15T16:32:47.179497Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-07-15T16:32:47.179505Z 0 [Note] Shutting down plugin 'CSV'
2018-07-15T16:32:47.179515Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-07-15T16:32:47.179522Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-07-15T16:32:47.179529Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-07-15T16:32:47.179535Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-07-15T16:32:47.179542Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-07-15T16:32:47.179654Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-07-15T16:32:47.179664Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-07-15T16:32:47.179671Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-07-15T16:32:47.179678Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-07-15T16:32:47.179684Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-07-15T16:32:47.179690Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-07-15T16:32:47.179696Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-07-15T16:32:47.179701Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-07-15T16:32:47.179707Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-07-15T16:32:47.179713Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-07-15T16:32:47.179719Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-07-15T16:32:47.179726Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-07-15T16:32:47.179733Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-07-15T16:32:47.179740Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-07-15T16:32:47.179746Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-07-15T16:32:47.179752Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-07-15T16:32:47.179759Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-07-15T16:32:47.179765Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-07-15T16:32:47.179771Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-07-15T16:32:47.179778Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-07-15T16:32:47.179784Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-07-15T16:32:47.179790Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-07-15T16:32:47.179797Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-07-15T16:32:47.179802Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-07-15T16:32:47.179809Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-07-15T16:32:47.179815Z 0 [Note] Shutting down plugin 'InnoDB'
2018-07-15T16:32:47.179956Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-07-15T16:32:47.180379Z 0 [Note] InnoDB: Starting shutdown...
2018-07-15T16:32:47.280635Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-07-15T16:32:50.974738Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180715 18:32:50
2018-07-15T16:33:55.004719Z 0 [Note] InnoDB: Shutdown completed; log sequence number 299674927
2018-07-15T16:33:55.010808Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T16:33:55.010849Z 0 [Note] Shutting down plugin 'sha256_password'
2018-07-15T16:33:55.010857Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-07-15T16:33:55.011236Z 0 [Note] Shutting down plugin 'binlog'
2018-07-15T16:33:55.012309Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-07-15T16:39:58.472842Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T16:39:58.472983Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T16:39:58.670529Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T16:39:58.673017Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 1331 ...
2018-07-15T16:39:58.680889Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T16:39:58.680945Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T16:39:58.680970Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T16:39:58.680980Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T16:39:58.680988Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T16:39:58.680997Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T16:39:58.681430Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T16:39:58.681620Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T16:39:58.684303Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T16:39:58.698198Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T16:39:58.701505Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T16:39:58.718263Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T16:40:08.658146Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T16:40:08.658271Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T16:40:21.894615Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T16:40:21.896208Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T16:40:21.896250Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T16:40:21.897360Z 0 [Note] InnoDB: Waiting for purge to start
2018-07-15T16:40:21.947584Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23246ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:40:21.947610Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 299674927
2018-07-15T16:40:21.949378Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T16:40:21.952571Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T16:40:21.962729Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T16:40:21.962773Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T16:40:21.962794Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T16:40:21.962846Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T16:40:21.965753Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 18:40:21
2018-07-15T16:40:21.976526Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T16:40:21.976754Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T16:40:22.654518Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T16:45:43.441087Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 43378ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T16:46:23.215950Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19324ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T16:47:20.738084Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23846ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T16:48:00.261291Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17621ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T16:49:37.438730Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 63497ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T16:50:43.508585Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17321ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T16:51:59.484817Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24140ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T16:55:42.540432Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9205ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T16:56:06.369782Z 0 [Note] Giving 2 client threads a chance to die gracefully
2018-07-15T16:56:06.369819Z 0 [Note] Shutting down slave threads
2018-07-15T16:56:08.369953Z 0 [Note] Forcefully disconnecting 2 remaining clients
2018-07-15T16:56:08.370010Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 37  user: 'xenfor'

2018-07-15T16:56:08.370056Z 0 [Warning] /usr/sbin/mysqld: Forcing close of thread 36  user: 'xenfor'

2018-07-15T16:56:08.377454Z 0 [Note] Event Scheduler: Purging the queue. 0 events
2018-07-15T16:56:21.229532Z 0 [Note] Binlog end
2018-07-15T16:56:21.236699Z 0 [Note] Shutting down plugin 'ngram'
2018-07-15T16:56:21.236727Z 0 [Note] Shutting down plugin 'partition'
2018-07-15T16:56:21.236737Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2018-07-15T16:56:21.236746Z 0 [Note] Shutting down plugin 'ARCHIVE'
2018-07-15T16:56:21.236974Z 0 [Note] Shutting down plugin 'MyISAM'
2018-07-15T16:56:21.236997Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2018-07-15T16:56:21.237037Z 0 [Note] Shutting down plugin 'MEMORY'
2018-07-15T16:56:21.237061Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2018-07-15T16:56:21.237070Z 0 [Note] Shutting down plugin 'CSV'
2018-07-15T16:56:21.237079Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2018-07-15T16:56:21.237087Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2018-07-15T16:56:21.237094Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2018-07-15T16:56:21.237102Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2018-07-15T16:56:21.237108Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2018-07-15T16:56:21.237115Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2018-07-15T16:56:21.237121Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2018-07-15T16:56:21.237128Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2018-07-15T16:56:21.237134Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2018-07-15T16:56:21.237142Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2018-07-15T16:56:21.237148Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2018-07-15T16:56:21.237154Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2018-07-15T16:56:21.237161Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2018-07-15T16:56:21.237167Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2018-07-15T16:56:21.237174Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2018-07-15T16:56:21.237181Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2018-07-15T16:56:21.237189Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2018-07-15T16:56:21.237195Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2018-07-15T16:56:21.237202Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2018-07-15T16:56:21.237209Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2018-07-15T16:56:21.237216Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2018-07-15T16:56:21.237223Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2018-07-15T16:56:21.237229Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2018-07-15T16:56:21.237235Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2018-07-15T16:56:21.237242Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2018-07-15T16:56:21.237249Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2018-07-15T16:56:21.237255Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2018-07-15T16:56:21.237262Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2018-07-15T16:56:21.237268Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2018-07-15T16:56:21.237274Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2018-07-15T16:56:21.237281Z 0 [Note] Shutting down plugin 'InnoDB'
2018-07-15T16:56:21.237445Z 0 [Note] InnoDB: FTS optimize thread exiting.
2018-07-15T16:56:21.237884Z 0 [Note] InnoDB: Starting shutdown...
2018-07-15T16:56:21.338512Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2018-07-15T16:56:21.338762Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 180715 18:56:21
2018-07-15T16:58:27.737223Z 0 [Note] InnoDB: Shutdown completed; log sequence number 299721020
2018-07-15T16:58:27.740489Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T16:58:27.740515Z 0 [Note] Shutting down plugin 'sha256_password'
2018-07-15T16:58:27.740522Z 0 [Note] Shutting down plugin 'mysql_native_password'
2018-07-15T16:58:27.740684Z 0 [Note] Shutting down plugin 'binlog'
2018-07-15T16:58:27.741404Z 0 [Note] /usr/sbin/mysqld: Shutdown complete

2018-07-15T17:25:43.361398Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T17:25:43.361816Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T17:25:43.918413Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T17:25:44.115380Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 660 ...
2018-07-15T17:25:49.876587Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T17:25:49.876677Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T17:25:49.876714Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T17:25:49.876725Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T17:25:49.876735Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T17:25:49.876744Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T17:25:50.508442Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T17:25:50.618902Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T17:25:50.649289Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T17:25:51.029259Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T17:25:51.043863Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T17:25:55.648719Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T17:26:07.585905Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T17:26:07.586250Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T17:26:23.298736Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T17:26:23.300187Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T17:26:23.300232Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T17:26:23.304966Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32261ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:26:23.309546Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 299721020
2018-07-15T17:26:23.309875Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T17:26:23.834783Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T17:26:27.088464Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T17:26:27.088523Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T17:26:27.088546Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T17:26:27.088648Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T17:26:35.585100Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T17:26:35.585514Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T17:26:35.592991Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 19:26:35
2018-07-15T17:32:09.263178Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23978ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T17:32:50.387196Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24241ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:33:11.036528Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19649ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T17:34:48.515310Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17975ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T17:36:08.135843Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 32289ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T17:36:39.624049Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17214ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T17:37:08.716347Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8030ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T17:37:30.402563Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11428ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T17:38:20.390293Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9208ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:39:38.729053Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 46164ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T17:40:17.127673Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20412ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T17:41:08.686641Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 39096ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T17:41:59.097788Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 49411ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T17:45:14.720275Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13595ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T17:45:35.670857Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19950ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:46:03.368818Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12692ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T17:46:11.596036Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7228ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:56:59.294360Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11657ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T17:57:22.350913Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11048ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T17:57:34.984439Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11633ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T17:58:00.609327Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23625ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T17:58:19.777339Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18168ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:11:28.377409Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5465ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:16:05.658712Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15227ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T18:16:21.749070Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9361ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:16:42.434362Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18685ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T18:17:42.183389Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10643ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:18:21.008632Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21710ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T18:19:56.509986Z 71 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T18:20:15.104264Z 73 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T18:20:40.060588Z 74 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2018-07-15T18:24:40.293667Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8315ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:25:24.872846Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16010ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-15T18:26:00.570189Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26774ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:26:16.012996Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14443ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T18:26:35.289493Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8113ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T18:26:48.058688Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5061ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T18:26:54.772318Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5714ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:38:50.950437Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13576ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:39:07.164685Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10213ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T18:39:14.040037Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5876ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:40:52.770824Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17716ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T18:41:33.419586Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27653ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T18:41:45.957314Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11537ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T18:53:47.728151Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25808ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T18:54:36.954974Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 46746ms. The settings might not be optimal. (flushed=139 and evicted=0, during the time.)
2018-07-15T18:55:19.204148Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22936ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T18:55:38.997977Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8688ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T18:56:17.398208Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10182ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T18:56:36.113821Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10779ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T18:56:59.262738Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4075ms. The settings might not be optimal. (flushed=28 and evicted=0, during the time.)
2018-07-15T18:57:37.362778Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15013ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T18:58:00.642156Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16993ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T18:58:32.112585Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19103ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T18:59:00.252528Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17151ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T18:59:36.953263Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18145ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:02:29.652969Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7665ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T19:08:01.758389Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18841ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T19:08:23.693677Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11574ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T19:08:56.462330Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4590ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:09:07.094186Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9632ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T19:09:32.439962Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16863ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T19:10:00.812772Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11967ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T19:10:14.073751Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5754ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T19:11:00.596683Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15577ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:11:13.435378Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11839ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T19:11:26.199205Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11764ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T19:11:42.863973Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7352ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:11:51.323484Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5460ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T19:12:24.317441Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16287ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:12:38.198326Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8293ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T19:13:09.299197Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9734ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T19:13:21.918509Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11619ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:13:30.157676Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7234ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T19:14:13.340019Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16221ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:14:35.806971Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20466ms. The settings might not be optimal. (flushed=148 and evicted=0, during the time.)
2018-07-15T19:15:16.500934Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12813ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T19:15:43.825587Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11494ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T19:16:08.609961Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9894ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:16:41.398452Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 31789ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T19:17:15.013434Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11954ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T19:17:35.317153Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14660ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T19:18:08.553480Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9453ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T19:18:32.841581Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4695ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:19:02.024230Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7093ms. The settings might not be optimal. (flushed=58 and evicted=0, during the time.)
2018-07-15T19:19:33.431282Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12738ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T19:19:42.203052Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7770ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:20:18.813775Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12173ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:20:36.168521Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16355ms. The settings might not be optimal. (flushed=32 and evicted=0, during the time.)
2018-07-15T19:20:59.609222Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8848ms. The settings might not be optimal. (flushed=24 and evicted=0, during the time.)
2018-07-15T19:21:29.275273Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14457ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T19:21:53.372069Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23097ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T19:22:12.288796Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11161ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T19:22:43.852828Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7196ms. The settings might not be optimal. (flushed=44 and evicted=0, during the time.)
2018-07-15T19:23:37.165454Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18287ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T19:24:07.948359Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9101ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:24:16.459341Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7510ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T19:24:37.466537Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 20008ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-15T19:24:43.662144Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5196ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:25:25.332993Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40670ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T19:25:42.623716Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8560ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T19:26:10.985604Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5935ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:26:58.698387Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9160ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:27:12.872023Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6624ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:27:19.392092Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5521ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T19:27:39.547860Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5567ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T19:28:30.362244Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21167ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:29:21.266261Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13814ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T19:29:41.973242Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19707ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T19:30:09.473352Z 75 [Note] Aborted connection 75 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2018-07-15T19:30:26.719327Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15358ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T19:30:48.638774Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18834ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T19:31:07.631434Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7953ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T19:31:38.125107Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8133ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-15T19:32:17.562744Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16221ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:33:22.555660Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 62991ms. The settings might not be optimal. (flushed=30 and evicted=0, during the time.)
2018-07-15T19:34:19.689812Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 34514ms. The settings might not be optimal. (flushed=41 and evicted=0, during the time.)
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           2018-07-15T19:40:24.847784Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2018-07-15T19:40:24.849284Z 0 [Warning] Changed limits: table_open_cache: 431 (requested 2000)
2018-07-15T19:40:27.753730Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2018-07-15T19:40:28.949501Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.21-0ubuntu0.16.04.1) starting as process 704 ...
2018-07-15T19:40:50.175741Z 0 [Note] InnoDB: PUNCH HOLE support available
2018-07-15T19:40:50.175791Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-07-15T19:40:50.175804Z 0 [Note] InnoDB: Uses event mutexes
2018-07-15T19:40:50.175815Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-07-15T19:40:50.175823Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8
2018-07-15T19:40:50.175833Z 0 [Note] InnoDB: Using Linux native AIO
2018-07-15T19:40:50.269024Z 0 [Note] InnoDB: Number of pools: 1
2018-07-15T19:40:50.405893Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2018-07-15T19:40:50.411033Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2018-07-15T19:40:50.587562Z 0 [Note] InnoDB: Completed initialization of buffer pool
2018-07-15T19:40:50.623907Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2018-07-15T19:40:56.691799Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2018-07-15T19:41:02.567622Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 300557661
2018-07-15T19:41:03.025093Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 300629088
2018-07-15T19:41:04.685597Z 0 [Note] InnoDB: Database was not shutdown normally!
2018-07-15T19:41:04.685630Z 0 [Note] InnoDB: Starting crash recovery.
2018-07-15T19:41:16.365993Z 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo
2018-07-15T19:41:16.366034Z 0 [Note] InnoDB: Trx id counter is 304384
2018-07-15T19:41:16.366739Z 0 [Note] InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percent: 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
2018-07-15T19:41:16.912735Z 0 [Note] InnoDB: Apply batch completed
2018-07-15T19:42:24.642763Z 0 [Note] InnoDB: Starting in background the rollback of uncommitted transactions
2018-07-15T19:42:24.642838Z 0 [Note] InnoDB: Rolling back trx with id 303902, 1 rows to undo
2018-07-15T19:42:24.643002Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2018-07-15T19:42:24.643036Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2018-07-15T19:42:24.643123Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2018-07-15T19:42:33.748023Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2018-07-15T19:42:33.749289Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2018-07-15T19:42:33.749319Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2018-07-15T19:42:33.754794Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 103131ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:42:33.757852Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 300629088
2018-07-15T19:42:33.759462Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2018-07-15T19:42:34.164249Z 0 [Note] Plugin 'FEDERATED' is disabled.
2018-07-15T19:42:37.484203Z 0 [Note] InnoDB: Rollback of trx with id 303902 completed
2018-07-15T19:42:37.484251Z 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2018-07-15T19:42:37.877845Z 0 [Warning] Failed to set up SSL because of the following SSL library error: SSL context is not usable without certificate and private key
2018-07-15T19:42:37.877901Z 0 [Note] Server hostname (bind-address): '127.0.0.1'; port: 3306
2018-07-15T19:42:37.877935Z 0 [Note]   - '127.0.0.1' resolves to '127.0.0.1';
2018-07-15T19:42:37.877988Z 0 [Note] Server socket created on IP: '127.0.0.1'.
2018-07-15T19:42:40.125624Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5371ms. The settings might not be optimal. (flushed=61 and evicted=0, during the time.)
2018-07-15T19:43:03.023772Z 0 [Note] Event Scheduler: Loaded 0 events
2018-07-15T19:43:03.024271Z 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.7.21-0ubuntu0.16.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Ubuntu)
2018-07-15T19:43:03.979444Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180715 21:43:03
2018-07-15T19:43:04.118948Z 2 [ERROR] /usr/sbin/mysqld: Table './xenforo/xf_session' is marked as crashed and should be repaired
2018-07-15T19:43:04.119248Z 2 [Warning] Checking table:   './xenforo/xf_session'
2018-07-15T19:44:13.945670Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 25018ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T19:46:15.830732Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 107185ms. The settings might not be optimal. (flushed=27 and evicted=0, during the time.)
2018-07-15T19:46:36.324583Z 10 [ERROR] /usr/sbin/mysqld: Table './xenforo/xf_session_admin' is marked as crashed and should be repaired
2018-07-15T19:46:36.324871Z 10 [Warning] Checking table:   './xenforo/xf_session_admin'
2018-07-15T19:48:51.617071Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 149590ms. The settings might not be optimal. (flushed=49 and evicted=0, during the time.)
2018-07-15T19:50:01.228816Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 48832ms. The settings might not be optimal. (flushed=60 and evicted=0, during the time.)
2018-07-15T19:50:10.878050Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6391ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T19:50:54.296180Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12532ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T19:51:21.205387Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9993ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:53:50.714591Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14484ms. The settings might not be optimal. (flushed=8 and evicted=0, during the time.)
2018-07-15T19:54:20.507566Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16048ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T19:54:37.852278Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16345ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:54:48.082690Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6731ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:55:06.893867Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9643ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T19:55:40.953334Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11568ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:56:07.153183Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16618ms. The settings might not be optimal. (flushed=63 and evicted=0, during the time.)
2018-07-15T19:56:43.675608Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5598ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T19:57:13.789833Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13106ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T19:57:24.411629Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9621ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:57:31.832843Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6417ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T19:57:54.383874Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8815ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T19:58:06.602558Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4757ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T19:58:31.801251Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8269ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T19:58:52.384265Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18583ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T19:59:55.743581Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40590ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-15T20:00:22.986197Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16911ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T20:01:37.389092Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40365ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T20:03:36.632233Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9672ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T20:06:12.303350Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14587ms. The settings might not be optimal. (flushed=2 and evicted=0, during the time.)
2018-07-15T20:07:36.990496Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 40030ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.)
2018-07-15T20:07:44.827142Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4264ms. The settings might not be optimal. (flushed=48 and evicted=0, during the time.)
2018-07-15T20:08:20.833275Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5447ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T20:40:16.406483Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8214ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T20:40:34.877936Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7925ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-15T20:40:58.213770Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9314ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T20:41:16.746116Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17532ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T20:47:16.478056Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9930ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T20:51:29.290110Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7771ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T20:52:07.947105Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 28540ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T20:52:47.964272Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21050ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-15T20:53:09.829767Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8881ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T20:53:59.138986Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15727ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T20:54:20.526191Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6834ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-15T20:54:32.933724Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11407ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T21:19:39.691024Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5517ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T21:20:08.447325Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17930ms. The settings might not be optimal. (flushed=38 and evicted=0, during the time.)
2018-07-15T21:20:39.795907Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7545ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T21:21:09.250335Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 21169ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-15T21:21:29.207161Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6371ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T21:21:46.803339Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6055ms. The settings might not be optimal. (flushed=25 and evicted=0, during the time.)
2018-07-15T21:22:32.307525Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 34234ms. The settings might not be optimal. (flushed=91 and evicted=0, during the time.)
2018-07-15T21:22:58.229615Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8547ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-15T21:23:38.673591Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8334ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T21:40:45.428758Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10516ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T21:41:04.131438Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13114ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T21:41:26.374359Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9336ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-15T21:42:01.780157Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7606ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T21:42:45.406735Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 18913ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T21:43:30.463326Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11778ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T21:43:44.075568Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6611ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-15T21:44:05.926967Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5350ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T21:44:13.835302Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5909ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T21:44:59.529696Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8027ms. The settings might not be optimal. (flushed=22 and evicted=0, during the time.)
2018-07-15T21:45:38.754936Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17868ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T21:45:54.648979Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5737ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T21:46:24.093521Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16314ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-15T21:46:49.040072Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6617ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T21:47:15.348390Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10173ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T21:47:49.452439Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9608ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-15T22:31:54.497893Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4304ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-15T22:32:10.396863Z 192 [ERROR] /usr/sbin/mysqld: Table './xenforo/xf_search_index' is marked as crashed and should be repaired
2018-07-15T22:32:10.399309Z 192 [Warning] Checking table:   './xenforo/xf_search_index'
2018-07-15T22:53:42.826196Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6306ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-15T22:54:03.176579Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5286ms. The settings might not be optimal. (flushed=159 and evicted=0, during the time.)
2018-07-15T22:54:12.946258Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6049ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-15T22:54:40.585653Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8184ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-15T22:54:53.486006Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4234ms. The settings might not be optimal. (flushed=29 and evicted=0, during the time.)
2018-07-15T22:55:14.939340Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4928ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-15T22:55:23.149445Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7210ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T22:55:44.592774Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10986ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T22:55:50.657160Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4064ms. The settings might not be optimal. (flushed=20 and evicted=0, during the time.)
2018-07-15T22:58:57.906926Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10735ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-15T22:59:12.215485Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6796ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-15T22:59:23.349437Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5300ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T00:45:21.097159Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14195ms. The settings might not be optimal. (flushed=1 and evicted=0, during the time.)
2018-07-16T00:45:48.654957Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6984ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T00:47:09.133126Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11466ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-16T00:47:29.445283Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5019ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T00:47:55.355663Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23907ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-16T00:48:48.958179Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10177ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T00:49:10.776822Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19818ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-16T00:49:33.011553Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5357ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T01:16:18.535841Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27073ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-16T01:16:32.634467Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8201ms. The settings might not be optimal. (flushed=10 and evicted=0, during the time.)
2018-07-16T01:17:21.360583Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15554ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-16T01:18:07.422831Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19161ms. The settings might not be optimal. (flushed=21 and evicted=0, during the time.)
2018-07-16T01:18:44.273955Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 23239ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-16T01:20:09.547140Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6788ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-16T01:20:18.444174Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7897ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T02:22:18.481726Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10893ms. The settings might not be optimal. (flushed=4 and evicted=0, during the time.)
2018-07-16T02:22:51.870121Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 17840ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-16T02:37:17.825788Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 27477ms. The settings might not be optimal. (flushed=11 and evicted=0, during the time.)
2018-07-16T02:38:34.917967Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 70441ms. The settings might not be optimal. (flushed=134 and evicted=0, during the time.)
2018-07-16T03:01:28.503035Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 16569ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-16T03:01:58.068414Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10448ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-16T03:02:08.616475Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 4381ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-16T03:02:39.168869Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5517ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T03:02:53.849113Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 12680ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-16T03:03:28.617406Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 8560ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-16T03:18:34.928573Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 10705ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-16T03:35:35.598059Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6970ms. The settings might not be optimal. (flushed=3 and evicted=0, during the time.)
2018-07-16T03:37:35.835209Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 6414ms. The settings might not be optimal. (flushed=19 and evicted=0, during the time.)
2018-07-16T03:38:32.461215Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 55626ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-16T03:39:09.639571Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26424ms. The settings might not be optimal. (flushed=23 and evicted=0, during the time.)
2018-07-16T03:39:49.535498Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 19407ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-16T03:49:10.848911Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5651ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-16T03:49:45.336242Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22438ms. The settings might not be optimal. (flushed=17 and evicted=0, during the time.)
2018-07-16T03:50:18.238918Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 15719ms. The settings might not be optimal. (flushed=14 and evicted=0, during the time.)
2018-07-16T03:51:45.315437Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 7767ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T03:52:38.129418Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9808ms. The settings might not be optimal. (flushed=5 and evicted=0, during the time.)
2018-07-16T03:53:07.465500Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 11540ms. The settings might not be optimal. (flushed=7 and evicted=0, during the time.)
2018-07-16T03:53:30.063584Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 14606ms. The settings might not be optimal. (flushed=13 and evicted=0, during the time.)
2018-07-16T03:54:07.660160Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5318ms. The settings might not be optimal. (flushed=12 and evicted=0, during the time.)
2018-07-16T04:13:29.914551Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22554ms. The settings might not be optimal. (flushed=9 and evicted=0, during the time.)
2018-07-16T04:14:02.798033Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 24651ms. The settings might not be optimal. (flushed=18 and evicted=0, during the time.)
2018-07-16T04:14:41.110169Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 13532ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)
2018-07-16T04:16:40.749326Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 26624ms. The settings might not be optimal. (flushed=6 and evicted=0, during the time.)
2018-07-16T04:16:55.558907Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9649ms. The settings might not be optimal. (flushed=15 and evicted=0, during the time.)
2018-07-16T04:17:58.786786Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 22158ms. The settings might not be optimal. (flushed=16 and evicted=0, during the time.)
2018-07-16T04:18:27.189146Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 5313ms. The settings might not be optimal. (flushed=0 and evicted=0, during the time.)

подскажет кто-то?

DimmmCom · 16 Июл 2018

Было такое ))) Оптимизируй сервер MySQL

У Вас недостаточно прав для просмотра ссылок. Вход или Регистрация

Там для разного размера памяти есть. Для начала можешь взять отсюда настройки. А в дальнейшем воспользоваться скриптом mysqltuner

Danik_com · 16 Июл 2018

DimmmCom написал(а):
Было такое ))) Оптимизируй сервер MySQL
У Вас недостаточно прав для просмотра ссылок. Вход или Регистрация
Там для разного размера памяти есть. Для начала можешь взять отсюда настройки. А в дальнейшем воспользоваться скриптом mysqltuner

спасибо, сейчас буду пробовать
А что могло вызвать такой сбой? Почти месяц настройки не трогал - всё норм было.

Mirovinger · 16 Июл 2018

Форум высоко посещаемый или нет?

Danik_com · 16 Июл 2018

Mirovinger написал(а):
Форум высоко посещаемый или нет?

нет, 250 человек в среднем в сутки

Очень сильно стал тормозить форум

Danik_com

Mirovinger

Danik_com

IlyaPep

Danik_com

IlyaPep

Mirovinger

Danik_com

Mirovinger

Danik_com

Mirovinger

Danik_com

Mirovinger

Sanar

Mirovinger

Danik_com

DimmmCom

Danik_com

Mirovinger

Danik_com

Похожие темы

Мы ценим вашу конфиденциальность