MySQL 5.0 and eqemu

aza77 · #1 06-09-2006, 09:23 AM

https://www.projectf.de/mysql5.diff

diff was made for 0.7.0-800. all you need to do is add it to your code and the server works with mysql5

Arex · #2 06-10-2006, 08:45 PM

u also need modify spawn2 create table script changing condition field for `condition`..

aza77 · #3 06-10-2006, 10:54 PM

if you import a new db u can either use spawn2.condition or `condition`

Arex · #4 06-11-2006, 05:42 AM

i already have compiled code succesfully and same with DB source...have u checked eqemu performance with mysql 5.0? works it so good like with mysql 4.0.24?

Thank you for help!

aza77 · #5 06-11-2006, 06:27 AM

i didn't notice any slowdown but i already changed to mysql5 some month ago

abaddon · #6 09-27-2006, 04:24 AM

call me slow (laffs) but I had a question.. I have crappy machines (lots of them) so I am constantly looking for a faster way to do everything... will 5.x speed up the server?

eq4me · #7 09-27-2006, 04:48 AM

no

But you could use machines for dedicated tasks.

Eg. let the mysql Database run on one Machine and the EQEmu Server itself on other machines. You could even run zones from one EQEmu server on multiple machines. As long as you have enough RAM and maybe Swapspace in each machine that is.
I intend do try some more complex setups (under Linux) in the near future and write a Wiki tutorial about it.