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

tom__bo id:tom__bo

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

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

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
ãƒªãƒ³ã‚¯
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
ãƒªãƒ³ã‚¯
1