mysqldumpslow
Count: 23197 Time=0.00s (6s) Lock=0.00s (3s) Rows=0.0 (0), root[root]@localhost
INSERT INTO login_log (`created_at`, `user_id`, `login`, `ip`, `succeeded`) VALUES ('S',N,'S','S',N)
Count: 94454 Time=0.00s (4s) Lock=0.00s (0s) Rows=0.3 (27270), 2users@localhost
#
Count: 8474 Time=0.00s (3s) Lock=0.00s (0s) Rows=1.0 (8474), root[root]@localhost
SELECT COUNT(N) AS failures FROM login_log WHERE user_id = N AND id > IFNULL((select id from login_log where user_id = N AND succeeded = N ORDER BY id DESC LIMIT N), N)
Count: 1 Time=2.62s (2s) Lock=0.89s (0s) Rows=0.0 (0), root[root]@localhost
INSERT INTO `users` (`id`, `login`, `password_hash`, `salt`) VALUES
(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
,(N, 'S', SHA2('S', N), 'S')
....
Count: 1 Time=0.20s (0s) Lock=0.00s (0s) Rows=254.0 (254), root[root]@localhost
select id, ip from (select * from login_log where succeeded = N order by id DESC) A group by ip
Count: 1 Time=0.20s (0s) Lock=0.00s (0s) Rows=254.0 (254), root[root]@localhost
select id, user_id from (select * from login_log where succeeded = N order by id DESC) A group by ip
Count: 1 Time=0.17s (0s) Lock=0.00s (0s) Rows=518.0 (518), root[root]@localhost
SELECT ip FROM (SELECT ip, MAX(succeeded) as max_succeeded, COUNT(N) as cnt FROM login_log GROUP BY ip) AS t0 WHERE t0.max_succeeded = N AND t0.cnt >= N
Count: 3033 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (3033), root[root]@localhost
SELECT @@max_allowed_packet
Count: 1 Time=0.14s (0s) Lock=0.00s (0s) Rows=2448.0 (2448), root[root]@localhost
SELECT user_id, login FROM (SELECT user_id, login, MAX(succeeded) as max_succeeded, COUNT(N) as cnt FROM login_log GROUP BY user_id) AS t0 WHERE t0.user_id IS NOT NULL AND t0.max_succeeded = N AND t0.cnt >= N
Count: 1 Time=0.13s (0s) Lock=0.00s (0s) Rows=6231.0 (6231), root[root]@localhost
SELECT user_id, login, MAX(id) AS last_login_id FROM login_log WHERE user_id IS NOT NULL AND succeeded = N GROUP BY user_id
Count: 1 Time=0.04s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
CREATE TABLE IF NOT EXISTS `users` (
`id` int NOT NULL AUTO_INCREMENT PRIMARY KEY,
`login` varchar(N) NOT NULL UNIQUE,
`password_hash` varchar(N) NOT NULL,
`salt` varchar(N) NOT NULL
) DEFAULT CHARSET=utf8
Count: 254 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (254), root[root]@localhost
SELECT COUNT(N) AS failures FROM login_log WHERE id > N AND succeeded = N AND ip = 'S'
Count: 1 Time=0.03s (0s) Lock=0.00s (0s) Rows=886.0 (886), root[root]@localhost
SELECT ip, MAX(id) AS last_login_id FROM login_log WHERE succeeded = N GROUP by ip
Count: 1 Time=0.01s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
CREATE TABLE IF NOT EXISTS `login_log` (
`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY,
`created_at` datetime NOT NULL,
`user_id` int,
`login` varchar(N) NOT NULL,
`ip` varchar(N) NOT NULL,
`succeeded` tinyint NOT NULL
) DEFAULT CHARSET=utf8
Count: 9 Time=0.00s (0s) Lock=0.00s (0s) Rows=1.0 (9), root[root]@localhost
select @@version_comment limit N
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
CREATE DATABASE isu4_qualifier
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), root[root]@localhost
show processlist
Count: 1 Time=0.00s (0s) Lock=0.07s (0s) Rows=0.0 (0), root[root]@localhost
DROP DATABASE IF EXISTS isu4_qualifier
Count: 1 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), 0users@0hosts
administrator command: Ping
Count: 32866 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), 0users@0hosts
administrator command: Close stmt
Count: 32866 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), 0users@0hosts
administrator command: Prepare
Count: 2496 Time=0.00s (0s) Lock=0.00s (0s) Rows=0.0 (0), 0users@0hosts
administrator command: Quit
nginx
146.29799999998488 28160 0.00519524147727219 /
89.1240000000021 15533 0.0057377196935557906 /login
58.49099999999389 31064 0.0018829191346894762 /stylesheets/bootstrap.min.css
52.02499999999513 31064 0.0016747682204479503 /stylesheets/bootflat.min.css
49.950999999996355 31064 0.0016080028328610725 /images/isucon-bank.png
48.0749999999968 31064 0.0015476113829512232 /stylesheets/isucon-bank.css
20.87700000000012 2905 0.007186574870912262 /mypage
2.298 1 2.298 /report
0.959 1 0.959 /init
0.0 1 0.0