Page MenuHomePhabricator
Paste P17278

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Sep 16 2021, 6:55 AM.
Tags
None
Referenced Files
F34644627: raw-paste-data.txt
Sep 16 2021, 6:55 AM
F34644625: raw-paste-data.txt
Sep 16 2021, 6:55 AM
Subscribers
None
=== db2123 (s5 codfw master): ===
mysql:root@localhost [dewiki]> alter table logging engine=InnoDB;
Query OK, 0 rows affected (8 min 47.942 sec)
Records: 0 Duplicates: 0 Warnings: 0
mysql:root@localhost [dewiki]> optimize table logging;
+----------------+----------+----------+-------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+----------------+----------+----------+-------------------------------------------------------------------+
| dewiki.logging | optimize | note | Table does not support optimize, doing recreate + analyze instead |
| dewiki.logging | optimize | status | OK |
+----------------+----------+----------+-------------------------------------------------------------------+
2 rows in set (8 min 31.735 sec)
=== db2111 (s5 codfw slave - happens everywhere): ===
root@db2111:/srv/sqldata# mysqlbinlog -vvv db2111-relay-bin.001406 | grep "alter table"
alter table logging engine=InnoDB
root@db2111:/srv/sqldata# mysqlbinlog -vvv db2111-relay-bin.001406 | grep "optimize table"
root@db2111:/srv/sqldata#