사이트 로그인
2018.02.25 02:35
노하우 게시판 펌
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
초기화 쿼리는 필요하면 하고
나비켓 로그는 테이블을 살펴보면 알겠지만 그닥 필요없이 자리만 차지하는 것들이 대부분입니다.
그래서 수시로 제거해주면 서버의 잔렉을 제거하는데 어느정도 도움이 될 것 같네요.
운영이되면 될수록 쌓이는 형식이라 자주자주 제거를 해줘야합니다.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
공지 | 다량의 중복 게시물 작성으로 인한 포인트 지급중단 [1] | 게임존 | 2020.06.28 | 198 |
497 | 다크에덴계작방법 | sine10 | 2018.03.21 | 92 |
496 | 다크에덴 앵벌이방법 | sine10 | 2018.03.21 | 28 |
495 | 다크에덴 검슬레이어 완벽본 | sine10 | 2018.03.21 | 126 |
494 | 다크에덴 올힘뱀 질드레 레어(질드레 레이드) 솔플 | sine10 | 2018.03.21 | 24 |
493 | 다크에덴 기본정보 | sine10 | 2018.03.21 | 42 |
492 | 구팩외형 [1] | 낭만적사랑 | 2018.03.17 | 103 |
» | 서버 최적화 팁 | 긔여미얌 | 2018.02.25 | 106 |
490 | 구축시 외부유저 들어오게 하는법 | 긔여미얌 | 2018.02.25 | 159 |
489 | 인첸트 게브찍는데 6시간 !? | 긔여미얌 | 2018.02.24 | 15 |
488 | 게브찍는데 2일이면 충분하다!? | 긔여미얌 | 2018.02.24 | 11 |
487 | 편한 사냥 꿀팁 자동사냥편 -다크에덴 오리진(Darkeden origin) | 긔여미얌 | 2018.02.24 | 189 |
486 | 다크에덴 앵벌이방법 | 긔여미얌 | 2018.02.24 | 28 |
485 | 다크에덴 계작방법 | 긔여미얌 | 2018.02.24 | 147 |
484 | 바토리던전 | 긔여미얌 | 2018.02.24 | 36 |
483 | 펫 만렙찍기 | 긔여미얌 | 2018.02.24 | 55 |
482 | 프리 다크에덴 스피드핵 스핵 + 모션핵 영상 및 사용법 ( 엔진 ) | 긔여미얌 | 2018.02.23 | 517 |
481 | 다크에덴 스킬1개 난사 영상 ( 스킬스핵 영상 및 사용법 ) | 긔여미얌 | 2018.02.23 | 208 |
480 | 섭폭하는 방법 | 긔여미얌 | 2018.02.23 | 111 |
479 | 긴급특수조사원모집 이벤트 | 긔여미얌 | 2018.02.23 | 11 |
478 | 다덴정보 | 긔여미얌 | 2018.02.23 | 28 |
477 | 튜닝기 | 긔여미얌 | 2018.02.22 | 32 |
476 | 오리진 이벤트 스케쥴 (펌 | 버전1 | 2018.02.06 | 28 |
475 | 퀘스트창 완료 버튼 누르지마세요!! (펌 + 내 글 조금 | 버전1 | 2018.02.06 | 40 |
474 | 펫합성시 특수옵션 수치 (펌 | 버전1 | 2018.02.06 | 62 |
473 | 아이템 강화 (펌 | 버전1 | 2018.02.06 | 25 |
472 | 튜닝기 시슷템 (펌 | 버전1 | 2018.02.06 | 19 |
471 | 튜닝기 합성 시스템 (펌 | 버전1 | 2018.02.06 | 15 |
470 | 성서전 (펌 | 버전1 | 2018.02.06 | 13 |
469 | 페로나 점령전 (펌 | 버전1 | 2018.02.06 | 12 |
468 | 필드 깃발전 (펌 | 버전1 | 2018.02.06 | 13 |
467 | 오리진 던전 모음집 (펌 | 버전1 | 2018.02.06 | 12 |
466 | 룬 레어옵션 종류들 (펌 | 버전1 | 2018.02.06 | 37 |
465 | 레드 룬 설명 (펌 | 버전1 | 2018.02.06 | 32 |
464 | 그린 룬 설명 (펌 | 버전1 | 2018.02.06 | 18 |
463 | 블루 룬 설명 (펌 | 버전1 | 2018.02.06 | 19 |
462 | 오리진 마뎀 실험(1) ] 서브펫 마법대미지의 효과 (펌 | 버전1 | 2018.02.06 | 17 |
461 | 오리진 옐로우룬] 옵션수치/이펙트 효과 (예상) (펌 | 버전1 | 2018.02.06 | 21 |
460 | 서브펫 마법대미지에 따른 실험 (펌 | 버전1 | 2018.02.06 | 12 |
459 | 지능 상승에 따른 마법데미지 효과 (펌 | 버전1 | 2018.02.06 | 31 |
458 | 증작에 따른 마뎀효과 (펌 | 버전1 | 2018.02.06 | 22 |
457 | 오리진 튜닝기 뜨는 곳 (펌 | 버전1 | 2018.02.06 | 8 |
456 | 오리진 7성펫 정보 (펌 | 버전1 | 2018.02.06 | 28 |
455 | 오리진 블러드 임플린트 정보 (펌 | 버전1 | 2018.02.06 | 6 |
454 | 오리진 뱃스피어 리뷰 (펌 | 버전1 | 2018.02.06 | 17 |
453 | 오리진 강화 단계 (펌 | 버전1 | 2018.02.06 | 5 |
452 | 오리진 마공펫에 따른 데미지 차이 (펌 | 버전1 | 2018.02.06 | 11 |
451 | 오리진 pk용 펫 추천 (펌 | 버전1 | 2018.02.06 | 17 |
450 | 경험치 배율 정리 (펌 | 버전1 | 2018.02.06 | 70 |
449 | 엑셀, 서든 분석 ( 펌 | 버전1 | 2018.02.06 | 57 |
448 | 데미지 공식 최종본 (펌 [1] | 버전1 | 2018.02.06 | 53 |