Page MenuHomePhabricator

Compress enwiki InnoDB tables
Open, MediumPublic

Description

Let's compress InnoDB on enwiki
Not super urgent, but creating this ticket so we don't forget.
This might result on more CPU usage as we've seen on s8, so ideally do this first on MariaDB 10.4 hosts.

  • labsdb1012
  • labsdb1011
  • labsdb1010
  • labsdb1009
  • dbstore1003
  • db2130
  • db2116
  • db2112
  • db2103
  • db2097
  • db2094
  • db2092
  • db2088
  • db2085
  • db2072
  • db2071
  • db1140
  • db1139
  • db1134
  • db1124
  • db1119
  • db1118
  • db1107
  • db1106
  • db1105
  • db1099
  • db1091
  • db1089
  • db1083
  • db1080 (copied to db1135)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 4 2020, 11:22 AM
Marostegui triaged this task as Medium priority.Jun 4 2020, 11:27 AM
Marostegui updated the task description. (Show Details)
Marostegui added a project: DBA.
Marostegui moved this task from Triage to Next on the DBA board.

Mentioned in SAL (#wikimedia-operations) [2020-06-04T11:29:07Z] <marostegui> Compress InnoDB on db1091 before pooling it as new slave on s1 - T254462

Marostegui updated the task description. (Show Details)Jun 8 2020, 12:05 PM

Mentioned in SAL (#wikimedia-operations) [2020-06-08T12:18:01Z] <marostegui> Compress InnoDB on db2094:3311 T254462

Marostegui updated the task description. (Show Details)Jun 8 2020, 12:18 PM
Marostegui updated the task description. (Show Details)Tue, Jun 9, 9:39 AM

Mentioned in SAL (#wikimedia-operations) [2020-06-09T09:40:59Z] <marostegui> Compress InnoDB on db2072 T254462

Marostegui moved this task from Next to In progress on the DBA board.Tue, Jun 9, 1:47 PM
Marostegui updated the task description. (Show Details)Fri, Jun 12, 8:41 AM
Marostegui updated the task description. (Show Details)

Change 605161 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2092: Disable notifications

https://gerrit.wikimedia.org/r/605161

Mentioned in SAL (#wikimedia-operations) [2020-06-12T08:44:21Z] <marostegui> Compress InnoDB on db2092 - T254462

Change 605161 merged by Marostegui:
[operations/puppet@production] db2092: Disable notifications

https://gerrit.wikimedia.org/r/605161

Marostegui updated the task description. (Show Details)Mon, Jun 15, 1:55 PM

Change 605732 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db2092: Enable notifications

https://gerrit.wikimedia.org/r/605732

Change 605732 merged by Marostegui:
[operations/puppet@production] db2092: Enable notifications

https://gerrit.wikimedia.org/r/605732

Mentioned in SAL (#wikimedia-operations) [2020-06-16T06:56:01Z] <marostegui@cumin2001> dbctl commit (dc=all): 'Depool db1134 for InnoDB compression T254462', diff saved to https://phabricator.wikimedia.org/P11522 and previous config saved to /var/cache/conftool/dbconfig/20200616-065600-marostegui.json

Mentioned in SAL (#wikimedia-operations) [2020-06-16T06:57:00Z] <marostegui> Compress InnoDB on db1134 T254462

Change 605811 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1134: Disable notifications

https://gerrit.wikimedia.org/r/605811

Change 605811 merged by Marostegui:
[operations/puppet@production] db1134: Disable notifications

https://gerrit.wikimedia.org/r/605811

Mentioned in SAL (#wikimedia-operations) [2020-06-16T13:32:42Z] <marostegui@cumin2001> dbctl commit (dc=all): 'Repool db2092 T254462', diff saved to https://phabricator.wikimedia.org/P11535 and previous config saved to /var/cache/conftool/dbconfig/20200616-133241-marostegui.json

Marostegui updated the task description. (Show Details)Mon, Jun 22, 4:46 AM

Change 606849 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1134: Enable notifications

https://gerrit.wikimedia.org/r/606849

Change 606849 merged by Marostegui:
[operations/puppet@production] db1134: Enable notifications

https://gerrit.wikimedia.org/r/606849

Change 606850 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] install_server: Reimage db1118 to Buster.

https://gerrit.wikimedia.org/r/606850

Change 606850 merged by Marostegui:
[operations/puppet@production] install_server: Reimage db1118 to Buster.

https://gerrit.wikimedia.org/r/606850

Mentioned in SAL (#wikimedia-operations) [2020-06-22T05:58:45Z] <marostegui> Compress InnoDb on db1118 T254462

Marostegui updated the task description. (Show Details)Mon, Jun 22, 3:30 PM

Change 607165 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1118: Enable notifications

https://gerrit.wikimedia.org/r/607165

Change 607165 merged by Marostegui:
[operations/puppet@production] db1118: Enable notifications

https://gerrit.wikimedia.org/r/607165

Change 607167 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1080: Disable notifications

https://gerrit.wikimedia.org/r/607167

Change 607167 merged by Marostegui:
[operations/puppet@production] db1080: Disable notifications

https://gerrit.wikimedia.org/r/607167

Mentioned in SAL (#wikimedia-operations) [2020-06-23T05:24:20Z] <marostegui> Compress InnoDB on db1080 T254462

Marostegui updated the task description. (Show Details)Mon, Jun 29, 4:26 AM
Marostegui updated the task description. (Show Details)Mon, Jun 29, 8:03 AM

Change 608267 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1089: Disable notifications

https://gerrit.wikimedia.org/r/c/operations/puppet/ /608267

Mentioned in SAL (#wikimedia-operations) [2020-06-29T08:58:54Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1089 for InnoDB compression T254462', diff saved to https://phabricator.wikimedia.org/P11690 and previous config saved to /var/cache/conftool/dbconfig/20200629-085854-marostegui.json

Change 608267 merged by Marostegui:
[operations/puppet@production] db1089: Disable notifications

https://gerrit.wikimedia.org/r/c/operations/puppet/ /608267

Mentioned in SAL (#wikimedia-operations) [2020-06-29T08:59:39Z] <marostegui> Compress InnoDB on db1089 (this will cause lag and will take a few days) - T254462

Marostegui updated the task description. (Show Details)Mon, Jul 6, 4:42 AM

Change 609613 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1089: Enable notifications

https://gerrit.wikimedia.org/r/609613

Change 609613 merged by Marostegui:
[operations/puppet@production] db1089: Enable notifications

https://gerrit.wikimedia.org/r/609613

Mentioned in SAL (#wikimedia-operations) [2020-07-06T11:07:23Z] <marostegui@cumin1001> dbctl commit (dc=all): 'Depool db1107 T254462', diff saved to https://phabricator.wikimedia.org/P11745 and previous config saved to /var/cache/conftool/dbconfig/20200706-110723-marostegui.json

Change 609765 had a related patch set uploaded (by Marostegui; owner: Marostegui):
[operations/puppet@production] db1107: Disable notifications

https://gerrit.wikimedia.org/r/609765

Mentioned in SAL (#wikimedia-operations) [2020-07-06T11:09:45Z] <marostegui> Compress InnoDB on db1107 T254462

Change 609765 merged by Marostegui:
[operations/puppet@production] db1107: Disable notifications

https://gerrit.wikimedia.org/r/609765