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

Hedonil hedonil at action.ms
Sat Aug 2 09:54:57 UTC 2014


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.wikimedia.org/pipermail/labs-l/attachments/20140802/d684af3e/attachment.html>


More information about the Labs-l mailing list