Optimize Your SQL With Percona’s Online Query Advisor!

February 15, 2012

Author

Baron Schwartz

Insight for DBAs

Insight for Developers

MySQL

Share this Post:

Wouldn’t it be nice if you could get expert advice on your SQL queries to find problems in them, the same way that programmers can use lint-check tools to warn about bugs in their C?



		
		
			
			

			
			if ( execute = 1 ) {<br>   launch_missile();<br>}
			
				
					
				
					1
				
						if ( execute = 1 ) {<br>   launch_missile();<br>}

Such a simple mistake, but it’s the kind of thing that James Bond movies are made of, isn’t it? Well, a lot of SQL queries have similar bugs, and thanks to Miguel Trias, now there’s a tool to help you find them. This is the second addition to our online suite of tools for MySQL users. You paste a query, it tells you what’s wrong with it. Simple as that.

Find the bug in this query:



		
		
			
			

			
			select * from t1<br>   left join t2 using(id)<br>where t2.created_date < 2012-02-15;
			
				
					
				
					1
				
						select * from t1<br>   left join t2 using(id)<br>where t2.created_date < 2012-02-15;

Do you see it? Congratulations! I’ve analyzed that query with the tool, and shared the results with you. Click here to see if you were right.

That demonstrates another feature of the tool: you can share queries so they’re public, and other people can see them. The tool uses the same account that you might have already created for our online MySQL Configuration Wizard, which helps you choose good settings for your server.

Give it a try, and tell your friends! Enjoy hunting for bugs and problems in your SQL queries!