Just for fun I optimized my tables, launch mysql, use <your db>, and copy and paste this into a file and source it in:
Quote:
OPTIMIZE TABLE aa_timers ;
OPTIMIZE TABLE account ;
OPTIMIZE TABLE altadv_vars ;
OPTIMIZE TABLE books ;
OPTIMIZE TABLE character_ ;
OPTIMIZE TABLE character_backup ;
OPTIMIZE TABLE city_defense ;
OPTIMIZE TABLE class_skill ;
OPTIMIZE TABLE doors ;
OPTIMIZE TABLE eventlog ;
OPTIMIZE TABLE faction_list ;
OPTIMIZE TABLE faction_values ;
OPTIMIZE TABLE forage ;
OPTIMIZE TABLE grid ;
OPTIMIZE TABLE guild_alliances ;
OPTIMIZE TABLE guild_controllers ;
OPTIMIZE TABLE guilds ;
OPTIMIZE TABLE hackers ;
OPTIMIZE TABLE inventory ;
OPTIMIZE TABLE items ;
OPTIMIZE TABLE lootdrop ;
OPTIMIZE TABLE lootdrop_entries ;
OPTIMIZE TABLE loottable ;
OPTIMIZE TABLE loottable_entries ;
OPTIMIZE TABLE merchantlist ;
OPTIMIZE TABLE name_filter ;
OPTIMIZE TABLE npc_faction ;
OPTIMIZE TABLE npc_faction_entries ;
OPTIMIZE TABLE npc_spells ;
OPTIMIZE TABLE npc_spells_entries ;
OPTIMIZE TABLE npc_types ;
OPTIMIZE TABLE object ;
OPTIMIZE TABLE object_contents ;
OPTIMIZE TABLE petitions ;
OPTIMIZE TABLE pets ;
OPTIMIZE TABLE player_corpses ;
OPTIMIZE TABLE player_corpses_backup ;
OPTIMIZE TABLE sharedbank ;
OPTIMIZE TABLE spawn2 ;
OPTIMIZE TABLE spawnentry ;
OPTIMIZE TABLE spawngroup ;
OPTIMIZE TABLE start_zones ;
OPTIMIZE TABLE starting_items ;
OPTIMIZE TABLE trader ;
OPTIMIZE TABLE tradeskillrecipe ;
OPTIMIZE TABLE variables ;
OPTIMIZE TABLE zone ;
OPTIMIZE TABLE zone_points ;
OPTIMIZE TABLE zone_server ;
OPTIMIZE TABLE zone_state_dump ;
OPTIMIZE TABLE zonepoints_raw ;
OPTIMIZE TABLE zoneserver_auth ;
|
You could incorporate this into your server startup if you wanted.