This query, which runs very often on the wikishared database in x1, is scanning 3M rows each time as it is not using an index.
mysql:root@localhost [wikishared]> explain SELECT /* ContentTranslation\Store\TranslationStore::findByPublishedTitle */ * FROM `cx_translations` WHERE translation_target_language = 'es' AND translation_target_title = 'Copa Mundial de Clubes de la FIFA 2025' AND ((translation_status = 'published' OR translation_target_url IS NOT NULL)) LIMIT 1;; +------+-------------+-----------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +------+-------------+-----------------+------+---------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | cx_translations | ALL | NULL | NULL | NULL | NULL | 2662363 | Using where | +------+-------------+-----------------+------+---------------+------+---------+------+---------+-------------+ 1 row in set (0.001 sec)
The query itself isn't super slow (around 3 seconds) but we should take a look and see if we can avoid all this full scans as if the table keeps growing, it will keep being slower.
Because of this, Currently, rows read in x1 is higher than every other section in production combined:
