Jcrespo has uploaded a new change for review. (
https://gerrit.wikimedia.org/r/351796 )
Change subject: query-killer: Do not kill queries containing gtid_wait or DMLs
......................................................................
query-killer: Do not kill queries containing gtid_wait or DMLs
Change-Id: If12e8a7afdd6accb54c6bba59955db0d66def9d6
---
M dbtools/events_coredb_slave.sql
1 file changed, 1 insertion(+), 1 deletion(-)
git pull ssh://gerrit.wikimedia.org:29418/operations/software
refs/changes/96/351796/1
diff --git a/dbtools/events_coredb_slave.sql b/dbtools/events_coredb_slave.sql
index abf0aec..12df84b 100644
--- a/dbtools/events_coredb_slave.sql
+++ b/dbtools/events_coredb_slave.sql
@@ -76,7 +76,7 @@
AND ps.PROCESSLIST_COMMAND = 'Query'
AND ps.processlist_time between 60 and 1000000
AND not lower(ps.PROCESSLIST_INFO) regexp 'wikiexporter'
- AND not lower(ps.PROCESSLIST_INFO) regexp 'master_pos_wait'
+ AND not lower(ps.PROCESSLIST_INFO) regexp
'(master_pos_wait|master_gtid_wait|insert|update|replace|delete)'
ORDER BY ps.processlist_time DESC;
declare continue handler for not found set all_done = 1;
--
To view, visit https://gerrit.wikimedia.org/r/351796
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: If12e8a7afdd6accb54c6bba59955db0d66def9d6
Gerrit-PatchSet: 1
Gerrit-Project: operations/software
Gerrit-Branch: master
Gerrit-Owner: Jcrespo <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
