Page MenuHomePhabricator

Please optimize logging table in dewiki
Closed, ResolvedPublic


Event Timeline

Marostegui moved this task from In progress to Blocked on the DBA board.

Waiting for the switch back to do codfw.

Mentioned in SAL (#wikimedia-operations) [2021-09-16T05:35:51Z] <marostegui> Optimize dewiki.logging in codfw T287344

Marostegui updated the task description. (Show Details)

This is fully done.
However I have found that the optimize event isn't being replicated (or written on the binlog) so I am investigating if this is a mariadb bug or a PBCAK so I have done eqiad host by host and used alter table engine=InnoDB; for codfw

1=== db2123 (s5 codfw master): ===
3mysql:root@localhost [dewiki]> alter table logging engine=InnoDB;
4Query OK, 0 rows affected (8 min 47.942 sec)
5Records: 0 Duplicates: 0 Warnings: 0
7mysql:root@localhost [dewiki]> optimize table logging;
9| Table | Op | Msg_type | Msg_text |
11| dewiki.logging | optimize | note | Table does not support optimize, doing recreate + analyze instead |
12| dewiki.logging | optimize | status | OK |
142 rows in set (8 min 31.735 sec)
16=== db2111 (s5 codfw slave - happens everywhere): ===
18root@db2111:/srv/sqldata# mysqlbinlog -vvv db2111-relay-bin.001406 | grep "alter table"
19alter table logging engine=InnoDB
20root@db2111:/srv/sqldata# mysqlbinlog -vvv db2111-relay-bin.001406 | grep "optimize table"