{"action":"created","issue":{"url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/5","labels_url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/5/labels{/name}","comments_url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/5/comments","events_url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/5/events","html_url":"https://github.com/tjinjin/isucon-practice/pull/5","id":111967570,"number":5,"title":"isuon5予選問題で10kを取るまでのお話","user":{"login":"tjinjin","id":10205123,"avatar_url":"https://avatars.githubusercontent.com/u/10205123?v=3","gravatar_id":"","url":"https://api.github.com/users/tjinjin","html_url":"https://github.com/tjinjin","followers_url":"https://api.github.com/users/tjinjin/followers","following_url":"https://api.github.com/users/tjinjin/following{/other_user}","gists_url":"https://api.github.com/users/tjinjin/gists{/gist_id}","starred_url":"https://api.github.com/users/tjinjin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjinjin/subscriptions","organizations_url":"https://api.github.com/users/tjinjin/orgs","repos_url":"https://api.github.com/users/tjinjin/repos","events_url":"https://api.github.com/users/tjinjin/events{/privacy}","received_events_url":"https://api.github.com/users/tjinjin/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":24,"created_at":"2015-10-17T15:15:09Z","updated_at":"2015-10-18T17:08:12Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/tjinjin/isucon-practice/pulls/5","html_url":"https://github.com/tjinjin/isucon-practice/pull/5","diff_url":"https://github.com/tjinjin/isucon-practice/pull/5.diff","patch_url":"https://github.com/tjinjin/isucon-practice/pull/5.patch"},"body":"何かを実施したら随時ここに書き込み。スコアが後で追える用に。可能なかぎりrecipeにする"},"comment":{"url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/comments/149030963","html_url":"https://github.com/tjinjin/isucon-practice/pull/5#issuecomment-149030963","issue_url":"https://api.github.com/repos/tjinjin/isucon-practice/issues/5","id":149030963,"user":{"login":"tjinjin","id":10205123,"avatar_url":"https://avatars.githubusercontent.com/u/10205123?v=3","gravatar_id":"","url":"https://api.github.com/users/tjinjin","html_url":"https://github.com/tjinjin","followers_url":"https://api.github.com/users/tjinjin/followers","following_url":"https://api.github.com/users/tjinjin/following{/other_user}","gists_url":"https://api.github.com/users/tjinjin/gists{/gist_id}","starred_url":"https://api.github.com/users/tjinjin/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tjinjin/subscriptions","organizations_url":"https://api.github.com/users/tjinjin/orgs","repos_url":"https://api.github.com/users/tjinjin/repos","events_url":"https://api.github.com/users/tjinjin/events{/privacy}","received_events_url":"https://api.github.com/users/tjinjin/received_events","type":"User","site_admin":false},"created_at":"2015-10-18T17:08:12Z","updated_at":"2015-10-18T17:08:12Z","body":"ローカルベンチだとおかしくなる症状。直接原因はこれ？\r\n\r\nリモートベンチ\r\n```\r\nmysql> select * from footprints order by created_at desc limit 10;\r\n+--------+---------+----------+---------------------+\r\n| id     | user_id | owner_id | created_at          |\r\n+--------+---------+----------+---------------------+\r\n| 503927 |     364 |      720 | 2015-10-19 02:05:11 |\r\n| 503920 |     720 |     4546 | 2015-10-19 02:05:10 |\r\n| 503922 |    2646 |      747 | 2015-10-19 02:05:10 |\r\n| 503918 |     747 |     4164 | 2015-10-19 02:05:10 |\r\n| 503926 |    3992 |      747 | 2015-10-19 02:05:10 |\r\n| 503919 |    2646 |      747 | 2015-10-19 02:05:10 |\r\n| 503923 |    3687 |     1004 | 2015-10-19 02:05:10 |\r\n| 503921 |    3687 |     1004 | 2015-10-19 02:05:10 |\r\n| 503925 |    2646 |      747 | 2015-10-19 02:05:10 |\r\n| 503924 |    3687 |     1004 | 2015-10-19 02:05:10 |\r\n+--------+---------+----------+---------------------+\r\n\r\n```\r\n\r\nローカルベンチ\r\n\r\n```\r\nmysql> select * from footprints order by created_at desc limit 10;\r\n+--------+---------+----------+---------------------+\r\n| id     | user_id | owner_id | created_at          |\r\n+--------+---------+----------+---------------------+\r\n| 503931 |    3331 |     3878 | 2015-10-19 02:05:36 |\r\n| 503930 |    3331 |     4999 | 2015-10-19 02:05:35 |\r\n| 503928 |    3331 |     4999 | 2015-10-19 02:05:33 |\r\n| 503929 |    3331 |     3878 | 2015-10-19 02:05:33 |\r\n| 500000 |    3829 |     3411 | 2015-08-12 20:40:00 |\r\n| 499999 |    1919 |     4092 | 2015-08-12 20:38:00 |\r\n| 499998 |      71 |     1142 | 2015-08-12 20:36:00 |\r\n| 499997 |    3873 |     2147 | 2015-08-12 20:34:00 |\r\n| 499996 |    2166 |      680 | 2015-08-12 20:32:00 |\r\n| 499995 |     884 |     4396 | 2015-08-12 20:30:00 |\r\n+--------+---------+----------+---------------------+\r\n```\r\n\r\nこの歯抜けはなんだ…"}}