MySQL Optimization

[koldar]

Hello,
Has anyone played around with the memory allocation/buffers/cache within MySQL to optimize the performance? My query cache is currently set to 0 (default) and i'm wondering if there is a more optimal setting for my queries.

Koldar

[knowom]

I'm curious about mysql query cache setting as well anyone played around with it on EQemu?

[Kingly_Krab]

I haven't played with it myself, however, you revived a 6 year old post, haha.

[knowom]

Originally Posted by Kingly_Krab

I haven't played with it myself, however, you revived a 6 year old post, haha.

Yeah I know I'm a performance nut I was just curious if anyone had tampered with it is all and sometimes those are the best kept secret threads.

Basically you can set a mysql query cache to a set amount and a few parameters to speed up query results is the gist of it which seems like it could be useful for EQemu servers.

Servers with high disk I/O going on would benefit the most from the setting. It wouldn't do much to help with connection based lag, but it could help minimize some hardware based server lag for some people.


I figured someone might have experimented with it, but apparently not. I think the best method to test it would probably be take as many mobs as you can and stick them in the arena zone spawn simultaneously and make them high aggro radius then aoe all them at once and make them different mob types and sizes as well with different weapon so it really hits the DB hard all at once.

[joligario]

Originally Posted by knowom

I think the best method to test it would probably be take as many mobs as you can and stick them in the arena zone spawn simultaneously and make them high aggro radius then aoe all them ... so it really hits the DB hard all at once.

Actually, there is a video (and command) where someone did this. I don't think it was for DB optimization - I think it was for pathing.

[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.