Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Падение сервера на MySQL R7

Статус
В этой теме нельзя размещать новые ответы.

Cruiser

Ученик
Мод на MySQL R7, при достижении некого онлайна на сервере происходит выключение сервера, какие могут быть проблемы?

Вот записи из mysql.log на момент падения:
PHP:
[13:05:21] >> mysql_query_callback( Connection handle: 1 )
[13:05:21] Passing query SELECT * FROM `Accounts` WHERE `Name` = 'Name' AND `Key` = 'key' | ds
[13:05:21] ProcessQueryThread(LoginCallback) - Query was successful. (SELECT * FROM `Accounts` WHERE `Name` = 'Name' AND `Key` = 'key')
[13:05:21] ProcessQueryThread(LoginCallback) - Data caching enabled.
[13:05:21] CMySQLHandler::StoreResult() - Result was stored.
[13:05:21] CMySQLHandler::FreeResult() - Result was successfully free'd.
[13:05:21] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:05:21] LoginCallback(ds) - Threaded function called.
[13:05:21] >> cache_get_data( Connection handle: 1 )
И еще отображение вот такого:
PHP:
[13:20:50] Passing query UPDATE `Accounts` SET `Level` = '12', `AdminLevel` = '0', `HelperLevel` = '0', `DonateRank` = '0', `DonateRankTime` = '0' , `UpgradePoints` = '20', `ConnectedTime` = '314', `Sex` = '1', `Age` = '25', `Origin` = '1', `MuteTime` = '0' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `Level` = '12', `AdminLevel` = '0', `HelperLevel` = '0', `DonateRank` = '0', `DonateRankTime` = '0' , `UpgradePoints` = '20', `ConnectedTime` = '314', `Sex` = '1', `Age` = '25', `Origin` = '1', `MuteTime` = '0' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `FMuteTime` = '0', `Respect` = '29', `Money` = '53079', `Bank` = '123353', `Crimes` = '19', `Deaths` = '424', `Arresteed` = '0', `WantedDeaths` = '14', `Phonebook` = '1', `LottoNr` = '0', `Fishes` = '0', `BiggestFish` = '11', `Job` = '13', `Paycheck` = '9120', `HeadValue` = '0', `Jailed` = '0', `JailTime` = '0', `Materials` = '0' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `FMuteTime` = '0', `Respect` = '29', `Money` = '53079', `Bank` = '123353', `Crimes` = '19', `Deaths` = '424', `Arresteed` = '0', `WantedDeaths` = '14', `Phonebook` = '1', `LottoNr` = '0', `Fishes` = '0', `BiggestFish` = '11', `Job` = '13', `Paycheck` = '9120', `HeadValue` = '0', `Jailed` = '0', `JailTime` = '0', `Materials` = '0' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `Drugs` = '0', `Leader` = '0', `Member` = '7', `Rank` = '2', `Char` = '164', `DetSkill` = '0', `SexSkill` = '0', `BoxSkill` = '0', `LawSkill` = '0', `MechSkill` = '0', `JackSkill` = '3', `CarSkill` = '1', `NewsSkill` = '0', `DrugsSkill` = '0', `CookSkill` = '0', `FishSkill` = '10', `CourierSkill` = '0', `RDrugsSkill` = '0', `pSHealth` = '0' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `Drugs` = '0', `Leader` = '0', `Member` = '7', `Rank` = '2', `Char` = '164', `DetSkill` = '0', `SexSkill` = '0', `BoxSkill` = '0', `LawSkill` = '0', `MechSkill` = '0', `JackSkill` = '3', `CarSkill` = '1', `NewsSkill` = '0', `DrugsSkill` = '0', `CookSkill` = '0', `FishSkill` = '10', `CourierSkill` = '0', `RDrugsSkill` = '0', `pSHealth` = '0' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `pHealth` = '1318926873', `Int` = '0', `Local` = '0', `Team` = '2', `PhoneNr` = '258274', `House` = '218', `VipHouse` = '255', `Bizz` = '255', `CarLic` = '1', `FlyLic` = '1', `BoatLic` = '1', `FishLic` = '1', `GunLic` = '1', `MotoLic` = '1', `CarTime` = '0', `PayDay` = '4', `PayDayHad` = '0', `CDPlayer` = '0', `Wins` = '0', `Loses` = '0' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `pHealth` = '1318926873', `Int` = '0', `Local` = '0', `Team` = '2', `PhoneNr` = '258274', `House` = '218', `VipHouse` = '255', `Bizz` = '255', `CarLic` = '1', `FlyLic` = '1', `BoatLic` = '1', `FishLic` = '1', `GunLic` = '1', `MotoLic` = '1', `CarTime` = '0', `PayDay` = '4', `PayDayHad` = '0', `CDPlayer` = '0', `Wins` = '0', `Loses` = '0' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `AlcoholPerk` = '0', `DrugPerk` = '0', `MiserPerk` = '0', `PainPerk` = '0', `TraderPerk` = '0', `Tutorial` = '1', `Rent` = '255', `RentVip` = '255', `Warnings` = '0', `TanikMoney` = '0', `TanikDrugs` = '90', `TanikMats` = '0', `Fuel` = '0', `Married` = '0', `MarriedTo` = '', `Wanted` = '0', `Plant` = '255' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `AlcoholPerk` = '0', `DrugPerk` = '0', `MiserPerk` = '0', `PainPerk` = '0', `TraderPerk` = '0', `Tutorial` = '1', `Rent` = '255', `RentVip` = '255', `Warnings` = '0', `TanikMoney` = '0', `TanikDrugs` = '90', `TanikMats` = '0', `Fuel` = '0', `Married` = '0', `MarriedTo` = '', `Wanted` = '0', `Plant` = '255' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `Trava` = '0', `Chest` = '0', `FWarn` = '0', `Medicaments` = '0', `Flatkey` = '255', `RadioSet` = '1', `TexOsmotr` = '1', `TexOsmotrTime` = '4485', `AdminVig` = '0', `Nounban` = '0', `Kolban` = '1', `Donate` = '20', `Reputathion` = '18', `VoenBilet` = '1', `VoenBiletStage` = '0', `VisaLS` = '1', `Skin1` = '3', `Skin2` = '5', `Skin3` = '7', `SummaKredita` = '2300000' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `Trava` = '0', `Chest` = '0', `FWarn` = '0', `Medicaments` = '0', `Flatkey` = '255', `RadioSet` = '1', `TexOsmotr` = '1', `TexOsmotrTime` = '4485', `AdminVig` = '0', `Nounban` = '0', `Kolban` = '1', `Donate` = '20', `Reputathion` = '18', `VoenBilet` = '1', `VoenBiletStage` = '0', `VisaLS` = '1', `Skin1` = '3', `Skin2` = '5', `Skin3` = '7', `SummaKredita` = '2300000' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[13:20:50] Passing query UPDATE `Accounts` SET `OplataKredita` = '3', `Shapka` = '0', `Passport` = '1', `MedCarta` = '1', `StatConnect` = '0' WHERE `Name` = 'Alfa_Nur' | 
[13:20:50] ProcessQueryThread() - Query was successful. (UPDATE `Accounts` SET `OplataKredita` = '3', `Shapka` = '0', `Passport` = '1', `MedCarta` = '1', `StatConnect` = '0' WHERE `Name` = 'Alfa_Nur')
[13:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()

Это нормально? или не должно быть такого?
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу