https://bugzilla.wikimedia.org/show_bug.cgi?id=35028
--- Comment #7 from Antoine "hashar" Musso <[email protected]> 2012-05-02 14:15:11 UTC --- Following the deployment on gallium, here are some slow queries. The first two are the most frequents: SELECT run_id, client_id, useragent_id FROM run_client, clients WHERE DATE_ADD(run_client.updated, INTERVAL 5 MINUTE) < NOW() AND clients.id = client_id AND run_client.status = 1; UPDATE run_useragent SET runs=0, completed=0, status=0 WHERE runs=max AND NOT EXISTS (SELECT * FROM run_client, clients WHERE run_client.run_id=run_useragent.run_id AND run_client.client_id=clients.id AND clients.useragent_id=run_useragent.useragent_id); And there are a few that looks like: SELECT useragents.engine as engine, useragents.name as name, (SELECT COUNT(*) FROM clients WHERE useragent_id=useragents.id AND updated > DATE_SUB(NOW(), INTERVAL 1 minute)) as clients, (engine='msie' AND '9.0' REGEXP version) as found FROM useragents WHERE active=1 AND mobile='0' ORDER BY engine, name; That one was with 'msie' and '9.0'. SELECT useragents.engine as engine, useragents.name as name, (SELECT COUNT(*) FROM clients WHERE useragent_id=useragents.id AND updated > DATE_SUB(NOW(), INTERVAL 1 minute)) as clients, (engine='' AND '' REGEXP version) as found FROM useragents WHERE active=1 AND mobile='1' ORDER BY engine, name; -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
