On tools-db-6 replication is lagging. SHOW FULL PROCESSLIST shows this query:
| 13 | system user | | s51434__mixnmatch_p | Slave_worker | 11 | Update_rows_log_event::find_row(-1) on table `auxiliary_broken` | UPDATE auxiliary_broken a INNER JOIN auxiliary_fix af ON a.aux_p=af.aux_p AND a.aux_name=af.label SET a.aux_name=af.aux_name | 0.000 |
The table s51434__mixnmatch_p.auxiliary_broken has 1583236 rows and no index:
MariaDB [(none)]> SELECT COUNT(*) FROM s51434__mixnmatch_p.auxiliary_broken; +----------+ | COUNT(*) | +----------+ | 1583236 | +----------+ 1 row in set (0.533 sec) MariaDB [(none)]> SHOW CREATE TABLE s51434__mixnmatch_p.auxiliary_broken; +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | auxiliary_broken | CREATE TABLE `auxiliary_broken` ( `id` int(11) unsigned NOT NULL DEFAULT 0, `entry_id` int(11) unsigned NOT NULL, `aux_p` int(10) unsigned NOT NULL, `aux_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '', `in_wikidata` tinyint(1) NOT NULL DEFAULT 0, `entry_is_matched` tinyint(1) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci | +------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.000 sec)
