[Labs-l] Pimp your SQL queries - Labs SQL Optimizer

[Hedonil]

Update: New version v0.9 overcomes some restrictions

- Analyses are now performed in real-time execution with SHOW EXPLAIN
- Query-base is no longer limited to hand.picked wiki's
- No longer limited to a set of snapshot data

https://tools.wmflabs.org/tools-info/optimizer.py

-Hedonil


On 02/08/14 11:54, Hedonil wrote:
> The end of database-upgrade is close at hand
> ..and there are some changes to take into account.
>
> One of them is that we can now reach/join any database from within one
> single connection without caring about federation issues.
> Good occasion to re-check the current queries.
>
> To facilitate this job, I've written a small and easy-to-use tool: The
> fancy Labs SQL Optimizer
> https://tools.wmflabs.org/tools-info/optimizer.php
>
> Features:
> - Analyses your query with EXPLAIN command (copy & paste)
> - Shows corresponding table definitions / indices / views at a glance
> - Gives some hints and provides links to related SOL-resources on
> Tools/Labs
>
> Limitations:
> - Limited set of data (100,000 - 600,000 records per table)
> - POST only, by intention
>
> Enjoy! Feedback always appreciated.
>
> -Hedonil
>
>
> _______________________________________________
> Labs-l mailing list
> Labs-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/labs-l

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140803/dcf24b73/attachment.html>