l2j-server-datapack/dist/sql/game/updates/gs_optimize.sql

OPTIMIZE TABLE account_gsdata;
OPTIMIZE TABLE airships;
OPTIMIZE TABLE auction;
OPTIMIZE TABLE auction_bid;
OPTIMIZE TABLE auction_watch;
OPTIMIZE TABLE auto_announcements;
-- OPTIMIZE TABLE buylists;
OPTIMIZE TABLE castle;
OPTIMIZE TABLE castle_doorupgrade;
OPTIMIZE TABLE castle_functions;
OPTIMIZE TABLE castle_manor_procure;
OPTIMIZE TABLE castle_manor_production;
-- OPTIMIZE TABLE castle_siege_guards;
OPTIMIZE TABLE character_contacts;
OPTIMIZE TABLE character_friends;
OPTIMIZE TABLE character_hennas;
OPTIMIZE TABLE character_instance_time;
OPTIMIZE TABLE character_item_reuse_save;
OPTIMIZE TABLE character_macroses;
OPTIMIZE TABLE character_norestart_zone_time;
OPTIMIZE TABLE character_offline_trade_items;
OPTIMIZE TABLE character_offline_trade;
OPTIMIZE TABLE character_pet_skills_save;
OPTIMIZE TABLE character_quest_global_data;
OPTIMIZE TABLE character_quests;
OPTIMIZE TABLE character_raid_points;
OPTIMIZE TABLE character_recipebook;
OPTIMIZE TABLE character_recipeshoplist;
OPTIMIZE TABLE character_reco_bonus;
OPTIMIZE TABLE character_shortcuts;
OPTIMIZE TABLE character_skills;
OPTIMIZE TABLE character_skills_save;
OPTIMIZE TABLE character_subclasses;
OPTIMIZE TABLE character_summons;
OPTIMIZE TABLE character_summon_skills_save;
OPTIMIZE TABLE character_tpbookmark;
OPTIMIZE TABLE character_ui_actions;
OPTIMIZE TABLE character_ui_categories;
OPTIMIZE TABLE character_variables;
OPTIMIZE TABLE characters;
OPTIMIZE TABLE clan_data;
OPTIMIZE TABLE clan_notices;
OPTIMIZE TABLE clan_privs;
OPTIMIZE TABLE clan_skills;
OPTIMIZE TABLE clan_subpledges;
OPTIMIZE TABLE clan_wars;
OPTIMIZE TABLE clanhall;
OPTIMIZE TABLE clanhall_functions;
OPTIMIZE TABLE clanhall_siege_attackers;
-- OPTIMIZE TABLE clanhall_siege_guards;
OPTIMIZE TABLE cursed_weapons;
-- OPTIMIZE TABLE dimensional_rift;
-- OPTIMIZE TABLE droplist;
OPTIMIZE TABLE fort;
OPTIMIZE TABLE fort_doorupgrade;
OPTIMIZE TABLE fort_functions;
-- OPTIMIZE TABLE fort_siege_guards;
-- OPTIMIZE TABLE fort_spawnlist;
OPTIMIZE TABLE fortsiege_clans;
OPTIMIZE TABLE forums;
-- OPTIMIZE TABLE four_sepulchers_spawnlist;
OPTIMIZE TABLE games;
OPTIMIZE TABLE global_tasks;
OPTIMIZE TABLE global_variables;
OPTIMIZE TABLE grandboss_data;
OPTIMIZE TABLE grandboss_list;
-- OPTIMIZE TABLE hellbound_spawnlist;
-- OPTIMIZE TABLE herb_droplist_groups;
OPTIMIZE TABLE heroes;
OPTIMIZE TABLE heroes_diary;
OPTIMIZE TABLE item_attributes;
OPTIMIZE TABLE item_auction_bid;
OPTIMIZE TABLE item_auction;
OPTIMIZE TABLE item_elementals;
OPTIMIZE TABLE items;
OPTIMIZE TABLE itemsonground;
-- OPTIMIZE TABLE locations;
-- OPTIMIZE TABLE merchant_buylists;
OPTIMIZE TABLE merchant_lease;
-- OPTIMIZE TABLE merchant_shopids;
OPTIMIZE TABLE messages;
-- OPTIMIZE TABLE minions;
OPTIMIZE TABLE mods_wedding;
-- OPTIMIZE TABLE npc;
-- OPTIMIZE TABLE npc_buffer;
-- OPTIMIZE TABLE npcaidata;
-- OPTIMIZE TABLE npc_elementals;
-- OPTIMIZE TABLE npcskills;
OPTIMIZE TABLE olympiad_data;
OPTIMIZE TABLE olympiad_fights;
OPTIMIZE TABLE olympiad_nobles;
OPTIMIZE TABLE olympiad_nobles_eom;
OPTIMIZE TABLE petition_feedback;
OPTIMIZE TABLE pets;
-- OPTIMIZE TABLE pets_skills;
OPTIMIZE TABLE posts;
OPTIMIZE TABLE punishments;
OPTIMIZE TABLE quest_global_data;
OPTIMIZE TABLE raidboss_spawnlist;
OPTIMIZE TABLE rainbowsprings_attacker_list;
-- OPTIMIZE TABLE random_spawn;
-- OPTIMIZE TABLE random_spawn_loc;
OPTIMIZE TABLE seven_signs;
OPTIMIZE TABLE seven_signs_festival;
OPTIMIZE TABLE seven_signs_status;
OPTIMIZE TABLE siegable_clanhall;
OPTIMIZE TABLE siegable_hall_flagwar_attackers;
OPTIMIZE TABLE siegable_hall_flagwar_attackers_members;
OPTIMIZE TABLE siege_clans;
-- OPTIMIZE TABLE skill_learn;
-- OPTIMIZE TABLE spawnlist;
-- OPTIMIZE TABLE teleport;
OPTIMIZE TABLE territories;
OPTIMIZE TABLE territory_registrations;
-- OPTIMIZE TABLE territory_spawnlist;
OPTIMIZE TABLE topic;