Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

View Poll Results: Which version MySql do you use for your server?
I use MySQL 4.0 or less 6 7.23%
I use MySql 4.1 and up, but less than MySql5x 14 16.87%
I use MySql 5.0 or higher 63 75.90%
Voters: 83. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #1  
Old 02-06-2007, 10:20 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default Poll who uses which MySQl?

Would like to see how much MySql5 is in use already. or who still uses 4
Reply With Quote
  #2  
Old 02-06-2007, 01:45 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

You should have an I use all 3 options for weirdos like me
Reply With Quote
  #3  
Old 02-06-2007, 02:36 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Looks like MySql5 is loosing ground! Darn, I gambled a lot of money there ...
Reply With Quote
  #4  
Old 02-06-2007, 02:38 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by cavedude
You should have an I use all 3 options for weirdos like me
I've had all three and just had 4.0 and 5.0 tell the other day.
Reply With Quote
  #5  
Old 02-06-2007, 02:53 PM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Replied for PEQ. As for myself, I have a 4.1 server and a 5.0. Personally, I actually like the 4.1 better. Seems to outperform 5.0 on my servers.
Reply With Quote
  #6  
Old 02-07-2007, 02:30 AM
John Adams
Demi-God
 
Join Date: Jul 2006
Posts: 1,552
Default

So far, my 4.1 on Linux smokes the pants off anything I ever tried on Windoze. I think 5.x, while newer and more fancy, is also slower because of the fatness being added. Good fatness, nonetheless.
Reply With Quote
  #7  
Old 02-07-2007, 03:45 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Quote:
Originally Posted by John Adams
So far, my 4.1 on Linux smokes the pants off anything I ever tried on Windoze. I think 5.x, while newer and more fancy, is also slower because of the fatness being added. Good fatness, nonetheless.
I agree 100%
Reply With Quote
  #8  
Old 02-07-2007, 04:44 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Let me just clarify.

I do agree MySQL 5.0 would be best to migrate to. Not so much for the features but for the fact that it is an active project and not obsolete. EQEmu needs to move forward.

However, I have to admit MySQL 4.1 is faster and uses less resources than 5.0. I won't hide that fact and tell everybody 5.0 is better in every way when it isn't.

As for 4.0, well it lacks the features of the above and also is slower than both. I voted for it because that is what PEQ runs, atm. It's obsolete unsupported software. HOWEVER, I do not want it to be forgotten at first. If a migration to 5.0 takes place, I do not want EQEmu to change to prevent use of 4.0 or 4.1. It should be backwards compatible, for at least the first year or so. Likewise, when 5.1 and 5.2 and so forth are out, I do not want 5.0 forgotten about. People deserve a choice.
Reply With Quote
  #9  
Old 02-07-2007, 12:08 PM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

Quote:
Originally Posted by John Adams
So far, my 4.1 on Linux smokes the pants off anything I ever tried on Windoze. I think 5.x, while newer and more fancy, is also slower because of the fatness being added. Good fatness, nonetheless.
Lol - that's ok , just so long as you voted for 5.0, and made the bar fatter too
Reply With Quote
  #10  
Old 02-12-2007, 02:15 AM
gernblan
Discordant
 
Join Date: Aug 2006
Posts: 394
Default

Believe it or not, I've had the best results (under linux anyway) with mysql 5.x vs. 4.x

I know you target 4.x still, but 5.x is just a better overall experience for me. Less problems across the board.
Reply With Quote
  #11  
Old 02-14-2007, 05:59 AM
Angelox
AX Classic Developer
 
Join Date: May 2006
Location: filler
Posts: 2,049
Default

I made this thread sticky, and gave it a mild "bump" see if we can't get in some more votes
Reply With Quote
  #12  
Old 02-14-2007, 09:36 AM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

When I started mySQL it was a 4.1. I needed it because PHPbb2 wouldn't accept any thing newer. Then a few months later they did. MySQL 5 is for me the most.

In 4.1 the Admin tool would load tables faster and didn't have an extra table on install. However the quary tool runs faster on 5 when building results.

MySQL 5 - The Way it's mean to be stored!
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #13  
Old 02-14-2007, 10:02 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

MS Access ftw.
Reply With Quote
  #14  
Old 02-14-2007, 05:18 PM
Kayot
Discordant
 
Join Date: Sep 2006
Location: Subsection 185.D354 C.12
Posts: 346
Default

Quote:
Originally Posted by cavedude
MS Access ftw.
I don't know if I should laugh or hate you...
__________________
If at first you don't succeed destroy all evidence that you ever tried.

God doesn't give second chances... Hell, he sets you up the first time.
Reply With Quote
  #15  
Old 02-19-2007, 05:40 AM
ArChron
Fire Beetle
 
Join Date: Dec 2006
Location: Vienna
Posts: 28
Default

A little late to the party, but MySQL 5... hang on... 5.0.27.

Gotta have them views...
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 04:57 AM.


 

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