https://bugzilla.wikimedia.org/show_bug.cgi?id=30740
Reedy <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Reedy <[email protected]> 2011-09-27 22:49:33 UTC --- Which wikis? Testing against enwiki would suggest < 20k have showjumplinks disabled (ie an entry exists)... So it's going to be less than that actually run with some figures. Skin suggest 3668520 people have different skins set (or not default/vector) mysql> explain SELECT count(*) FROM user_properties INNER JOIN user ON up_user=user_id WHERE up_property = 'showjumplinks' AND user_touched > 20110000000000 +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+-------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+-------+-------------+ | 1 | SIMPLE | user_properties | ref | user_properties_user_property,user_properties_property | user_properties_property | 258 | const | 19988 | Using where | | 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | enwiki.user_properties.up_user | 1 | Using where | +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+-------+-------------+ 2 rows in set (0.00 sec) mysql> explain SELECT count(*) FROM user_properties INNER JOIN user ON up_user=user_id WHERE up_property = 'skin' AND up_value IN ( 'standard', 'nostalgia', 'cologneblue' ) AND user_touched > 20110000000000 +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+---------+-------------+ | 1 | SIMPLE | user_properties | ref | user_properties_user_property,user_properties_property | user_properties_property | 258 | const | 3668520 | Using where | | 1 | SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | enwiki.user_properties.up_user | 1 | Using where | +----+-------------+-----------------+--------+--------------------------------------------------------+--------------------------+---------+--------------------------------+---------+-------------+ 2 rows in set (0.00 sec) -- 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
