EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)
-   -   mqsql 5 (https://www.eqemulator.org/forums/showthread.php?t=20803)

fireclav 06-16-2006 12:50 AM

mqsql 5
 
i see the new patch supports mysql 5 and i was wondering what are the advantages of upgrading to this over the one used currently.

sesmar 06-16-2006 04:25 AM

I just set this up on my server and so far, using MySql 5, the Emu seems to load the DB info faster.

I could not get the precompiled binaries to work for me. I kept getting this error:

Code:

Failed to connect to database: Error: #1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client
So I recompiled the server using the MySql 5 include and Lib files and it booted right up for me.

Coleshadowblades 06-16-2006 10:44 AM

I posted new binaries for mysql 5 in the Development forum and also updated source for use with vs 2003 with an updated server.sln file with the file references taken out that cause compile errors

fireclav 06-16-2006 11:47 AM

ok thanks for the reply was thinking about upgrading to 5.0 but wanted to wait to see what the advants were before i did it. thanks again

Coleshadowblades 06-16-2006 12:24 PM

Ok DONT use the version i compiled Quests dont seem to work in it working on it will post updated files ASAP

fireclav 06-16-2006 02:42 PM

so the only benefit is that the DB will load quicker during startup?

Coleshadowblades 06-16-2006 11:04 PM

It also boots the zones faster thus making the clients zone in faster mysql 5 executes queries much faster then 4 due to 4 being so outdated

Sesmar and i have tinkered ( He did most of the code tinkering ) I found bugs and mysql edits that need to be done... anyway I posted our precompiled 0.7.0-800 for mysql 5 along with the needed database edits in the development section

Also note that these binaries up the max level to 127 for players


All times are GMT -4. The time now is 12:03 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.