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

tom__bo id:tom__bo

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

${{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}}

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
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(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
ãƒªãƒ³ã‚¯
1