Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Bugs

Archive::Bugs Archive area for Bugs's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2003, 11:56 AM
Guest
 
Posts: n/a
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 01:30 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3