[B! benchmark] tom__boã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tom__bo id:tom__bo

benchmarkã«é–¢ã™ã‚‹tom__boã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (24)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

EC2ã§SR-IOVã‚’ä½¿ã†ã¨ãã®NICãƒ‰ãƒ©ã‚¤ãƒãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æ¤œè¨¼ - ã‚†ã†ã†ããƒ–ãƒã‚°
SR-IOV enabledãª c3/i2 ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ä½¿ã†ã¨ãã®NICãƒ‰ãƒ©ã‚¤ãƒã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’ã©ã†ã—ãŸã‚‰ã„ã„ã‹ã‚ã‹ã‚‰ãªã‹ã£ãŸã®ã§è»½ãæ¤œè¨¼ã—ã¦ã¿ãŸã€‚ NICã®ãƒ‰ãƒ©ã‚¤ãƒãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ï¼ˆInterruptThrottleRateï¼‰ã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã“ã¨ã§ã€ä¾‹ãˆã°HAProxyã‚’ä½¿ã£ã¦ã‚‹ã‚ˆã†ãªé«˜ppsç’°å¢ƒã§CPUã®å‰²ã‚Šè¾¼ã¿è² è·ã‚’å‰Šæ¸›ã§ãã‚‹ã€‚ ELBã®ä»£ã‚ã‚Šã«HAProxyä½¿ã£ã¦ã‚‹å™‚ã¯çµæ§‹èžã„ãŸã‚Šã™ã‚‹ã€‚ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã®VPCç§»è¡Œã«ã¤ã„ã¦ - Cookpad's deployment and auto scaling // Speaker Deck ã¿ã‚“ãªELBã‹ã‚‰haproxyã«ç§»è¡Œã—ã¦ã‚‹ #jawsdaysâ€” kenjiskywalker (@kenjiskywalker) March 15, 2014 å‰æ c3ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ 2013å¹´ã®11æœˆãã‚‰ã„ã«ã§ãŸæ–°ã—ã„ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚¿ã‚¤ãƒ— SSD Xe
tom__bo 2018/08/10
benchmark

network
ãƒªãƒ³ã‚¯
SystemTapã§MySQLã®Disk I/Oã‚’åˆ†æžã™ã‚‹ - SH2ã®æ—¥è¨˜
å®Ÿé¨“ã‚¨ãƒ³ãƒˆãƒªã§ã™ã€‚ å‹•æ©Ÿ Oracleã®Statspack/AWRã§å–ã‚Œã‚‹ãƒ•ã‚¡ã‚¤ãƒ«å˜ä½ã®Disk I/Oæƒ…å ±ã‚’ã€MySQLã§ã‚‚æŽ¡å–ã—ãŸã„ã€‚ã“ã‚Œã¯æ¬¡ã«ç¤ºã™ã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ã§ã™ã€‚ File IO Stats DB/Inst: ORA112/ORA112 Snaps: 6-7 ->Mx Rd Bkt: Max bucket time for single block read ->ordered by Tablespace, File Tablespace Filename ------------------------ ---------------------------------------------------- Av Mx Av Av Rd Rd Av Av Buffer BufWt Reads Reads/s (ms) Bkt Blks/Rd Writes Writes/s Wai
tom__bo 2018/06/27
systemtap

mysql

performance

benchmark
ãƒªãƒ³ã‚¯
http://www.snia-j.org/tech/WH/SSD/files/SSD_Performance-A_Primer_J.pdf
tom__bo 2018/06/03
benchmark

fio

ssd
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒ“ãƒ¥ãƒ¼ã€‘ 6ã‚³ã‚¢ã«ãªã£ã¦ã‚³ã‚¹ãƒ‘ãŒå‘ä¸Šã—ãŸCore i7-8700Kã‚’ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯
tom__bo 2018/05/05
benchmark

cpu
ãƒªãƒ³ã‚¯
GitHub - wg/wrk: Modern HTTP benchmarking tool
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
tom__bo 2018/03/28
benchmark

http
ãƒªãƒ³ã‚¯
å®Ÿä¾‹ã«å¦ã¶å‹•ç”»é…ä¿¡ã‚µãƒ¼ãƒ“ã‚¹ã®è² è·è©¦é¨“ã€œãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ä½œæˆã‹ã‚‰ãƒ„ãƒ¼ãƒ«é¸å®šã€æ€§èƒ½åŠ£åŒ–ã¸ã®å¯¾å¿œã¾ã§
å®Ÿä¾‹ã«å¦ã¶å‹•ç”»é…ä¿¡ã‚µãƒ¼ãƒ“ã‚¹ã®è² è·è©¦é¨“ï½žãƒ†ã‚¹ãƒˆã‚±ãƒ¼ã‚¹ä½œæˆã‹ã‚‰ãƒ„ãƒ¼ãƒ«é¸å®šã€æ€§èƒ½åŠ£åŒ–ã¸ã®å¯¾å¿œã¾ã§ ãƒ©ã‚¤ãƒ–å‹•ç”»ã‚¹ãƒˆãƒªãƒ¼ãƒŸãƒ³ã‚°ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã€ŒSHOWROOMã€ã§å®Ÿæ–½ã—ãŸè² è·è©¦é¨“ã®å†…å®¹ã¨ã¯ã©ã®ã‚ˆã†ãªã‚‚ã®ã ã£ãŸã®ã§ã—ã‚‡ã†ã‹ã€‚DeNAã®ã‚¤ãƒ³ãƒ•ãƒ©åŸºç›¤ã‚’æ”¯ãˆã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢æ¼¢Â ç¥ä»‹ã•ã‚“ã«ã€è²´é‡ãªãƒŽã‚¦ãƒã‚¦ã‚’å¾¹åº•è§£èª¬ã—ã¦ã‚‚ã‚‰ã„ã¾ã—ãŸï¼ ã‚µãƒ¼ãƒ“ã‚¹ãŒæ¥å‹™ã«è€ãˆã†ã‚‹å‡¦ç†æ€§èƒ½ã‚’æŒã£ã¦ã„ã‚‹ã‹ã‚’æ¤œè¨¼ã™ã‚‹ãŸã‚ã€ã‚·ã‚¹ãƒ†ãƒ ã«å¯¾ã—ã¦æ“¬ä¼¼çš„ã«å¤§é‡ã‚¢ã‚¯ã‚»ã‚¹ã‚’ç™ºç”Ÿã•ã›ã¦åå¿œã‚’æ¸¬å®šã™ã‚‹ã€Œè² è·è©¦é¨“ã€ã€‚ã‚µãƒ¼ãƒãƒ¼ã®é™ç•Œæ€§èƒ½ã‚’è¦‹æ¥µã‚ã€å®‰å®šç¨¼åƒã•ã›ã‚‹ãŸã‚ã®æŒ‡æ¨™ã‚„ä»•çµ„ã¿ã‚’ä½œã‚‹ãŸã‚ã«ã€ãªãã¦ã¯ãªã‚‰ãªã„ã‚‚ã®ã§ã™ã€‚ ã§ã¯ã€å¤šãã®äººãŒçŸ¥ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€ã©ã®ã‚ˆã†ãªè² è·è©¦é¨“ã‚’çµŒã¦ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã®ã§ã—ã‚‡ã†ã‹ã€‚ã™ã§ã«é‹ç”¨æ®µéšŽã«ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®èƒŒå¾Œã«ã‚ã‚‹è² è·è©¦é¨“ã®ãƒŽã‚¦ãƒã‚¦ã¯ã€ã“ã‚Œã‹ã‚‰ä½•ã‚‰ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ãƒªãƒªãƒ¼ã‚¹ã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦æœ‰ç”¨ãªæƒ…å ±ã§ã™ã€‚ ãã“ã§ä»Šå›žã¯ã€
tom__bo 2018/03/10
DeNA

benchmark
ãƒªãƒ³ã‚¯
è² è·è©¦é¨“ã®ãŸã‚ã®ãƒŽã‚¦ãƒã‚¦ã¨ Webãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®è² è·è©¦é¨“ (Python,Node,Go,PHP) - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ã“ã®è¨˜äº‹ã¯Retty Advent Calendar 2017 ã«ãŠã‘ã‚‹ 22æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ æ˜¨æ—¥ã¯ @saku ã•ã‚“ã® swiftã§ä¸¸ç”»åƒã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é«˜ãè¡¨ç¤ºã™ã‚‹æ–¹æ³• ã§ã—ãŸã€‚ ã¯ã˜ã‚ã« è¶£å‘³ã®Boté–‹ç™ºã‹ã‚‰æ°—ã¥ã‘ã°Webãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®è² è·è©¦é¨“ã‚’è¡Œãªã£ã¦ã„ã¾ã—ãŸã€‚ Software Engineerã®@tkngueã§ã™ã€‚æ™®æ®µæ¥å‹™ã¨ã—ã¦ã¯ã€Data Engineer/Web Serviceé–‹ç™º/ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚„ã£ã¦ã¾ã™ ã€Œé€Ÿã•ã¯æ£ç¾©ã€ ã¨ã¯çš†ã®å…±é€šã®èªè˜ã§ã€è¨€ã†ã¾ã§ã‚‚ãªã„ã“ã¨ã ã¨æ€ã†ã®ã§ã™ãŒ æœ¬è¨˜äº‹ã§ã¯ã€é€Ÿã•ã£ã¦ãªã‚“ã ã‚ã†ã£ã¦è€ƒãˆã¦
tom__bo 2017/12/28
Performance

benchmark
ãƒªãƒ³ã‚¯
RabbitMQ Performance Measurements, part 2 | RabbitMQ
Welcome back! Last time we talked about flow control and latency; today let's talk about how different features affect the performance we see. Here are some simple scenarios. As before, they're all variations on the theme of one publisher and one consumer publishing as fast as they can. Some Simple Scenariosâ€‹ This first scenario is the simplest - just one producer and one consumer. So we have a ba
tom__bo 2017/12/21
output sample

rabbitmq

benchmark
ãƒªãƒ³ã‚¯
1åˆ†ã§ã§ãã‚‹ï¼mysqlslapã§DBã®ã‹ã‚“ãŸã‚“æ€§èƒ½èª¿æŸ»ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ - Qiita
æ¥å‹™ä¸ã«ãã“ãã“å¤§ããªã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’ã™ã‚‹ã“ã¨ã«ãªã‚Šã€å®Ÿéš›ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤‰åŒ–ãŒã‚ã‚‹ã‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å–ã‚‹å¿…è¦ãŒå‡ºã¦ãã¾ã—ãŸã€‚ jmeterã¨ã‹ã§ã”ã‚Šã‚‡ã”ã‚Šã‚‡ã¨ã‹ã—ãªã„ã¨ãªã®ã‹ãƒ¼ã¨ã‹æ€ã£ãŸã®ã§ã™ãŒã€ ä»Šå›žã¯ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã®ã¿ãªã®ã§ã€å˜ç´”ã«DBã®ã¿ã®æ¸¬å®šã§ã‚ˆã„ã®ã§ã€ãªã‚“ã‹ã„ã„ãƒ„ãƒ¼ãƒ«ã¯ãªã„ã‹ã¨æŽ¢ã—ãŸã¨ã“ã‚ã€ mysqlslapãªã‚‹ã‚‚ã®ãŒã‚ã‚‹ã‚ˆã†ãªã®ã§è©¦ã—ã¦ã¿ã¾ã—ãŸ 4.5.7 mysqlslap â€” Load Emulation Client mysqlslapã¯MySQLã‚µãƒ¼ãƒã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆè² è·ã‚’ã‚¨ãƒŸãƒ¥ãƒ¬ãƒ¼ãƒˆã—ã€å„ã‚¹ãƒ†ãƒ¼ã‚¸ã®ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’å ±å‘Šã™ã‚‹è¨ºæ–ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã™ã€‚ã‚µãƒ¼ãƒã«ãŸã„ã—ã¦è¤‡æ•°ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã‹ã®ã‚ˆã†ã«ä½œå‹•ã—ã¾ã™ã€‚mysqlslapã¯MySQL 5.1.4.ã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã•ã£ããè©¦ã—ã¦ã¿ãƒ¼ã‚‹ ä½¿ã„æ–¹ mysqlãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚Œã°æ¨™æº–ã§mysqlslapã‚‚ã‚¤ãƒ³
tom__bo 2017/09/16
benchmark

DB
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.4 Reference Manual :: 10.13 Measuring Performance (Benchmarking)
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
tpcc-mysqlã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ï½žè¨ˆæ¸¬ æ‰‹é †ãƒ¡ãƒ¢
å¿…è¦ãªãƒ‘ãƒƒã‚±ãƒ¼ã‚¸(yumã§ä¾å˜é–¢ä¿‚ã‚’è¿½ã£ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã‚‹å¥´ã¯é™¤ãï¼‰ ãƒ»MySQL-serverï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-serverï¼‰ ãƒ»MySQL-develï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-develï¼‰ ãƒ»MySQL-shredï¼ˆCentOSã®ãƒªãƒã‚¸ãƒˆãƒªä½¿ã†ãªã‚‰ã€mysql-libsï¼‰ ãƒ»bzr ãƒ»make ãƒ»gcc MySQL-serverãŒå…¥ã£ã¦ãªã„çŠ¶æ…‹ã ã¨ã€ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã¯å‡ºæ¥ãŸã‘ã©å®Ÿè¡Œã—ã‚ˆã†ã¨ã™ã‚‹ã¨Segmentation Faultã—ãŸã€‚ ã‚½ãƒ¼ã‚¹ã®å…¥æ‰‹ï¼†ã‚³ãƒ³ãƒ‘ã‚¤ãƒ« $ bzr branch lp:~percona-dev/perconatools/tpcc-mysql ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®ã«tpcc-mysqlãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’æŒã£ã¦ãã¦ãã‚Œã‚‹ã€‚ $ cd tpcc-mysql/src $ make ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ãŒå…¨éƒ¨æƒã£ã¦ã„ã‚Œã°makeä¸€ç™º
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
tpcc-mysql: Simple usage steps and how to build graphs with gnuplot - DZone
tom__bo 2017/09/16
tpc

benchmark

DB
ãƒªãƒ³ã‚¯
https://courses.cs.duke.edu/fall13/cps296.4/838-CloudPapers/ycsb.pdf
tom__bo 2017/09/16
YCSB

benchmark

db

NoSQL
ãƒªãƒ³ã‚¯
YCSBã§NoSQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã€€ãã®1 - å·¥å ´é•·ã®ãƒ–ãƒã‚°
ã“ã“æ•°å¹´ã§NoSQLã‚’å®Ÿéš›ã®ã‚·ã‚¹ãƒ†ãƒ ã§æ‰±ã†ã®ã‚‚å‰²ã‚Šã¨ä¸€èˆ¬çš„ã«ãªã£ã¦ãã¦ã„ã¦ã€æ©Ÿèƒ½é¢ã ã‘ã§ãªãã€æ€§èƒ½é¢ãŒæ°—ã«ãªã‚‹ã‚±ãƒ¼ã‚¹ãŒå¤šããªã£ã¦ããŸã¨æ€ã†ã€‚ ã˜ã‚ƒã‚ã©ã†ã‚„ã£ã¦æ€§èƒ½ã¯ã‹ã‚‹ã®ï¼Ÿæ¯”ã¹ã‚‹ã®ï¼Ÿã£ã¦è©±ã«ãªã‚‹ã‚ˆãã€‚ ã„ã‚ã‚†ã‚‹ã€NoSQLã«ãŠã‘ã‚‹apache benchã‚„JMeterã®ã‚ˆã†ãªã‚‚ã®ãŒã»ã—ã„ã‚ˆãã€‚ ä»Šæ—¥ã¯ã€ãã®ã‚ãŸã‚Šã®ã²ã¨ã¤ã®ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¨ãªã‚‹ã‹ã‚‚ãªã€YCSBã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã‚‹ã€‚ YCSBã¨ã¯ YCSBã¯Yahcoo Cloud Serving Benchmarkã®ç•¥ç§°ã§ã€ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®Webã¯ã“ã¡ã‚‰ã€‚ http://research.yahoo.com/Web_Information_Management/YCSB https://github.com/brianfrankcooper/YCSB/wiki ã–ã£ãã‚Šã²ã¨ã“ã¨ã§å½¹å‰²ã¨èª¬æ˜Žã™ã‚‹ã¨ã€NoSQLå‘ã‘ã®Benchmarkãƒ„
tom__bo 2017/09/16
YCSB

NoSQL

benchmark
ãƒªãƒ³ã‚¯
YCSBã®æ¦‚è¦ã¨Cassandraã¸ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ - Qiita
YCSB, Yahoo! Cloud Service Benchmark ã«ã¤ã„ã¦ YCSBã¯ã€ç±³Yahoo!ã®ç ”ç©¶é–‹ç™ºéƒ¨éƒ¨é–€ Yahoo! Research ãŒé–‹ç™ºã—ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’å¯¾è±¡ã¨ã—ãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ç•°ãªã‚‹ç¨®é¡žã®NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦å…±é€šçš„ãªè² è·ã‚·ãƒŠãƒªã‚ªã¨ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã®æä¾›ã‚’ç›®çš„ã¨ã—ã¦é–‹ç™ºã•ã‚Œã¦ã„ã¾ã™ã€‚è² è·ã‚·ãƒŠãƒªã‚ªã«é–¢ã—ã¦ã¯è‡ªåˆ†ã§å®šç¾©ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€5ç¨®é¡žã®ã‚·ãƒŠãƒªã‚ªãŒäº‹å‰ã«å®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ Workload Title ã‚·ãƒŠãƒªã‚ªã®å†…å®¹ æƒ³å®šã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
tom__bo 2017/09/16
NoSQL

YCSB

benchmark
ãƒªãƒ³ã‚¯
tpcc-mysqlã«ã‚ˆã‚‹MySQLã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹è² è·ãƒ„ãƒ¼ãƒ«ã€ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã¯ä¸–ã®ä¸ã«ãŸãã•ã‚“ã‚ã‚‹ã®ã§ã™ãŒã€å˜ä¸€ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ä¸»ã‚ãƒ¼æ¤œç´¢ã—ã‹ã—ãªã„ã‚‚ã®ãªã©ã€CPUã‚¯ãƒãƒƒã‚¯å‹è² ã®æ¯”è¼ƒçš„å˜ç´”ãªã‚‚ã®ãŒå¤šãã‚’å ã‚ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ãã“ã§æœ¬æ—¥ã¯ã€ã‚‚ã†å°‘ã—é«˜åº¦ãªãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã¨ã—ã¦ã®TPC-Cã¨ã€MySQLå‘ã‘ã®ç°¡æ˜“å®Ÿè£…ã§ã‚ã‚‹tpcc-mysqlã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ TPC-Cã¨ã¯å¸å£²æ¥ã«ãŠã‘ã‚‹æ³¨æ–‡ãƒ»æ”¯æ‰•ã„ãªã©ã®å‡¦ç†ã‚’æ“¬ä¼¼çš„ã«å†ç¾ã—ãŸæ¥å‹™ãƒ¢ãƒ‡ãƒ«ã§ã€TPCã¨ã„ã†æ¥ç•Œå›£ä½“ã«ã‚ˆã£ã¦ç–å®šã•ã‚ŒãŸã‚‚ã®ã§ã™ã€‚9ç¨®é¡žã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹5ç¨®é¡žã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒãƒŸãƒƒã‚¯ã‚¹ã•ã‚Œã¦ãŠã‚Šã€ãã®ã†ã¡æ³¨æ–‡å‡¦ç†ã®ã‚¹ãƒ«ãƒ¼ãƒ—ãƒƒãƒˆã‚’æ¸¬å®šçµæžœã¨ã—ã¦åˆ©ç”¨ã—ã¾ã™ã€‚å…¬å¼ã‚µã‚¤ãƒˆã§ä»•æ§˜æ›¸(PDF)ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ã¡ãªã¿ã«ã“ã®ERå›³ã¯MySQL Workbenchã§å‡ºåŠ›ã—ãŸã‚‚ã®ã§ã™ã€‚ warehouseï¼šå€‰åº«ã§ã™ã€‚å€‰åº«è¡¨ã®ãƒ¬ã‚³ãƒ¼ãƒ‰æ•°ã¯
tom__bo 2017/09/16
tpc

MySQL

benchmark
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬2å›žã§ã™ã€‚ å‰å›žã¯TPC-Bãƒ™ãƒ¼ã‚¹ã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã‹ã‚‰6ã¤ã®ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã—ãŸã€‚ä»Šå›žã¯TPC-Cãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã«ã¤ã„ã¦è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ tpcc-mysql å¯¾å¿œRDBMSï¼šMySQL å¯¾å¿œOSï¼šLinuxãªã© è¨€èªžï¼šC ä½œè€…ï¼šPercona Inc. ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ï¼šä¸æ˜Ž(ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«é–¢ã™ã‚‹è¨˜è¿°ãŒãªã„) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä»•æ§˜ï¼šTPC-Cãƒ™ãƒ¼ã‚¹ URLï¼šhttps://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql tpcc-mysqlã¯MySQLã®ã‚³ãƒ³ã‚µãƒ«ä¼šç¤¾ã§ã‚ã‚‹Percona Inc.ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã§ã€TPC-Cã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚TPC-Cã®ä»•æ§˜ã‚„tpcc-mysqlã«ã¤ã„ã¦ã¯ä»¥å‰ã®ã‚¨ãƒ³ãƒˆãƒªã§è©³ã—ãæ‰±ã£ã¦ã„ã‚‹ã®ã§ã€ãã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ tpc
tom__bo 2017/09/12
DB

Benchmark

tpc
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(3) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬3å›žã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(1) TPC-Bã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) TPC-Cãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ã‹ãªã‚ŠæœŸé–“ãŒç©ºã„ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯TPC-Hãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ TPC-Hã¨ã¯ TPC-Hã¯RDBMSãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã®ä¸€ã¤ã§ã€æ„æ€æ±ºå®šæ”¯æ´ã‚·ã‚¹ãƒ†ãƒ (DSS)ã¨ã—ã¦ã®æ€§èƒ½ã‚’æ¸¬å®šã™ã‚‹ã‚‚ã®ã§ã™ã€‚å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’å¯¾è±¡ã«ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ã‚¯ã‚¨ãƒªã¯å…¨éƒ¨ã§22ç¨®é¡žå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ TPC-Hã¯TPC-B/W/Cãªã©ã¨ç•°ãªã‚Šã€å®Ÿè¡Œã™ã‚‹ã‚¯ã‚¨ãƒªãã®ã‚‚ã®ã‚„ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”Ÿæˆãƒ„ãƒ¼ãƒ«ãŒTPCã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚è©¦ã—ã«ã€ä¸€ç•ªè² è·ãŒé«˜ã„9ç•ªã®ã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ -- $ID$ -- TPC-H/TPC-R Product Type Profit Me
tom__bo 2016/05/30
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

Benchmark
ãƒªãƒ³ã‚¯
Database Test Suite
Database Test 1 (DBT-1TM) DBT-1TM is a web-based transactional performance test. It simulates the activities of web users browsing and buying it ems from an on-line bookstore. DBT-1TM is a fair usage implementation of the Transaction Processing Performance Council's (TPC) TPC-WTM Benchmark" specification. The results of a test run include transactions per second, CPU utilization, I/O activity, and
tom__bo 2016/05/30
database

benchmark
ãƒªãƒ³ã‚¯
MySQL5.7 / RDS / Aurora / Cloud SQL ã®æ€§èƒ½æ¯”è¼ƒ | å¤–é“çˆ¶ã®åŒ
CloudSQLã®ä¾¡æ ¼ã¯å®Ÿæˆ¦çš„ã¨ã„ã†æ„å‘³ã§ã€per Dayã®ä¾¡æ ¼ã‚’24hourã§å‰²ã£ãŸä¾¡æ ¼ã«ã—ã¦ã„ã¾ã™ã€‚ ãƒ¡ãƒ¢ãƒªã¯2GBã‚ã‚Œã°æ¤œè¨¼ã¨ã—ã¦ã¯ååˆ†ãªã®ã§æ ¼å·®ã¯é–¢ä¿‚ã‚ã‚Šã¾ã›ã‚“ã€‚ IOPSã¯EBSãªã‚‰General Purposeã®1000GB*3ã§æœ€å¤§ç¢ºä¿ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»–ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯å‘¨ã‚Šãªã©ãƒã‚¤ãƒ³ãƒˆãŒã‚ã‚Œã°éƒ½åº¦ã€è£œè¶³ã—ã¦ã„ãã¾ã™ã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ãƒ‡ãƒ¼ã‚¿ ä»Šå›žã€æŽ¡å–ã—ãŸå…¨ãƒ‡ãƒ¼ã‚¿ã¯ã“ã¡ã‚‰ã«ãªã‚Šã¾ã™ã€‚ä¸€éƒ¨ã€ç›®çš„ã«å¯¾ã—ã¦ä¸è¦ã¨åˆ¤æ–ã—ãŸã‚‰çœç•¥ã—ã¦ã„ã¾ã™ã€‚ã¾ãã€ã“ã‚“ãªã‚ªãƒ¬ã‚ªãƒ¬ãƒ¡ãƒ¢ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã¦ã‚‚æ¥½ã—ããªã„ã§ã—ã‚‡ã†ã‹ã‚‰ã€ï¼‘ã¤ï¼‘ã¤è€ƒå¯Ÿã—ã¦ã„ãã¾ã—ã‚‡ã†ã€‚ æ‰‹æ³•ã«ã¤ã„ã¦ ç§ãŒã‚ˆãã‚„ã‚‹è¨ˆæ¸¬æ–¹æ³•ãªã®ã§ã™ãŒã€innodb_buffer_pool_size ãŒãƒ‡ãƒ¼ã‚¿å®¹é‡ã‚ˆã‚Šå¤§ãã„å¥å…¨ãªçŠ¶æ…‹ã¨ã€æœ€å°ã®16MBã§éŽè² è·ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ¼”å‡ºã—ã€ãã‚Œãžã‚Œã§å‚ç…§ï¼æ›´æ–°ã‚’åˆ¥ã€…ã«ãƒ©ãƒ³ãƒ€ãƒ ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã™ã‚‹ã“ã¨ã§ã€æœ€åˆã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‚™ã‚Šå‡ºã—
tom__bo 2015/10/23
ã‚ã¨ã§èªã‚€

MySQL

benchmark
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸