search

Nagarei / isucon11q-check

MIT License
0 stars 0 forks source link

スコア記録 #1

Open Nagarei opened 3 years ago

Nagarei commented 3 years ago

初期状態

+-------+--------+------------------------------+-------+-------+---------+-------+-------+
| COUNT | METHOD |             URI              |  MIN  |  MAX  |   SUM   |  AVG  |  P99  |
+-------+--------+------------------------------+-------+-------+---------+-------+-------+
|   578 | GET    | /api/trend                   | 0.004 | 1.004 | 156.184 | 0.270 | 1.000 |
| 40498 | POST   | /api/condition/[-a-z0-9]+    | 0.000 | 0.156 | 123.440 | 0.003 | 0.004 |
|   363 | GET    | /api/isu                     | 0.004 | 1.004 |  86.928 | 0.239 | 0.600 |
|  1413 | GET    | /api/condition/[-a-z0-9]+    | 0.004 | 0.284 |  84.384 | 0.060 | 0.088 |
|  3018 | GET    | /api/isu/.+/icon             | 0.004 | 0.128 |  34.844 | 0.012 | 0.016 |
|   374 | GET    | /api/isu/.+/graph            | 0.008 | 0.196 |  21.404 | 0.057 | 0.124 |
|   377 | GET    | /api/isu/[-a-z0-9]+          | 0.000 | 0.116 |   2.756 | 0.007 | 0.016 |
|    31 | POST   | /api/isu                     | 0.052 | 0.100 |   2.036 | 0.066 | 0.072 |
|   578 | GET    | /assets/vendor.519e803f.js   | 0.000 | 0.020 |   1.068 | 0.002 | 0.004 |
|   578 | GET    | /assets/index.ee7b4942.css   | 0.000 | 0.016 |   0.976 | 0.002 | 0.000 |
|   578 | GET    | /assets/index.b1cd63b1.js    | 0.000 | 0.020 |   0.964 | 0.002 | 0.000 |
|   578 | GET    | /assets/favicon.d0f5f504.svg | 0.000 | 0.020 |   0.892 | 0.002 | 0.000 |
|   657 | GET    | /                            | 0.000 | 0.016 |   0.716 | 0.001 | 0.000 |
|    79 | POST   | /api/auth                    | 0.004 | 0.048 |   0.704 | 0.009 | 0.004 |
|    79 | GET    | /api/user/me                 | 0.000 | 0.044 |   0.460 | 0.006 | 0.004 |
|    75 | POST   | /api/signout                 | 0.000 | 0.024 |   0.364 | 0.005 | 0.000 |
|     1 | POST   | /initialize                  | 0.192 | 0.192 |   0.192 | 0.192 | 0.192 |
+-------+--------+------------------------------+-------+-------+---------+-------+-------+
  33 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S ORDER BY `timestamp` DESC LIMIT N
  31 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S     AND `timestamp` < S     ORDER BY `timestamp` DESC
  22 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S ORDER BY timestamp DESC
  12 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S ORDER BY `timestamp` ASC
  11 COMMIT
   3 INSERT INTO `isu_condition`        (`jia_isu_uuid`, `timestamp`, `is_sitting`, `condition`, `message`)     VALUES (?, ?, ?, ?, ?)
   2 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S     AND `timestamp` < S     AND S <= `timestamp`    ORDER BY `timestamp` DESC
   1 SELECT COUNT(*) FROM `user` WHERE `jia_user_id` = ?
   1 SELECT name FROM `isu` WHERE `jia_isu_uuid` = ? AND `jia_user_id` = ?
   1 SELECT COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = S
   1 SELECT COUNT(*) FROM `isu` WHERE `jia_isu_uuid` = ?
20:59:20.558238 LOAD WAIT
20:59:20.558389 --- userAdder END
20:59:20.567980 TIME:
condition: 954, repair: 296, graph: 488
20:59:20.585226 <=== LOAD END
20:59:20.585287 SCORE: 00.StartBenchmark       : 1
20:59:20.585297 SCORE: 01.GraphExcellent       : 0
20:59:20.585303 SCORE: 02.GraphGood            : 0
20:59:20.585310 SCORE: 03.GraphNormal          : 0
20:59:20.585316 SCORE: 04.GraphBad             : 0
20:59:20.585322 SCORE: 05.GraphWorst           : 257
20:59:20.585328 SCORE: 06.TodayGraphExcellent  : 0
20:59:20.585335 SCORE: 07.TodayGraphGood       : 0
20:59:20.585341 SCORE: 08.TodayGraphNormal     : 0
20:59:20.585345 SCORE: 09.TodayGraphBad        : 0
20:59:20.585357 SCORE: 10.TodayGraphWorst      : 114
20:59:20.585368 SCORE: 11.ReadInfoCondition    : 121
20:59:20.585375 SCORE: 12.ReadWarningCondition : 233
20:59:20.585382 SCORE: 13.ReadCriticalCondition: 81
20:59:20.585395 SCORE: _1.IsuInitialize        : 31
20:59:20.585402 SCORE: _2.NormalUserInitialize : 4
20:59:20.585414 SCORE: _3.ViewerInitialize     : 12
20:59:20.585420 SCORE: _4.ViewerDropout        : 12
20:59:20.585427 SCORE: _5.RepairIsu            : 80
20:59:20.585431 SCORE: _6.PostInfoCondition    : 2023
20:59:20.585442 SCORE: _7.PostWarningCondition : 3725
20:59:20.585448 SCORE: _8.PostCriticalCondition: 2336
20:59:20.585678 score: 14335(14336 - 1) : pass
20:59:20.585684 deduction: 0 / timeout: 15
20:59:20.585694 <=== sendResult finish
Nagarei commented 3 years ago

index dstatで5~9のidle

| COUNT | METHOD |             URI              |  MIN  |  MAX  |   SUM   |  AVG  |  P99  |
+-------+--------+------------------------------+-------+-------+---------+-------+-------+
| 85073 | POST   | /api/condition/[-a-z0-9]+    | 0.008 | 0.216 | 480.042 | 0.006 | 0.016 |
|  1459 | GET    | /api/trend                   | 0.016 | 1.004 | 440.009 | 0.302 | 1.000 |
| 10765 | GET    | /api/isu/.+/icon             | 0.004 | 0.184 | 208.196 | 0.019 | 0.028 |
|  4335 | GET    | /api/condition/[-a-z0-9]+    | 0.004 | 0.424 | 182.037 | 0.042 | 0.036 |
|  1351 | GET    | /api/isu                     | 0.004 | 1.004 | 135.531 | 0.100 | 0.060 |
|  1088 | GET    | /api/isu/.+/graph            | 0.004 | 0.208 |  45.512 | 0.042 | 0.092 |
|  1386 | GET    | /api/isu/[-a-z0-9]+          | 0.004 | 0.132 |  19.993 | 0.014 | 0.084 |
|    66 | POST   | /api/isu                     | 0.052 | 0.144 |   4.952 | 0.075 | 0.080 |
|   247 | POST   | /api/auth                    | 0.000 | 0.240 |   2.940 | 0.012 | 0.004 |
|  1459 | GET    | /assets/vendor.519e803f.js   | 0.012 | 0.024 |   2.916 | 0.002 | 0.000 |
|  1459 | GET    | /assets/index.b1cd63b1.js    | 0.004 | 0.024 |   2.692 | 0.002 | 0.000 |
|  1459 | GET    | /assets/favicon.d0f5f504.svg | 0.004 | 0.032 |   2.528 | 0.002 | 0.000 |
|  1459 | GET    | /assets/index.ee7b4942.css   | 0.004 | 0.024 |   2.464 | 0.002 | 0.000 |
|   247 | GET    | /api/user/me                 | 0.004 | 0.060 |   2.412 | 0.010 | 0.032 |
|  1706 | GET    | /                            | 0.004 | 0.040 |   2.384 | 0.001 | 0.004 |
|   238 | POST   | /api/signout                 | 0.004 | 0.188 |   2.288 | 0.010 | 0.028 |
|     2 | POST   | /initialize                  | 0.080 | 0.156 |   0.236 | 0.118 | 0.080 |
+-------+--------+------------------------------+-------+-------+---------+-------+-------+
##  2021-08-15 21:24:40.43 +0900
  70 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S ORDER BY timestamp DESC
  23 COMMIT
  10 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S     AND `timestamp` < S     ORDER BY `timestamp` DESC
  10 INSERT INTO `isu_condition`        (`jia_isu_uuid`, `timestamp`, `is_sitting`, `condition`, `message`)  VALUES (?, ?, ?, ?, ?)
   5 SELECT * FROM `isu` WHERE `character` = ?
   2 SELECT COUNT(*) FROM `user` WHERE `jia_user_id` = ?
   2 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? ORDER BY timestamp DESC
   2 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S ORDER BY `timestamp` ASC
   1 SELECT COUNT(*) FROM `user` WHERE `jia_user_id` = S
   1 SELECT `image` FROM `isu` WHERE `jia_user_id` = S AND `jia_isu_uuid` = S
   1 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = S     AND `timestamp` < S     AND S <= `timestamp` ORDER BY `timestamp` DESC
   1 SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = ? ORDER BY `timestamp` DESC LIMIT N
   1 SELECT `image` FROM `isu` WHERE `jia_user_id` = ? AND `jia_isu_uuid` = ?
   1 SELECT * FROM `isu` WHERE `character` = S
21:24:47.381639 TIME:
condition: 378, repair: 151, graph: 223
21:24:47.394000 <=== LOAD END
21:24:47.394084 SCORE: 00.StartBenchmark       : 1
21:24:47.394094 SCORE: 01.GraphExcellent       : 0
21:24:47.394100 SCORE: 02.GraphGood            : 0
21:24:47.394106 SCORE: 03.GraphNormal          : 0
21:24:47.394113 SCORE: 04.GraphBad             : 0
21:24:47.394120 SCORE: 05.GraphWorst           : 336
21:24:47.394126 SCORE: 06.TodayGraphExcellent  : 0
21:24:47.394139 SCORE: 07.TodayGraphGood       : 0
21:24:47.394143 SCORE: 08.TodayGraphNormal     : 0
21:24:47.394150 SCORE: 09.TodayGraphBad        : 0
21:24:47.394156 SCORE: 10.TodayGraphWorst      : 320
21:24:47.394162 SCORE: 11.ReadInfoCondition    : 370
21:24:47.394168 SCORE: 12.ReadWarningCondition : 372
21:24:47.394174 SCORE: 13.ReadCriticalCondition: 40
21:24:47.394186 SCORE: _1.IsuInitialize        : 35
21:24:47.394192 SCORE: _2.NormalUserInitialize : 5
21:24:47.394198 SCORE: _3.ViewerInitialize     : 15
21:24:47.394204 SCORE: _4.ViewerDropout        : 15
21:24:47.394215 SCORE: _5.RepairIsu            : 228
21:24:47.394228 SCORE: _6.PostInfoCondition    : 4182
21:24:47.394232 SCORE: _7.PostWarningCondition : 4180
21:24:47.394243 SCORE: _8.PostCriticalCondition: 483
21:24:47.394474 score: 28279(28280 - 1) : pass
21:24:47.394481 deduction: 0 / timeout: 15
21:24:47.394490 <=== sendResult finish
Nagarei commented 3 years ago

この時点で既に負荷が浮く形になるので、マニュアルを読まないといけない