[B! MySQL] t-cyrillã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

t-cyrill id:t-cyrill

MySQLã«é–¢ã™ã‚‹t-cyrillã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (26)

${{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 ã¯åˆ†æ•£DBã®å¤¢ã‚’è¦‹ã‚‹ã‹ã€Google F1 è«–æ–‡ã‚’å®Ÿè£…ã—ãŸ TiDB ã‚’ä½¿ã£ã¦ã¿ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
MySQL ã¯åˆ†æ•£DBã®å¤¢ã‚’è¦‹ã‚‹ã‹ã€Google F1 è«–æ–‡ã‚’å®Ÿè£…ã—ãŸ TiDB ã‚’ä½¿ã£ã¦ã¿ãŸ ã“ã‚“ã«ã¡ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® nobuh ã§ã™ åˆ†æ•£DBã¨ã„ã†å¤¢ ã‚¯ãƒ©ã‚¦ãƒ‰ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç•Œéšˆã§ã¯æ˜¨å¹´ãã‚‰ã„ã‹ã‚‰ MySQL äº’æ›ã®ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€Amazon Aurora ã‚„ Google Cloud SQL ãŒãƒ›ãƒƒãƒˆãªè©±é¡Œã ã¨æ€ã„ã¾ã™ã€‚ ãã‚Œã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é»Žæ˜ŽæœŸã‹ã‚‰ç ”ç©¶ã®å ´ã§ã¯åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ãŒå¤§ããªç ”ç©¶åˆ†é‡Žã«ãªã£ã¦ã„ã¦ã€RDBMS ã§ã‚ã‚ŠãªãŒã‚‰ã‚‚ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆãŒå¯èƒ½ã§è€éšœå®³æ€§ã‚‚ã‚ã‚Šã€ãã—ã¦å®Ÿç”¨çš„ãªé€Ÿåº¦ã§ç¨¼åƒã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ãŒãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ç´„æŸã®åœ°ã€æœ€å¾Œã®æ¥½åœ’ã¨ãªã£ã¦ã„ã‚‹ã‹ã‚‰ã§ã™ã€‚ã¾ãŸãã®åˆ†æ•£ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ MySQL äº’æ›ã§ WordPress ã‚‚å‹•ã‘ã°ã‚‚ã†æœ€é«˜ã§ã™ã€‚ Google Cloud SQL ã®å…ƒã¨ãªã£ã¦ã„ã‚‹ã‚‰ã—ã„ Google ã® F
t-cyrill 2020/09/30
mysql

ã‚µãƒ¼ãƒ

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Amazon Aurora Multi-Master is Now Generally Available
Amazon AuroraÂ Multi-Master is now generally available, allowing you to create multiple read-write instances of your Aurora database across multiple Availability Zones, which enables uptime-sensitive applications to achieve continuous write availability through instance failure. In the event of instance or Availability Zone failures, Aurora Multi-Master enables the Aurora database to maintain read
t-cyrill 2019/08/09
ã•ã¦ã©ã†ã‹ãª

aurora

mysql

database
ãƒªãƒ³ã‚¯
MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã¨ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° | Yakst
MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒãƒ³ãƒ‰ãƒªãƒ³ã‚°ã®å†…éƒ¨æ§‹é€ ã€ã‚¹ã‚±ãƒ¼ãƒ«é™ç•Œã€ãã—ã¦æœ€å¤§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³æ•°ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ å…è²¬äº‹é … ã“ã®è¨˜äº‹ã¯Geir Hoydalsvikæ°ã«ã‚ˆã‚‹MySQL Server Blogã®æŠ•ç¨¿ã€ŒMySQL Connection Handling and Scalingã€(2019/3/19)ã‚’ãƒ¦ãƒ¼ã‚¶ãŒç¿»è¨³ã—ãŸã‚‚ã®ã§ã‚ã‚Šã€Oracleå…¬å¼ã®æ–‡æ›¸ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã“ã®æŠ•ç¨¿ã§ã¯ã€MySQLã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰ãŠã‚ˆã³ã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚°ã«ã¤ã„ã¦å–ã‚Šæ‰±ã„ã¾ã™ã€‚MySQLãŒã©ã®ã‚ˆã†ã«å‹•ä½œã™ã‚‹ã‹ã‚’ã‚ˆã‚Šã‚ˆãç†è§£ã™ã‚‹ã“ã¨ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³é–‹ç™ºè€…ã‚„ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ãŒã€ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’è¸ã¾ãˆãŸè‰¯ã„é¸æŠžã‚’ã§ãã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚æœ¬è¨˜äº‹ã§ã¯ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒ¼ç‰ˆã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒã©ã®ã‚ˆã†ã«å‹•ä½œã™ã‚‹ã‹ã«ã¤ã„ã¦è¿°ã¹ã¾ã™ãŒã€ä¸€æ–¹ã§ã‚¹ãƒ¬ãƒƒãƒ‰ãƒ—ãƒ¼ãƒ«ã€ãƒªã‚½ãƒ¼ã‚¹ã‚°ãƒ«ãƒ¼ãƒ—ã€ã‚ã‚‹ã„ã¯ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³å¤šé‡åŒ–ã¨ã„ã£ãŸé–¢
t-cyrill 2019/05/20
ãµã‚€

mysql
ãƒªãƒ³ã‚¯
MySQLã«WEBã‚¢ãƒ—ãƒªã®ãƒã‚°ã‚’ä¿å˜ã—ã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ã®8å‰²ãã‚‰ã„ãŒå¹¸ã›ã«ãªã‚‹æ–¹æ³•
2019/03/30 PHPerKaigi 2019
t-cyrill 2019/03/31
ãƒã‚°ã‚’MySQLã«å…¥ã‚Œã‚‹ãªã‚“ã¦ãªã„ã¨æ€ã£ã¦ãŸã‚“ã ã‘ã©ãã‚Œã¯ã„ã¤ã®é–“ã«ã‹ã‚ã£ãŸã®ã‚ˆã€‚ãã—ã¦å·¨å¤§åŒ–ã™ã‚‹ãƒã‚°ã‚ˆã€‚ã ã„ãŸã„ã‚¹ãƒ©ã‚¤ãƒ‰ã§è©±ã•ã‚Œã¦ã„ãŸé€šã‚Š

mysql
ãƒªãƒ³ã‚¯
GitHub - google/mysql-ripple: Ripple, a server that can serve as a middleman in MySQL replication
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.
t-cyrill 2019/03/18
ã“ã†ã„ã†ã®æ¬²ã—ã„ã¨æ€ã£ã¦ãŸã‘ã©GoogleãŒæŒã£ã¦ã„ãŸã®ãã€‚

google

mysql
ãƒªãƒ³ã‚¯
BASEã®ãƒ¡ã‚¤ãƒ³DBã‚’Aurora(MySQL)ã«ç§»è¡Œã—ã¾ã—ãŸ - BASEãƒ—ãƒãƒ€ã‚¯ãƒˆãƒãƒ¼ãƒ ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€BASEãƒ©ãƒ³ãƒ‹ãƒ³ã‚°éƒ¨ã§10kmãƒžãƒ©ã‚½ãƒ³ãªã©ã«å‚åŠ ã—ã€3kgã»ã©ä½“é‡ãŒè½ã¡ãŸSRE Groupã«æ‰€å±žã—ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ¤æœ¨ã§ã™ã€‚ãŠã‹ã’ã§ç”˜ã„ã‚‚ã®ãŒç¾Žå‘³ã—ã„ã§ã™ã€‚ã¡ãªã¿ã«æ¬¡ã¯ãƒãƒ¼ãƒ•ãƒžãƒ©ã‚½ãƒ³ã«æŒ‘æˆ¦ã§ã™ï¼ ä»Šå›žã¯ä¼šç¤¾ã®ãƒ–ãƒã‚°ãªã©ã‚’æ›¸ã„ã¦ã¿ã¾ã™ã€‚å¼Šç¤¾ã§ã¯ã€ãƒãƒƒãƒˆã‚·ãƒ§ãƒƒãƒ—ä½œæˆã‚µãƒ¼ãƒ“ã‚¹ã€ŒBASEã€ãŠã‚ˆã³ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚¢ãƒ—ãƒªã€ŒBASEã€ã‚’é‹å–¶ã—ã¦ã„ã¾ã™ãŒã€11æœˆã«ãƒ¡ã‚¤ãƒ³DBã‚’RDS for MySQL5.6ã‹ã‚‰Aurora(MySQL5.6ã‚³ãƒ³ãƒ‘ãƒãƒ–ãƒ«)ã«å¤‰æ›´ã—ã¾ã—ãŸã®ã§ã€ãã¡ã‚‰ã®è©±ã‚’æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ä½•æ•…Auroraï¼Ÿ ã¾ãšã€å¼Šç¤¾ã§AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã£ã¦ã„ãŸã¨ã„ã†èƒŒæ™¯ãŒã‚ã‚Šã¾ã™ã€‚å…¥ç¤¾ã—ãŸéš›ã«ã¯RDS for MySQLã‚’ä½¿ç”¨ã—ã¦ãŠã‚Šã€CTOã®è—¤å·ã‚‚ã€ŒAWSã‚’ä½¿ã†ãªã‚‰Auroraã«ã—ãŸã„ã€ã¨ã„ã†è¦æœ›ã‚’æŒã£ã¦ã„ã¾ã—ãŸã€‚ç§è‡ªèº«ã€AWSã‚’ãƒ¡ã‚¤ãƒ³ã«ä½¿ã„ç¶šã‘ã‚‹ã¤ã‚‚ã‚Šã§ã‚ã‚Œã°Aurora
t-cyrill 2018/11/28
â€œãƒ†ãƒ¼ãƒ–ãƒ«ã®åœ§ç¸®æ©Ÿèƒ½ãŒç„¡ã„â€ åœ°å‘³ãªãŒã‚‰ç§»ã™ãªã‚‰è€ƒãˆãªã„ã¨ãªãƒ»ãƒ»ãƒ»

aurora

mysql
ãƒªãƒ³ã‚¯
SQLã§ç¾ƒç‰ã«DBã‚¹ã‚ãƒ¼ãƒžç®¡ç†ãŒã§ãã‚‹ãƒ„ãƒ¼ãƒ«ã€Œsqldefã€ã‚’ä½œã£ãŸ - k0kubun's blog
sqldefã®ãƒªãƒã‚¸ãƒˆãƒª github.com ã“ã‚Œã¯ä½•ã‹ Ridgepoleã¨ã„ã†ãƒ„ãƒ¼ãƒ«ã‚’ã”å˜ã˜ã§ã—ã‚‡ã†ã‹ã€‚ ã“ã‚Œã¯Rubyã®DSLã§create_tableã‚„add_indexç‰ã‚’æ›¸ã„ã¦ã‚¹ã‚ãƒ¼ãƒžå®šç¾©ã‚’ã—ã¦ãŠãã¨ãã‚Œã¨å®Ÿéš›ã®ã‚¹ã‚ãƒ¼ãƒžã®å·®ç•°ã‚’åŸ‹ã‚ã‚‹ãŸã‚ã«å¿…è¦ãªDDLã‚’è‡ªå‹•ã§ç”Ÿæˆãƒ»é©ç”¨ã§ãã‚‹ä¾¿åˆ©ãªãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ä¸€æ–¹ã€ ã§è¨€ã‚ã‚Œã¦ã„ã‚‹ã‚ˆã†ã«ã€Ridgepoleã‚’å‹•ä½œã•ã›ã‚‹ãŸã‚ã«ã¯Rubyã‚„ActiveRecordã¨ã„ã£ãŸä¾å˜ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€Railsã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ä»¥å¤–ã§ä½¿ã†å ´åˆã«ã¯å°‘ã€…é¢å€’ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚*1 *2 ãã“ã§ã€Pure Goã§æ›¸ãã“ã¨ã§ãƒ¯ãƒ³ãƒã‚¤ãƒŠãƒªã«ã—ã€ã¾ãŸåˆ¥è¨€èªžåœã®äººã§ã‚‚ä½¿ã„ã‚„ã™ã„ã‚ˆã†ã€Rubyã®DSLã®ã‹ã‚ã‚Šã«ã€èª°ã§ã‚‚çŸ¥ã£ã¦ã‚‹SQLã§CREATE TABLEã‚„ALTER TABLEã‚’æ›¸ã„ã¦åŒã˜ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã—ãŸã®ãŒsqldefã§ã™ã€‚ ä½¿ç”¨ä¾‹ ç¾æ™‚ç‚¹ã§ã¯My
t-cyrill 2018/08/25
è‰¯ã•ãã†

mysql
ãƒªãƒ³ã‚¯
MySQLã®INSERTã‚’é«˜é€ŸåŒ–ã™ã‚‹Change bufferingã‚’ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ç†è§£ã™ã‚‹ - Akatsuki Hackers Lab | æ ªå¼ä¼šç¤¾ã‚¢ã‚«ãƒ„ã‚ï¼ˆAkatsuki Inc.)
èƒŒæ™¯ ã‚¢ã‚«ãƒ„ã‚ã§æä¾›ã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€ã»ã¼å…¨ã¦ã«ãŠã„ã¦AWSã®RDS(MySQL5.6, InnoDB)ã‚’ä½¿ç”¨ã—ã¦ãŠã‚Šã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã¯å¤šãã®WriteãŒã‹ã‹ã‚Šã¾ã™ãŒã€ãã®ã‚³ã‚¹ãƒˆãŒæ°—ã«ãªã£ãŸã®ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ èª¿ã¹ã¦ã¿ãŸã“ã¨ ä¸€è¨€ã«INSERTã¨ã„ã£ã¦ã‚‚ã€COMMITæ™‚ã«å³ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«åæ˜ ã•ã‚Œã‚‹ã‚ˆã†ãªå˜ç´”ãªå‡¦ç†ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ä¾‹ãˆã°INSERTã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚»ã‚«ãƒ³ãƒ€ãƒªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚‹å ´åˆã€ãã“ã«åŠ ãˆã‚‰ã‚ŒãŸå¤‰æ›´ã‚’åæ˜ ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ã¨ã“ã‚ãŒã€INSERTæ™‚ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«å†…ã«è©²å½“ã™ã‚‹ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒšãƒ¼ã‚¸ãŒç„¡ã„æ™‚ã¯ã“ã‚Œã‚’ãƒ‡ã‚£ã‚¹ã‚¯ã‹ã‚‰èªã¿ã ã™å¿…è¦ãŒã‚ã‚Šã€éžå¸¸ã«ã‚³ã‚¹ãƒˆãŒæŽ›ã‹ã‚Šã¾ã™ã€‚ InnoDBã«ã¯ã“ã‚Œã‚’æŠ‘ãˆã‚‹ãŸã‚ã®"Change buffering"ã¨ã„ã†æ©Ÿèƒ½ãŒã‚ã‚Šã€ä»Šå›žã¯ãã®è§£èª¬ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Change bufferingã¨ã¯ å¤‰æ›´ã‚’åŠ ãˆãŸãƒšãƒ¼ã‚¸ãŒãƒãƒƒ
t-cyrill 2018/08/04
mysql

innoDB
ãƒªãƒ³ã‚¯
linux-os-tuning-for-mysql-database-performance
All of Perconaâ€™s open-source software products, in one place, to download as much or as little as you need.
t-cyrill 2018/07/04
åŸºæœ¬ã ã‘ã©ä¸€é€šã‚Šã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã£ãŸ

performance

linux

mysql

sysctl
ãƒªãƒ³ã‚¯
MySQL 8.0ç™»å ´ï¼ç«‹ã¡æ¢ã¾ã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„é€²åŒ–ã¯ã“ã‚Œã‹ã‚‰ã‚‚ç¶šãã€‚
ã‚´ãƒ¼ãƒ«ãƒ‡ãƒ³ã‚¦ã‚£ãƒ¼ã‚¯ã¯ã„ã‹ãŒãŠéŽã”ã—ã•ã‚ŒãŸã ã‚ã†ã‹ã€‚ä»Šå¹´ã¯å¤©æ°—ã‚‚è‰¯ãã€è¡Œæ¥½æ—¥å’ŒãŒç¶šã„ãŸã‚ˆã†ã«æ€ã†ã€‚ ã•ã¦ã€å…ˆæ—¥MySQL 8.0ãŒæ£å¼ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸã€‚å°‘ã—æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã£ãŸãŒã€ä»Šå›žã¯MySQL 8.0ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã€‚ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç‰ˆã®ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¯ã“ã¡ã‚‰ã‹ã‚‰å¯èƒ½ã ã€‚ ã²ã¨ã¤å‰ã®æ£å¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯MySQL 5.7ã ã£ãŸã®ã ãŒã€MySQL 8.0ã¯éžå¸¸ã«å¤§ããªãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ãŒå«ã¾ã‚Œã¦ãŠã‚Šã€5.xå°ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’æ¨ã¦åŽ»ã‚ã†ã¨ã„ã†è©±ãŒã‚ã£ãŸã€‚ãã“ã§ã€æ¬¡ã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯æœ€åˆã®æ¡ã‚’å¢—ã‚„ã™ã¨ã„ã†ã“ã¨ã«ãªã£ãŸã®ã ãŒã€MySQL 6.0ã¯éŽåŽ»ã«æ—¢ã«å˜åœ¨ã—ã€è²·åŽãªã©ã®é¨’ãŽã§é–‹ç™ºãŒé “æŒ«ã—ã¦ã—ã¾ã£ãŸçµŒç·¯ãŒã‚ã‚‹ã€‚7.xã¯MySQL NDB Clusterã¨è¢«ã£ã¦ã„ã‚‹ã€‚ã¨ã„ã†ã‚ã‘ã§ã€5.7ã®7ã®éƒ¨åˆ†ã®æ¬¡ã¨ã„ã†æ„å‘³åˆã„ã‚‚ã‚ã£ã¦ã€8.0ã¨ã„ã†ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç•ªå·ã‚’å¼•ã£ã•ã’ã€æº€ã‚’æŒã—ã¦ã®ç™»å ´ã¨ãªã£ãŸã€‚ãã®
t-cyrill 2018/05/07
é€†é †ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã€order by desc limitã«åŠ¹æžœã‚ã‚‹ã®ã‹ã—ã‚‰

mysql
ãƒªãƒ³ã‚¯
ãƒ¢ãƒ³ã‚¹ãƒˆã®ã‚µãƒ¼ãƒãƒ¼è² è·ã¨ã®æˆ¦ã„ ã€œã‚ã‘ãŠã‚2018ç·¨ã€œ / bcu_30_server_9
ã‚¹ãƒžãƒ›ã‚¢ãƒ—ãƒªã€Œãƒ¢ãƒ³ã‚¹ã‚¿ãƒ¼ã‚¹ãƒˆãƒ©ã‚¤ã‚¯ã€ã®ã‚µãƒ¼ãƒãƒ¼è² è·ã¯ã€å¹´æœ«å¹´å§‹ã«1å¹´ã®ãƒ”ãƒ¼ã‚¯ã‚’è¿Žãˆã¾ã™ã€‚2018å¹´å…ƒæ—¦ã®ã‚µãƒ¼ãƒãƒ¼è² è·ã«ç«‹ã¡å‘ã‹ã†ãŸã‚ã«å®Ÿæ–½ã—ãŸå¯¾ç–ã®ä¸€ä¾‹ã¨ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ï¼ˆMySQLï¼‰ã‚’å®‰å…¨ã«æ°´å¹³åˆ†å‰²ã—ãŸäº‹ä¾‹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚è¦‹ç©ã‚‚ã‚Šã‹ã‚‰è¨ˆç”»ã€å®Ÿæ–½ã«è‡³ã‚‹ã¾ã§ã‚’æ™‚ç³»åˆ—ã§æŒ¯ã‚Šè¿”ã‚Šã¾ã™ã€‚
t-cyrill 2018/04/23
ã†ãƒ¼ã‚“ã€è¾›ãã†

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

mysql

ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
t-cyrill 2018/03/22
â€œðŸ’ªâ€

MySQL
ãƒªãƒ³ã‚¯
ActiveRecordã§INã®ä¸ãŒä¸€ä¸‡å€‹ã¨ã‹ã«ãªã‚‰ãªã„ã‚ˆã†ã«ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ã“ã®è¨˜äº‹ã¯ MySQL Casual Advent Calendar 2017 ã®23æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã¿ãªã•ã‚“ORãƒžãƒƒãƒ‘ãƒ¼ã¯ä½¿ã£ã¦ã„ã¾ã™ã‹ï¼Ÿ åƒ•ã¯ä»•äº‹ã¨ã‹è¶£å‘³ã§ActiveRecordã¨ã„ã†ORãƒžãƒƒãƒ‘ãƒ¼ã‚’ä½¿ã£ã¦ã„ã‚‹ã‚“ã§ã™ã‘ã©ã€ã“ã„ã¤ä¾‹ãˆã° Team.preload(players: :high_score).to_a ã¿ãŸã„ãªã“ã¨ã‚’ã™ã‚‹ã¨ã™ã SELECT `scores`.* FROM `scores` FROM `scores`.`id` IN (a, b, c, ...æ•°åƒå€‹ç¶šã...) ã¿ãŸã„ãªã‚¯ã‚¨ãƒªã‚’ç”Ÿæˆã—ã‚ˆã‚‹ã‚“ã§ã™ã‘ã©ã€MySQL 5.7ã«ä¸Šã’ãŸã¨ãã« range_optimizer_max_mem_size ã®åˆ¶é™ã§å®Ÿè¡Œè¨ˆç”»ãŒãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã«è½ã¡ã¦ãˆã‚‰ã„ç›®ã«ã‚ã£ãŸã“ã¨ãŒã‚ã‚Šã¾ã—ãŸã€‚MySQLå´ã§ range_optimizer_max_mem_size = 0 ã™ã‚‹ã“ã¨ã§
t-cyrill 2017/12/24
MySQL

rails
ãƒªãƒ³ã‚¯
MySQLã®FLOATåž‹ã‚’ä½¿ã†ç†ç”±ãŒè¦‹ã¤ã‹ã‚‰ãªã„ä»¶ - hnwã®æ—¥è¨˜
MySQLã®ãƒ‡ãƒ¼ã‚¿åž‹ã¨ã—ã¦FLOATåž‹ã¨ã„ã†åž‹ãŒã‚ã‚‹ã®ã§ã™ãŒã€ã“ã‚Œã‚’æŽ¡ç”¨ã™ã‚‹ã®ã¯æ··ä¹±ã®å…ƒã§ã¯ãªã„ã‹ï¼Ÿã¨æ„Ÿã˜ãŸã®ã§ã€ãã®è©³ç´°ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ãã‚‚ãã‚‚ã“ã®è©±ã®ãã£ã‹ã‘ã¯ã€ŒMySQLã§6æ¡ã¾ã§ã®å°æ•°ç‚¹ã‚’ä¸¸ã‚ãšã«æ‰±ã†ãªã‚‰FLOATåž‹ã‚’ä½¿ã†ã¹ãç†ç”±ã€ã¨ã„ã†è¨˜äº‹ãŒç›®ã«æ¢ã¾ã£ãŸã“ã¨ã§ã™ã€‚ãã‚Œãªã‚Šã«äººæ°—ã‚’é›†ã‚ã¦ã„ã‚‹è¨˜äº‹ã®ã‚ˆã†ã§ã™ãŒã€ç§ã®èªã‚“ã é™ã‚Šã§ã¯FLOATåž‹ã‚’ä½¿ã†ã ã‘ã®æ ¹æ‹ ãŒæ–‡ä¸ã‹ã‚‰èªã¿å–ã‚Œãšã€ã•ã‚‰ã«é¡žä¼¼ã™ã‚‹ä¸€æ¬¡æƒ…å ±ã‚„è‹±èªžè¨˜äº‹ãŒå…¨ãè¦‹ã¤ã‹ã‚‰ãªã‹ã£ãŸã®ã§ã€çœŸå½ãŒæ€ªã—ã„æƒ…å ±ã ã¨æ„Ÿã˜ã¾ã—ãŸã€‚ ãã®å¾Œã€MySQLä¸Šã§å®Ÿé¨“ã—ãŸã‚ŠCã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã¿ãŸã‚Šã—ãŸçµæžœã€ç§ã®å¾—ãŸçµè«–ã¯çœŸé€†ã®ã‚‚ã®ã«ãªã‚Šã¾ã—ãŸã€‚MySQLè¦å¯Ÿã®æ–¹ã‚„æµ®å‹•å°æ•°ç‚¹æ•°è¦å¯Ÿã®æ–¹ã€è¿½è©¦ã‚„åè«–ãªã©é ‚ã‘ã‚‹ã¨åŠ©ã‹ã‚Šã¾ã™ã€‚ MySQLã®FLOATåž‹ã¨ã¯ MySQLã®FLOATåž‹ã¯åŽŸå‰‡ã¨ã—ã¦IEEE754æµ®å‹•å°æ•°ç‚¹æ•°å˜ç²¾åº¦åž‹ï¼ˆ32bitï¼‰ã§å®Ÿç¾ã•ã‚Œã¾ã™*1ã€‚
t-cyrill 2017/12/22
MySQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
ãƒªãƒ³ã‚¯
Top 20+ MySQL Best Practices | Envato Tuts+
Database operations often tend to be the main bottleneck for most web applications today. It's not only the DBA's (database administrators) that have to worry about these performance issues. We as programmers need to do our part by structuring tables properly, writing optimized queries and better code. In this article, I'll list some MySQL optimization techniques for programmers. Before we start,
t-cyrill 2017/11/16
ãªã‚“ã§ã“ã‚“ãªã®ãŒã„ã¾ã•ã‚‰ï¼Ÿ

MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’å‰²ã¨ä¸€äººã§300å°ç®¡ç†ã™ã‚‹æŠ€è¡“
14. MySQLã®â¾¯å€’ã‚’â¾’ã‚‹ #ã¨ã¯ DBã«ç‰¹åŒ–ã—ãŸï¼ˆåºƒç¾©ã®ï¼‰ã‚¤ãƒ³ãƒ•ãƒ©ãƒ‡ã‚¶ã‚¤ãƒ³ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã®é »åº¦, ä¿ç®¡å…ˆ, ..etc. + ãã®å®Ÿè£…- ç›£è¦–, ãƒªã‚½ãƒ¼ã‚¹ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°, ..etc. + ãã®å®Ÿè£…- mikasafabric for MySQL + MySQL Router- ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®æ¤œè¨¼ã¨ã‹ã€Percona Serverã¨ã‹ MariaDBã¨ã‹ - DBã«ç‰¹åŒ–ã—ãŸã‚·ãƒ§ãƒƒãƒˆä½œæ¥ åŠã‚‹ã—ã® ALTER TABLE ä»¥å¤–ã‚’ä½¿ã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã®æ›´æ–° < 5.6 ã ã£ãŸã‚Šã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒâ¼¤ãã™ãŽã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè©°ã¾ã£ãŸã‚Šã™ã‚‹ã‚±ãƒ¼ã‚¹ - ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°- ãƒžã‚¤ãƒŠãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—- 13/63
t-cyrill 2017/09/06
ä¼šç¤¾ã®æ•°ã ã‘ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ‘ã‚¿ãƒ¼ãƒ³ãŒã‚ã‚‹ã¨èžã„ã¦é ãŒç—›ããªã‚Šã¾ã—ãŸãƒ»ãƒ»ãƒ»

MySQL

é‹ç”¨
ãƒªãƒ³ã‚¯
SREã‚°ãƒ«ãƒ¼ãƒ—ãŒã§ãã¦ã“ã®åŠå¹´é–“ã‚„ã£ã¦ããŸã“ã¨
SRE Tech Talks #2 XFLAG ã‚¹ã‚¿ã‚¸ã‚ªã«ãŠã‘ã‚‹SREã®ç´¹ä»‹ã€MySQL, InnoDB, THPã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãªã©
t-cyrill 2017/01/31
MySQL

ã‚¤ãƒ³ãƒ•ãƒ©

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

kernel

linux
ãƒªãƒ³ã‚¯
MySQLã®COUNTã‚’é€Ÿãã™ã‚‹ï¼ˆï¼Ÿï¼‰SQL1æœ¬ãƒŽãƒƒã‚¯ ãã®2
ã“ã®è¨˜äº‹ã¯ MySQL Casual Advent Calendar 2016 ã®23æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ãã—ã¦ã©ã†ã‚„ã‚‰ã€ æ—¥ã€…ã®è¦šæ›¸Â ã®400æœ¬ç›®ã®å…¬é–‹è¨˜äº‹ã§ã™ã€‚ãã‚“ãªã«æ›¸ã„ã¦ãŸã®ã‹ã€‚ã€‚ å‰å›ž ã®ã‚ã‚‰ã™ã˜ã€‚ mysql57> SHOW CREATE TABLE game_score\G *************************** 1. row *************************** Table: game_score Create Table: CREATE TABLE `game_score` ( `seq` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `game_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `play_end_time` datetime N
t-cyrill 2016/12/23
MySQL

ãƒˆãƒªã‚¬ãƒ¼

ãƒãƒƒã‚¯
ãƒªãƒ³ã‚¯
MySQLã‚„SSDã¨ã‹ã®è©±ã€€ãã®å¾Œ | GREE Engineering
ã“ã‚“ã«ã¡ã‚ã€‚ã›ã˜ã¾ã§ã™ã€‚ ã™ã¹ã¦ã®åŸºæœ¬ã¯ monitoring ã ã¨è€ƒãˆã¦ã‚‹ã®ã§ã€ã‚¤ãƒžãƒ‰ã‚ã®ã‚¦ã‚§ã‚¢ãƒ©ãƒ–ãƒ«ãƒ‡ãƒã‚¤ã‚¹ã„ã‚ã„ã‚è²·ã£ã¦ã„ã‚ã„ã‚è¨ˆæ¸¬ã—ã¦ã‚‹ã‚“ã§ã™ãŒã€æœ€è¿‘ã®ãƒ‡ã‚¸ã‚¿ãƒ«ã‚¬ã‚¸ã‚§ãƒƒãƒˆé¢ç™½ã„ãªãï¼’ï¼‘ä¸–ç´€æ„Ÿãƒ‘ãªã„ã¨æ„Ÿå¿ƒã—ã¾ãã£ã¦ã‚‹ä»Šæ—¥ã“ã®ã”ã‚ã§ã™ã€‚ ã¡ã‚‡ã†ã©ä¸€å¹´ãã‚‰ã„å‰ã€ MySQL User Conference Tokyo 2015 ã§ MySQLã‚„SSDã¨ã‹ã®è©±ã€€å‰ç·¨ã‚’ã€ GREE Tech Talk #9 ã§ MySQLã‚„SSDã¨ã‹ã®è©±ã€€å¾Œç·¨ã‚’ã€ãŠè©±ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ãã®å¾Œã©ã†ãªã£ãŸã®ï¼Ÿã¨ã„ã†ã“ã¨ã§ã€å¾Œæ—¥è«‡ã‚’ã¾ã¨ã‚ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ï¼ˆä»Šå›žã¯MySQLæˆåˆ†ãã‚Œã»ã©ã‚ã‚Šã¾ã›ã‚“ï¼‰ å¿™ã—ã„äººã®ãŸã‚ã«ä¸‰è¡Œã§ã¾ã¨ã‚ã‚‹ã¨ ä»¥å‰ã®è©¦ã¿ã¯ã‚ã‚Šã¨ã†ã¾ãã„ãã¾ã—ãŸã€‚ SSDã®å¤§å®¹é‡åŒ–ãŒã•ã‚‰ã«é€²ã‚“ã§ã¾ã™ã—ã€å‰å›žã®çµŒé¨“ã‚’æ´»ã‹ã—ã¦ã€HDDç©ã‚“ã ã‚µãƒ¼ãƒã®æ§‹æˆå¤‰æ›´ã—ã¾ã—ãŸã€‚ æ¬¡ã®ã‚¹ãƒ†ãƒ¼ã‚¸ã¨ã—ã¦ã¯ã€ï¼‘ãƒ©ãƒƒã‚¯ã‚ãŸã‚Š
t-cyrill 2016/12/16
MySQL

SSD

ã‚µãƒ¼ãƒ

ã‚ªãƒ³ãƒ—ãƒ¬ãƒŸã‚¹
ãƒªãƒ³ã‚¯
MySQLã«é‡å¤§ãªè„†å¼±æ€§è¦‹ã¤ã‹ã‚‹ã€ãƒ‘ãƒƒãƒå˜åœ¨ã›ãšãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§å½±éŸ¿
æ”»æ’ƒã«åˆ©ç”¨ã•ã‚ŒãŸå ´åˆã€rootæ¨©é™ã§ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã€ã‚µãƒ¼ãƒã‚’åˆ¶å¾¡ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹ã€‚ ç±³Oracleå‚˜ä¸‹ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ŒMySQLã€ã«æœªè§£æ±ºã®è„†å¼±æ€§ãŒè¦‹ã¤ã‹ã£ãŸã¨ã—ã¦ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ç ”ç©¶è€…ãŒ9æœˆ12æ—¥ã«æ¦‚ç•¥ã‚„ã‚³ãƒ³ã‚»ãƒ—ãƒˆå®Ÿè¨¼ã‚³ãƒ¼ãƒ‰ã‚’å…¬é–‹ã—ãŸã€‚ã‚µã‚¤ãƒãƒ¼æ”»æ’ƒã«åˆ©ç”¨ã•ã‚ŒãŸå ´åˆã€rootæ¨©é™ã§ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã‚’å®Ÿè¡Œã•ã‚Œã€ã‚µãƒ¼ãƒã‚’åˆ¶å¾¡ã•ã‚Œã‚‹å¯èƒ½æ€§ãŒæŒ‡æ‘˜ã•ã‚Œã¦ã„ã‚‹ã€‚ ç ”ç©¶è€…ã®Dawid Golunskiæ°ãŒå…¬é–‹ã—ãŸæƒ…å ±ã«ã‚ˆã‚Œã°ã€MySQLã®è„†å¼±æ€§ã¯è¤‡æ•°ç™ºè¦‹ã•ã‚Œã€ã€ä¸ã§ã‚‚ç‰¹ã«æ·±åˆ»ãª1ä»¶ã«ã¤ã„ã¦ã¯ã€ãƒªãƒ¢ãƒ¼ãƒˆã®æ”»æ’ƒè€…ãŒMySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã«ä¸æ£ãªå†…å®¹ã‚’ä»•è¾¼ã‚€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³æ”»æ’ƒã«åˆ©ç”¨ã•ã‚Œã‚‹æã‚ŒãŒã‚ã‚‹ã€‚ ã“ã®è„†å¼±æ€§ã¯ã€MySQLã®æœ€æ–°ç‰ˆã‚’å«ã‚€5.7ç³»ã€5.6ç³»ã€5.5ç³»ã®å…¨ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®çŠ¶æ…‹ã§å˜åœ¨ã™ã‚‹ã€‚ç¾æ™‚ç‚¹ã§Oracle MySQLã‚µãƒ¼ãƒã®è„†å¼±æ€§ä¿®æ£ãƒ‘ãƒƒãƒã¯å˜åœ¨
t-cyrill 2016/09/13
ã¤ã‚‰ã„

MySQL

è„†å¼±æ€§
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸