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
