Hello, I'm trying to run this query more fastly. Can you help me how to optimalize it?
MariaDB [commonswiki_p]> select count(*) from logging_logindex where log_type="thanks" and log_title="Martin_Urbanec"; +----------+ | count(*) | +----------+ | 6 | +----------+ 1 row in set (8 min 42.87 sec) MariaDB [commonswiki_p]> It's supposed to provide web-accessible information, and it's not possible to wait 8 mins for completion. https://tools.wmflabs.org/sql-optimizer/ didn't offer any solution. Any suggestions? Martin
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud
