My analysis:
Query is:
UPDATE users SET last_login_date=NOW()
WHERE id = N;
Schema is:
CREATE TABLE users (
id INT NOT NULL PRIMARY KEY auto_increment,
username CHAR(32) NOT NULL,
..
last_login_date DATETIME,
UNIQUE (username)
) ENGINE=MyISAM;
www.percona.com
21
