Подскажите с выбором VDS/веб-хостинга!

Stas · 17 Июл 2019

Доброго времени суток, форумчане!

Имею сервер кс 1.6 на хостинге serva4ok и веб хостинг на jino.
Веб хостинг jino за последние пол года уже второй у меня. Первый был webhost1, все и началось с него.
На webhost1 сидел очень долго (более года), но вот в начале 2019 начались проблемы с обрывами соединения (создавал тему: https://dev-cs.ru/threads/6077/). Так вот перешел на jino и вроде бы все было хорошо, но тут снова начались обрывы соединения:

Код:

11.07.2019

L 07/11/2019 - 06:15:05: [csstatsx_sql.amxx] SQL connection failed
L 07/11/2019 - 06:15:05: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/11/2019 - 06:46:14: [admin_loader.amxx] [Проблемы с БД. Код ошибки: #2003] Ошибка: Can't connect to MySQL server on '195.161.62.191' (4)


12.07.2019

L 07/12/2019 - 13:39:29: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/12/2019 - 14:42:25: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/12/2019 - 15:09:25: [ucc.amxx] MySQL INIT is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/12/2019 - 21:01:59: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/12/2019 - 21:03:00: [csstatsx_sql.amxx] SQL connection failed
L 07/12/2019 - 21:03:00: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)


13.07.2019 - небыло ошибок.


14.07.2019

L 07/14/2019 - 18:46:39: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 18:59:30: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:03:28: [aes_main.amxx] SQL connection failed
L 07/14/2019 - 19:03:28: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:12:04: [aes_main.amxx] SQL connection failed
L 07/14/2019 - 19:12:04: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:20:56: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:21:26: [csstatsx_sql.amxx] SQL connection failed
L 07/14/2019 - 19:21:26: [csstatsx_sql.amxx] [ 2013 ] Lost connection to MySQL server at 'reading authorization packet', system error: 0
L 07/14/2019 - 19:22:52: [csstatsx_sql.amxx] SQL connection failed
L 07/14/2019 - 19:22:52: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:23:04: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/14/2019 - 19:26:40: [csstatsx_sql.amxx] SQL connection failed
L 07/14/2019 - 19:26:40: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191'' (4)


15.07.2019 здесь вообще почти весь день, хорошо видно по логам ДопБана:
/*
L 07/15/2019 - 00:42:54: Log file started (file "cstrike/addons/amxmodx/logs/DB/2019_07_15.log") (game "cstrike") (amx "1.9.0.5249")
L 07/15/2019 - 00:42:54: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 01:01:01: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 01:19:33: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 01:51:27: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 03:20:08: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 03:39:49: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 03:59:59: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 05:29:12: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 06:46:39: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 07:21:17: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 08:00:37: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 09:10:19: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 09:40:21: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 09:41:35: [DB]TCONNECTION_FAILED time 64.720901
L 07/15/2019 - 10:10:58: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 10:31:02: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 10:47:29: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 10:51:22: [DB]TCONNECTION_FAILED time 67.332656
L 07/15/2019 - 10:58:36: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 11:58:46: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 12:12:15: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 12:31:47: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 12:38:37: [DB]TCONNECTION_FAILED time 186.472778
L 07/15/2019 - 12:41:40: [DB]TCONNECTION_FAILED time 346.973449
L 07/15/2019 - 12:46:49: [DB]TCONNECTION_FAILED time 549.836791
L 07/15/2019 - 12:47:50: [DB]TCONNECTION_FAILED time 604.462524
L 07/15/2019 - 12:50:58: [DB]TCONNECTION_FAILED time 694.942382
L 07/15/2019 - 12:57:02: [DB]TCONNECTION_FAILED time 970.657287
L 07/15/2019 - 13:00:10: [DB]TCONNECTION_FAILED time 976.283447
L 07/15/2019 - 13:02:10: [DB]TCONNECTION_FAILED time 1061.761718
L 07/15/2019 - 13:04:13: [DB]TCONNECTION_FAILED time 1178.702880
L 07/15/2019 - 13:07:15: [DB]TCONNECTION_FAILED time 1283.756103
L 07/15/2019 - 13:18:56: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 13:23:00: [DB]TCONNECTION_FAILED time 157.475524
L 07/15/2019 - 13:24:04: [DB]TCONNECTION_FAILED time 186.291870
L 07/15/2019 - 13:25:09: [DB]TCONNECTION_FAILED time 195.819519
L 07/15/2019 - 13:26:13: [DB]TCONNECTION_FAILED time 197.659622
L 07/15/2019 - 13:27:25: [DB]TCONNECTION_FAILED time 186.699768
L 07/15/2019 - 13:28:25: [DB]TCONNECTION_FAILED time 244.701171
L 07/15/2019 - 13:29:28: [DB]TCONNECTION_FAILED time 226.011260
L 07/15/2019 - 13:36:37: [DB]TCONNECTION_FAILED time 507.615722
L 07/15/2019 - 13:40:50: [DB]TCONNECTION_FAILED time 607.983276
L 07/15/2019 - 13:41:54: [DB]TCONNECTION_FAILED time 655.332641
L 07/15/2019 - 13:42:54: [DB]TCONNECTION_FAILED time 644.232543
L 07/15/2019 - 13:43:54: [DB]TCONNECTION_FAILED time 673.170532
L 07/15/2019 - 13:47:02: [DB]TCONNECTION_FAILED time 618.155761
L 07/15/2019 - 13:55:38: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 13:58:46: [DB]TCONNECTION_FAILED time 170.319259
L 07/15/2019 - 14:06:55: [DB]TCONNECTION_FAILED time 486.276977
L 07/15/2019 - 14:12:36: [DB]TCONNECTION_FAILED time 614.979492
L 07/15/2019 - 14:23:59: [DB]TCONNECTION_FAILED time 985.809082
L 07/15/2019 - 14:35:15: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 14:40:22: [DB]TCONNECTION_FAILED time 291.776702
L 07/15/2019 - 14:41:22: [DB]TCONNECTION_FAILED time 350.577850
L 07/15/2019 - 14:43:26: [DB]TCONNECTION_FAILED time 392.311645
L 07/15/2019 - 14:44:26: [DB]TCONNECTION_FAILED time 450.422973
L 07/15/2019 - 14:46:29: [DB]TCONNECTION_FAILED time 522.426696
L 07/15/2019 - 14:47:30: [DB]TCONNECTION_FAILED time 555.801818
L 07/15/2019 - 14:50:34: [DB]TCONNECTION_FAILED time 545.830566
L 07/15/2019 - 14:53:45: [DB]TCONNECTION_FAILED time 427.892639
L 07/15/2019 - 14:58:53: [DB]TCONNECTION_FAILED time 634.995727
L 07/15/2019 - 15:00:54: [DB]TCONNECTION_FAILED time 713.348449
L 07/15/2019 - 15:03:58: [DB]TCONNECTION_FAILED time 733.070922
L 07/15/2019 - 15:04:59: [DB]TCONNECTION_FAILED time 733.625244
L 07/15/2019 - 15:09:09: [DB]TCONNECTION_FAILED time 788.083618
L 07/15/2019 - 15:11:09: [DB]TCONNECTION_FAILED time 899.658813
L 07/15/2019 - 15:13:09: [DB]TCONNECTION_FAILED time 1014.998901
L 07/15/2019 - 15:14:16: [DB]TCONNECTION_FAILED time 944.912353
L 07/15/2019 - 15:17:24: [DB]TCONNECTION_FAILED time 950.455932
L 07/15/2019 - 15:18:24: [DB]TCONNECTION_FAILED time 1009.770507
L 07/15/2019 - 15:26:52: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 15:27:14: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 15:29:17: [DB]TCONNECTION_FAILED time 110.414306
L 07/15/2019 - 15:30:18: [DB]TCONNECTION_FAILED time 165.973327
L 07/15/2019 - 15:35:14: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 15:36:14: [DB]TCONNECTION_FAILED time 60.046726
L 07/15/2019 - 15:37:14: [DB]TCONNECTION_FAILED time 119.856117
L 07/15/2019 - 15:44:29: [DB]TCONNECTION_FAILED time 429.105987
L 07/15/2019 - 15:46:30: [DB]TCONNECTION_FAILED time 367.195312
L 07/15/2019 - 16:55:01: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 17:15:02: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 17:35:35: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 18:05:12: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 18:24:59: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 18:45:16: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 19:05:30: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 19:26:59: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 19:47:21: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 20:06:57: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 20:27:36: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 20:48:32: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 21:20:26: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 21:40:01: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 21:59:42: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 22:19:34: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 22:54:10: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 23:13:56: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 23:33:17: [ACTIVATED] DopBan 3.0.3b activated
L 07/15/2019 - 23:53:03: [ACTIVATED] DopBan 3.0.3b activated
*/

И часть общих логов:
L 07/15/2019 - 08:55:50: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 08:55:50: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:04:48: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 09:04:48: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:13:49: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:19:19: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 09:19:19: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:31:42: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 09:31:42: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:33:39: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:41:55: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 09:41:55: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 09:43:36: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 09:43:36: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:08:42: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:10:57: [admin_loader.amxx] [Проблемы с БД. Код ошибки: #2003] Ошибка: Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:26:12: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:27:31: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 10:27:31: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:31:15: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:31:17: [csstatsx_sql.amxx] deleted 114 inactive entries
L 07/15/2019 - 10:41:59: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 10:41:59: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:43:19: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2013] Lost connection to MySQL server at 'reading authorization packet', system error: 11
L 07/15/2019 - 10:47:39: [ucc.amxx] MySQL LoadPlayer is FAILED... [#2003] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:48:57: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 10:48:57: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 10:50:08: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 10:50:08: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 11:00:49: [csstatsx_sql.amxx] SQL connection failed
L 07/15/2019 - 11:00:49: [csstatsx_sql.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191' (4)
L 07/15/2019 - 11:30:06: [aes_main.amxx] SQL connection failed
L 07/15/2019 - 11:30:06: [aes_main.amxx] [ 2003 ] Can't connect to MySQL server on '195.161.62.191'' (4)

В личном кабинете веб хостинга я нашел вкладку "Медленные запросы MySQL" и там следующие логи:

Код:

UPDATE `aes_stats` SET`exp` = `exp` + '3.00',`last_update` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:0:1631808452',`ip` = '62.133.162.226',`name` = 'MMG'WHERE `id` = '32686';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88846157  Schema: j962373  QC_hit: No
# Query_time: 2.031736  Lock_time: 0.000056  Rows_sent: 0  Rows_examined: 18
# Rows_affected: 1
use j962373;
SET timestamp=1563123915;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '38'WHERE `weapon` = 'ak47' AND `player_id` = '25871';
# Time: 190714 20:05:17
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88846184  Schema: j962373  QC_hit: No
# Query_time: 2.047527  Lock_time: 0.000015  Rows_sent: 0  Rows_examined: 14
# Rows_affected: 0
use j962373;
SET timestamp=1563123917;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '3'WHERE `weapon` = 'deagle' AND `player_id` = '18484';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88846185  Schema: j962373  QC_hit: No
# Query_time: 2.008681  Lock_time: 0.000080  Rows_sent: 0  Rows_examined: 591
# Rows_affected: 1
SET timestamp=1563123917;
UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 29,`hits` = `hits` + 6,`dmg` = `dmg` + 141,`skill` = `skill` + -0.49,`h_2` = `h_2` + '2',`h_3` = `h_3` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`session_id` = '2747',`session_map` = 'de_inferno',`connection_time` = `connection_time` + 67,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_99:0:49910485',`ip` = '94.19.240.152',`name` = 'AHAJIbHbIu_BKyC'WHERE `id` = '4';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88923376  Schema: j962373  QC_hit: No
# Query_time: 2.073543  Lock_time: 0.000079  Rows_sent: 0  Rows_examined: 16
# Rows_affected: 1
use j962373;
SET timestamp=1563131025;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'mp5navy' AND `player_id` = '27418';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88927705  Schema: j962373  QC_hit: No
# Query_time: 4.028033  Lock_time: 0.000064  Rows_sent: 0  Rows_examined: 12
# Rows_affected: 1
use j962373;
SET timestamp=1563131408;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'deagle' AND `player_id` = '2266';
# Time: 190714 22:12:20
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88929068  Schema: j962373  QC_hit: No
# Query_time: 5.350435  Lock_time: 0.000151  Rows_sent: 0  Rows_examined: 145
# Rows_affected: 1
use j962373;
SET timestamp=1563131540;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 3,`hits` = `hits` + 3,`dmg` = `dmg` + 59,`skill` = `skill` + -0.65,`h_4` = `h_4` + '3',`roundct` = `roundct` + '1',`session_id` = '2752',`session_map` = 'de_nuke',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:0:1671638719',`ip` = '46.175.160.5',`name` = 'ANGELINA'WHERE `id` = '10484';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88929078  Schema: j962373  QC_hit: No
# Query_time: 5.316649  Lock_time: 0.000047  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1
use j962373;
SET timestamp=1563131540;
UPDATE `aes_stats` SET`exp` = `exp` + '2.00',`last_update` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:0:1671638719',`ip` = '46.175.160.5',`name` = 'ANGELINA'WHERE `id` = '47647';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88929091  Schema: j962373  QC_hit: No
# Query_time: 2.485990  Lock_time: 0.000052  Rows_sent: 27  Rows_examined: 722007
# Rows_affected: 0
use j962373;
SET timestamp=1563131540;
SELECT `id`,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)) FROM `csstats` as `a` WHERE `id` IN('20','3413','669','15','9582','19855','21944','4','411','2881','27132','843','9748','11644','458','24839','12884','28746','4473','27151','1649','860','28632','13412','2646','25449','13283');
# Time: 190714 22:46:44
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88952407  Schema: j962373  QC_hit: No
# Query_time: 2.422876  Lock_time: 0.000042  Rows_sent: 0  Rows_examined: 22
# Rows_affected: 1
use j962373;
SET timestamp=1563133604;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '18',`hits` = `hits` + '4',`dmg` = `dmg` + '55',`h_3` = `h_3` + '1',`h_6` = `h_6` + '2',`h_7` = `h_7` + '1'WHERE `weapon` = 'glock18' AND `player_id` = '3413';
# Time: 190715  0:12:43
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89015903  Schema: j962373  QC_hit: No
# Query_time: 1.053175  Lock_time: 0.000044  Rows_sent: 0  Rows_examined: 12
# Rows_affected: 1
use j962373;
SET timestamp=1563138763;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'deagle' AND `player_id` = '21978';
# Time: 190715  0:13:05
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89016126  Schema: j962373  QC_hit: No
# Query_time: 1.683278  Lock_time: 0.000058  Rows_sent: 0  Rows_examined: 23
# Rows_affected: 1
use j962373;
SET timestamp=1563138785;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '6',`hits` = `hits` + '1',`dmg` = `dmg` + '29',`h_4` = `h_4` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '4109';
# Time: 190715  0:26:58
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89024380  Schema: j962373  QC_hit: No
# Query_time: 1.454480  Lock_time: 0.000092  Rows_sent: 0  Rows_examined: 1357
# Rows_affected: 1
use j962373;
SET timestamp=1563139618;
UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 3,`hits` = `hits` + 1,`dmg` = `dmg` + 109,`skill` = `skill` + -0.61,`h_5` = `h_5` + '1',`roundt` = `roundt` + '1',`wint` = `wint` + '1',`session_id` = '2757',`session_map` = 'de_dust2',`connection_time` = `connection_time` + 76,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:1764076346',`ip` = '77.222.98.54',`name` = '.OLGA'WHERE `id` = '722';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89024391  Schema: j962373  QC_hit: No
# Query_time: 1.312356  Lock_time: 0.000072  Rows_sent: 18  Rows_examined: 481734
# Rows_affected: 0
SET timestamp=1563139618;
SELECT `id`,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)) FROM `csstats` as `a` WHERE `id` IN('722','1649','9418','28794','28795','28780','3','28245','13','8','60','4743','13856','28789','26125','28778','815','27151');
# Time: 190715  2:08:53
# User@Host: root[root] @  [10.0.0.10]
# Thread_id: 89079591  Schema: j962373  QC_hit: No
# Query_time: 1.179158  Lock_time: 0.000024  Rows_sent: 63201  Rows_examined: 63201
# Rows_affected: 0
use j962373;
SET timestamp=1563145733;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `aes_stats`;
# Time: 190715  2:08:56
# User@Host: root[root] @  [10.0.0.10]
# Thread_id: 89079619  Schema: j962373  QC_hit: No
# Query_time: 1.521025  Lock_time: 0.000018  Rows_sent: 111424  Rows_examined: 111424
# Rows_affected: 0
SET timestamp=1563145736;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `csstats_maps`;
# Time: 190715  2:08:59
# User@Host: root[root] @  [10.0.0.10]
# Thread_id: 89079642  Schema: j962373  QC_hit: No
# Query_time: 1.957574  Lock_time: 0.000018  Rows_sent: 123368  Rows_examined: 123368
# Rows_affected: 0
SET timestamp=1563145739;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `csstats_weapons`;
/*# Time: 190715  3:17:21
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89113480  Schema: j962373  QC_hit: No
# Query_time: 1.645548  Lock_time: 0.000044  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 1
use j962373;
SET timestamp=1563149841;
INSERT INTO `csstats_weapons` (`player_id`,`weapon`,`deaths`) VALUES('28842','flashbang','1');
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89127805  Schema: j962373  QC_hit: No
# Query_time: 4.761293  Lock_time: 0.049531  Rows_sent: 0  Rows_examined: 8
# Rows_affected: 1
use j962373;
SET timestamp=1563151545;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '15'WHERE `weapon` = 'm4a1' AND `player_id` = '18180';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89130426  Schema: j962373  QC_hit: No
# Query_time: 4.146245  Lock_time: 0.000047  Rows_sent: 0  Rows_examined: 11
# Rows_affected: 1
use j962373;
SET timestamp=1563151832;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`hs` = `hs` + '1',`shots` = `shots` + '3',`hits` = `hits` + '1',`dmg` = `dmg` + '84',`h_1` = `h_1` + '1'WHERE `weapon` = 'glock18' AND `player_id` = '27213';
# Time: 190715  4:14:21
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89143750  Schema: j962373  QC_hit: No
# Query_time: 1.826808  Lock_time: 0.000055  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1
use j962373;
SET timestamp=1563153261;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'mp5navy' AND `player_id` = '28863';
# Time: 190715  4:14:27
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89143750  Schema: j962373  QC_hit: No
# Query_time: 5.897885  Lock_time: 0.000028  Rows_sent: 0  Rows_examined: 4
# Rows_affected: 0
SET timestamp=1563153267;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'usp' AND `player_id` = '28859';
# Time: 190715  4:14:28
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89143750  Schema: j962373  QC_hit: No
# Query_time: 1.250304  Lock_time: 0.000058  Rows_sent: 0  Rows_examined: 3
# Rows_affected: 1
use j962373;
SET timestamp=1563153268;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -0.87,`roundct` = `roundct` + '1',`session_id` = '2764',`session_map` = '$2000$',`connection_time` = `connection_time` + 27,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:1757768870',`ip` = '109.252.26.11',`name` = 'MeToRi'WHERE `id` = '28859';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89156649  Schema: j962373  QC_hit: No
# Query_time: 2.633869  Lock_time: 0.000023  Rows_sent: 0  Rows_examined: 3
# Rows_affected: 0
use j962373;
SET timestamp=1563154682;
UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`shots` = `shots` + 5,`hits` = `hits` + 1,`dmg` = `dmg` + 20,`skill` = `skill` + 0.41,`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`session_id` = '2764',`session_map` = '$2000$',`connection_time` = `connection_time` + 25,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:736305464',`ip` = '185.236.210.184',`name` = '[KLCX]АРСЕНИЙ ПИДОР'WHERE `id` = '28870';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89156650  Schema: j962373  QC_hit: No
# Query_time: 2.432817  Lock_time: 0.000047  Rows_sent: 0  Rows_examined: 8
# Rows_affected: 0
SET timestamp=1563154682;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`hs` = `hs` + '1',`shots` = `shots` + '15',`hits` = `hits` + '5',`dmg` = `dmg` + '208',`h_1` = `h_1` + '1',`h_4` = `h_4` + '2',`h_5` = `h_5` + '1',`h_7` = `h_7` + '1'WHERE `weapon` = 'ak47' AND `player_id` = '28866';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89156651  Schema: j962373  QC_hit: No
# Query_time: 3.271055  Lock_time: 0.000067  Rows_sent: 12  Rows_examined: 320988
# Rows_affected: 0
use j962373;
SET timestamp=1563154683;
SELECT `id`,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)) FROM `csstats` as `a` WHERE `id` IN('28865','28859','28869','28870','16795','20125','25953','9800','28866','28405','27213','28831');
# Time: 190715  4:38:05
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89156650  Schema: j962373  QC_hit: No
# Query_time: 1.296359  Lock_time: 0.000013  Rows_sent: 0  Rows_examined: 7
# Rows_affected: 1
use j962373;
SET timestamp=1563154685;
UPDATE `csstats_weapons` SET`shots` = `shots` + '12',`hits` = `hits` + '1',`dmg` = `dmg` + '21',`h_7` = `h_7` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '28831';
# Time: 190715  4:59:52
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89169293  Schema: j962373  QC_hit: No
# Query_time: 3.182252  Lock_time: 0.000058  Rows_sent: 0  Rows_examined: 6
# Rows_affected: 1
use j962373;
SET timestamp=1563155992;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '19',`hits` = `hits` + '1',`dmg` = `dmg` + '56',`h_1` = `h_1` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '14500';
# Time: 190715  5:15:17
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89177429  Schema: j962373  QC_hit: No
# Query_time: 3.302009  Lock_time: 0.000053  Rows_sent: 0  Rows_examined: 2
# Rows_affected: 1
use j962373;
SET timestamp=1563156917;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '4',`hits` = `hits` + '1',`dmg` = `dmg` + '29',`h_4` = `h_4` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '28881';
# User@Host: j962373[j962373] @  [195.161.62.191]
# Thread_id: 89185037  Schema: j962373  QC_hit: No
# Query_time: 1.337029  Lock_time: 0.000066  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 2
use j962373;
SET timestamp=1563157689;
INSERT INTO `db_dyncookie` (`server`, `identid`, `id`, `uid`, `ip`, `ident`, `status`, `servertime`, `serversign`, `ts`) VALUES ('0440b933a','0', '7', '4467', '92.50.223.196','84121e51e68190738dfe2d89ba75d582_1523644547', '1' ,'1563157686',  'fb878705765b7bebaa57197c3ab23d49',  UNIX_TIMESTAMP(NOW()))
                ON DUPLICATE KEY
                UPDATE
                `servertime` ='1563157686', `serversign` ='fb878705765b7bebaa57197c3ab23d49', `ts` = UNIX_TIMESTAMP(NOW()), `ident` = '84121e51e68190738dfe2d89ba75d582_1523644547', `uid` = '4467', `ip` = '92.50.223.196';
# Time: 190715  5:58:44
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89202689  Schema: j962373  QC_hit: No
# Query_time: 3.049473  Lock_time: 0.000059  Rows_sent: 0  Rows_examined: 6
# Rows_affected: 1
use j962373;
SET timestamp=1563159524;
UPDATE `csstats_weapons` SET`shots` = `shots` + '2',`hits` = `hits` + '2',`dmg` = `dmg` + '68',`h_4` = `h_4` + '1',`h_5` = `h_5` + '1'WHERE `weapon` = 'ak47' AND `player_id` = '28888';
# Time: 190715  6:24:11
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89217224  Schema: j962373  QC_hit: No
# Query_time: 1.173505  Lock_time: 0.000047  Rows_sent: 0  Rows_examined: 23
# Rows_affected: 1
use j962373;
SET timestamp=1563161051;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`hs` = `hs` + '1',`shots` = `shots` + '4',`hits` = `hits` + '2',`dmg` = `dmg` + '131',`h_1` = `h_1` + '1',`h_4` = `h_4` + '1'WHERE `weapon` = 'ak47' AND `player_id` = '924';
# Time: 190715  6:24:14
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89217224  Schema: j962373  QC_hit: No
# Query_time: 3.028055  Lock_time: 0.000026  Rows_sent: 0  Rows_examined: 5
# Rows_affected: 0
SET timestamp=1563161054;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`deaths` = `deaths` + '2',`shots` = `shots` + '6',`hits` = `hits` + '5',`dmg` = `dmg` + '144',`h_2` = `h_2` + '1',`h_3` = `h_3` + '1',`h_4` = `h_4` + '3'WHERE `weapon` = 'ak47' AND `player_id` = '28892';
# Time: 190715  7:01:33
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89239761  Schema: j962373  QC_hit: No
# Query_time: 2.505243  Lock_time: 0.000062  Rows_sent: 0  Rows_examined: 12
# Rows_affected: 1
use j962373;
SET timestamp=1563163293;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`deaths` = `deaths` + '1',`shots` = `shots` + '17',`hits` = `hits` + '4',`dmg` = `dmg` + '110',`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_6` = `h_6` + '1',`h_7` = `h_7` + '1'WHERE `weapon` = 'ak47' AND `player_id` = '28888';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89259991  Schema: j962373  QC_hit: No
# Query_time: 5.496941  Lock_time: 0.000057  Rows_sent: 0  Rows_examined: 18
# Rows_affected: 1
use j962373;
SET timestamp=1563165297;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`shots` = `shots` + '7',`hits` = `hits` + '1',`dmg` = `dmg` + '17',`h_3` = `h_3` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '1736';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89279868  Schema: j962373  QC_hit: No
# Query_time: 3.828118  Lock_time: 0.000088  Rows_sent: 0  Rows_examined: 25
# Rows_affected: 1
use j962373;
SET timestamp=1563166784;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`deaths` = `deaths` + '1',`hs` = `hs` + '1',`shots` = `shots` + '5',`hits` = `hits` + '2',`dmg` = `dmg` + '136',`h_1` = `h_1` + '1',`h_4` = `h_4` + '1'WHERE `weapon` = 'xm1014' AND `player_id` = '371';
# Time: 190715  8:05:46
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89284845  Schema: j962373  QC_hit: No
# Query_time: 3.914056  Lock_time: 0.000065  Rows_sent: 0  Rows_examined: 25
# Rows_affected: 1
use j962373;
SET timestamp=1563167146;
UPDATE `csstats_weapons` SET`kills` = `kills` + '2',`shots` = `shots` + '21',`hits` = `hits` + '2',`dmg` = `dmg` + '70',`h_3` = `h_3` + '1',`h_4` = `h_4` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '371';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89284845  Schema: j962373  QC_hit: No
# Query_time: 1.857462  Lock_time: 0.000027  Rows_sent: 0  Rows_examined: 19
# Rows_affected: 1
use j962373;
SET timestamp=1563167148;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '12',`hits` = `hits` + '1',`dmg` = `dmg` + '35',`h_4` = `h_4` + '1'WHERE `weapon` = 'ak47' AND `player_id` = '23517';
# Time: 190715  8:05:52
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89284845  Schema: j962373  QC_hit: No
# Query_time: 3.820597  Lock_time: 0.000081  Rows_sent: 0  Rows_examined: 19
# Rows_affected: 1
SET timestamp=1563167152;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 12,`hits` = `hits` + 1,`dmg` = `dmg` + 35,`skill` = `skill` + -0.53,`h_4` = `h_4` + '1',`roundt` = `roundt` + '1',`session_id` = '2768',`session_map` = 'de_dust2_2x2',`connection_time` = `connection_time` + 50,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:1125820215',`ip` = '95.153.128.245',`name` = '.L.S.D.'WHERE `id` = '23517';
# Time: 190715  8:05:53
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89284923  Schema: j962373  QC_hit: No
# Query_time: 3.480629  Lock_time: 0.000035  Rows_sent: 0  Rows_examined: 21
# Rows_affected: 1
use j962373;
SET timestamp=1563167153;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'deagle' AND `player_id` = '11464';
# Time: 190715  9:08:00
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89337511  Schema: j962373  QC_hit: No
# Query_time: 3.337751  Lock_time: 0.000090  Rows_sent: 0  Rows_examined: 1057
# Rows_affected: 1
use j962373;
SET timestamp=1563170880;
UPDATE `csstats` SET `kills` = `kills` + 1,`deaths` = `deaths` + 1,`hs` = `hs` + 1,`hits` = `hits` + 2,`dmg` = `dmg` + 104,`skill` = `skill` + -0.29,`h_1` = `h_1` + '2',`roundct` = `roundct` + '1',`session_id` = '2768',`session_map` = 'de_dust2_2x2',`connection_time` = `connection_time` + 56,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:2114467592',`ip` = '92.244.99.98',`name` = '<good>'WHERE `id` = '391';
# Time: 190715  9:55:14
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89376990  Schema: j962373  QC_hit: No
# Query_time: 3.704639  Lock_time: 0.000101  Rows_sent: 0  Rows_examined: 27
# Rows_affected: 4
use j962373;
SET timestamp=1563173714;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'grenade' AND `player_id` = '458';
# Time: 190715 11:58:23
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89488346  Schema: j962373  QC_hit: No
# Query_time: 1.135068  Lock_time: 0.000056  Rows_sent: 0  Rows_examined: 22
# Rows_affected: 1
use j962373;
SET timestamp=1563181103;
UPDATE `csstats_weapons` SET`shots` = `shots` + '44',`hits` = `hits` + '4',`dmg` = `dmg` + '70',`h_2` = `h_2` + '1',`h_4` = `h_4` + '2',`h_6` = `h_6` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '24028';
# Time: 190715 11:58:26
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89488361  Schema: j962373  QC_hit: No
# Query_time: 2.668661  Lock_time: 0.000025  Rows_sent: 0  Rows_examined: 1069
# Rows_affected: 0
SET timestamp=1563181106;
UPDATE `csstats` SET `kills` = `kills` + 1,`shots` = `shots` + 10,`hits` = `hits` + 1,`dmg` = `dmg` + 102,`bombdef` = `bombdef` + 1,`bombdefused` = `bombdefused` + 1,`skill` = `skill` + 0.41,`h_3` = `h_3` + '1',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`session_id` = '2774',`session_map` = 'de_dust2',`connection_time` = `connection_time` + 101,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:2114467592',`ip` = '92.244.99.98',`name` = '<good>'WHERE `id` = '391';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89488362  Schema: j962373  QC_hit: No
# Query_time: 2.660493  Lock_time: 0.000062  Rows_sent: 10  Rows_examined: 26710
# Rows_affected: 0
SET timestamp=1563181106;
SELECT *,(`skill`) as `rank` FROM `csstats` as `a` ORDER BY `rank` DESC LIMIT 0,10;
# Time: 190715 15:52:09
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89696401  Schema: j962373  QC_hit: No
# Query_time: 1.842733  Lock_time: 0.000050  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 1
use j962373;
SET timestamp=1563195129;
INSERT INTO `aes_stats` (`name`,`steamid`,`ip`,`exp`,`bonus_count`)VALUES('//sky','VALVE_13:1:1707379870','95.32.74.211','0.00','0');
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89780736  Schema: j962373  QC_hit: No
# Query_time: 2.368294  Lock_time: 0.000054  Rows_sent: 0  Rows_examined: 140
# Rows_affected: 0
use j962373;
SET timestamp=1563200291;
SELECT `expired_time`, `reason`, `admin_steamid`, `block_type` FROM `ucc_gag` WHERE (`ip` = '145.249.201.46' OR `steamid` = 'VALVE_13:0:2138183550') AND (`expired_time` = '0' OR `expired_time` > '1563200288');
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89791504  Schema: j962373  QC_hit: No
# Query_time: 2.522426  Lock_time: 0.000063  Rows_sent: 0  Rows_examined: 23
# Rows_affected: 1
use j962373;
SET timestamp=1563201003;
UPDATE `csstats_weapons` SET`kills` = `kills` + '2',`deaths` = `deaths` + '1',`hs` = `hs` + '1',`shots` = `shots` + '36',`hits` = `hits` + '5',`dmg` = `dmg` + '164',`h_1` = `h_1` + '1',`h_5` = `h_5` + '4'WHERE `weapon` = 'famas' AND `player_id` = '924';
# Time: 190715 17:32:37
# User@Host: j962373[j962373] @  [195.161.62.191]
# Thread_id: 89794099  Schema: j962373  QC_hit: No
# Query_time: 1.696910  Lock_time: 0.000081  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 2
use j962373;
SET timestamp=1563201157;
INSERT INTO `db_dyncookie` (`server`, `identid`, `id`, `uid`, `ip`, `ident`, `status`, `servertime`, `serversign`, `ts`) VALUES ('0440b933a', '2', '22', '380', '89.102.3.164','Just Motd','2','1563201154',  'ddb572c7595b5091ac7f43c869315c39',  UNIX_TIMESTAMP(NOW()))
    ON DUPLICATE KEY
    UPDATE
    `servertime` ='1563201154', `serversign` ='ddb572c7595b5091ac7f43c869315c39',`ts` = UNIX_TIMESTAMP(NOW()), `status`= '2' ,`ident` = 'Just Motd', `uid` = '380', `ip` = '89.102.3.164';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89794084  Schema: j962373  QC_hit: No
# Query_time: 2.873586  Lock_time: 0.000040  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 0
use j962373;
SET timestamp=1563201157;
SELECT * FROM `csstats_weapons` WHERE `player_id` = '29008';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89797548  Schema: j962373  QC_hit: No
# Query_time: 2.597199  Lock_time: 0.000058  Rows_sent: 0  Rows_examined: 140
# Rows_affected: 0
use j962373;
SET timestamp=1563201364;
SELECT `expired_time`, `reason`, `admin_steamid`, `block_type` FROM `ucc_gag` WHERE (`ip` = '85.192.188.0' OR `steamid` = 'VALVE_13:1:1542076899') AND (`expired_time` = '0' OR `expired_time` > '1563201361');
# Time: 190715 17:50:33
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89812257  Schema: j962373  QC_hit: No
# Query_time: 1.590390  Lock_time: 0.000027  Rows_sent: 0  Rows_examined: 131
# Rows_affected: 1
use j962373;
SET timestamp=1563202233;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 9,`skill` = `skill` + -0.36,`roundct` = `roundct` + '1',`session_id` = '2781',`session_map` = 'de_dust2002',`connection_time` = `connection_time` + 29,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_99:0:242961900',`ip` = '176.59.7.140',`name` = 'KcIO .'WHERE `id` = '2211';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89812258  Schema: j962373  QC_hit: No
# Query_time: 1.645840  Lock_time: 0.000038  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1
SET timestamp=1563202233;
UPDATE `aes_stats` SET`exp` = `exp` + '12.00',`last_update` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_99:0:242961900',`ip` = '176.59.7.140',`name` = 'KcIO .'WHERE `id` = '19118';
# Time: 190715 17:53:08
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89814683  Schema: j962373  QC_hit: No
# Query_time: 1.483890  Lock_time: 0.000076  Rows_sent: 0  Rows_examined: 565
# Rows_affected: 1
use j962373;
SET timestamp=1563202388;
UPDATE `csstats` SET `kills` = `kills` + 2,`hs` = `hs` + 1,`shots` = `shots` + 41,`hits` = `hits` + 6,`dmg` = `dmg` + 232,`skill` = `skill` + 1.31,`h_1` = `h_1` + '1',`h_2` = `h_2` + '1',`h_4` = `h_4` + '1',`h_5` = `h_5` + '1',`h_6` = `h_6` + '1',`h_7` = `h_7` + '1',`roundct` = `roundct` + '1',`session_id` = '2781',`session_map` = 'de_dust2002',`connection_time` = `connection_time` + 112,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:694872067',`ip` = '95.37.217.69',`name` = 'Нервный'WHERE `id` = '13283';
# Time: 190715 17:53:10
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89814674  Schema: j962373  QC_hit: No
# Query_time: 3.119251  Lock_time: 0.000023  Rows_sent: 0  Rows_examined: 5
# Rows_affected: 1
SET timestamp=1563202390;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`shots` = `shots` + 7,`skill` = `skill` + -0.86,`roundt` = `roundt` + '1',`wint` = `wint` + '1',`session_id` = '2781',`session_map` = 'de_dust2002',`connection_time` = `connection_time` + 111,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:0:1938500619',`ip` = '176.105.196.33',`name` = 'masterserver.online | Player'WHERE `id` = '12394';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89814706  Schema: j962373  QC_hit: No
# Query_time: 1.655718  Lock_time: 0.000076  Rows_sent: 23  Rows_examined: 611409
# Rows_affected: 0
use j962373;
SET timestamp=1563202390;
SELECT `id`,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)) FROM `csstats` as `a` WHERE `id` IN('5','29013','497','28997','1568','90','29012','722','613','29003','12394','27912','3','16983','4743','28217','28601','17899','1411','9681','13283','29014','29007');
# User@Host: j962373[j962373] @  [195.161.62.191]
# Thread_id: 89862832  Schema: j962373  QC_hit: No
# Query_time: 1.959455  Lock_time: 0.000060  Rows_sent: 0  Rows_examined: 0
# Rows_affected: 2
use j962373;
SET timestamp=1563205470;
INSERT INTO `db_dyncookie` (`server`, `identid`, `id`, `uid`, `ip`, `ident`, `status`, `servertime`, `serversign`, `ts`) VALUES ('0440b933a', '2', '16', '572', '31.132.177.218','Just Motd','2','1563205467',  '670b2cb4265387ac4bd702d534301960',  UNIX_TIMESTAMP(NOW()))
    ON DUPLICATE KEY
    UPDATE
    `servertime` ='1563205467', `serversign` ='670b2cb4265387ac4bd702d534301960',`ts` = UNIX_TIMESTAMP(NOW()), `status`= '2' ,`ident` = 'Just Motd', `uid` = '572', `ip` = '31.132.177.218';
# Time: 190715 18:52:07
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89869764  Schema: j962373  QC_hit: No
# Query_time: 1.221955  Lock_time: 0.000057  Rows_sent: 0  Rows_examined: 1
# Rows_affected: 1
use j962373;
SET timestamp=1563205927;
UPDATE `aes_stats` SET`exp` = `exp` + '2.00',`last_update` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:1:2057340213',`ip` = '176.59.196.108',`name` = 'MEDVEGAN'WHERE `id` = '56494';
# Time: 190715 19:13:11
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89889533  Schema: j962373  QC_hit: No
# Query_time: 1.244016  Lock_time: 0.000051  Rows_sent: 0  Rows_examined: 24
# Rows_affected: 2
use j962373;
SET timestamp=1563207191;
UPDATE `csstats_weapons` SET`hits` = `hits` + '6',`dmg` = `dmg` + '130',`h_4` = `h_4` + '6'WHERE `weapon` = 'grenade' AND `player_id` = '19855';
# Time: 190715 19:44:43
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 89918700  Schema: j962373  QC_hit: No
# Query_time: 1.028113  Lock_time: 0.000039  Rows_sent: 0  Rows_examined: 363
# Rows_affected: 1
use j962373;
SET timestamp=1563209083;
UPDATE `csstats` SET `kills` = `kills` + 3,`hs` = `hs` + 1,`shots` = `shots` + 10,`hits` = `hits` + 7,`dmg` = `dmg` + 606,`skill` = `skill` + 1.48,`h_1` = `h_1` + '1',`h_2` = `h_2` + '2',`h_4` = `h_4` + '2',`h_5` = `h_5` + '2',`roundct` = `roundct` + '1',`winct` = `winct` + '1',`session_id` = '2786',`session_map` = 'de_eldorado',`connection_time` = `connection_time` + 66,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_99:1:189016807',`ip` = '213.222.244.196',`name` = '///AMG | Sem_26_rus'WHERE `id` = '24';
# Time: 190715 22:54:10
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90080984  Schema: j962373  QC_hit: No
# Query_time: 1.283363  Lock_time: 0.000052  Rows_sent: 0  Rows_examined: 14
# Rows_affected: 1
use j962373;
SET timestamp=1563220450;
UPDATE `csstats_weapons` SET`kills` = `kills` + '1',`hs` = `hs` + '1',`shots` = `shots` + '6',`hits` = `hits` + '1',`dmg` = `dmg` + '86',`h_1` = `h_1` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '26533';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90081147  Schema: j962373  QC_hit: No
# Query_time: 1.421272  Lock_time: 0.000051  Rows_sent: 0  Rows_examined: 26634
# Rows_affected: 50
use j962373;
SET timestamp=1563220458;
DELETE `csstats`,`csstats_weapons`,`csstats_maps` FROM `csstats`LEFT JOIN `csstats_weapons` ON `csstats`.`id` = `csstats_weapons`.`player_id`LEFT JOIN `csstats_maps` ON `csstats`.`id` = `csstats_maps`.`player_id`WHERE `csstats`.`last_join` <= DATE_SUB(NOW(),INTERVAL 50 DAY);
# Time: 190715 23:21:21
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90100609  Schema: j962373  QC_hit: No
# Query_time: 1.681863  Lock_time: 0.000040  Rows_sent: 0  Rows_examined: 18
# Rows_affected: 1
use j962373;
SET timestamp=1563222081;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'glock18' AND `player_id` = '27132';
# Time: 190715 23:36:22
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90111826  Schema: j962373  QC_hit: No
# Query_time: 3.125404  Lock_time: 0.000046  Rows_sent: 0  Rows_examined: 12
# Rows_affected: 1
use j962373;
SET timestamp=1563222982;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'm4a1' AND `player_id` = '23154';
# Time: 190716  0:14:14
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90140018  Schema: j962373  QC_hit: No
# Query_time: 4.868162  Lock_time: 0.000043  Rows_sent: 0  Rows_examined: 24
# Rows_affected: 1
use j962373;
SET timestamp=1563225254;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1'WHERE `weapon` = 'aug' AND `player_id` = '1479';
# Time: 190716  0:14:16
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90140085  Schema: j962373  QC_hit: No
# Query_time: 1.974549  Lock_time: 0.000050  Rows_sent: 0  Rows_examined: 27
# Rows_affected: 1
use j962373;
SET timestamp=1563225256;
UPDATE `csstats_weapons` SET`deaths` = `deaths` + '1',`shots` = `shots` + '9'WHERE `weapon` = 'm4a1' AND `player_id` = '4743';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90140018  Schema: j962373  QC_hit: No
# Query_time: 2.508228  Lock_time: 0.000073  Rows_sent: 0  Rows_examined: 211
# Rows_affected: 1
SET timestamp=1563225256;
UPDATE `csstats` SET `deaths` = `deaths` + 1,`skill` = `skill` + -1.07,`roundct` = `roundct` + '1',`session_id` = '2798',`session_map` = 'fy_pool_day',`connection_time` = `connection_time` + 13,`last_join` = CURRENT_TIMESTAMP,`steamid` = 'STEAM_99:0:28622755',`ip` = '62.91.82.84',`name` = 'Pikasso'WHERE `id` = '1479';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90140089  Schema: j962373  QC_hit: No
# Query_time: 2.343549  Lock_time: 0.000075  Rows_sent: 1  Rows_examined: 53115
# Rows_affected: 0
SET timestamp=1563225256;
SELECT *,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)),(SELECT COUNT(*) FROM csstats WHERE 1) FROM `csstats` AS `a` WHERE `steamid` = 'VALVE_13:1:87438028';
# Time: 190716  0:14:39
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 90140432  Schema: j962373  QC_hit: No
# Query_time: 1.951943  Lock_time: 0.000101  Rows_sent: 13  Rows_examined: 318709
# Rows_affected: 0
use j962373;
SET timestamp=1563225279;
SELECT `id`,(SELECT COUNT(*) FROM csstats WHERE (skill)>=(a.skill)) FROM `csstats` as `a` WHERE `id` IN('15023','17301','29092','19855','28794','29093','90','4743','29089','1873','890','29091','588');

Из всех перечитанных мною тем на данном форуме и сторонних ресурсах, я понял то, что отваливается веб хостинг. Отваливается он потому что режут запросы (нужно отключать автоматическую чистку БД в плагинах и т.д., но как по мне так это костыли) и в связи с этим нужно переходить на VDS.
Вот отсюда и хотелось бы услышать ваши рекомендации по выбору VDS/веб-хостинга (но как я понял веб-хостинг лучше вообще не использовать).
Так же стоит учитывать, что я совсем не разбираюсь с операционными система Linux то наверное нужно приобретать VDS с панелью ISPmanager.
Размещать на VDS я планирую:
Основной сайт CsBans и сайт (поддомен) для продажи привилегий + БД + FastDL.
Подскажите какие характеристики сервера я должен выбрать для этого? Где лучше выбрать - цена/качество? И на сколько важно OpenVZ или KVM?

Сервер не планирую размещать на VDS, так как IPшнику сервера 7 лет и совсем не хотелось бы его менять.

Stas · 17 Июл 2019

Как варианты, сейчас присмотрел, эти:
memvds.com

Вариант MEM-1. Но опасаюсь, что не хватит ресурсов сервера. И не знаю смогу ли разобраться без панели.
и
reg.ru

Вариант Cloud-2 очень дорого выходит с панелью. А Вариант Cloud-1 опасаюсь как и с memvds.com.

present · 17 Июл 2019

Stas, firstvds.ru

Denzer · 17 Июл 2019

На арене сейчас недорогие вдски + там есть веб хостинг (за смешную цену в 100р) с ISPManager.

Хотя вроде коннект к веб хосту арены с чужих хостов нельзя.

Stas · 17 Июл 2019

Denzer написал(а):
Хотя вроде коннект к веб хосту арены с чужих хостов нельзя.

Вроде можно, но так же обрывы присутствуют. Соответственно видимо так же на веб хосте режут запросы.

Javekson · 17 Июл 2019

Самый лучший вариант держать базу вместе с сервером, а веб часть можно где угодно, я сам измучался в свое время, в итоге вдс взял под сервер и базу

Nordic Warrior · 17 Июл 2019

Javekson,

Есть ссылочка на нормальный гайд?

kucklovod · 17 Июл 2019

ipserver.su
ставишь халявную VestaCP, а там с веб частью разберешься. очень просто добавить домен, создать бд, открыть порты и прочее.
после веб части по мануалам, если не знаешь как, ставишь сервер КС. усё.

BaHeK · 17 Июл 2019

Код:

UPDATE `aes_stats` SET`exp` = `exp` + '3.00',`last_update` = CURRENT_TIMESTAMP,`steamid` = 'VALVE_13:0:1631808452',`ip` = '62.133.162.226',`name` = 'MMG'WHERE `id` = '32686';
# User@Host: j962373[j962373] @  [193.26.217.77]
# Thread_id: 88846157  Schema: j962373  QC_hit: No
# Query_time: 2.031736  Lock_time: 0.000056  Rows_sent: 0  Rows_examined: 18
# Rows_affected: 1

Предположу, что не проставлены индексы, они решат проблему, 2 секунды - очень долго для такого запроса

upd: хотя поиск только по id, если он не primary, то это жесть

CHEL74 · 17 Июл 2019

Тоже на Джино. Тоже долгие запросы время от времени. Цена вроде низкая (126 р./мес.), поэтому смирился. Тем более, мне эти редкие долгие запросы не особо мешают. Даже не ощущаю их )

Sonyx · 17 Июл 2019

BaHeK, в AES по дефолту есть и PK и индексы по полям выборок. Причина банальнее скорее всего - шареды очень любят урезать до минимума ресурсы БД

Javekson · 17 Июл 2019

sbelov020, не видел таких гайдов, опыт благодаря множеству ошибок

Stas · 18 Июл 2019

Как думаете, достаточно будет тарифа "Иос" для моих потребностей:
1) Сайт CsBans и сайт (поддомен) для продажи привилегий
+
2) БД, работающая без сбоев с плагинами сервера
+
3) FastDL.

IIIKuIIeP · 18 Июл 2019

Stas, советую попробовать argatel.ru

zhorzh78 · 18 Июл 2019

SaHTuK написал(а):
Stas, советую попробовать argatel.ru

сами попробуйте.

18 Июл 2019

Stas, 5 лет пользуюсь от ВДС до выделенного. Партнерка...

VladJkee · 18 Июл 2019

zhorzh78, там ошибка в домене
argotel.ru

H1GH · 19 Июл 2019

ForNex.com :derisive:

babylkin_band · 26 Июл 2019

ihor, 150 деревянных в месяц. Идеальное соотношение цена - качество, имхо.

Подскажите с выбором VDS/веб-хостинга!

Stas

Stas

present

Denzer

Stas

Javekson

Nordic Warrior

kucklovod

BaHeK

CHEL74

Sonyx

Javekson

Stas

IIIKuIIeP

zhorzh78

VladJkee

H1GH

babylkin_band

Download all Attachments

Пользователи, просматривающие эту тему