| 
   | 
   | 
  
 
    | 
    | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
    | 
   | 
    | 
  
 
   | 
  
	
		
   
   
      | 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% | 
 
	
 
 
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-06-2007, 10:20 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 AX Classic Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2006 
					Location: filler 
					
					
						Posts: 2,049
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
				 
				Poll who uses which MySQl?
			 
			 
			
		
		
		
		Would like to see how much MySql5 is in use already. or who still uses 4 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-06-2007, 01:45 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		You should have an I use all 3 options for weirdos like me    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-06-2007, 02:36 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 AX Classic Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2006 
					Location: filler 
					
					
						Posts: 2,049
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		Looks like MySql5 is loosing ground! Darn, I gambled a lot of money there ... 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-06-2007, 02:38 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 AX Classic Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2006 
					Location: filler 
					
					
						Posts: 2,049
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	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.  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-06-2007, 02:53 PM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		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. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-07-2007, 02:30 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Demi-God 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Jul 2006 
					
					
					
						Posts: 1,552
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		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. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-07-2007, 03:45 AM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	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%  
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-07-2007, 04:44 AM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		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. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-07-2007, 12:08 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 AX Classic Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2006 
					Location: filler 
					
					
						Posts: 2,049
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	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    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-12-2007, 02:15 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Aug 2006 
					
					
					
						Posts: 394
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		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. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2007, 05:59 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 AX Classic Developer 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: May 2006 
					Location: filler 
					
					
						Posts: 2,049
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		I made this thread sticky, and gave it a mild "bump" see if we can't get in some more votes    
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2007, 09:36 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2006 
					Location: Subsection 185.D354 C.12 
					
					
						Posts: 346
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		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. 
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2007, 10:02 AM
			
			
			
		  
	 | 
 
	
		
		
		
			  | 
			
			
				
				
				 The PEQ Dude 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Apr 2003 
					Location: - 
					
					
						Posts: 1,988
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		MS Access ftw. 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-14-2007, 05:18 PM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Discordant 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Sep 2006 
					Location: Subsection 185.D354 C.12 
					
					
						Posts: 346
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		
	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. 
			 
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
	
	
		
	
	
	
		
		
		
			
			 
			
				02-19-2007, 05:40 AM
			
			
			
		  
	 | 
 
	
		
		
		
			
			| 
			
				
				
				 Fire Beetle 
				
				
				
			 | 
			  | 
			
				
				
					Join Date: Dec 2006 
					Location: Vienna 
					
					
						Posts: 28
					 
					
					
					
					     
				 
				
			 | 
		 
		 
		
	 | 
 
	
	
	
		
		
		
			
			
			 
			
		
		
		
		A little late to the party, but MySQL 5... hang on... 5.0.27. 
 
Gotta have them views... 
		
	
		
		
		
		
		
		
		
		
		
	
		
		
	
	
	 | 
 
 
	 
	
		 
	 
 
 
	
		
	
	
	
	
	
		
	
		 
		Posting Rules
	 | 
 
	
		
		You may not post new threads 
		You may not post replies 
		You may not post attachments 
		You may not edit your posts 
		 
		
		
		
		
		HTML code is Off 
		 
		
	  | 
 
 
	 | 
	
		
	 | 
 
 
All times are GMT -4. The time now is 06:23 AM. 
 
		 
	 
 
 
     | 
     | 
    
   
      | 
     | 
      | 
    
   
     | 
      | 
     | 
    
   
       | 
      | 
       | 
     
    
    
  | 
   |