mysql Медленные запросы к таблице БД, используемой плагином Ultimate Chats Control 4.1

Gudaus · 8 Дек 2018

Вы не пробовали у маздана запросить по какому полю в БД ищется инфа? Или полям.
Ну а далее что-то типа create index lol on amx_gag(steamid)?
CReate Index

CHEL74 · 9 Дек 2018

Всем, кто пытался мне, нубу, помочь, спасибо, но всё равно я слишком мало знаю, чтобы всё сделать красиво. Поэтому нашёл не очень красивый способ.
Увеличил timeout (последнюю циферку, если вдруг кому-то пригодится) в этой строчке плагина:
g_hTuple = SQL_MakeDbTuple(DB_HOST, DB_USER, DB_PASS, DB_NAME, 1);

CHEL74 · 10 Дек 2018

Сделал таймаут аж 10, всё равно ошибки... Бред

oxoTHuk · 11 Дек 2018

CHEL74, так это не исправление ошибки, а костыль. Проблема в том, что хостинг не любит тяжелые запросы, т.к. это шаред(несколько лет назад имел аналогичные проблемы на том же хостинге).
Вообще, проблемы 2:
1. Структура БД настолько древняя и плохо спроектирована, что вызывает "тормоза". По больше части, просто, тупо, из-за отсутствия индексов, что и показывает "медленность", запрос, выполняемый 4 секунды априори не может быть нормальным.
2. Хостинг - шаре хостинги не переваривают нагрузку на мускуль. Тут получилось так, что твои запросы нагружали их БД, и они просто потушили на время (на сутки вроде) доступ в БД.

Первое, что нужно сделать в твоем случае - убрать все, что касается УДАЛЕНИЯ из БД данных. Уже миллиарды раз и я и fantom и вроде кто-то еще поясняли мысли по поводу удаления банов.
Далее, дождаться очередного лога медленных запросов от хостера (или если есть доступ, очистить его от "удаления банов - DELETE FROM"), и скинуть суюда все SELEC, которые попадают в лог.
Ну а мы уже поможем с индексами.

Не обещаю что это внезапно станет работать идеально, но в любом случае, оптимизация структуры будет не лишней.

CHEL74 · 11 Дек 2018

fantom, oxoTHuk, тут "0" поставить, получается?

fb_sql_clear "300" - Очистка истекших банов старее чем fb_sql_clear дней, рекомендуемо для sqlite т.к. они не имеют веб морды где это можно сделать нажав на кнопку. Да и для mysql неплохо.

oxoTHuk · 11 Дек 2018

CHEL74, не знаю, я исходник маздана не видел. Кто делает эти записи, сказать точно не могу, тебе должно быть виднее. Но если никакого стороннего софта (плагина\кронскрипта или прочего) не стоит для удаления банов, то да, там ставь 0

CHEL74 · 11 Дек 2018

И в плагине гагов такое есть для автоочистки:

Код:

    {
        SQL_FreeHandle(hTest);
#if AMXX_VERSION_NUM >= 183
        SQL_SetCharset(g_hTuple, "utf8");
#endif
        new iClearPeriod = get_systime() - 86400 * "Время очистки";
        // superfix compile for amxx 1.8.2
        new iLen = formatex(g_szQuery, charsmax(g_szQuery),
            "CREATE TABLE IF NOT EXISTS `amx_gag` ( \
             `id` smallint(6) NOT NULL AUTO_INCREMENT, \
             `name` varchar(32) NOT NULL, \
             `steamid` varchar(32) NOT NULL, \
             `ip` varchar(16) NOT NULL, \
             `admin_name` varchar(32) NOT NULL, \
             `admin_steamid` varchar(32) NOT NULL, \
             `admin_ip` varchar(32) NOT NULL, ");
        formatex(g_szQuery[iLen], charsmax(g_szQuery),
            "`create_time` int(11) NOT NULL, \
             `expired_time` int(11) NOT NULL, \
             `reason` varchar(%d) NOT NULL, \
              PRIMARY KEY (`id`), \
              UNIQUE KEY `steamid` (`steamid`) \
            )ENGINE=InnoDB DEFAULT CHARSET=utf8; \
            DELETE FROM `amx_gag` WHERE (`expired_time` < '%d' AND `expired_time` > '0') OR (`expired_time` = '-1' AND `create_time` < '%d');",
                REASON_LENGTH, iClearPeriod, iClearPeriod);

        g_Data[0] = SQL_INIT;
        SQL_ThreadQuery(g_hTuple, "SQL_ThreadsHandler", g_szQuery, g_Data, sizeof(g_Data));
    }

oxoTHuk · 11 Дек 2018

CHEL74, а причем тут это? У тебя в логах вроде все в amx_bans связано. В общем избавься от делитов в amx_bans, чисти логи и показывай что получится в итоге.

CHEL74 · 11 Дек 2018

oxoTHuk, ))) А я до этого момента не мог понять, причём тут FB. Щас логи рассмотрел, понял о чём идёт речь. Ну хорошо, попробуем.

11 Дек 2018

oxoTHuk написал(а):
или если есть доступ, очистить его от "удаления банов - DELETE FROM"

Можно узнать подробнее, как это делается? Команду какую вводить или что? Не понимаю вообще. fb_sql_clear "0" сделал.

fantom · 11 Дек 2018

CHEL74, я б закоментировал данный код. Незачем каждую смену карты дергать создание даблицы с удалением. По факту у вас в основном тупит автоудаление истекших банов. Есть и другие запросы. Но беглый просмотр тех логов показал что они не настолько критичны

oxoTHuk · 11 Дек 2018

fantom написал(а):
я б закоментировал данный код.

Этот код скорее всего во Фрешбанс. А тот закрыт =) Поэтому ему должно хватить отключения опции удаления банов.

CHEL74, ты логи где брал, которые скидывал на прошлой странице? Вот мне нужны новые такие же логи, в которых уже не будет упоминания об удалении банов. Сечешь? =)

CHEL74 · 11 Дек 2018

fantom написал(а):
я б закоментировал данный код.

Код, который я скинул или код, ответственный за удаление банов в фрэш бансе?

oxoTHuk, то есть я отключил автоудаление в кваре и теперь ждать новых долгих запросов? Я просто думал, ещё надо в SQL чистить

fantom · 11 Дек 2018

CHEL74 написал(а):
Код, который я скинул или код

тот что скинули

CHEL74 написал(а):
то есть я отключил автоудаление в кваре и теперь ждать новых долгих запросов?

да

CHEL74 · 27 Дек 2018

fantom, oxoTHuk,
Вот, с тех пор:

# User@Host: nickname[nickname] @ [ip]
# Thread_id: 2907182 Schema: nickname_public QC_hit: No
# Query_time: 1.605310 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 128
# Rows_affected: 0
use nickname_public;
SET timestamp=1543952505;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '5.18.205.128' OR `steamid` = 'VALVE_0:0:849831068') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 3317148 Schema: nickname_public QC_hit: No
# Query_time: 2.402716 Lock_time: 0.000086 Rows_sent: 0 Rows_examined: 133
# Rows_affected: 0
use nickname_public;
SET timestamp=1544022991;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '46.39.49.6' OR `steamid` = 'VALVE_0:0:336970510') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 3784231 Schema: nickname_public QC_hit: No
# Query_time: 2.607745 Lock_time: 0.000075 Rows_sent: 0 Rows_examined: 149
# Rows_affected: 0
use nickname_public;
SET timestamp=1544102507;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '5.166.35.170' OR `steamid` = 'VALVE_0:1:1960059038') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 6344005 Schema: nickname_public QC_hit: No
# Query_time: 3.028483 Lock_time: 0.000068 Rows_sent: 0 Rows_examined: 770
# Rows_affected: 0
use nickname_public;
SET timestamp=1544504306;
DELETE FROM `amx_bans` WHERE ( ((`ban_length` > 0) AND (`ban_created` + `ban_length`*60 < UNIX_TIMESTAMP(NOW())) ) OR `expired` = 1) AND (`ban_created` + 7776000 < UNIX_TIMESTAMP(NOW()));
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 6624989 Schema: nickname_public QC_hit: No
# Query_time: 3.437990 Lock_time: 0.000092 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1544540449;
INSERT INTO `amx_gag` (`name`, `steamid`, `ip`, `admin_name`, `admin_steamid`, `admin_ip`, `create_time`, `expired_time`, `reason`) VALUES ('дрышь', 'VALVE_0:1:2078509746', '94.25.171.210', 'nupi i dupi', 'STEAM_1:1:426867997', '77.40.61.179', '1544540445', '0', 'нарушение правил') ON DUPLICATE KEY UPDATE `name` = 'дрышь', `ip` = '94.25.171.210', `admin_name` = 'nupi i dupi', `admin_steamid` = 'STEAM_1:1:426867997', `admin_ip` = '77.40.61.179', `create_time` = '1544540445', `expired_time` = '0', `reason` = 'нарушение правил';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 7087205 Schema: nickname_public QC_hit: No
# Query_time: 1.534813 Lock_time: 0.000086 Rows_sent: 1 Rows_examined: 189
# Rows_affected: 0
use nickname_public;
SET timestamp=1544618886;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '178.211.191.93' OR `steamid` = 'VALVE_0:1:1728079437') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 8022225 Schema: nickname_public QC_hit: No
# Query_time: 29.545391 Lock_time: 0.000088 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1544763870;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:1:872366059','88.200.136.9','Dev1ce','ip','STEAMID_SERVER','Сервер','S','Обнаружен Aim Script/Hack',UNIX_TIMESTAMP(NOW()),0,'Полная Обойма © Перезагрузка (de_dust2_2x2)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 9309009 Schema: nickname_public QC_hit: No
# Query_time: 1.835905 Lock_time: 0.000076 Rows_sent: 0 Rows_examined: 234
# Rows_affected: 0
use nickname_public;
SET timestamp=1544978801;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '95.32.32.186' OR `steamid` = 'VALVE_0:0:58592319') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 9780743 Schema: nickname_public QC_hit: No
# Query_time: 1.111331 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 239
# Rows_affected: 0
use nickname_public;
SET timestamp=1545065532;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '185.146.212.76' OR `steamid` = 'VALVE_0:1:899322341') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 10708229 Schema: nickname_public QC_hit: No
# Query_time: 5.197679 Lock_time: 0.000082 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545214553;
INSERT INTO `amx_gag` (`name`, `steamid`, `ip`, `admin_name`, `admin_steamid`, `admin_ip`, `create_time`, `expired_time`, `reason`) VALUES ('[T-B] Gamer', 'VALVE_0:1:846749739', '78.154.176.178', 'HeMHoro geg Mopo3', 'VALVE_0:0:1794888144', '188.18.225.190', '1545214548', '1545300948', 'нарушение правил') ON DUPLICATE KEY UPDATE `name` = '[T-B] Gamer', `ip` = '78.154.176.178', `admin_name` = 'HeMHoro geg Mopo3', `admin_steamid` = 'VALVE_0:0:1794888144', `admin_ip` = '188.18.225.190', `create_time` = '1545214548', `expired_time` = '1545300948', `reason` = 'нарушение правил';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 10732625 Schema: nickname_public QC_hit: No
# Query_time: 3.183613 Lock_time: 0.000071 Rows_sent: 0 Rows_examined: 252
# Rows_affected: 0
use nickname_public;
SET timestamp=1545217498;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '77.40.3.215' OR `steamid` = 'STEAM_1:1:426867997') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 10745672 Schema: nickname_public QC_hit: No
# Query_time: 6.882487 Lock_time: 0.000058 Rows_sent: 0 Rows_examined: 254
# Rows_affected: 0
use nickname_public;
SET timestamp=1545220045;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '95.220.218.61' OR `steamid` = 'VALVE_0:1:1017745795') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 10749145 Schema: nickname_public QC_hit: No
# Query_time: 7.637321 Lock_time: 0.000069 Rows_sent: 0 Rows_examined: 254
# Rows_affected: 0
use nickname_public;
SET timestamp=1545220624;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '178.211.191.93' OR `steamid` = 'VALVE_0:1:1728079437') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 10758155 Schema: nickname_public QC_hit: No
# Query_time: 5.676680 Lock_time: 0.000095 Rows_sent: 0 Rows_examined: 254
# Rows_affected: 0
use nickname_public;
SET timestamp=1545222118;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '93.185.28.56' OR `steamid` = 'VALVE_0:1:1163810379') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 11943296 Schema: nickname_public QC_hit: No
# Query_time: 2.285364 Lock_time: 0.000058 Rows_sent: 0 Rows_examined: 220
# Rows_affected: 0
use nickname_public;
SET timestamp=1545393291;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '46.185.83.108' OR `steamid` = 'VALVE_0:0:1207992981') AND `expired_time` >= '0';
# Time: 181225 11:09:58
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 13986384 Schema: nickname_public QC_hit: No
# Query_time: 1.708490 Lock_time: 0.000074 Rows_sent: 0 Rows_examined: 245
# Rows_affected: 0
use nickname_public;
SET timestamp=1545725398;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '94.158.122.70' OR `steamid` = 'VALVE_0:0:1384236115') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 13987487 Schema: nickname_public QC_hit: No
# Query_time: 1.316057 Lock_time: 0.000087 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545725558;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:1:843593843','94.29.124.235','Gusar4ik','ip','STEAMID_SERVER','Сервер','S','Обнаружен CheatDLL',UNIX_TIMESTAMP(NOW()),0,'Полная Обойма © Перезагрузка (de_dust2_2x2)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 13996742 Schema: nickname_public QC_hit: No
# Query_time: 1.693088 Lock_time: 0.000097 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545726813;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:0:1090749296','176.126.30.160','[Soldiers Of Fortune]~>ReM1X','ip','STEAMID_SERVER','Сервер','S','Обнаружен Bunny Hop Script',UNIX_TIMESTAMP(NOW()),0,'Полная Обойма © Перезагрузка (awp_india)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 13998193 Schema: nickname_public QC_hit: No
# Query_time: 17.283709 Lock_time: 0.000084 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545726997;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:0:449284121','37.232.132.254','27','ip','STEAMID_SERVER','Сервер','S','Обнаружен Private Aimbot asi',UNIX_TIMESTAMP(NOW()),0,'Полная Обойма © Перезагрузка (awp_india)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14008428 Schema: nickname_public QC_hit: No
# Query_time: 7.521812 Lock_time: 0.000073 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545728493;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:1:743153017','176.105.209.156','шішь','ip','STEAMID_SERVER','Сервер','S','Обнаружен Bad DemoPlayer.dll',UNIX_TIMESTAMP(NOW()),300,'Полная Обойма © Перезагрузка (de_inferno_2x2)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14013379 Schema: nickname_public QC_hit: No
# Query_time: 4.153646 Lock_time: 0.000077 Rows_sent: 0 Rows_examined: 245
# Rows_affected: 0
use nickname_public;
SET timestamp=1545729241;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '77.222.104.66' OR `steamid` = 'VALVE_0:1:2068079101') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14028254 Schema: nickname_public QC_hit: No
# Query_time: 6.969956 Lock_time: 0.000063 Rows_sent: 0 Rows_examined: 245
# Rows_affected: 0
use nickname_public;
SET timestamp=1545731863;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '176.212.138.211' OR `steamid` = 'VALVE_0:1:747499078') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14032844 Schema: nickname_public QC_hit: No
# Query_time: 2.857934 Lock_time: 0.000079 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545732560;
INSERT INTO `amx_bans` (`player_id`,`player_ip`,`player_nick`,`admin_ip`,`admin_id`,`admin_nick`,`ban_type`,`ban_reason`,`ban_created`,`ban_length`,`server_name`,`server_ip`,`expired`) VALUES('VALVE_0:0:621653815','212.87.168.109','art','ip','STEAMID_SERVER','Сервер','S','Обнаружен Zero Ware',UNIX_TIMESTAMP(NOW()),0,'Полная Обойма © Перезагрузка (de_westwood)','ip:27015',0);
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14035087 Schema: nickname_public QC_hit: No
# Query_time: 3.334009 Lock_time: 0.000067 Rows_sent: 0 Rows_examined: 247
# Rows_affected: 0
use nickname_public;
SET timestamp=1545732930;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '77.40.61.186' OR `steamid` = 'STEAM_1:1:426867997') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14035977 Schema: nickname_public QC_hit: No
# Query_time: 8.648874 Lock_time: 0.000062 Rows_sent: 0 Rows_examined: 247
# Rows_affected: 0
use nickname_public;
SET timestamp=1545733077;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '195.64.208.243' OR `steamid` = 'VALVE_0:0:2056044686') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14771805 Schema: nickname_public QC_hit: No
# Query_time: 4.840727 Lock_time: 0.000082 Rows_sent: 0 Rows_examined: 285
# Rows_affected: 0
use nickname_public;
SET timestamp=1545846018;
SELECT `expired_time`, `reason`, `admin_steamid` FROM `amx_gag` WHERE (`ip` = '5.138.39.215' OR `steamid` = 'VALVE_0:1:327611629') AND `expired_time` >= '0';
# User@Host: nickname[nickname] @ [ip]
# Thread_id: 14771978 Schema: nickname_public QC_hit: No
# Query_time: 5.337119 Lock_time: 0.000088 Rows_sent: 0 Rows_examined: 0
# Rows_affected: 1
use nickname_public;
SET timestamp=1545846039;
INSERT INTO `amx_gag` (`name`, `steamid`, `ip`, `admin_name`, `admin_steamid`, `admin_ip`, `create_time`, `expired_time`, `reason`) VALUES ('VINEGRET', 'VALVE_0:0:2040122554', '188.18.229.69', 'HeMHoro geg Mopo3', 'VALVE_0:0:1794888144', '188.19.38.35', '1545846033', '1545846633', 'нарушение правил') ON DUPLICATE KEY UPDATE `name` = 'VINEGRET', `ip` = '188.18.229.69', `admin_name` = 'HeMHoro geg Mopo3', `admin_steamid` = 'VALVE_0:0:1794888144', `admin_ip` = '188.19.38.35', `create_time` = '1545846033', `expired_time` = '1545846633', `reason` = 'нарушение правил';

oxoTHuk · 27 Дек 2018

CHEL74, покури еще логи amxx на предмет time difference с БД. Обычно фрешбан об этом пишет. Старнно долгие инсерты у тебя

27 Дек 2018

https://ruhighload.com/Индексы+в+mysql

CHEL74 · 27 Дек 2018

oxoTHuk, проскальзывают время от времени какашки в логах, ага.

12/26/2018 - 00:04:08: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275144577 sec
12/26/2018 - 00:06:42: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275143384 sec
12/26/2018 - 00:24:28: [fB 1.4.0b][WARNING] mySQL delay is to BIG =(! delay 0.000000000 sec
12/26/2018 - 00:33:01: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300560712 sec
12/26/2018 - 00:58:06: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.402024984 sec
12/26/2018 - 01:18:11: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300415039 sec
12/26/2018 - 01:38:17: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300466299 sec
12/26/2018 - 02:20:38: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.306292295 sec
12/26/2018 - 02:41:00: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.339137792 sec
12/26/2018 - 03:07:11: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.341705083 sec
12/26/2018 - 03:20:20: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275785207 sec
12/26/2018 - 03:33:43: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301073789 sec
12/26/2018 - 03:40:17: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300410270 sec
12/26/2018 - 04:05:22: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326519727 sec
12/26/2018 - 04:15:19: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300781250 sec
12/26/2018 - 04:40:23: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300815820 sec
12/26/2018 - 05:00:29: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326737642 sec
12/26/2018 - 05:20:35: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.352560997 sec
12/26/2018 - 05:45:40: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326779365 sec
12/26/2018 - 05:58:07: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300873756 sec
12/26/2018 - 06:23:12: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326503992 sec
12/26/2018 - 06:43:18: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326613426 sec
12/26/2018 - 06:59:17: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.351471662 sec
12/26/2018 - 07:24:23: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301121711 sec
12/26/2018 - 07:27:20: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326485395 sec
12/26/2018 - 07:51:21: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301171779 sec
12/26/2018 - 08:14:09: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326612472 sec
12/26/2018 - 08:39:14: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300792217 sec
12/26/2018 - 08:47:11: [FB]Ban Player [Player] [46.61.128.122] [VALVE_0:1:43542080] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 08:48:24: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.325822591 sec
12/26/2018 - 08:59:45: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300547122 sec
12/26/2018 - 09:23:08: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275946617 sec
12/26/2018 - 09:25:30: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300827264 sec
12/26/2018 - 09:35:15: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301421642 sec
12/26/2018 - 09:45:13: [FB]Ban Player [MiuMiu^_^] [37.212.74.193] [VALVE_0:1:461991623] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 10:05:00: [FB]Ban Player [FixPlay] [46.98.188.142] [VALVE_0:0:832926333] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 10:06:05: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.392258167 sec
12/26/2018 - 10:23:12: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.051114559 sec
12/26/2018 - 10:24:05: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326779365 sec
12/26/2018 - 10:26:38: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.351978063 sec
12/26/2018 - 10:34:16: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301685810 sec
12/26/2018 - 10:37:14: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300717592 sec
12/26/2018 - 10:47:56: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301512956 sec
12/26/2018 - 10:49:18: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301320075 sec
12/26/2018 - 10:59:41: [FB]Ban Player [Player] [94.29.124.212] [VALVE_0:1:1608977175] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 11:00:55: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.325737237 sec
12/26/2018 - 11:10:50: [FB]Ban Player [Geo] [80.76.242.197] [VALVE_0:0:1274984301] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 11:12:04: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.326645135 sec
12/26/2018 - 11:13:00: [FB]Ban Player [Player] [80.76.242.197] [VALVE_0:1:261727349] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 11:14:08: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300963878 sec
12/26/2018 - 11:19:27: [fB 1.4.0b]mySQL is OK! Time difference 1 sec, DB delay 0.275578260 sec
12/26/2018 - 11:49:35: [FB]Ban Player [vito] [176.117.234.53] [VALVE_0:0:1314001269] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 11:57:32: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.582191467 sec
12/26/2018 - 12:40:00: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.305691957 sec
12/26/2018 - 13:00:08: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.308498859 sec
12/26/2018 - 13:20:36: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300233840 sec
12/26/2018 - 13:41:33: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301791906 sec
12/26/2018 - 13:45:14: [FB]Ban Player [Pasha321] [94.31.211.19] [VALVE_0:1:1331676489] on Навсегда for Обнаружен Metla by Сервер from 185.248.100.219
12/26/2018 - 14:21:43: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275798082 sec
12/26/2018 - 14:44:32: [FB]TCONNECTION_FAILED time 17.171630
12/26/2018 - 14:44:32: [FB]MYSQL ERROR #2013
12/26/2018 - 14:44:32: [FB]MYSQL ERROR Lost connection to MySQL server at 'reading authorization packet', system error: 0
12/26/2018 - 14:44:40: [fB 1.4.0b][WARNING] mySQL delay is to BIG =(! delay 0.000000000 sec
12/26/2018 - 14:53:07: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.288237810 sec
12/26/2018 - 15:14:20: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.279978275 sec
12/26/2018 - 15:23:14: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.306000232 sec
12/26/2018 - 15:41:40: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300954341 sec
12/26/2018 - 15:54:07: [FB]Ban Player [Player] [31.132.177.169] [VALVE_0:0:963855271] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 16:06:15: [FB]Ban Player [OGUREC.TEAM // 4udo* Yudo*] [91.76.31.238] [VALVE_0:0:1348400397] on Навсегда for Обнаружен Silent Defuse Script by Сервер from 185.248.100.219
12/26/2018 - 16:17:40: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.277377128 sec
12/26/2018 - 16:38:12: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301947832 sec
12/26/2018 - 16:39:46: [FB]Ban Player [Player] [31.132.177.169] [VALVE_0:0:963855271] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 16:59:14: [fB 1.4.0b]mySQL is OK! Time difference 1 sec, DB delay 0.338464498 sec
12/26/2018 - 17:00:55: [FB]Ban Player [vitaba] [188.163.116.65] [VALVE_0:0:1567415487] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 17:16:07: [FB]Ban Player [корсар 2000] [37.212.89.20] [VALVE_0:0:628884780] on Навсегда for Обнаружен NoSpread by Сервер from 185.248.100.219
12/26/2018 - 17:29:31: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275701284 sec
12/26/2018 - 17:36:48: [FB]Ban Player [lol] [193.105.62.22] [VALVE_0:0:85066866] on 1 месяц for Читерам здесь не место by Nørd1c ※ Ⱳarriør from 178.78.63.251
12/26/2018 - 17:50:45: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.310688972 sec
12/26/2018 - 18:07:58: [FB]Ban Player [youtube.com/c/MaqsiZYyz] [109.201.73.138] [STEAM_1:1:459910823] on 1 час for Недопустимый никнейм by HeMHoro geg Mopo3 from 188.19.38.35
12/26/2018 - 18:11:02: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.276033639 sec
12/26/2018 - 18:31:27: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.316238641 sec
12/26/2018 - 18:32:21: [FB]Ban Player [Mr.marmok] [188.43.116.231] [VALVE_0:1:1329810258] on Навсегда for Обнаружен CheatDLL by Сервер from 185.248.100.219
12/26/2018 - 18:33:18: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.327706098 sec
12/26/2018 - 18:54:15: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275498867 sec
12/26/2018 - 19:19:51: [FB]Ban Player [24B | Player] [93.100.114.146] [VALVE_0:1:849166941] on Навсегда for Обнаружен Aim Script/Hack by Сервер from 185.248.100.219
12/26/2018 - 19:22:04: [FB]Ban Player [M O R T I] [31.129.233.159] [VALVE_0:0:700590975] on Навсегда for Обнаружен CHEETAH asi by Сервер from 185.248.100.219
12/26/2018 - 19:22:28: [FB]Ban Player [u pro pac2234] [178.214.254.13] [VALVE_0:0:1549425826] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 19:25:13: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.250000000 sec
12/26/2018 - 19:25:17: [FB]Ban Player [Kakashechka)] [5.142.94.85] [VALVE_0:0:2099355914] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 19:30:54: [FB]Ban Player [Juzy] [188.234.171.39] [VALVE_0:1:1254782902] on Навсегда for Обнаружен Private Aimbot by Сервер from 185.248.100.219
12/26/2018 - 19:38:47: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.275170564 sec
12/26/2018 - 19:59:12: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.515336513 sec
12/26/2018 - 20:15:26: [FB]Ban Player [aRmP] [85.140.2.211] [VALVE_0:1:1679775436] on 5 часов for Обнаружен No Core.dll by Сервер from 185.248.100.219
12/26/2018 - 20:24:30: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300093889 sec
12/26/2018 - 20:25:30: [FB]Ban Player [Kakashechka)] [5.142.94.85] [VALVE_0:0:2099355914] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 20:30:13: [FB]Ban Player [Mandarinka] [176.115.142.59] [VALVE_0:0:1495076969] on Навсегда for Обнаружен NoSpread by Сервер from 185.248.100.219
12/26/2018 - 20:44:52: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.314406871 sec
12/26/2018 - 21:15:27: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.319284439 sec
12/26/2018 - 21:18:23: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301631450 sec
12/26/2018 - 21:30:36: [FB]Ban Player [$heykh] [88.135.62.108] [VALVE_0:0:1838001267] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 21:47:55: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.304211139 sec
12/26/2018 - 21:55:03: [FB]Ban Player [piligriM] [37.60.210.150] [VALVE_0:0:1873450718] on 5 минут for Флэш под ноги by HeMHoro geg Mopo3 from 188.19.38.35
12/26/2018 - 22:02:01: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301957607 sec
12/26/2018 - 22:02:46: [FB]TCONNECTION_FAILED time 12.671092
12/26/2018 - 22:02:46: [FB]MYSQL ERROR #2013
12/26/2018 - 22:02:46: [FB]MYSQL ERROR Lost connection to MySQL server at 'reading authorization packet', system error: 0
12/26/2018 - 22:02:47: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.031723022 sec
12/26/2018 - 22:07:53: [FB]Ban Player [vcounter-strike16 | user] [82.208.100.97] [VALVE_0:1:1659814247] on 1 час for Регулярное кемперство by HeMHoro geg Mopo3 from 188.19.38.35
12/26/2018 - 22:15:22: [FB]Ban Player [Barbos] [134.249.169.105] [VALVE_0:0:2661864] on 1 день for Мешал игрокам by HeMHoro geg Mopo3 from 188.19.38.35
12/26/2018 - 22:27:09: [FB]Ban Player [_PeTr0_Iz_W@tCh_DoGs_2_] [80.77.39.21] [VALVE_0:1:2053192415] on Навсегда for Обнаружен Private Aimbot by Сервер from 185.248.100.219
12/26/2018 - 22:38:14: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.306879043 sec
12/26/2018 - 22:43:46: [FB]Ban Player [Kakashechka)] [5.142.94.85] [VALVE_0:0:2099355914] on Навсегда for Обнаружен OpenGL32 by Сервер from 185.248.100.219
12/26/2018 - 22:52:03: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.301135778 sec
12/26/2018 - 23:22:26: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.276198148 sec
12/26/2018 - 23:52:57: [fB 1.4.0b]mySQL is OK! Time difference 0 sec, DB delay 0.300458669 sec

oxoTHuk · 27 Дек 2018

CHEL74, да не, тут все в пределах нормы. Ну теперь анализируй запросы и смотри в статью, что я скинул выше. Там все подробно и понятно описано.
1. Делаешь эксплен запроса
2. Вешаешь индексы
3. Делаешь эксплен запроса
4. Сравниваешь что было и что стало

CHEL74 · 12 Апр 2020

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

Некропостнул, чтобы поблагодарить fantom и oxoTHuk за активные попытки помочь. Как говорится - лучше поздно, чем никогда))