okashoi commented 3 weeks ago

ISUCON11 予選 member: @okashoi, @mism-mism

special thanks: https://github.com/matsuu/aws-isucon/tree/main/isucon11-qualify

documents

サーバ構成

i-05f29a4be885b8b71     18.183.180.69   isucon11-app1
i-03edc9216bd3249a1     3.112.226.240   isucon11-app2
i-0c7413f1f81a78215     54.199.18.216   isucon11-app3
i-03f747689a76b693d     54.64.1.82      isucon11-bench

メモ

ベンチコマンド

./bench -all-addresses 172.31.34.129,172.31.33.98 -target 172.31.34.129:443 -tls -jia-service-url http://172.31.36.139:4999

mism-mism commented 3 weeks ago

インフラ構成

スペック

OS: "Ubuntu 20.04.4 LTS"
vCPU: 2

メモリ

              total        used        free      shared  buff/cache   available
Mem:          3.6Gi       233Mi       1.2Gi       0.0Ki       2.2Gi       3.1Gi
Swap:            0B          0B          0B

ミドルウェア

MySQL: mysqld Ver 10.3.34-MariaDB-0ubuntu0.20.04.1-log for debian-linux-gnu on x86_64 (Ubuntu 20.04)
Nginx: nginx version: nginx/1.18.0 (Ubuntu)
Go: go version go1.16.5 linux/amd64

開いているポート

COMMAND  PID     USER   FD   TYPE DEVICE SIZE/OFF NODE NAME
nginx    510     root    6u  IPv4  21013      0t0  TCP *:https (LISTEN)
nginx    511 www-data    6u  IPv4  21013      0t0  TCP *:https (LISTEN)
nginx    512 www-data    6u  IPv4  21013      0t0  TCP *:https (LISTEN)
mysqld  2258    mysql   22u  IPv4 282528      0t0  TCP localhost:mysql (LISTEN)

起動中のサービス

  UNIT                                 LOAD   ACTIVE SUB     DESCRIPTION
  accounts-daemon.service              loaded active running Accounts Service
  acpid.service                        loaded active running ACPI event daemon
  apparmor.service                     loaded active exited  Load AppArmor profiles
  apport.service                       loaded active exited  LSB: automatic crash report generation
  atd.service                          loaded active running Deferred execution scheduler
  blk-availability.service             loaded active exited  Availability of block devices
  cloud-config.service                 loaded active exited  Apply the settings specified in cloud-config
  cloud-final.service                  loaded active exited  Execute cloud user/final scripts
  cloud-init-local.service             loaded active exited  Initial cloud-init job (pre-networking)
  cloud-init.service                   loaded active exited  Initial cloud-init job (metadata service crawler)
  console-setup.service                loaded active exited  Set console font and keymap
  cron.service                         loaded active running Regular background program processing daemon
  dbus.service                         loaded active running D-Bus System Message Bus
  finalrd.service                      loaded active exited  Create final runtime dir for shutdown pivot root
  getty@tty1.service                   loaded active running Getty on tty1
  irqbalance.service                   loaded active running irqbalance daemon
  isucondition.go.service              loaded active running isucondition.go
  jiaapi-mock.service                  loaded active running jiaapi-mock
  keyboard-setup.service               loaded active exited  Set the console keyboard layout
  kmod-static-nodes.service            loaded active exited  Create list of static device nodes for the current kernel
  lvm2-monitor.service                 loaded active exited  Monitoring of LVM2 mirrors, snapshots etc. using dmeventd or progress polling
  mariadb.service                      loaded active running MariaDB 10.3.34 database server
  ModemManager.service                 loaded active running Modem Manager
  multipathd.service                   loaded active running Device-Mapper Multipath Device Controller
  networkd-dispatcher.service          loaded active running Dispatcher daemon for systemd-networkd
  nginx.service                        loaded active running A high performance web server and a reverse proxy server
  polkit.service                       loaded active running Authorization Manager
  rsyslog.service                      loaded active running System Logging Service
  serial-getty@ttyS0.service           loaded active running Serial Getty on ttyS0
  setvtrgb.service                     loaded active exited  Set console scheme
  ssh.service                          loaded active running OpenBSD Secure Shell server
  systemd-fsck-root.service            loaded active exited  File System Check on Root Device
  systemd-journal-flush.service        loaded active exited  Flush Journal to Persistent Storage
  systemd-journald.service             loaded active running Journal Service
  systemd-logind.service               loaded active running Login Service
  systemd-modules-load.service         loaded active exited  Load Kernel Modules
  systemd-networkd-wait-online.service loaded active exited  Wait for Network to be Configured
  systemd-networkd.service             loaded active running Network Service
  systemd-random-seed.service          loaded active exited  Load/Save Random Seed
  systemd-remount-fs.service           loaded active exited  Remount Root and Kernel File Systems
  systemd-resolved.service             loaded active running Network Name Resolution
  systemd-sysctl.service               loaded active exited  Apply Kernel Variables
  systemd-sysusers.service             loaded active exited  Create System Users
  systemd-timesyncd.service            loaded active running Network Time Synchronization
  systemd-tmpfiles-setup-dev.service   loaded active exited  Create Static Device Nodes in /dev
  systemd-tmpfiles-setup.service       loaded active exited  Create Volatile Files and Directories
  systemd-udev-settle.service          loaded active exited  udev Wait for Complete Device Initialization
  systemd-udev-trigger.service         loaded active exited  udev Coldplug all Devices
  systemd-udevd.service                loaded active running udev Kernel Device Manager
  systemd-update-utmp.service          loaded active exited  Update UTMP about System Boot/Shutdown
  systemd-user-sessions.service        loaded active exited  Permit User Sessions
  udisks2.service                      loaded active running Disk Manager
  ufw.service                          loaded active exited  Uncomplicated firewall
  unattended-upgrades.service          loaded active running Unattended Upgrades Shutdown
  user-runtime-dir@1000.service        loaded active exited  User Runtime Directory /run/user/1000
  user-runtime-dir@1100.service        loaded active exited  User Runtime Directory /run/user/1100
  user@1000.service                    loaded active running User Manager for UID 1000
  user@1100.service                    loaded active running User Manager for UID 1100

LOAD   = Reflects whether the unit definition was properly loaded.
ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
SUB    = The low-level unit activation state, values depend on unit type.

58 loaded units listed.
To show all installed unit files use 'systemctl list-unit-files'.

PATH (バックアップ)

/home/isucon/.cargo/bin:/home/isucon/.cargo/bin:/home/isucon/local/ruby/bin:/home/isucon/local/python/bin:/home/isucon/local/php/bin:/home/isucon/local/perl/bin:/home/isucon/local/node/bin:/home/isucon/local/go/bin:/home/isucon/go/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/snap/bin

mism-mism commented 3 weeks ago

レコード数

table_name	table_rows	total_storage_mb	avg_storage_b	total_data_mb
isu_condition	66123	12	198	12
isu	72	3	51427	3
user	13	0	1260	0
isu_association_config	0	0	null	0

mism-mism commented 3 weeks ago

classDiagram
direction BT
class isu {
   bigint(20) id
   char(36) jia_isu_uuid
   varchar(255) name
   longblob image
   varchar(255) character
   varchar(255) jia_user_id
   datetime(6) created_at
   datetime(6) updated_at
}
class isu_association_config {
   varchar(255) name
   varchar(255) url
}
class isu_condition {
   bigint(20) id
   char(36) jia_isu_uuid
   datetime timestamp
   tinyint(1) is_sitting
   varchar(255) condition
   varchar(255) message
   datetime(6) created_at
}
class user {
   varchar(255) jia_user_id
   datetime(6) created_at
}

okashoi commented 3 weeks ago

諸々セットアップした状態でのベンチ結果

11:52:36.400747 score: 1503(1538 - 35) : pass

kataribe

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx   4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
70218  647.167  0.0092  0.0269  0.000  0.001  0.013  0.100  0.101  0.247  65205    0  5013    0          84          0          0         14  POST /api/condition/[\w-]+
  351  268.069  0.7637  0.3936  0.000  1.000  1.001  1.001  1.001  3.000    106    0   245    0      268951          0        766       4645  GET /api/isu
  933  138.669  0.1486  0.2354  0.000  0.066  0.391  0.505  1.000  3.011    821    0   112    0    15390135          0      16495     135259  GET /api/isu/[\w-]+
  295   84.549  0.2866  0.2994  0.000  0.172  0.773  0.916  1.000  1.360    213    0    82    0      963598          0       3266       7123  GET /api/condition/[\w-]+
   48   41.148  0.8572  0.3020  0.021  1.000  1.001  1.001  1.002  1.002      9    0    39    0       42471          0        884       4783  GET /api/trend
   89   13.422  0.1508  0.2042  0.001  0.078  0.330  0.655  1.097  1.097     87    0     2    0     1822699          0      20479     135259  GET /api/isu/[\w-]+/icon
  155   13.356  0.0862  0.2378  0.000  0.009  0.174  0.537  1.001  1.675     61    0    94    0        1012          0          6         19  POST /api/auth
   33    7.499  0.2272  0.2467  0.000  0.154  0.587  0.706  1.000  1.000     21    0    12    0       89976          0       2726       6866  GET /api/isu/[\w-]+/graph
   55    4.070  0.0740  0.0273  0.000  0.076  0.091  0.108  0.171  0.171     51    0     4    0        7045         15        128        148  POST /api/isu
   33    2.619  0.0794  0.2069  0.000  0.002  0.159  0.555  0.997  0.997     20    0    13    0         273          0          8         21  POST /api/signout
   57    1.817  0.0319  0.0809  0.000  0.001  0.127  0.317  0.389  0.389     28    0    29    0        1682         21         29         44  GET /api/user/me
  530    0.833  0.0016  0.0023  0.000  0.001  0.004  0.007  0.011  0.016    305  225     0    0    40608777          0      76620     743417  GET /assets/*
    1    0.214  0.2140  0.0000  0.214  0.214  0.214  0.214  0.214  0.214      1    0     0    0          23         23         23         23  POST /initialize
   63    0.066  0.0010  0.0011  0.000  0.001  0.003  0.003  0.005  0.005     50   13     0    0       26400          0        419        528  GET /
   29    0.035  0.0012  0.0015  0.000  0.001  0.002  0.005  0.007  0.007     29    0     0    0       15312        528        528        528  GET /?jwt=*
   19    0.007  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001     14    5     0    0        7392          0        389        528  GET /isu/[\w-]+
    9    0.002  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      2    7     0    0        1056          0        117        528  GET /isu/[\w-]+/condition
    2    0.001  0.0005  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      2    0     0    0        1056        528        528        528  GET /isu/[\w-]+/graph
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    2     0    0         528          0        176        528  GET /register

slow query

```plaintext Reading from STDIN ... # 120ms user time, 10ms system time, 30.43M rss, 37.38M vsz # Current date: Sat Oct 5 12:07:22 2024 # Hostname: ip-172-31-34-129 # Files: STDIN # Overall: 57 total, 30 unique, 0 QPS, 0x concurrency ____________________ # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= ======= ======= ======= ======= # Exec time 4ms 0 770us 63us 125us 129us 36us # Lock time 2ms 0 103us 30us 89us 34us 0 # Rows sent 27 0 25 0.47 0 3.26 0 # Rows examine 38 0 35 0.67 0 4.59 0 # Rows affecte 25 0 1 0.44 0.99 0.49 0 # Bytes sent 2.22k 0 1.63k 39.81 10.84 217.65 10.84 # Query size 2.50k 27 270 44.82 65.89 32.42 29.47 # Profile # Rank Query ID Response time Calls R/Call V/M I # ==== ================================ ============= ===== ====== ===== = # 1 0xA0B014EF6109CC5B6EFD41F1969... 0.0008 21.2% 1 0.0008 0.00 SELECT information_schema.TABLES # 2 0xE77769C62EF669AA7DD5F6760F2... 0.0006 17.3% 1 0.0006 0.00 SHOW VARIABLES # 3 0xAD2241013767B7FD2DB9FB7816A... 0.0002 5.8% 1 0.0002 0.00 SELECT mysql.user # 4 0xCF687630FB22BAB8B86E2178F4A... 0.0001 3.5% 1 0.0001 0.00 SELECT mysql.time_zone_leap_second # 5 0xCEC637FA6FCA55A41E3FF025002... 0.0001 3.2% 1 0.0001 0.00 SELECT mysql.help_keyword # 6 0x58E62C94D134834E54A2AFD79EE... 0.0001 3.1% 1 0.0001 0.00 SELECT mysql.column_stats # 7 0xB8CA39C07A84A6C75886C8E91DB... 0.0001 2.9% 1 0.0001 0.00 SELECT mysql.proc # 8 0xCB4B6BA217338255240BD39831F... 0.0001 2.8% 1 0.0001 0.00 SELECT mysql.table_stats # 9 0x09F160DEEB00C188D7DC9303A82... 0.0001 2.7% 1 0.0001 0.00 SELECT mysql.time_zone_transition_type # 10 0x430C98932F75479B40FA5250DE9... 0.0001 2.6% 1 0.0001 0.00 SELECT mysql.help_topic # 11 0x3F56802DC9E0039FFAA61F14034... 0.0001 2.6% 1 0.0001 0.00 SELECT mysql.help_category # 12 0x4E5054DB925E80F59091EB4D237... 0.0001 2.5% 1 0.0001 0.00 SELECT mysql.index_stats # 13 0xA9CAB8D84396F4219B867AD2DA7... 0.0001 2.4% 1 0.0001 0.00 SELECT mysql.time_zone_transition # 14 0x883BDEF37DA2388DC56C839C6B2... 0.0001 2.4% 1 0.0001 0.00 SELECT mysql.help_relation # 15 0x934CDDF65D56A94DD3A29FEF06F... 0.0001 2.3% 1 0.0001 0.00 SELECT mysql.time_zone_name # 16 0x3C7895E431BD9E14ABFB4842178... 0.0001 2.3% 1 0.0001 0.00 SELECT mysql.func # 17 0xA20EED88D40EDE9C36C91AE6407... 0.0001 2.3% 1 0.0001 0.00 SELECT mysql.plugin # 18 0x8FDF90C12B453C08149834361F6... 0.0001 2.2% 1 0.0001 0.00 SELECT mysql.time_zone # 19 0xB59FADC050D4DAC961FEFEFBB9B... 0.0001 2.2% 1 0.0001 0.00 SET # 20 0xC0AA9BEC727256417350E56ECC9... 0.0001 1.7% 1 0.0001 0.00 SELECT mysql.procs_priv # MISC 0xMISC 0.0004 11.7% 37 0.0000 0.0 <10 ITEMS> # Query 1: 0 QPS, 0x concurrency, ID 0xA0B014EF6109CC5B6EFD41F196940589 at byte 1495 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 21 770us 770us 770us 770us 770us 0 770us # Lock time 5 103us 103us 103us 103us 103us 0 103us # Rows sent 92 25 25 25 25 25 0 25 # Rows examine 92 35 35 35 35 35 0 35 # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 73 1.63k 1.63k 1.63k 1.63k 1.63k 0 1.63k # Query size 10 270 270 270 270 270 0 270 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `information_schema` LIKE 'TABLES'\G # SHOW CREATE TABLE `information_schema`.`TABLES`\G # EXPLAIN /*!50100 PARTITIONS*/ select concat('select count(*) into @discard from `', TABLE_SCHEMA, '`.`', TABLE_NAME, '`') from information_schema.TABLES where TABLE_SCHEMA<>'INFORMATION_SCHEMA' and TABLE_SCHEMA<>'PERFORMANCE_SCHEMA' and ( ENGINE='MyISAM' or ENGINE='Aria' )\G # Query 2: 0 QPS, 0x concurrency, ID 0xE77769C62EF669AA7DD5F6760F2D2EBB at byte 461 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 17 629us 629us 629us 629us 629us 0 629us # Lock time 3 56us 56us 56us 56us 56us 0 56us # Rows sent 3 1 1 1 1 1 0 1 # Rows examine 2 1 1 1 1 1 0 1 # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 11 252 252 252 252 252 0 252 # Query size 1 29 29 29 29 29 0 29 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ show variables like 'datadir'\G # Query 3: 0 QPS, 0x concurrency, ID 0xAD2241013767B7FD2DB9FB7816AA5A1B at byte 958 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 5 212us 212us 212us 212us 212us 0 212us # Lock time 5 87us 87us 87us 87us 87us 0 87us # Rows sent 3 1 1 1 1 1 0 1 # Rows examine 5 2 2 2 2 2 0 2 # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 2 63 63 63 63 63 0 63 # Query size 3 79 79 79 79 79 0 79 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'user'\G # SHOW CREATE TABLE `mysql`.`user`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT count(*) FROM mysql.user WHERE user='root' and password='' and plugin=''\G # Query 4: 0 QPS, 0x concurrency, ID 0xCF687630FB22BAB8B86E2178F4A42D77 at byte 2229 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 3 127us 127us 127us 127us 127us 0 127us # Lock time 5 101us 101us 101us 101us 101us 0 101us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 66 66 66 66 66 0 66 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'time_zone_leap_second'\G # SHOW CREATE TABLE `mysql`.`time_zone_leap_second`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`time_zone_leap_second`\G # Query 5: 0 QPS, 0x concurrency, ID 0xCEC637FA6FCA55A41E3FF025002EC3E9 at byte 3270 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 3 117us 117us 117us 117us 117us 0 117us # Lock time 5 94us 94us 94us 94us 94us 0 94us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 57 57 57 57 57 0 57 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'help_keyword'\G # SHOW CREATE TABLE `mysql`.`help_keyword`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`help_keyword`\G # Query 6: 0 QPS, 0x concurrency, ID 0x58E62C94D134834E54A2AFD79EE9D9DA at byte 3787 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 3 114us 114us 114us 114us 114us 0 114us # Lock time 5 91us 91us 91us 91us 91us 0 91us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 57 57 57 57 57 0 57 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'column_stats'\G # SHOW CREATE TABLE `mysql`.`column_stats`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`column_stats`\G # Query 7: 0 QPS, 0x concurrency, ID 0xB8CA39C07A84A6C75886C8E91DB96E0C at byte 11015 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 106us 106us 106us 106us 106us 0 106us # Lock time 5 90us 90us 90us 90us 90us 0 90us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 1 49 49 49 49 49 0 49 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'proc'\G # SHOW CREATE TABLE `mysql`.`proc`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`proc`\G # Query 8: 0 QPS, 0x concurrency, ID 0xCB4B6BA217338255240BD39831FAE642 at byte 6867 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 100us 100us 100us 100us 100us 0 100us # Lock time 4 82us 82us 82us 82us 82us 0 82us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 56 56 56 56 56 0 56 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'table_stats'\G # SHOW CREATE TABLE `mysql`.`table_stats`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`table_stats`\G # Query 9: 0 QPS, 0x concurrency, ID 0x09F160DEEB00C188D7DC9303A82AE691 at byte 8410 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 99us 99us 99us 99us 99us 0 99us # Lock time 4 80us 80us 80us 80us 80us 0 80us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 70 70 70 70 70 0 70 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us # 100us ################################################################ # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'time_zone_transition_type'\G # SHOW CREATE TABLE `mysql`.`time_zone_transition_type`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`time_zone_transition_type`\G # Query 10: 0 QPS, 0x concurrency, ID 0x430C98932F75479B40FA5250DE9C0EE4 at byte 7383 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 96us 96us 96us 96us 96us 0 96us # Lock time 4 80us 80us 80us 80us 80us 0 80us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 55 55 55 55 55 0 55 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'help_topic'\G # SHOW CREATE TABLE `mysql`.`help_topic`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`help_topic`\G # Query 11: 0 QPS, 0x concurrency, ID 0x3F56802DC9E0039FFAA61F14034B739D at byte 8940 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 93us 93us 93us 93us 93us 0 93us # Lock time 4 77us 77us 77us 77us 77us 0 77us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 58 58 58 58 58 0 58 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'help_category'\G # SHOW CREATE TABLE `mysql`.`help_category`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`help_category`\G # Query 12: 0 QPS, 0x concurrency, ID 0x4E5054DB925E80F59091EB4D237A20AC at byte 9458 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 90us 90us 90us 90us 90us 0 90us # Lock time 4 74us 74us 74us 74us 74us 0 74us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 56 56 56 56 56 0 56 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'index_stats'\G # SHOW CREATE TABLE `mysql`.`index_stats`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`index_stats`\G # Query 13: 0 QPS, 0x concurrency, ID 0xA9CAB8D84396F4219B867AD2DA7595AD at byte 9974 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 86us 86us 86us 86us 86us 0 86us # Lock time 4 70us 70us 70us 70us 70us 0 70us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 65 65 65 65 65 0 65 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'time_zone_transition'\G # SHOW CREATE TABLE `mysql`.`time_zone_transition`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`time_zone_transition`\G # Query 14: 0 QPS, 0x concurrency, ID 0x883BDEF37DA2388DC56C839C6B2F4C44 at byte 11524 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 86us 86us 86us 86us 86us 0 86us # Lock time 4 70us 70us 70us 70us 70us 0 70us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 58 58 58 58 58 0 58 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'help_relation'\G # SHOW CREATE TABLE `mysql`.`help_relation`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`help_relation`\G # Query 15: 0 QPS, 0x concurrency, ID 0x934CDDF65D56A94DD3A29FEF06FB99A5 at byte 14600 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 85us 85us 85us 85us 85us 0 85us # Lock time 4 69us 69us 69us 69us 69us 0 69us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 59 59 59 59 59 0 59 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'time_zone_name'\G # SHOW CREATE TABLE `mysql`.`time_zone_name`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`time_zone_name`\G # Query 16: 0 QPS, 0x concurrency, ID 0x3C7895E431BD9E14ABFB48421784C84F at byte 14091 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 85us 85us 85us 85us 85us 0 85us # Lock time 4 70us 70us 70us 70us 70us 0 70us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 1 49 49 49 49 49 0 49 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'func'\G # SHOW CREATE TABLE `mysql`.`func`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`func`\G # Query 17: 0 QPS, 0x concurrency, ID 0xA20EED88D40EDE9C36C91AE64071BF40 at byte 12556 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 84us 84us 84us 84us 84us 0 84us # Lock time 4 69us 69us 69us 69us 69us 0 69us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 1 51 51 51 51 51 0 51 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'plugin'\G # SHOW CREATE TABLE `mysql`.`plugin`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`plugin`\G # Query 18: 0 QPS, 0x concurrency, ID 0x8FDF90C12B453C08149834361F66175B at byte 12042 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 81us 81us 81us 81us 81us 0 81us # Lock time 3 66us 66us 66us 66us 66us 0 66us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 54 54 54 54 54 0 54 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'time_zone'\G # SHOW CREATE TABLE `mysql`.`time_zone`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`time_zone`\G # Query 19: 0 QPS, 0x concurrency, ID 0xB59FADC050D4DAC961FEFEFBB9B41ECE at byte 0 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 2 81us 81us 81us 81us 81us 0 81us # Lock time 0 0 0 0 0 0 0 0 # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 0 0 0 0 0 0 0 0 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 1 31 31 31 31 31 0 31 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ SET SQL_LOG_BIN=0, WSREP_ON=OFF\G # Query 20: 0 QPS, 0x concurrency, ID 0xC0AA9BEC727256417350E56ECC978CD3 at byte 2755 # This item is included in the report because it matches --limit. # Scores: V/M = 0.00 # Time range: all events occurred at 2024-10-05 12:02:39 # Attribute pct total min max avg 95% stddev median # ============ === ======= ======= ======= ======= ======= ======= ======= # Count 1 1 # Exec time 1 63us 63us 63us 63us 63us 0 63us # Lock time 2 39us 39us 39us 39us 39us 0 39us # Rows sent 0 0 0 0 0 0 0 0 # Rows examine 0 0 0 0 0 0 0 0 # Rows affecte 4 1 1 1 1 1 0 1 # Bytes sent 0 11 11 11 11 11 0 11 # Query size 2 55 55 55 55 55 0 55 # String: # Databases mysql # Hosts localhost # Users root # Query_time distribution # 1us # 10us ################################################################ # 100us # 1ms # 10ms # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `mysql` LIKE 'procs_priv'\G # SHOW CREATE TABLE `mysql`.`procs_priv`\G # EXPLAIN /*!50100 PARTITIONS*/ select count(*) into @discard from `mysql`.`procs_priv`\G ```

mism-mism commented 3 weeks ago

データベース分離完了

12:06:40.630783 score: 7108(7116 - 8) : pass
12:06:40.630790 deduction: 0 / timeout: 82
12:06:40.630799 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx   4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
74448  353.657  0.0048  0.0160  0.000  0.001  0.006  0.028  0.100  0.118  73305    0  1143    0          56          0          0         14  POST /api/condition/[\w-]+
 1416  181.393  0.1281  0.1088  0.000  0.112  0.260  0.308  0.469  1.000   1121    0   295    0     6197188          0       4376       7003  GET /api/condition/[\w-]+
  425  162.375  0.3821  0.3927  0.000  0.187  1.000  1.001  1.001  1.001    286    0   139    0      747316          0       1758       4660  GET /api/isu HTTP/2.0
 1631   81.039  0.0497  0.0522  0.000  0.034  0.120  0.162  0.238  0.378   1345    0   286    0    24338662         14      14922     135259  GET /api/isu/[\w-]+
   83   73.732  0.8883  0.2897  0.022  1.000  1.001  1.001  1.001  1.001     12    0    71    0       58418          0        703       6231  GET /api/trend HTTP/2.0
  978   46.077  0.0471  0.0477  0.000  0.035  0.095  0.131  0.237  0.585    919    0    59    0    22261040         14      22761     135259  GET /api/isu/[\w-]+/icon
  272   23.391  0.0860  0.0843  0.000  0.071  0.185  0.249  0.387  0.470    155    0   117    0      738490         14       2715       7605  GET /api/isu/[\w-]+/graph
  534    8.537  0.0160  0.0549  0.000  0.004  0.031  0.056  0.187  1.000    189    0   345    0        3956          0          7         19  POST /api/auth HTTP/2.0
   55    3.497  0.0636  0.0234  0.000  0.064  0.076  0.103  0.168  0.168     51    0     4    0        7160         15        130        163  POST /api/isu HTTP/2.0
  895    1.449  0.0016  0.0024  0.000  0.001  0.003  0.005  0.013  0.017    509  386     0    0    67683487          0      75624     743417  GET /assets/*
  156    1.130  0.0072  0.0141  0.000  0.001  0.024  0.039  0.078  0.079     62    0    94    0        4257         21         27         40  GET /api/user/me HTTP/2.0
   98    1.129  0.0115  0.0176  0.000  0.004  0.031  0.043  0.109  0.109     54    0    44    0         924          0          9         21  POST /api/signout HTTP/2.0
    1    0.227  0.2270  0.0000  0.227  0.227  0.227  0.227  0.227  0.227      1    0     0    0          23         23         23         23  POST /initialize HTTP/2.0
  129    0.131  0.0010  0.0016  0.000  0.001  0.002  0.004  0.010  0.012     84   45     0    0       44352          0        343        528  GET / HTTP/2.0
   29    0.004  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     18   11     0    0        9504          0        327        528  GET /isu/[\w-]+
    1    0.003  0.0030  0.0000  0.003  0.003  0.003  0.003  0.003  0.003      1    0     0    0         528        528        528        528  GET /?jwt=eyJhbGciOiJFUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjgwOTkwNDQsImlhdCI6MTcyODA5OTAxMywiamlhX3VzZXJfaWQiOiJmdW5ueV9wZXJsbWFuIn0.58Et0OHv8FZp8gCy8-c5fe-qp6E1Fd3TDXtrPg_yrMRJOr3m2O87WFxaLm75dnQrlnJXefcJ0LF-sN316iKH7A HTTP/2.0
    1    0.003  0.0030  0.0000  0.003  0.003  0.003  0.003  0.003  0.003      1    0     0    0         528        528        528        528  GET /?jwt=eyJhbGciOiJFUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjgwOTkwMTgsImlhdCI6MTcyODA5ODk4NywiamlhX3VzZXJfaWQiOiJzaGFycF9zcGVuY2UifQ.1fXuYWhQkXPTyGgoFjkwmfDVQeZ8fV4AkmDKe1ml3AxfY4_jM0FAZ4ghLyB-NOCa00aaPZ7xNZEf4qrKLBnRkg HTTP/2.0
    1    0.003  0.0030  0.0000  0.003  0.003  0.003  0.003  0.003  0.003      1    0     0    0         528        528        528        528  GET /?jwt=eyJhbGciOiJFUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjgwOTkwMTgsImlhdCI6MTcyODA5ODk4NywiamlhX3VzZXJfaWQiOiJub3N0YWxnaWNfYmVhdmVyIn0.iX1LpBAQRqBdzq8f9kW56eR1ORB1YkGpMjEji0f8MAeo_7UL747RuvHsfsRklQ0CjK0WbvrnnInkyjUOZ-_uEQ HTTP/2.0
    1    0.003  0.0030  0.0000  0.003  0.003  0.003  0.003  0.003  0.003      1    0     0    0         528        528        528        528  GET /?jwt=eyJhbGciOiJFUzI1NiIsInR5cCI6IkpXVCJ9.eyJleHAiOjE3MjgwOTkwMTgsImlhdCI6MTcyODA5ODk4NywiamlhX3VzZXJfaWQiOiJmdW5ueV9wZXJsbWFuIn0.A-QV4YV8F7AFDBXlhI5-4WKkB7_Pw1V1rZRb1RicktU0uNsVV8yJH4DoRpTkYBmJFoV0hm6k1T5azwki3F1K8A HTTP/2.0

okashoi commented 3 weeks ago

2

12:30:48.539351 score: 6902(6914 - 12) : pass

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx   4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
74367  362.544  0.0049  0.0165  0.000  0.001  0.005  0.028  0.100  0.117  73035    0  1332    0          56          0          0         14  POST /api/condition/[\w-]+
  447  177.205  0.3964  0.3920  0.000  0.216  1.000  1.001  1.001  1.342    299    0   148    0      779978          0       1744       4670  GET /api/isu
 1483  172.800  0.1165  0.1068  0.000  0.103  0.206  0.272  0.562  1.000   1194    0   289    0     6595562          0       4447       7123  GET /api/condition/[\w-]+
 2638  126.347  0.0479  0.0569  0.000  0.033  0.108  0.142  0.262  1.001   2239    0   399    0    44398648          0      16830     135259  GET /api/isu/[\w-]+
   80   70.638  0.8830  0.2964  0.022  1.000  1.001  1.001  1.002  1.002     11    0    69    0       53086          0        663       6239  GET /api/trend
  121   11.942  0.0987  0.0849  0.000  0.090  0.192  0.215  0.383  0.516     81    0    40    0      398369         14       3292       7971  GET /api/isu/[\w-]+/graph
  251   10.606  0.0423  0.0319  0.000  0.033  0.089  0.115  0.133  0.176    236    0    15    0     6660946         14      26537     135259  GET /api/isu/[\w-]+/icon
  520    6.662  0.0128  0.0344  0.000  0.005  0.028  0.043  0.121  0.613    184    0   336    0        3864          0          7         19  POST /api/auth
   55    3.438  0.0625  0.0207  0.000  0.065  0.073  0.106  0.120  0.120     51    0     4    0        7017         15        127        154  POST /api/isu
  877    1.515  0.0017  0.0023  0.000  0.001  0.004  0.007  0.011  0.017    485  392     0    0    64498227          0      73544     743417  GET /assets/*
  148    0.978  0.0066  0.0131  0.000  0.001  0.020  0.031  0.062  0.100     58    0    90    0        3949         21         26         42  GET /api/user/me
   94    0.905  0.0096  0.0146  0.000  0.003  0.026  0.043  0.074  0.074     50    0    44    0         924          0          9         21  POST /api/signout
    1    0.139  0.1390  0.0000  0.139  0.139  0.139  0.139  0.139  0.139      1    0     0    0          23         23         23         23  POST /initialize
  126    0.104  0.0008  0.0010  0.000  0.001  0.002  0.003  0.004  0.005     80   46     0    0       42240          0        335        528  GET /
   59    0.067  0.0011  0.0010  0.000  0.001  0.002  0.004  0.005  0.005     59    0     0    0       31152        528        528        528  GET /?jwt=*
   20    0.001  0.0001  0.0002  0.000  0.000  0.000  0.001  0.001  0.001     14    6     0    0        7392          0        369        528  GET /isu/[\w-]+
    8    0.001  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001      2    6     0    0        1056          0        132        528  GET /isu/[\w-]+/condition
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2     0    0         528          0        176        528  GET /register
    2    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      2    0     0    0        1056        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '383c80fc-bc2d-4d4a-ac9b-ab50327be1fb' ORDER BY timestamp DESC;

インデックス貼る前

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	isu_condition	ALL	null	null	null	null	65553	Using where; Using filesort

インデクス貼ったあと

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	isu_condition	ref	isu_condition_jia_isu_uuid_index	isu_condition_jia_isu_uuid_index	144	const	1	Using index condition; Using where; Using filesort

mism-mism commented 3 weeks ago

12:53:13.595201 score: 23134(23136 - 2) : pass
12:53:13.595208 deduction: 0 / timeout: 22
12:53:13.595214 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
75903  465.289  0.0061  0.0124  0.000  0.002  0.016  0.036  0.061  0.102  75836    0   67    0          70          0          0         14  POST /api/condition/[\w-]+
10954  261.874  0.0239  0.0167  0.000  0.020  0.044  0.054  0.082  0.179  10297    0  657    0   216025409          0      19721     135259  GET /api/isu/[\w-]+
  280  254.829  0.9101  0.1959  0.022  1.000  1.001  1.001  1.003  1.006     95    0  185    0      716144          0       2557       8196  GET /api/trend
 4567  175.836  0.0385  0.0248  0.000  0.034  0.071  0.085  0.118  0.250   4103    0  464    0    22517290          0       4930       6843  GET /api/condition/[\w-]+
 1378   94.780  0.0688  0.0461  0.000  0.058  0.135  0.162  0.203  0.260   1310    0   68    0     4022836          0       2919       4582  GET /api/isu
 1147   27.311  0.0238  0.0150  0.000  0.021  0.042  0.053  0.078  0.148   1122    0   25    0    28260728          0      24638     135259  GET /api/isu/[\w-]+/icon
  990   10.261  0.0104  0.0096  0.000  0.008  0.020  0.026  0.043  0.122    454    0  536    0        6164          0          6         19  POST /api/auth
  303    9.768  0.0322  0.0235  0.000  0.028  0.060  0.072  0.098  0.177    234    0   69    0     1139475          0       3760       7730  GET /api/isu/[\w-]+/graph
 2202    5.650  0.0026  0.0025  0.000  0.002  0.006  0.008  0.011  0.022   1655  547    0    0   219779652          0      99809     743417  GET /assets/*
   55    3.429  0.0623  0.0200  0.001  0.064  0.075  0.103  0.114  0.114     51    0    4    0        7026         15        127        148  POST /api/isu
  563    3.074  0.0055  0.0075  0.000  0.002  0.014  0.019  0.035  0.080    253    0  310    0       15937         21         28         41  GET /api/user/me
  314    2.924  0.0093  0.0093  0.000  0.006  0.020  0.030  0.045  0.057    245    0   69    0        1449          0          4         21  POST /api/signout
  351    0.569  0.0016  0.0023  0.000  0.001  0.004  0.005  0.011  0.026    275   76    0    0      145200          0        413        528  GET /
  254    0.558  0.0022  0.0026  0.000  0.002  0.005  0.006  0.010  0.026    254    0    0    0      134112        528        528        528  GET /?jwt=*
    1    0.268  0.2680  0.0000  0.268  0.268  0.268  0.268  0.268  0.268      1    0    0    0          23         23         23         23  POST /initialize
   20    0.003  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     15    5    0    0        7920          0        396        528  GET /isu/[\w-]+
   10    0.003  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      3    7    0    0        1584          0        158        528  GET /isu/[\w-]+/condition
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    2    0    0         528          0        176        528  GET /register

okashoi commented 3 weeks ago

https://github.com/okashoi/isucon11q-practice-20241005/pull/2/commits/2fe839353e7e017d9c2816b52f46a404f1edac68

13:00:36.215779 score: 23866(23868 - 2) : pass

mism-mism commented 3 weeks ago

5

13:27:09.891586 score: 25790(25792 - 2) : pass
13:27:09.891594 deduction: 0 / timeout: 22
13:27:09.891602 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
76120  410.995  0.0054  0.0060  0.000  0.004  0.012  0.017  0.029  0.101  76116    0    4    0          28          0          0         14  POST /api/condition/[\w-]+
  413  360.228  0.8722  0.1923  0.021  0.963  1.000  1.001  1.001  1.003    224    0  189    0     1737473          0       4206       8204  GET /api/trend
 9199  214.915  0.0234  0.0138  0.000  0.021  0.041  0.049  0.069  0.114   8599    0  600    0   161634927          0      17570     135259  GET /api/isu/[\w-]+
 5124  167.191  0.0326  0.0190  0.000  0.029  0.058  0.068  0.097  0.167   4652    0  472    0    25338898          0       4945       7183  GET /api/condition/[\w-]+
 5980  143.015  0.0239  0.0133  0.000  0.021  0.041  0.049  0.069  0.122   5896    0   84    0   148405644         14      24816     135259  GET /api/isu/[\w-]+/icon
 1709   74.426  0.0435  0.0215  0.000  0.041  0.072  0.083  0.108  0.170   1640    0   69    0     5139669          0       3007       4594  GET /api/isu
 1054   12.761  0.0121  0.0080  0.000  0.010  0.023  0.028  0.042  0.064    518    0  536    0        6164          0          5         19  POST /api/auth
 3000   11.998  0.0040  0.0036  0.000  0.003  0.008  0.011  0.017  0.038   2039  961    0    0   270743812          0      90247     743417  GET /assets/*
  197    5.203  0.0264  0.0175  0.000  0.023  0.049  0.059  0.081  0.124    139    0   58    0      681324         14       3458       7700  GET /api/isu/[\w-]+/graph
  691    4.946  0.0072  0.0082  0.000  0.004  0.017  0.023  0.043  0.077    317    0  374    0       19511         21         28         44  GET /api/user/me
  378    4.107  0.0109  0.0087  0.000  0.009  0.021  0.027  0.043  0.060    309    0   69    0        1449          0          3         21  POST /api/signout
   55    3.436  0.0625  0.0209  0.001  0.062  0.081  0.104  0.113  0.113     51    0    4    0        7116         15        129        157  POST /api/isu
  484    1.363  0.0028  0.0029  0.000  0.002  0.007  0.009  0.014  0.020    339  145    0    0      178992          0        369        528  GET /
  318    1.167  0.0037  0.0034  0.000  0.003  0.008  0.010  0.017  0.022    318    0    0    0      167904        528        528        528  GET /?jwt=*
    1    0.169  0.1690  0.0000  0.169  0.169  0.169  0.169  0.169  0.169      1    0    0    0          23         23         23         23  POST /initialize
   19    0.004  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     12    7    0    0        6336          0        333        528  GET /isu/[\w-]+
    9    0.003  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      4    5    0    0        2112          0        234        528  GET /isu/[\w-]+/condition
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    2    0.001  0.0005  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      2    0    0    0        1056        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
76127  384.063  0.0050  0.0057  0.000  0.003  0.011  0.015  0.028  0.101  76115    0   12    0          98          0          0         14  POST /api/condition/[\w-]+
  429  373.480  0.8706  0.1935  0.022  0.991  1.001  1.001  1.002  1.005    223    0  206    0     1716646          0       4001       8204  GET /api/trend
13636  321.262  0.0236  0.0140  0.000  0.021  0.041  0.049  0.070  0.171  13081    0  555    0   282888429          0      20745     135259  GET /api/isu/[\w-]+
 5095  162.313  0.0319  0.0183  0.000  0.029  0.055  0.065  0.092  0.185   4621    0  474    0    25261520          0       4958       7263  GET /api/condition/[\w-]+
 1766   76.204  0.0432  0.0209  0.000  0.040  0.070  0.081  0.103  0.153   1697    0   69    0     5381435          0       3047       4632  GET /api/isu
 1595   37.182  0.0233  0.0132  0.000  0.021  0.039  0.049  0.070  0.151   1573    0   22    0    40416040         14      25339     135259  GET /api/isu/[\w-]+/icon
  712   20.442  0.0287  0.0175  0.000  0.026  0.050  0.061  0.089  0.122    546    0  166    0     2645089         14       3715       7519  GET /api/isu/[\w-]+/graph
 1107   12.613  0.0114  0.0072  0.000  0.010  0.021  0.025  0.034  0.075    563    0  544    0        6256          0          5         19  POST /api/auth
  776    5.417  0.0070  0.0072  0.000  0.005  0.016  0.021  0.032  0.055    358    0  418    0       21663          0         27         41  GET /api/user/me
  421    4.130  0.0098  0.0070  0.000  0.008  0.019  0.023  0.031  0.060    351    0   70    0        1470          0          3         21  POST /api/signout
   55    3.470  0.0631  0.0214  0.000  0.063  0.084  0.107  0.120  0.120     51    0    4    0        7119         15        129        157  POST /api/isu
  360    1.507  0.0042  0.0036  0.000  0.003  0.009  0.012  0.017  0.027    360    0    0    0      190080        528        528        528  GET /?jwt=*
  501    1.338  0.0027  0.0029  0.000  0.002  0.006  0.008  0.013  0.025    381  120    0    0      201168          0        401        528  GET /
    1    0.282  0.2820  0.0000  0.282  0.282  0.282  0.282  0.282  0.282      1    0    0    0          23         23         23         23  POST /initialize
 2291    0.061  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.006   2291    0    0    0   304189042        592     132775     743417  GET /assets/*
   11    0.006  0.0005  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      4    7    0    0        2112          0        192        528  GET /isu/[\w-]+/condition
   16    0.004  0.0003  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     11    5    0    0        5808          0        363        528  GET /isu/[\w-]+
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      3    0    0    0        1584        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

nginxから静的ファイル配信

13:36:02.969692 score: 25402(25404 - 2) : pass
13:36:02.969699 deduction: 0 / timeout: 22
13:36:02.969707 <=== sendResult finish

mism-mism commented 3 weeks ago

これに気なる

// TODO: 一定割合リクエストを落としてしのぐようにしたが、本来は全量さばけるようにすべき

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
  874  767.353  0.8780  0.1336  0.019  0.890  1.000  1.001  1.002  1.007    633    0  241    0     5290272          0       6052       9068  GET /api/trend
90510  379.565  0.0042  0.0050  0.000  0.003  0.010  0.014  0.024  0.100  90498    0   12    0          98          0          0         14  POST /api/condition/[\w-]+
13426  274.566  0.0205  0.0115  0.000  0.018  0.035  0.042  0.058  0.136  12911    0  515    0   240604938          0      17920     135259  GET /api/isu/[\w-]+
 6984  200.611  0.0287  0.0142  0.000  0.027  0.047  0.055  0.072  0.110   6483    0  501    0    34447041          0       4932       7068  GET /api/condition/[\w-]+
 9327  194.560  0.0209  0.0113  0.000  0.019  0.036  0.041  0.057  0.130   9219    0  108    0   243483743          0      26105     135259  GET /api/isu/[\w-]+/icon
 2843   93.183  0.0328  0.0145  0.000  0.031  0.051  0.059  0.078  0.106   2769    0   74    0     7767607          0       2732       4607  GET /api/isu
 1148   29.539  0.0257  0.0136  0.000  0.024  0.044  0.051  0.067  0.101    972    0  176    0     4825061          0       4203       7706  GET /api/isu/[\w-]+/graph
 1329   13.944  0.0105  0.0066  0.000  0.009  0.019  0.023  0.032  0.073    753    0  576    0        6624          0          4         19  POST /api/auth
 1133    6.908  0.0061  0.0069  0.000  0.004  0.015  0.020  0.030  0.072    537    0  596    0       33075         21         29         43  GET /api/user/me
  600    5.670  0.0094  0.0073  0.000  0.008  0.019  0.023  0.035  0.042    526    0   74    0        1554          0          2         21  POST /api/signout
   67    4.570  0.0682  0.0233  0.000  0.065  0.098  0.116  0.129  0.129     63    0    4    0        8748         15        130        157  POST /api/isu
  951    2.066  0.0022  0.0025  0.000  0.001  0.005  0.007  0.012  0.025    568  383    0    0      299904          0        315        528  GET /
  538    1.981  0.0037  0.0032  0.000  0.003  0.008  0.010  0.016  0.023    538    0    0    0      284064        528        528        528  GET /?jwt=*
    1    0.270  0.2700  0.0000  0.270  0.270  0.270  0.270  0.270  0.270      1    0    0    0          23         23         23         23  POST /initialize
 3414    0.114  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.009   3414    0    0    0   453126614        592     132726     743417  GET /assets/*
   25    0.009  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001     15   10    0    0        7920          0        316        528  GET /isu/[\w-]+
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /isu/[\w-]+/condition
    2    0.001  0.0005  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      2    0    0    0        1056        528        528        528  GET /isu/[\w-]+/graph
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    2    0    0         528          0        176        528  GET /register

okashoi commented 3 weeks ago

6

13:48:13.236262 score: 38854(38858 - 4) : pass                                                                                                                                              13:48:13.236270 deduction: 1 / timeout: 31

okashoi commented 3 weeks ago

7

13:55:36.254094 SCORE: 00.StartBenchmark       : 1
13:55:36.254099 SCORE: 01.GraphGood            : 0
13:55:36.254102 SCORE: 02.GraphNormal          : 0
13:55:36.254105 SCORE: 03.GraphBad             : 7
13:55:36.254109 SCORE: 04.GraphWorst           : 299
13:55:36.254112 SCORE: 05.TodayGraphGood       : 0
13:55:36.254115 SCORE: 06.TodayGraphNormal     : 0
13:55:36.254119 SCORE: 07.TodayGraphBad        : 3
13:55:36.254122 SCORE: 08.TodayGraphWorst      : 124
13:55:36.254125 SCORE: 09.ReadInfoCondition    : 761
13:55:36.254128 SCORE: 10.ReadWarningCondition : 1096
13:55:36.254132 SCORE: 11.ReadCriticalCondition: 600
13:55:36.254471 score: 31364(31366 - 2) : pass
13:55:36.254478 deduction: 0 / timeout: 25

okashoi commented 3 weeks ago

8

キャッシュ保持期間 0.1 秒

14:33:24.696511 score: 33352(33374 - 22) : pass

キャッシュ保持期間 0.5 秒

14:35:45.417201 score: 33203(33208 - 5) : pass

キャッシュ保持期間 0.9 秒

14:38:10.900349 score: 31885(31906 - 21) : pass

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count     Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
78209  1010.719  0.0129  0.0184  0.000  0.006  0.036  0.052  0.097  0.107  77431    0  778    0         420          0          0         14  POST /api/condition/[\w-]+
 7165   390.699  0.0545  0.0440  0.000  0.042  0.113  0.141  0.204  0.469   6759    0  406    0    41520851          0       5794       7018  GET /api/condition/[\w-]+
 4385   105.959  0.0242  0.0230  0.000  0.017  0.050  0.068  0.118  0.289   3837    0  548    0    82658809         14      18850     135259  GET /api/isu/[\w-]+
  441    61.888  0.1403  0.3134  0.000  0.002  0.757  1.000  1.001  1.001    414    0   27    0     3328042          0       7546       8425  GET /api/trend
  578    18.796  0.0325  0.0254  0.000  0.028  0.061  0.078  0.134  0.227    521    0   57    0     1441456          3       2493       4658  GET /api/isu
  431     9.621  0.0223  0.0205  0.000  0.017  0.043  0.060  0.127  0.156    406    0   25    0    11531639         14      26755     135259  GET /api/isu/[\w-]+/icon
  717     7.920  0.0110  0.0116  0.000  0.008  0.020  0.031  0.070  0.088    261    0  456    0        5244          0          7         19  POST /api/auth
  162     6.618  0.0409  0.0349  0.000  0.035  0.088  0.102  0.193  0.206    107    0   55    0     1120473          0       6916      14668  GET /api/isu/[\w-]+/graph
   58     3.641  0.0628  0.0232  0.001  0.062  0.081  0.109  0.147  0.147     54    0    4    0        7586         15        130        157  POST /api/isu
  140     1.093  0.0078  0.0146  0.000  0.004  0.017  0.023  0.062  0.143     81    0   59    0        1239          0          8         21  POST /api/signout
  226     1.050  0.0046  0.0064  0.000  0.002  0.013  0.017  0.036  0.040     90    0  136    0        6240         21         27         43  GET /api/user/me
  502     1.010  0.0020  0.0026  0.000  0.001  0.005  0.007  0.014  0.024    115  387    0    0       60720          0        120        528  GET /
   91     0.205  0.0023  0.0022  0.000  0.002  0.006  0.007  0.009  0.009     91    0    0    0       48048        528        528        528  GET /?jwt=*
    1     0.157  0.1570  0.0000  0.157  0.157  0.157  0.157  0.157  0.157      1    0    0    0          23         23         23         23  POST /initialize
  695     0.047  0.0001  0.0004  0.000  0.000  0.000  0.000  0.002  0.006    695    0    0    0    92369252        592     132905     743417  GET /assets/*
   24     0.003  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     16    8    0    0        8448          0        352        528  GET /isu/[\w-]+
    4     0.001  0.0003  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      0    4    0    0           0          0          0          0  GET /isu/[\w-]+/condition
    3     0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    2     0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      2    0    0    0        1056        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
10591  431.156  0.0407  0.0300  0.000  0.033  0.084  0.100  0.130  0.223  10106    0  485    0    60969407          0       5756       7123  GET /api/condition/[\w-]+
  906  125.042  0.1380  0.2878  0.000  0.002  0.673  0.829  1.000  1.001    870    0   36    0     7104750          0       7841       9076  GET /api/trend
 5006   86.186  0.0172  0.0177  0.000  0.012  0.036  0.050  0.094  0.182   4505    0  501    0    84861624          0      16951     135259  GET /api/isu/[\w-]+
 3205   49.527  0.0155  0.0118  0.000  0.012  0.030  0.039  0.059  0.106   3121    0   84    0    85651646          0      26724     135259  GET /api/isu/[\w-]+/icon
 1094   35.401  0.0324  0.0244  0.000  0.027  0.063  0.081  0.119  0.215   1025    0   69    0     2613735          3       2389      10000  GET /api/isu
  581   19.900  0.0343  0.0323  0.000  0.024  0.083  0.102  0.136  0.168    409    0  172    0     4109132         14       7072      15011  GET /api/isu/[\w-]+/graph
  977    9.654  0.0099  0.0088  0.000  0.007  0.022  0.026  0.042  0.058    425    0  552    0        6348          0          6         19  POST /api/auth
   67    4.285  0.0640  0.0216  0.000  0.060  0.101  0.104  0.112  0.112     63    0    4    0        8789         15        131        154  POST /api/isu
  492    2.179  0.0044  0.0061  0.000  0.002  0.012  0.017  0.031  0.051    218    0  274    0       14150         21         28         44  GET /api/user/me
  979    1.901  0.0019  0.0028  0.000  0.001  0.005  0.007  0.014  0.026    249  730    0    0      131472          0        134        528  GET /
  278    1.770  0.0064  0.0070  0.000  0.004  0.015  0.023  0.034  0.042    207    0   71    0        1491          0          5         21  POST /api/signout
  219    0.626  0.0029  0.0031  0.000  0.002  0.006  0.009  0.015  0.023    219    0    0    0      115632        528        528        528  GET /?jwt=*
    1    0.191  0.1910  0.0000  0.191  0.191  0.191  0.191  0.191  0.191      1    0    0    0          23         23         23         23  POST /initialize
 1499    0.071  0.0000  0.0004  0.000  0.000  0.000  0.000  0.001  0.006   1499    0    0    0   199075462        592     132805     743417  GET /assets/*
   35    0.008  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     24   11    0    0       12672          0        362        528  GET /isu/[\w-]+
    7    0.003  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      4    0    3    0          42          0          6         14  POST /api/condition/[\w-]+
   14    0.002  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001      5    9    0    0        2640          0        188        528  GET /isu/[\w-]+/condition
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    1    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    0    0    0         528        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

14:44:50.866874 score: 52188(52214 - 26) : pass
14:44:50.866881 deduction: 26 / timeout: 5
14:44:50.866887 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
10591  431.156  0.0407  0.0300  0.000  0.033  0.084  0.100  0.130  0.223  10106    0  485    0    60969407          0       5756       7123  GET /api/condition/[\w-]+
 7692  132.755  0.0173  0.0170  0.000  0.012  0.036  0.049  0.091  0.182   7047    0  645    0   150255064          0      19533     135259  GET /api/isu/[\w-]+
  906  125.042  0.1380  0.2878  0.000  0.002  0.673  0.829  1.000  1.001    870    0   36    0     7104750          0       7841       9076  GET /api/trend
 1094   35.401  0.0324  0.0244  0.000  0.027  0.063  0.081  0.119  0.215   1025    0   69    0     2613735          3       2389      10000  GET /api/isu
  800   11.967  0.0150  0.0118  0.000  0.012  0.031  0.039  0.057  0.077    771    0   29    0    22194900          0      27743     135259  GET /api/isu/[\w-]+/icon
  300   10.891  0.0363  0.0341  0.000  0.024  0.093  0.110  0.137  0.164    217    0   83    0     2172438         14       7241      15227  GET /api/isu/[\w-]+/graph
  977    9.654  0.0099  0.0088  0.000  0.007  0.022  0.026  0.042  0.058    425    0  552    0        6348          0          6         19  POST /api/auth
   67    4.285  0.0640  0.0216  0.000  0.060  0.101  0.104  0.112  0.112     63    0    4    0        8789         15        131        154  POST /api/isu
  492    2.179  0.0044  0.0061  0.000  0.002  0.012  0.017  0.031  0.051    218    0  274    0       14150         21         28         44  GET /api/user/me
  979    1.901  0.0019  0.0028  0.000  0.001  0.005  0.007  0.014  0.026    249  730    0    0      131472          0        134        528  GET /
  278    1.770  0.0064  0.0070  0.000  0.004  0.015  0.023  0.034  0.042    207    0   71    0        1491          0          5         21  POST /api/signout
  219    0.626  0.0029  0.0031  0.000  0.002  0.006  0.009  0.015  0.023    219    0    0    0      115632        528        528        528  GET /?jwt=*
    1    0.191  0.1910  0.0000  0.191  0.191  0.191  0.191  0.191  0.191      1    0    0    0          23         23         23         23  POST /initialize
 1499    0.071  0.0000  0.0004  0.000  0.000  0.000  0.000  0.001  0.006   1499    0    0    0   199075462        592     132805     743417  GET /assets/*
   35    0.010  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001     23   12    0    0       12144          0        346        528  GET /isu/[\w-]+
    7    0.003  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      4    0    3    0          42          0          6         14  POST /api/condition/[\w-]+
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
   14    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      6    8    0    0        3168          0        226        528  GET /isu/[\w-]+/condition
    1    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    0    0    0         528        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
10566  450.155  0.0426  0.0309  0.000  0.035  0.087  0.104  0.137  0.215  10095    0  471    0    61035428          0       5776       7243  GET /api/condition/[\w-]+
  898  131.369  0.1463  0.3108  0.000  0.002  0.771  0.956  1.001  1.004    862    0   36    0     7066292          0       7868       9080  GET /api/trend
 4720   85.260  0.0181  0.0180  0.000  0.013  0.038  0.052  0.096  0.195   4255    0  465    0    81584266          0      17284     135259  GET /api/isu/[\w-]+
 3130   51.275  0.0164  0.0122  0.000  0.013  0.032  0.042  0.060  0.103   3037    0   93    0    83232905         14      26591     135259  GET /api/isu/[\w-]+/icon
 1046   35.363  0.0338  0.0250  0.000  0.028  0.064  0.081  0.124  0.186    980    0   66    0     2487431          3       2378       4672  GET /api/isu
  578   22.182  0.0384  0.0354  0.000  0.027  0.091  0.116  0.149  0.181    409    0  169    0     4178404         14       7229      15171  GET /api/isu/[\w-]+/graph
  914    9.881  0.0108  0.0100  0.000  0.008  0.025  0.032  0.046  0.071    386    0  528    0        6072          0          6         19  POST /api/auth
   67    4.148  0.0619  0.0223  0.001  0.058  0.092  0.112  0.120  0.120     63    0    4    0        8782         15        131        154  POST /api/isu
  429    2.204  0.0051  0.0077  0.000  0.002  0.013  0.021  0.038  0.055    188    0  241    0       12168         21         28         48  GET /api/user/me
  245    1.793  0.0073  0.0080  0.000  0.005  0.017  0.021  0.041  0.061    177    0   68    0        1428          0          5         21  POST /api/signout
  968    1.765  0.0018  0.0024  0.000  0.001  0.004  0.006  0.012  0.018    219  749    0    0      115632          0        119        528  GET /
  189    0.610  0.0032  0.0041  0.000  0.002  0.009  0.012  0.024  0.027    189    0    0    0       99792        528        528        528  GET /?jwt=*
    1    0.150  0.1500  0.0000  0.150  0.150  0.150  0.150  0.150  0.150      1    0    0    0          23         23         23         23  POST /initialize
 1319    0.080  0.0001  0.0005  0.000  0.000  0.000  0.000  0.003  0.006   1319    0    0    0   175186012        592     132817     743417  GET /assets/*
   21    0.007  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001     15    6    0    0        7920          0        377        528  GET /isu/[\w-]+
    5    0.004  0.0008  0.0004  0.000  0.001  0.001  0.001  0.001  0.001      2    0    3    0          42          0          8         14  POST /api/condition/[\w-]+
    9    0.003  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      3    6    0    0        1584          0        176        528  GET /isu/[\w-]+/condition
    3    0.002  0.0007  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    1    0.001  0.0010  0.0000  0.001  0.001  0.001  0.001  0.001  0.001      0    0    1    0          71         71         71         71  GET /autodiscover/autodiscover.json?@zdi/Powershell

mism-mism commented 3 weeks ago

10

15:09:54.024427 score: 54602(54632 - 30) : pass

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
11130  438.436  0.0394  0.0280  0.000  0.033  0.081  0.094  0.121  0.199  10627    0  503    0    64226773          0       5770       7243  GET /api/condition/[\w-]+
 8013  132.434  0.0165  0.0164  0.000  0.012  0.032  0.046  0.090  0.186   7342    0  671    0   166971109          0      20837     135259  GET /api/isu/[\w-]+
  963  120.772  0.1254  0.2740  0.000  0.002  0.612  0.801  1.000  1.001    935    0   28    0     7757745          0       8055       9080  GET /api/trend
 1126   35.535  0.0316  0.0216  0.000  0.027  0.060  0.073  0.106  0.158   1054    0   72    0     2713054          0       2409       4632  GET /api/isu
  799   11.610  0.0145  0.0105  0.000  0.012  0.027  0.032  0.054  0.083    777    0   22    0    21836129         14      27329     135259  GET /api/isu/[\w-]+/icon
  313   11.609  0.0371  0.0356  0.000  0.024  0.095  0.120  0.135  0.178    222    0   91    0     2219521          0       7091      14916  GET /api/isu/[\w-]+/graph
  983    9.924  0.0101  0.0084  0.000  0.008  0.021  0.025  0.044  0.074    415    0  568    0        6532          0          6         19  POST /api/auth
   67    4.320  0.0645  0.0210  0.000  0.062  0.086  0.106  0.119  0.119     63    0    4    0        8692         15        129        148  POST /api/isu
 1038    1.868  0.0018  0.0023  0.000  0.001  0.004  0.006  0.012  0.019    233  805    0    0      123024          0        118        528  GET /
  462    1.830  0.0040  0.0056  0.000  0.002  0.010  0.014  0.029  0.043    202    0  260    0       13240         21         28         43  GET /api/user/me
  264    1.725  0.0065  0.0069  0.000  0.004  0.016  0.021  0.036  0.043    191    0   73    0        1533          0          5         21  POST /api/signout
  203    0.612  0.0030  0.0034  0.000  0.002  0.007  0.010  0.016  0.021    203    0    0    0      107184        528        528        528  GET /?jwt=*
    1    0.142  0.1420  0.0000  0.142  0.142  0.142  0.142  0.142  0.142      1    0    0    0          23         23         23         23  POST /initialize
 1403    0.069  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.007   1403    0    0    0   186334422        592     132811     743417  GET /assets/*
    5    0.005  0.0010  0.0006  0.000  0.001  0.002  0.002  0.002  0.002      2    0    3    0          42          0          8         14  POST /api/condition/[\w-]+
   24    0.004  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     16    8    0    0        8448          0        352        528  GET /isu/[\w-]+
    3    0.003  0.0010  0.0000  0.001  0.001  0.001  0.001  0.001  0.001      1    2    0    0         528          0        176        528  GET /register
    6    0.001  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      2    4    0    0        1056          0        176        528  GET /isu/[\w-]+/condition

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
11115  465.368  0.0419  0.0297  0.000  0.034  0.086  0.100  0.128  0.205  10637    0  478    0    64460665          0       5799       7243  GET /api/condition/[\w-]+
  916  122.673  0.1339  0.2898  0.000  0.002  0.721  0.825  1.000  1.001    896    0   20    0     7404171          0       8083       9088  GET /api/trend
 7670  121.967  0.0159  0.0127  0.000  0.013  0.031  0.040  0.064  0.106   7045    0  625    0   154504078          0      20143     135259  GET /api/isu/[\w-]+
 1097   35.176  0.0321  0.0224  0.000  0.027  0.060  0.075  0.114  0.169   1029    0   68    0     2597303          3       2367      10000  GET /api/isu
  809   12.363  0.0153  0.0112  0.000  0.012  0.030  0.038  0.052  0.089    780    0   29    0    20473182         14      25306     135259  GET /api/isu/[\w-]+/icon
  938    9.148  0.0098  0.0087  0.000  0.007  0.022  0.029  0.040  0.065    394    0  544    0        6256          0          6         19  POST /api/auth
  309    6.875  0.0222  0.0186  0.000  0.017  0.050  0.058  0.082  0.115    217    0   92    0     2126445          0       6881      15325  GET /api/isu/[\w-]+/graph
   67    4.291  0.0640  0.0213  0.001  0.062  0.087  0.107  0.125  0.125     63    0    4    0        8757         15        130        157  POST /api/isu
  435    1.815  0.0042  0.0053  0.000  0.002  0.011  0.016  0.023  0.046    190    0  245    0       12398         21         28         41  GET /api/user/me
  988    1.697  0.0017  0.0025  0.000  0.001  0.004  0.006  0.012  0.027    221  767    0    0      116688          0        118        528  GET /
  249    1.559  0.0063  0.0073  0.000  0.004  0.015  0.021  0.038  0.049    179    0   70    0        1470          0          5         21  POST /api/signout
  191    0.614  0.0032  0.0037  0.000  0.002  0.007  0.012  0.017  0.025    191    0    0    0      100848        528        528        528  GET /?jwt=*
    1    0.290  0.2900  0.0000  0.290  0.290  0.290  0.290  0.290  0.290      1    0    0    0          23         23         23         23  POST /initialize
 1331    0.058  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.006   1331    0    0    0   176778642        592     132816     743417  GET /assets/*
    1    0.023  0.0230  0.0000  0.023  0.023  0.023  0.023  0.023  0.023      0    0    1    0          71         71         71         71  GET /favicon.ico
    7    0.004  0.0006  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      1    0    6    0          84          0         12         14  POST /api/condition/[\w-]+
   35    0.004  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     23   12    0    0       12144          0        346        528  GET /isu/[\w-]+
   12    0.002  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      4    8    0    0        2112          0        176        528  GET /isu/[\w-]+/condition
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    2    0    0         528          0        176        528  GET /register

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx  3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
32083  308.158  0.0096  0.0055  0.000  0.009  0.016  0.019  0.026  0.155  31242    0  841    0   688550186          0      21461     135259  GET /api/isu/[\w-]+
24640  250.129  0.0102  0.0056  0.000  0.009  0.017  0.020  0.029  0.136  24006    0  634    0   142891062          0       5799       7075  GET /api/condition/[\w-]+
 1565  181.459  0.1159  0.2130  0.000  0.002  0.464  0.554  0.761  0.883   1565    0    0    0    13111331       3993       8377       9076  GET /api/trend
 4320   93.062  0.0215  0.0118  0.000  0.020  0.034  0.039  0.053  0.293   4226    0   94    0    11465238          0       2653      10000  GET /api/isu
 3299   31.825  0.0096  0.0050  0.000  0.009  0.016  0.019  0.026  0.054   3269    0   30    0    85643603         14      25960     135259  GET /api/isu/[\w-]+/icon
 1261   16.919  0.0134  0.0077  0.000  0.013  0.021  0.024  0.036  0.131   1132    0  129    0    12863839         14      10201      14881  GET /api/isu/[\w-]+/graph
 1867    8.385  0.0045  0.0034  0.000  0.004  0.008  0.009  0.014  0.064   1139    0  728    0        8372          0          4         19  POST /api/auth
 1810    4.427  0.0024  0.0030  0.000  0.002  0.006  0.007  0.013  0.057    866    0  944    0       53811         21         29         44  GET /api/user/me
   67    4.107  0.0613  0.0190  0.000  0.061  0.073  0.106  0.110  0.110     63    0    4    0        8839         15        131        151  POST /api/isu
  948    3.586  0.0038  0.0029  0.000  0.003  0.007  0.009  0.013  0.030    855    0   93    0        1953          0          2         21  POST /api/signout
 1661    1.893  0.0011  0.0014  0.000  0.001  0.002  0.004  0.007  0.012    897  764    0    0      473616          0        285        528  GET /
  867    1.477  0.0017  0.0015  0.000  0.001  0.003  0.005  0.008  0.013    867    0    0    0      457776        528        528        528  GET /?jwt=*
    1    0.309  0.3090  0.0000  0.309  0.309  0.309  0.309  0.309  0.309      1    0    0    0          23         23         23         23  POST /initialize
 5388    0.138  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.008   5388    0    0    0   715114249        592     132723     743417  GET /assets/*
   29    0.008  0.0003  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     23    6    0    0       12144          0        418        528  GET /isu/[\w-]+
   20    0.005  0.0003  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      6   14    0    0        3168          0        158        528  GET /isu/[\w-]+/condition
    7    0.005  0.0007  0.0007  0.000  0.001  0.002  0.002  0.002  0.002      6    0    1    0          14          0          2         14  POST /api/condition/[\w-]+
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    2    0    0         528          0        176        528  GET /register
    1    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1    0    0    0         528        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

15:57:26.450307 SCORE: 11.ReadCriticalCondition: 71
15:57:26.450849 score: 170056(170088 - 32) : pass
15:57:26.450857 deduction: 32 / timeout: 1
15:57:26.450863 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx   3xx   4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
62969  631.468  0.0100  0.0061  0.000  0.009  0.017  0.021  0.029  0.126  61288     0  1681    0  1327119084          0      21075     135259  GET /api/isu/[\w-]+
52010  573.904  0.0110  0.0065  0.000  0.010  0.019  0.022  0.033  0.120  50736     0  1274    0   301196062          0       5791       7140  GET /api/condition/[\w-]+
 3907  415.852  0.1064  0.2124  0.000  0.002  0.484  0.591  0.730  1.000   3891     0    16    0    33375334          0       8542      10075  GET /api/trend
 8515  179.771  0.0211  0.0109  0.000  0.020  0.035  0.040  0.053  0.141   8329     0   186    0    22727412          0       2669      10000  GET /api/isu
 6778   68.044  0.0100  0.0057  0.000  0.009  0.017  0.020  0.029  0.058   6702     0    76    0   180979219         14      26700     135259  GET /api/isu/[\w-]+/icon
 2298   31.349  0.0136  0.0073  0.000  0.013  0.022  0.026  0.035  0.097   2039     0   259    0    23168188          0      10081      15029  GET /api/isu/[\w-]+/graph
 3606   16.205  0.0045  0.0037  0.000  0.004  0.008  0.010  0.017  0.091   2150     0  1456    0       16744          0          4         19  POST /api/auth
  148    9.076  0.0613  0.0194  0.001  0.059  0.077  0.099  0.124  0.126    140     0     8    0       19514         15        131        160  POST /api/isu
 3362    8.169  0.0024  0.0028  0.000  0.002  0.006  0.008  0.013  0.034   1604     0  1758    0       97876         21         29         47  GET /api/user/me
 1766    7.104  0.0040  0.0037  0.000  0.003  0.007  0.010  0.016  0.060   1580     0   186    0        3906          0          2         21  POST /api/signout
 4098    4.607  0.0011  0.0014  0.000  0.001  0.003  0.004  0.007  0.018   1672  2426     0    0      882816          0        215        528  GET /
 1606    2.749  0.0017  0.0017  0.000  0.001  0.004  0.005  0.008  0.017   1606     0     0    0      847968        528        528        528  GET /?jwt=*
    4    0.620  0.1550  0.0594  0.089  0.164  0.247  0.247  0.247  0.247      2     0     0    2          46          0         11         23  POST /initialize
10043    0.277  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.009  10043     0     0    0  1333025326        592     132731     743417  GET /assets/*
   39    0.009  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     26    13     0    0       13728          0        352        528  GET /isu/[\w-]+
   12    0.009  0.0008  0.0004  0.000  0.001  0.001  0.001  0.001  0.001      4     0     8    0         112          0          9         14  POST /api/condition/[\w-]+
   29    0.004  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     10    19     0    0        5280          0        182        528  GET /isu/[\w-]+/condition
   12    0.003  0.0003  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     12     0     0    0        6336        528        528        528  GET /isu/[\w-]+/graph
    6    0.001  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      2     4     0    0        1056          0        176        528  GET /register

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx   3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
 1144  187.210  0.1636  0.2444  0.000  0.002  0.559  0.626  0.729  0.962   1144     0    0    0     9915276       3940       8667      10071  GET /api/trend
13412  167.135  0.0125  0.0065  0.000  0.011  0.020  0.024  0.034  0.078  13062     0  350    0    76297773          3       5688       7019  GET /api/condition/[\w-]+
10407  105.822  0.0102  0.0062  0.000  0.009  0.018  0.021  0.032  0.077   4257  5792  358    0    39735412          0       3818     135259  GET /api/isu/[\w-]+
 7178   76.524  0.0107  0.0061  0.000  0.009  0.018  0.022  0.030  0.074   1288  5821   69    0    33341647          0       4644     135259  GET /api/isu/[\w-]+/icon
 2268   49.512  0.0218  0.0105  0.000  0.021  0.035  0.040  0.056  0.089   2218     0   50    0     5910244          3       2605      10000  GET /api/isu
  940   13.457  0.0143  0.0080  0.000  0.014  0.023  0.027  0.035  0.076    817     0  123    0     8387151         14       8922      14856  GET /api/isu/[\w-]+/graph
   81    4.883  0.0603  0.0161  0.000  0.059  0.078  0.084  0.095  0.095     77     0    4    0       10664         15        131        151  POST /api/isu
  996    4.407  0.0044  0.0030  0.000  0.004  0.008  0.010  0.016  0.025    596     0  400    0        4600          0          4         19  POST /api/auth
  927    2.242  0.0024  0.0029  0.000  0.001  0.006  0.008  0.014  0.024    446     0  481    0       27073         21         29         44  GET /api/user/me
  485    2.077  0.0043  0.0034  0.000  0.003  0.008  0.011  0.017  0.028    433     0   52    0        1092          0          2         21  POST /api/signout
 1208    1.237  0.0010  0.0014  0.000  0.001  0.002  0.003  0.007  0.014    483   725    0    0      255024          0        211        528  GET /
  447    0.576  0.0013  0.0013  0.000  0.001  0.003  0.004  0.006  0.009    447     0    0    0      236016        528        528        528  GET /?jwt=*
    1    0.166  0.1660  0.0000  0.166  0.166  0.166  0.166  0.166  0.166      1     0    0    0          23         23         23         23  POST /initialize
 2903    0.109  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.007   2903     0    0    0   385413172        592     132763     743417  GET /assets/*
    7    0.006  0.0009  0.0008  0.000  0.001  0.002  0.002  0.002  0.002      2     0    5    0          70          0         10         14  POST /api/condition/[\w-]+
   24    0.003  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     14    10    0    0        7392          0        308        528  GET /isu/[\w-]+
   19    0.003  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001      9    10    0    0        4752          0        250        528  GET /isu/[\w-]+/condition
    7    0.003  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      7     0    0    0        3696        528        528        528  GET /isu/[\w-]+/graph
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1     2    0    0         528          0        176        528  GET /register

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx    3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
26864  354.265  0.0132  0.0071  0.000  0.012  0.021  0.025  0.036  0.153  26238      0  626    0   156125683          0       5811       7183  GET /api/condition/[\w-]+
26931  300.874  0.0112  0.0069  0.000  0.010  0.019  0.023  0.034  0.105   9605  16468  858    0   118198983          0       4388     135259  GET /api/isu/[\w-]+
 1451  300.403  0.2070  0.2789  0.000  0.002  0.625  0.694  0.870  1.000   1443      0    8    0    12750977          0       8787      10087  GET /api/trend
 3701   86.125  0.0233  0.0117  0.000  0.022  0.037  0.042  0.058  0.144   3610      0   91    0     9594946          0       2592      10000  GET /api/isu
 2920   32.275  0.0111  0.0066  0.000  0.010  0.019  0.023  0.031  0.091    493   2399   28    0    12978920          0       4444     135259  GET /api/isu/[\w-]+/icon
 1009   15.566  0.0154  0.0079  0.000  0.015  0.024  0.028  0.040  0.088    904      0  105    0    10038136         14       9948      15232  GET /api/isu/[\w-]+/graph
 1701    7.887  0.0046  0.0039  0.000  0.004  0.008  0.010  0.017  0.061    989      0  712    0        8188          0          4         19  POST /api/auth
   81    4.883  0.0603  0.0161  0.000  0.059  0.078  0.084  0.095  0.095     77      0    4    0       10664         15        131        151  POST /api/isu
 1518    3.816  0.0025  0.0031  0.000  0.001  0.006  0.008  0.014  0.027    722      0  796    0       44322         21         29         44  GET /api/user/me
  800    3.480  0.0043  0.0033  0.000  0.004  0.008  0.010  0.017  0.028    709      0   91    0        1911          0          2         21  POST /api/signout
 1544    1.576  0.0010  0.0015  0.000  0.001  0.002  0.003  0.007  0.028    759    785    0    0      400752          0        259        528  GET /
  723    0.937  0.0013  0.0014  0.000  0.001  0.003  0.004  0.006  0.015    723      0    0    0      381744        528        528        528  GET /?jwt=*
    1    0.166  0.1660  0.0000  0.166  0.166  0.166  0.166  0.166  0.166      1      0    0    0          23         23         23         23  POST /initialize
 4559    0.130  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.007   4559      0    0    0   605196112        592     132747     743417  GET /assets/*
    7    0.006  0.0009  0.0008  0.000  0.001  0.002  0.002  0.002  0.002      2      0    5    0          70          0         10         14  POST /api/condition/[\w-]+
   31    0.005  0.0002  0.0004  0.000  0.000  0.001  0.001  0.001  0.001     22      9    0    0       11616          0        374        528  GET /isu/[\w-]+
   14    0.002  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001      3     11    0    0        1584          0        113        528  GET /isu/[\w-]+/condition
    5    0.002  0.0004  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      5      0    0    0        2640        528        528        528  GET /isu/[\w-]+/graph
    3    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1      2    0    0         528          0        176        528  GET /register

mism-mism commented 3 weeks ago

16:46:22.361967 score: 413631(413668 - 37) : pass
16:46:22.361975 deduction: 37 / timeout: 0
16:46:22.361982 <=== sendResult finish

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx    3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
40794  395.611  0.0097  0.0054  0.000  0.009  0.016  0.019  0.028  0.098  40144      0  650    0   243383854          0       5966       7543  GET /api/condition/[\w-]+
25006  223.370  0.0089  0.0056  0.000  0.008  0.016  0.019  0.028  0.088   8971  15156  879    0   120143823          0       4804     135259  GET /api/isu/[\w-]+
 2767  176.125  0.0637  0.1633  0.000  0.001  0.412  0.499  0.607  0.714   2761      0    6    0    24555527          0       8874      10591  GET /api/trend
 3470   61.162  0.0176  0.0093  0.000  0.016  0.029  0.034  0.047  0.082   3377      0   93    0     8618157          0       2483       4599  GET /api/isu
 2558   22.129  0.0087  0.0049  0.000  0.008  0.015  0.017  0.025  0.051    391   2129   38    0    10251669          0       4007     135259  GET /api/isu/[\w-]+/icon
 1008   14.178  0.0141  0.0078  0.000  0.013  0.023  0.028  0.038  0.064    907      0  101    0    14126766          0      14014      19175  GET /api/isu/[\w-]+/graph
 1651    7.679  0.0047  0.0035  0.000  0.004  0.009  0.011  0.019  0.035    915      0  736    0        8464          0          5         19  POST /api/auth
   88    5.108  0.0580  0.0143  0.000  0.058  0.071  0.074  0.083  0.083     84      0    4    0       11648         15        132        154  POST /api/isu
 2863    3.680  0.0013  0.0015  0.000  0.001  0.003  0.004  0.007  0.018    678   2185    0    0      357984          0        125        528  GET /
 1352    3.127  0.0023  0.0026  0.000  0.002  0.005  0.007  0.011  0.035    638      0  714    0       40070         21         29         45  GET /api/user/me
  718    2.609  0.0036  0.0029  0.000  0.003  0.007  0.009  0.015  0.020    624      0   94    0        1974          0          2         21  POST /api/signout
  639    1.186  0.0019  0.0016  0.000  0.001  0.004  0.005  0.007  0.012    639      0    0    0      337392        528        528        528  GET /?jwt=*
    1    0.147  0.1470  0.0000  0.147  0.147  0.147  0.147  0.147  0.147      1      0    0    0          23         23         23         23  POST /initialize
 4073    0.142  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.010   4073      0    0    0   540694597        592     132750     743417  GET /assets/*
    5    0.004  0.0008  0.0004  0.000  0.001  0.001  0.001  0.001  0.001      0      0    5    0          70         14         14         14  POST /api/condition/[\w-]+
   10    0.003  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      3      7    0    0        1584          0        158        528  GET /isu/[\w-]+/condition
   19    0.002  0.0001  0.0003  0.000  0.000  0.001  0.001  0.001  0.001     14      5    0    0        7392          0        389        528  GET /isu/[\w-]+
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1      2    0    0         528          0        176        528  GET /register
    1    0.000  0.0000  0.0000  0.000  0.000  0.000  0.000  0.000  0.000      1      0    0    0         528        528        528        528  GET /isu/[\w-]+/graph

mism-mism commented 3 weeks ago

Top 20 Sort By Total
Count    Total    Mean  Stddev    Min  P50.0  P90.0  P95.0  P99.0    Max    2xx    3xx  4xx  5xx  TotalBytes   MinBytes  MeanBytes   MaxBytes  Request
40794  395.611  0.0097  0.0054  0.000  0.009  0.016  0.019  0.028  0.098  40144      0  650    0   243383854          0       5966       7543  GET /api/condition/[\w-]+
24883  221.869  0.0089  0.0056  0.000  0.008  0.016  0.019  0.028  0.088   8933  15080  870    0   119555540          0       4804     135259  GET /api/isu/[\w-]+
 2767  176.125  0.0637  0.1633  0.000  0.001  0.412  0.499  0.607  0.714   2761      0    6    0    24555527          0       8874      10591  GET /api/trend
 3470   61.162  0.0176  0.0093  0.000  0.016  0.029  0.034  0.047  0.082   3377      0   93    0     8618157          0       2483       4599  GET /api/isu
 2636   22.682  0.0086  0.0047  0.000  0.008  0.014  0.017  0.023  0.057    403   2205   28    0    10197777          0       3868     135259  GET /api/isu/[\w-]+/icon
 1053   15.126  0.0144  0.0076  0.000  0.013  0.024  0.029  0.040  0.062    933      0  120    0    14768941         14      14025      19175  GET /api/isu/[\w-]+/graph
 1651    7.679  0.0047  0.0035  0.000  0.004  0.009  0.011  0.019  0.035    915      0  736    0        8464          0          5         19  POST /api/auth
   88    5.108  0.0580  0.0143  0.000  0.058  0.071  0.074  0.083  0.083     84      0    4    0       11648         15        132        154  POST /api/isu
 2863    3.680  0.0013  0.0015  0.000  0.001  0.003  0.004  0.007  0.018    678   2185    0    0      357984          0        125        528  GET /
 1352    3.127  0.0023  0.0026  0.000  0.002  0.005  0.007  0.011  0.035    638      0  714    0       40070         21         29         45  GET /api/user/me
  718    2.609  0.0036  0.0029  0.000  0.003  0.007  0.009  0.015  0.020    624      0   94    0        1974          0          2         21  POST /api/signout
  639    1.186  0.0019  0.0016  0.000  0.001  0.004  0.005  0.007  0.012    639      0    0    0      337392        528        528        528  GET /?jwt=*
    1    0.147  0.1470  0.0000  0.147  0.147  0.147  0.147  0.147  0.147      1      0    0    0          23         23         23         23  POST /initialize
 4073    0.142  0.0000  0.0003  0.000  0.000  0.000  0.000  0.001  0.010   4073      0    0    0   540694597        592     132750     743417  GET /assets/*
    5    0.004  0.0008  0.0004  0.000  0.001  0.001  0.001  0.001  0.001      0      0    5    0          70         14         14         14  POST /api/condition/[\w-]+
    5    0.003  0.0006  0.0005  0.000  0.001  0.001  0.001  0.001  0.001      1      4    0    0         528          0        105        528  GET /isu/[\w-]+/condition
   25    0.002  0.0001  0.0003  0.000  0.000  0.000  0.001  0.001  0.001     17      8    0    0        8976          0        359        528  GET /isu/[\w-]+
    3    0.001  0.0003  0.0005  0.000  0.000  0.001  0.001  0.001  0.001      1      2    0    0         528          0        176        528  GET /register

okashoi / isucon11q-practice-20241005

やっていき #1

documents

サーバ構成

メモ

ベンチコマンド

インフラ構成

スペック

メモリ

ミドルウェア

開いているポート

起動中のサービス

PATH (バックアップ)

レコード数

データベース分離完了

2

SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '383c80fc-bc2d-4d4a-ac9b-ab50327be1fb' ORDER BY timestamp DESC;

インデックス貼る前

インデクス貼ったあと

5

6

7

8

10

okashoi / isucon11q-practice-20241005

やっていき #1

documents

サーバ構成

メモ

ベンチコマンド

インフラ構成

スペック

メモリ

ミドルウェア

開いているポート

起動中のサービス

PATH (バックアップ)

レコード数

データベース分離完了

2

SELECT * FROM isu_condition WHERE jia_isu_uuid = '383c80fc-bc2d-4d4a-ac9b-ab50327be1fb' ORDER BY timestamp DESC;

インデックス貼る前

インデクス貼ったあと

5

6

7

8

10

SELECT * FROM `isu_condition` WHERE `jia_isu_uuid` = '383c80fc-bc2d-4d4a-ac9b-ab50327be1fb' ORDER BY timestamp DESC;