| 
			 | 
		
			 
				Specific Query Performance Tips (see also database design tips for tips on indexes): Use ... Retrieved from "http://forge.mysql.com/wiki/Top10SQLPerformanceTips" ...			 
			
				
					http://forge.mysql.com/wiki/Top10SQLPerformanceTips				
									
							 
			
						popularity:
						 
					
				
							mysql						 
					
							performance						 
					
							database						 
					
							tips						 
					
							sql						 
					
							optimization						 
					
							tuning						 
					
							development						 
					
							programming						 
					
							howto						 
					 | 
		
| 
				 | 
			
				 
					MySQL Performance Blog - The Percona Team blog dedicated to performance and optimization for MySQL, InnoDB, XtraBackup, XtraDB, and related technologies				 
				
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								performance							 
						
								database							 
						
								optimization							 
						
								blog							 
						
								sql							 
						
								tips							 
						
								tuning							 
						
								programming							 
						
								tutorial							 
						 | 
		
| 
				 | 
			
				 
					Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								optimization							 
						
								performance							 
						
								tips							 
						
								sql							 
						
								database							 
						
								bestpractices							 
						
								tutorial							 
						
								php							 
						
								development							 
						 | 
		
| 
				 | 
			
				 
					No information avaiable				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								sql							 
						
								database							 
						
								mysql							 
						
								performance							 
						
								optimization							 
						
								tips							 
						
								programming							 
						
								code							 
						
								development							 
						
								bestpractices							 
						 | 
		
| 
				 | 
			
				 
					I've been thinking a lot about invalid and zero temporal values and how to ... The requirements are complex because we have to take into account what MySQL ...				 
				
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								performance							 
						
								database							 
						
								optimization							 
						
								tools							 
						
								reference							 
						
								tips							 
						
								hack							 
						
								sysadmin							 
						
								tuning							 
						 | 
		
| 
				 | 
			
				 
					No information avaiable				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								performance							 
						
								cache							 
						
								database							 
						
								optimization							 
						
								caching							 
						
								sql							 
						
								query							 
						
								tuning							 
						
								programming							 
						 | 
		
| 
				 | 
			
				 
					For the first examples we assume the be ID is starting at 1 and we have no holes ... As MAX(id) == COUNT(id) we just generate random number between 1 and MAX(id) and ...				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								random							 
						
								sql							 
						
								performance							 
						
								database							 
						
								optimization							 
						
								rand							 
						
								programming							 
						
								tips							 
						
								php							 
						 | 
		
| 
				 | 
			
				 
					No information avaiable				 
				
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								optimization							 
						
								performance							 
						
								index							 
						
								database							 
						
								sql							 
						
								join							 
						
								howto							 
						
								joins							 
						
								programming							 
						 | 
		
| 
				 | 
			
				 
					When a MyISAM table grows large enough, you'll encounter the dreaded "The ... Now I could simply point at that page and leave this subject alone, but there's ...				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								database							 
						
								optimization							 
						
								performance							 
						
								howto							 
						
								tuning							 
						
								sysadmin							 
						
								reference							 
						
								limit							 
						
								sql							 
						 | 
		
| 
				 | 
			
				 
					No information avaiable				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								performance							 
						
								optimization							 
						
								database							 
						
								indexing							 
						
								sql							 
						
								tutorial							 
						
								query							 
						
								index							 
						
								tuning							 
						 | 
		
| 
				 | 
			
				 
					No information avaiable				 
				
							similarity:
							 
						
							popularity:
							 
						
					
								mysql							 
						
								performance							 
						
								database							 
						
								indexes							 
						
								index							 
						
								tips							 
						
								optimization							 
						
								tutorial							 
						
								sql							 
						
								toread							 
						 | 
		
			an example search result