These 4 queries were running at the same time and had been running for over an hour. As a result of creating the indexes on disk, it reduced disk free from ~4.2T to ~300G.
| 3539660 | civicrm | 10.64.40.115:37558 | civicrm | Query | 3919 | Creating sort index | /* User : 1711 PID : 1431988 */SELECT `a`.`id` AS `id`, `a`.`tracking_date` AS `tracking_date`, `a`.`amount` AS `amount`, `a`.`currency` AS `currency`, `a`.`country` AS `country`, `a`.`utm_key` AS `utm_key`, `a`.`utm_medium` AS `utm_medium`, `a`.`referrer` AS `referrer`, `contribution_id_1`.`currency` AS `contribution_id.currency` FROM `civicrm_contribution_tracking` a LEFT JOIN civicrm_contribution `contribution_id_1` ON `a`.`contribution_id` = `contribution_id_1`.`id` ORDER BY `a`.`id` ASC, `a`.`tracking_date` ASC, `a`.`amount` ASC, `a`.`currency` ASC, `a`.`country` ASC, `a`.`utm_key` ASC, `a`.`utm_medium` ASC, `a`.`referrer` ASC LIMIT 11 OFFSET 0 | 0.000 | | 3539664 | civicrm | 10.64.40.115:39970 | civicrm | Query | 3811 | Creating sort index | /* User : 1711 PID : 1431973 */SELECT `a`.`id` AS `id`, `a`.`tracking_date` AS `tracking_date`, `a`.`amount` AS `amount`, `a`.`currency` AS `currency`, `a`.`country` AS `country`, `a`.`utm_key` AS `utm_key`, `a`.`utm_medium` AS `utm_medium`, `a`.`referrer` AS `referrer`, `contribution_id_1`.`currency` AS `contribution_id.currency` FROM `civicrm_contribution_tracking` a LEFT JOIN civicrm_contribution `contribution_id_1` ON `a`.`contribution_id` = `contribution_id_1`.`id` ORDER BY `a`.`id` ASC, `a`.`tracking_date` ASC, `a`.`amount` ASC, `a`.`currency` ASC, `a`.`country` ASC, `a`.`utm_key` ASC, `a`.`utm_medium` ASC, `a`.`referrer` ASC LIMIT 11 OFFSET 0 | 0.000 | | 3539665 | civicrm | 10.64.40.115:39986 | civicrm | Query | 3859 | Creating sort index | /* User : 1711 PID : 1429440 */SELECT `a`.`id` AS `id`, `a`.`tracking_date` AS `tracking_date`, `a`.`amount` AS `amount`, `a`.`currency` AS `currency`, `a`.`country` AS `country`, `a`.`utm_key` AS `utm_key`, `a`.`utm_medium` AS `utm_medium`, `a`.`referrer` AS `referrer`, `contribution_id_1`.`currency` AS `contribution_id.currency` FROM `civicrm_contribution_tracking` a LEFT JOIN civicrm_contribution `contribution_id_1` ON `a`.`contribution_id` = `contribution_id_1`.`id` ORDER BY `a`.`id` ASC, `a`.`tracking_date` ASC, `a`.`amount` ASC, `a`.`currency` ASC, `a`.`country` ASC, `a`.`utm_key` ASC, `a`.`utm_medium` ASC, `a`.`referrer` ASC LIMIT 11 OFFSET 0 | 0.000 | | 3539673 | civicrm | 10.64.40.115:33078 | civicrm | Query | 3799 | Creating sort index | /* User : 1711 PID : 1431916 */SELECT `a`.`id` AS `id`, `a`.`tracking_date` AS `tracking_date`, `a`.`amount` AS `amount`, `a`.`currency` AS `currency`, `a`.`country` AS `country`, `a`.`utm_key` AS `utm_key`, `a`.`utm_medium` AS `utm_medium`, `a`.`referrer` AS `referrer`, `contribution_id_1`.`currency` AS `contribution_id.currency` FROM `civicrm_contribution_tracking` a LEFT JOIN civicrm_contribution `contribution_id_1` ON `a`.`contribution_id` = `contribution_id_1`.`id` ORDER BY `a`.`id` ASC, `a`.`tracking_date` ASC, `a`.`amount` ASC, `a`.`currency` ASC, `a`.`country` ASC, `a`.`utm_key` ASC, `a`.`utm_medium` ASC, `a`.`referrer` ASC LIMIT 11 OFFSET 0 | 0.000 |
If they would have kept running, we would have shortly run out of disk on the FRDB origin server.
https://frmon.wikimedia.org/goto/afb25dtfv8mpsd?orgId=1