서버 최적화 팁입니다

노하우 게시판 펌

vm 로그제거

cd /root/darkeden/vs/bin 으로 이동 

rm -f core*
rm -f *.log
rm -f *.txt

나비켓 서버 로그

delete from BugReportLog;
delete from CanEnterGDRLair;
delete from CrashReportLog;
delete from DeleteChar;
delete from EffectAftermath;
delete from EffectBloodDrain;
delete from EffectKillAftermath;
delete from EffectRestore;
delete from EnemyErase;
delete from GQuestSave;
delete from GuildUnionOffer;
delete from HeadCount;
delete from ItemTraceLog;
delete from NicknameBook;
delete from OpCreate;
delete from SpecialEvent;
delete from YellowDropLog;
delete from WeekItemGive;
delete from WarItemObject;
delete from Valuepackagelog;
delete from usewupinlog;
delete from TradeLog;
delete from SpeedHackLog;
delete from PetWeblog;
delete from PetMixingLog;
delete from pdsweeplog;
delete from pdposelog;
delete from MonsterKillLog;
delete from MoneyTraceLog;
delete from MofusLog;
delete from LoginPlayerData;
delete from LogoutPlayerData;
delete from LilithSeriesLog;
delete from ItemUseLog;
delete from GuildMasterChangeLog;

서버 초기화

delete from WeekItemListObject;
delete from WaterObject;
delete from VampireWingItemObject;
delete from VampireWeaponObject;
delete from VampireTunningItemObject;
delete from VampireRingObject;
delete from VampirePortalItemObject;
delete from VampireNecklaceObject;
delete from VampireETCObject;
delete from VampireEarringObject;
delete from VampireCoupleRingObject;
delete from VampireCoatObject;
delete from VampireBraceletObject;
delete from VampireAmuletObject;
delete from TrouserObject;
delete from TrapItemObject;
delete from Vampire;
delete from TimeLimitItems;
delete from SwordObject;
delete from SweeperObject;
delete from SubInventoryObject;
delete from SRObject;
delete from SpeedHackPlayer;
delete from SMSItemObject;
delete from SMGObject;
delete from SlayerTunningItemObject;
delete from SlayerPortalItemObject;
delete from Slayer;
delete from SkullObject;
delete from SkillSave;
delete from SkillBookObject;
delete from ShoulderArmorObject;
delete from ShoesObject;
delete from ShieldObject;
delete from SGObject;
delete from SerumObject;
delete from RingObject;
delete from ResurrectItemObject;
delete from RelicObject;
delete from RedistributeAttr50Count;
delete from QuestItemObject;
delete from PupaObject;
delete from PotionObject;
delete from Player;
delete from PetItemObject;
delete from PetFoodObject;
delete from PetEnchantItemObject;
delete from PersonaObject;
delete from OustersWristletObject;
delete from OustersWingItemObject;
delete from OustersTunningItemObject;
delete from OustersSummonItemObject;
delete from OustersStoneObject;
delete from OustersSkillSave;
delete from OustersRingObject;
delete from OustersPendentObject;
delete from OustersHarmonicPendentObject;
delete from OustersCoatObject;
delete from OustersCircletObject;
delete from OustersChakramObject;
delete from OustersBootsObject;
delete from OustersArmsbandObject;
delete from Ousters;
delete from NecklaceObject;
delete from MotorcycleObject;
delete from MoonCardObject;
delete from MoneyObject;
delete from MixingItemObject;
delete from MittenObject;
delete from MineObject;
delete from MagazineObject;
delete from MaceObject;
delete from LuckyBagObject;
delete from LearningItemObject;
delete from LarvaObject;
delete from KeyObject;
delete from HolyWaterObject;
delete from HelmObject;
delete from GQuestItemObject;
delete from GoodsListObject;
delete from GloveObject;
delete from FasciaObject;
delete from EventTreeObject;
delete from EventStarObject;
delete from EventItemObject;
delete from EventGiftBoxObject;
delete from EventETCObject;
delete from EtherealChainObject;
delete from ETCObject;
delete from DyePotionObject;
delete from DermisObject;
delete from CueOfAdamObject;
delete from CrossObject;
delete from CoupleRingObject;
delete from CoreZapObject;
delete from ContractOfBloodObject;
delete from ComposMeiObject;
delete from CommonQuestItemObject;
delete from CodeSheetObject;
delete from CoatObject;
delete from CheckMoneyObject;
delete from CastleSymbolObject;
delete from CarryingReceiverObject;
delete from CallNPCCardObject;
delete from BulletinBoardObject;
delete from BraceletObject;
delete from BombObject;
delete from BombMaterialObject;
delete from BloodBibleSignObject;
delete from BloodBibleObject;
delete from BladeObject;
delete from BeltObject;
delete from ARObject;

delete from onuri_member

초기화 쿼리는 필요하면 하고 

나비켓 로그는 테이블을 살펴보면 알겠지만 그닥 필요없이 자리만 차지하는 것들이 대부분입니다.

그래서 수시로 제거해주면 서버의 잔렉을 제거하는데 어느정도 도움이 될 것 같네요.

운영이되면 될수록 쌓이는 형식이라 자주자주 제거를 해줘야합니다.