Печать страницы - Вопрос по Radius

Добрый день.

В логе радиуса появляются записи:

Код:

Thu Oct 15 02:00:12 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 51117 - ID: 196 due to unfinished request 608021
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 52481 - ID: 197 due to unfinished request 608022
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 51601 - ID: 198 due to unfinished request 608023
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 39968 - ID: 188 due to unfinished request 608024
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 38327 - ID: 199 due to unfinished request 608025
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 33214 - ID: 189 due to unfinished request 608026
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 58964 - ID: 190 due to unfinished request 608027
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 56413 - ID: 191 due to unfinished request 608028
Thu Oct 15 02:00:12 2020 : Error: Discarding duplicate request from client Mikrotik port 53030 - ID: 192 due to unfinished request 608029
Thu Oct 15 02:00:13 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:14 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:15 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:16 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:17 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:18 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:19 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:20 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:21 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:22 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:23 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:24 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:27 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Thu Oct 15 02:00:28 2020 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0

Причем эти записи появляются ночью, траф - минимальный в это время.
В час-пик нагрузки в логе чисто.
Подскажите куда копнуть.
Абоны работают через IPoE. На нодени работают модули Mikrotik

Цитата: Redmen от 15 Октября 2020, 09:45:09

http://forum.nodeny.com.ua/index.php?topic=1890.0 (http://forum.nodeny.com.ua/index.php?topic=1890.0)
https://linux-notes.org/uvelichit-max_connections-v-mysql/ (https://linux-notes.org/uvelichit-max_connections-v-mysql/)

Ок. Спасибо! Прочел.

Как правильно рассчитать оптимальное значение max_connections?

Сейчас так:

Код:

mysql> show variables like "max_connections";
+-----------------+-------+
| Variable_name   | Value |
+-----------------+-------+
| max_connections | 151   |
+-----------------+-------+

https://ixnfo.com/izmenenie-max_connections-v-mysql.html (https://ixnfo.com/izmenenie-max_connections-v-mysql.html)
https://github.com/major/MySQLTuner-perl (https://github.com/major/MySQLTuner-perl)
https://firstwiki.ru/index.php/%D0%9E%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B5%D0%BA_Mysql_%D1%81_%D0%BF%D0%BE%D0%BC%D0%BE%D1%89%D1%8C%D1%8E_Mysqltuner (https://firstwiki.ru/index.php/%D0%9E%D0%BF%D1%82%D0%B8%D0%BC%D0%B8%D0%B7%D0%B0%D1%86%D0%B8%D1%8F_%D0%BD%D0%B0%D1%81%D1%82%D1%80%D0%BE%D0%B5%D0%BA_Mysql_%D1%81_%D0%BF%D0%BE%D0%BC%D0%BE%D1%89%D1%8C%D1%8E_Mysqltuner)

freebsd

Код:

pkg install mysqltuner

Биллинговая система Nodeny

Главная категория => Nodeny Plus => Тема начата: NTE от 15 Октября 2020, 08:31:58