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 > [email protected] > https://lists.wikimedia.org/mailman/listinfo/labs-l
_______________________________________________ Labs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/labs-l
