On May 11, 2008, at 4:53 PM, Aaron Schulz wrote:
Mean to send this directly to brion, ah well ;D
oh, and by the way, just you wouldn't say it was "just one query slipped". The '\n' string at tags looks buggy too :)
mysql> explain -> SELECT /* FlaggedRevs::getStablePageRev ... */ fr_rev_id,fr_page_id,fr_user,fr_timestamp,fr_comment,fr_quality,fr_tags, fr_text,fr_flags FROM `flaggedpages`,`flaggedrevs` WHERE fp_page_id = '2327944' AND (fp_stable = fr_rev_id) LIMIT 1 -> ; +--------------+-------+---------------+---------+---------+------- +--------+-------------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +--------------+-------+---------------+---------+---------+------- +--------+-------------+ | flaggedpages | const | PRIMARY | PRIMARY | 4 | const | 1 | | | flaggedrevs | ALL | NULL | NULL | NULL | NULL | 131893 | Using where | +--------------+-------+---------------+---------+---------+------- +--------+-------------+ 2 rows in set (0.01 sec)
mysql> SELECT /* FlaggedRevs::getStablePageRev 89.15.146.145 */ fr_rev_id,fr_page_id,fr_user,fr_timestamp,fr_comment,fr_quality,fr_tags, fr_text,fr_flags FROM `flaggedpages`,`flaggedrevs` WHERE fp_page_id = '2327944' AND (fp_stable = fr_rev_id) LIMIT 1 -> ; +-----------+------------+---------+----------------+------------ +------------+--------------+------------------------ +---------------------+ | fr_rev_id | fr_page_id | fr_user | fr_timestamp | fr_comment | fr_quality | fr_tags | fr_text | fr_flags | +-----------+------------+---------+----------------+------------ +------------+--------------+------------------------ +---------------------+ | 45783237 | 2327944 | 32049 | 20080508112117 | | 0 | accuracy:1\n | DB://cluster14/2911910 | utf-8,gzip,external | +-----------+------------+---------+----------------+------------ +------------+--------------+------------------------ +---------------------+ 1 row in set (0.71 sec)