[13:30:25] 10DBA, 06Labs, 10Tool-Labs: u13367 is running 2 inefficient 9-day-long queries, causing high cpu usage - https://phabricator.wikimedia.org/T144180#2590904 (10jcrespo) [13:37:54] 10DBA, 06Labs, 10Tool-Labs: u13367 is running 2 inefficient 9-day-long queries, causing high cpu usage - https://phabricator.wikimedia.org/T144180#2590954 (10Urbanecm) I'm sorry for it. I'm trying to update list of 500 most linked disambigs at cswiki. I have some script but I want to convert it to one SQL qu... [13:39:37] 10DBA, 06Labs, 10Tool-Labs: u13367 is running 2 inefficient 9-day-long queries, causing high cpu usage - https://phabricator.wikimedia.org/T144180#2590958 (10Urbanecm) ATM all my processes including any mysql consoles should be killed, no job should be running from my personal account, from my two tools only... [13:50:43] 10DBA, 06Labs, 10Tool-Labs, 07Tracking: Certain tools users create multiple long running queries that take all memory from labsdb hosts, slowing it down and potentially crashing (tracking) - https://phabricator.wikimedia.org/T119601#2590976 (10jcrespo) [13:50:45] 10DBA, 06Labs, 10Tool-Labs, 15User-Urbanecm: u13367 is running 2 inefficient 9-day-long queries, causing high cpu usage - https://phabricator.wikimedia.org/T144180#2590973 (10jcrespo) 05Open>03Resolved a:03Urbanecm Yes, I killed the queries. Normally the query killer should limit these, but for some... [14:51:31] 10DBA, 06Operations, 13Patch-For-Review: Decomission old coredb machines (<=db1050) - https://phabricator.wikimedia.org/T134476#2591129 (10jcrespo) db1015, db1035 are starting to run low on available disk space. We should prioritize decomm'em soon. [17:05:15] 10DBA, 10Beta-Cluster-Infrastructure, 06Release-Engineering-Team, 13Patch-For-Review, 07WorkType-Maintenance: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 - https://phabricator.wikimedia.org/T138778#2591932 (10dduvall) I think we're ready to roll with this on the pup... [17:11:41] 10DBA, 10Beta-Cluster-Infrastructure, 06Release-Engineering-Team, 13Patch-For-Review, 07WorkType-Maintenance: Upgrade mariadb in deployment-prep from Precise/MariaDB 5.5 to Jessie/MariaDB 5.10 - https://phabricator.wikimedia.org/T138778#2591952 (10jcrespo) @dduval, assuming everyhing is prepared (the mac...