https://bugzilla.wikimedia.org/show_bug.cgi?id=36983
--- Comment #1 from Sam Reed (reedy) <[email protected]> 2012-05-21 01:41:45 UTC --- Locally: Total number of results: 1,628 mysql> explain select count(*) from mw_code_paths +----+-------------+---------------+-------+---------------+-----------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+-------+---------------+-----------+---------+------+---------+-------------+ | 1 | SIMPLE | mw_code_paths | index | NULL | repo_path | 261 | NULL | 1588190 | Using index | +----+-------------+---------------+-------+---------------+-----------+---------+------+---------+-------------+ 1 row in set (0.02 sec) mysql> select count(*) from mw_code_paths +----------+ | count(*) | +----------+ | 1463769 | +----------+ 1 row in set (10.46 sec) mysql> explain select count(*) from mw_code_paths where cp_repo_id = 1 AND cp_path = '/trunk/extensions/AbuseFilter'; +----+-------------+---------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ | 1 | SIMPLE | mw_code_paths | ref | PRIMARY,repo_path | repo_path | 261 | const,const | 1627 | Using where; Using index | +----+-------------+---------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ 1 row in set (0.03 sec) mysql> select count(*) from mw_code_paths where cp_repo_id = 1 AND cp_path = '/trunk/extensions/AbuseFilter'; +----------+ | count(*) | +----------+ | 1628 | +----------+ 1 row in set (0.01 sec) MW.org: Total number of results: 1,134 mysql> explain select count(*) from code_paths; +----+-------------+------------+-------+---------------+-----------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+-------+---------------+-----------+---------+------+---------+-------------+ | 1 | SIMPLE | code_paths | index | NULL | repo_path | 261 | NULL | 1677673 | Using index | +----+-------------+------------+-------+---------------+-----------+---------+------+---------+-------------+ 1 row in set (0.00 sec) mysql> select count(*) from code_paths; +----------+ | count(*) | +----------+ | 1576529 | +----------+ 1 row in set (4.02 sec) mysql> explain select count(*) from code_paths where cp_repo_id = 1 AND cp_path = '/trunk/extensions/AbuseFilter'; +----+-------------+------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ | 1 | SIMPLE | code_paths | ref | PRIMARY,repo_path | repo_path | 261 | const,const | 2498 | Using where; Using index | +----+-------------+------------+------+-------------------+-----------+---------+-------------+------+--------------------------+ 1 row in set (0.00 sec) mysql> select count(*) from code_paths where cp_repo_id = 1 AND cp_path = '/trunk/extensions/AbuseFilter'; +----------+ | count(*) | +----------+ | 1628 | +----------+ 1 row in set (0.00 sec) Difference is 494.. Set of database rows (for AF at least!) is the same on the 2 copies. The count being what should be found. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
