Please optimize logging table in dewiki
Closed, ResolvedPublic
Actions

Assigned To

Authored By

	Ladsgroup
	Jul 26 2021, 5:17 AM

Description

Part of T285608: Stop logging and clean up auto review logs

Progress

eqiad
codfw

Related Objects
Search...

Status	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	T287344 Please optimize logging table in dewiki

Event Timeline

Ladsgroup created this task.Jul 26 2021, 5:17 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 26 2021, 5:17 AM

Marostegui triaged this task as Medium priority.Jul 26 2021, 5:48 AM

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

Marostegui added a parent task: T285139: DB maintenance work to do while eqiad is passive (June 2021).

Marostegui updated the task description. (Show Details)Jul 26 2021, 7:07 AM

It went from 52G to 14G

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

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

P17278 (An Untitled Masterwork)

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

Opened https://jira.mariadb.org/browse/MDEV-26618

Please optimize logging table in dewikiClosed, ResolvedPublicActions

Description

Related ObjectsSearch...

Event Timeline

Please optimize logging table in dewiki
Closed, ResolvedPublic
Actions

Related Objects
Search...