Slow query log from Friday morning to present:
http://www.wikipedia.org/tools/slowquerylog.gz
I notice more slow queries than you'd expect on user_newtalk. It's a
bone-simple query, fully indexed:
EXPLAIN SELECT 1 FROM user_newtalk WHERE user_ip='some_ip_address';
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
| user_newtalk | ref | user_ip | user_ip | 40 | const | 1 | where used;
Using index |
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
or:
EXPLAIN SELECT 1 FROM user_newtalk WHERE user_id=some_user_id_number;
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
| table | type | possible_keys | key | key_len | ref | rows | Extra
|
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
| user_newtalk | ref | user_id | user_id | 4 | const | 1 | where used;
Using index |
+--------------+------+---------------+---------+---------+-------+------+-------------------------+
One of these two queries happens on *every* page view; the table itself
is quite small (a few dozen rows generally), and 99% of the time queries
will turn up no rows. It's only altered when a user talk page is
changed, or viewed by its owner.
CREATE TABLE `user_newtalk` (
`user_id` int(5) NOT NULL default '0',
`user_ip` varchar(40) NOT NULL default '',
KEY `user_ip` (`user_ip`),
KEY `user_id` (`user_id`)
) TYPE=MyISAM
I'm assuming that the sometime slowness here is a side effect of other
things being slow somehow.
-- brion vibber (brion @
pobox.com)