MySQL Optimization

[Maze_EQ]

In regards to this, Secrets optimized to the point where he had all of Sanctus Seru on his screen, no hardware lag, nada.

As far as I can see, EQEmu runs fine on a 4gb quad core laptop, let alone a 32gb 8 core xeon...........

There shouldn't be that much overhead, and if there are issues, man do a #reloadworld, it respawns the whole game at once.

I never EVER see EQEmu use more than 3% processor, or over 6gb of ram (181) static zones.

"Optimization" shouldn't be needed, unless you're project1999, where every bit of resources helps.

If you seriously want a server state platform, why not use SQL server?

Of course it's a bit more difficult to setup, but it's as stable as a rock, and has the benefits of auto-utilization of resources to a specific cap.

TL: DR

You don't need to optimize your "mysql" to run faster queries.