| jcrespo added a comment. |
I am ok with that, but on my version, it doesn't create a temporary table (maybe you were mixing 2 different executions?):
MariaDB [wikidatawiki]> FLUSH STATUS; pager cat > /dev/null; SELECT page_id,page_title FROM `page` LEFT JOIN redirect ON rd_from = page_id WHERE (page_id > 3128073) AND page_namespace IN ('0','120') AND rd_from IS NULL ORDER BY page_id ASC LIMIT 100; nopager; SHOW STATUS like 'Hand%';
Query OK, 0 rows affected (0.00 sec)PAGER set to 'cat > /dev/null' 100 rows in set (0.00 sec) PAGER set to stdout +----------------------------+-------+ | Variable_name | Value | +----------------------------+-------+ | Handler_commit | 1 | | Handler_delete | 0 | | Handler_discover | 0 | | Handler_external_lock | 0 | | Handler_icp_attempts | 0 | | Handler_icp_match | 0 | | Handler_mrr_init | 0 | | Handler_mrr_key_refills | 0 | | Handler_mrr_rowid_refills | 0 | | Handler_prepare | 0 | | Handler_read_first | 0 | | Handler_read_key | 104 | | Handler_read_last | 0 | | Handler_read_next | 102 | | Handler_read_prev | 0 | | Handler_read_rnd | 0 | | Handler_read_rnd_deleted | 0 | | Handler_read_rnd_next | 0 | | Handler_rollback | 0 | | Handler_savepoint | 0 | | Handler_savepoint_rollback | 0 | | Handler_tmp_update | 0 | | Handler_tmp_write | 0 | | Handler_update | 0 | | Handler_write | 0 | +----------------------------+-------+ 25 rows in set (0.00 sec)
TASK DETAIL
EMAIL PREFERENCES
To: hoo, jcrespo
Cc: Aklapper, Addshore, Marostegui, jcrespo, aude, daniel, hoo, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
Cc: Aklapper, Addshore, Marostegui, jcrespo, aude, daniel, hoo, Minhnv-2809, D3r1ck01, Izno, Luke081515, Wikidata-bugs, Mbch331, Jay8g, Krenair
_______________________________________________ Wikidata-bugs mailing list Wikidata-bugs@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
