Yesterday I removed 35M rows from 75M rows of ruwiki's logging table as part of T285608: Stop logging and clean up auto review logs. I can brush off a couple more millions but that's not super straightforward. Can we optimize the table for now to use the benefits?
Progress
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Restricted Task | |||||
| Resolved | Legoktm | T281515 June 2021 Datacenter switchover | |||
| Resolved | • Marostegui | T285139 DB maintenance work to do while eqiad is passive (June 2021) | |||
| Resolved | • Marostegui | T286102 Please optimize logging table in ruwiki |
I have tried this to see the benefits:
Compressed table:
root@db1096:~# ls -lh /srv/sqldata.s6/ruwiki/logging.ibd -rw-rw---- 1 mysql mysql 20G Jul 5 10:07 /srv/sqldata.s6/ruwiki/logging.ibd
After:
root@db1096:~# ls -lh /srv/sqldata.s6/ruwiki/logging.ibd -rw-rw---- 1 mysql mysql 9.1G Jul 5 10:27 /srv/sqldata.s6/ruwiki/logging.ibd
Non compressed table:
root@db1131:~# ls -lh /srv/sqldata/ruwiki/logging.ibd -rw-rw---- 1 mysql mysql 38G Jul 5 10:07 /srv/sqldata/ruwiki/logging.ibd
After
root@db1131:~# ls -lh /srv/sqldata/ruwiki/logging.ibd -rw-rw---- 1 mysql mysql 19G Jul 5 10:28 /srv/sqldata/ruwiki/logging.ibd
Mentioned in SAL (#wikimedia-operations) [2021-07-05T10:29:31Z] <marostegui> Optimize ruwiki.logging on s6 eqiad with replication T286102
This is affected by https://jira.mariadb.org/browse/MDEV-26618 so eqiad needs to be done again (the master is done)
Mentioned in SAL (#wikimedia-operations) [2021-09-23T05:24:49Z] <marostegui> Optimize ruwiki.logging on codfw T286102