[B! MySQL] ikosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ikosin id:ikosin

MySQLã«é–¢ã™ã‚‹ikosinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (239)

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

ç¬¬180å›žã€€MySQLã®ãƒ¡ã‚¿ãƒ‡ãƒ¼ã‚¿ãƒãƒƒã‚¯ã«ã¤ã„ã¦ | gihyo.jp
é »ç¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã•ã‚Œã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã“ã®å•é¡ŒãŒèµ·ã“ã‚‹ã¨ã€ã‚µãƒ¼ãƒ“ã‚¹ã‹ã‚‰ã®ã™ã¹ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ãŒå¾…æ©Ÿã•ã‚Œã€ã‚µãƒ¼ãƒ“ã‚¹éšœå®³ã«ã¤ãªãŒã‚‹å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ãã®ãŸã‚ã€MySQLã§ã¯ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯æ¥µåŠ›å°ã•ãä¿ã¤ã“ã¨ã¨ã€commitã‚„rollbackæ¼ã‚Œã«ã‚ˆã‚‹çµ‚äº†ã™ã‚‹ã“ã¨ã®ãªã„ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é˜²ãŒãªã‘ã‚Œã°ã„ã‘ã¾ã›ã‚“ã€‚ ã‚‚ã—ã€ã“ã®å•é¡ŒãŒèµ·ã“ã£ã¦ã—ã¾ã£ãŸéš›ã«è§£æ¶ˆã™ã‚‹ã«ã¯ä»¥ä¸‹ã®æ–¹æ³•ã«ãªã‚Šã¾ã™ã€‚ session1ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæ£å¸¸çµ‚äº†ã™ã‚‹ã¾ã§å¾…ã¤ session1ã‚’killã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã§å¼·åˆ¶çµ‚äº†ã•ã›ã‚‹ session2ã®DDLã‚’ã‚ãƒ£ãƒ³ã‚»ãƒ«ã™ã‚‹ã€ã¾ãŸã¯ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã•ã‚Œã‚‹ã¾ã§å¾…ã¤ï¼ˆlock_wait_timeoutãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ï¼‰ 1.ã«ã¤ã„ã¦ã¯ã€ãŸã¾ãŸã¾ãƒãƒ³ã‚°ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒå®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹ã®ã§ã‚ã‚Œã°ã€ã“ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæ£å¸¸çµ‚äº†ã™ã‚‹ã¾ã§å¾…ã£ã¦ã‹ã‚‰ã€DDLã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ 2.ã«ã¤ã„ã¦ã¯ã€æ£å¸¸çµ‚äº†ã™ã‚‹è¦‹è¾¼ã¿ã®ãªã„äºˆ
ikosin 2024/12/11
mysql
ãƒªãƒ³ã‚¯
å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®ALTER TABLEä¸€æ’ƒã§ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã€‚ãã“ã‹ã‚‰å¦ã‚“ã æƒ¨äº‹ã‚’ç¹°ã‚Šè¿”ã•ãªã„ãŸã‚ã®ãƒ«ãƒ¼ãƒ«ä½œã‚Š - Qiita
ã“ã¡ã‚‰ã¯ NewsPicksã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã®9æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚NewsPicks ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®é¶´æˆ¿ã§ã™ã€‚ ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®åˆ·æ–°ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦ã€ä¸»ã«ã‚¤ãƒ³ãƒ•ãƒ©ã¨ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’æ‹…å½“ã—ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ç§ãŒä»¥å‰èµ·ã“ã—ã¦ã—ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹å…¨åœæ¢ã®éšœå®³ã®åŽŸå› ã¨ã€ãã®å†ç™ºé˜²æ¢ç–ã«é–¢ã—ã¦è¨˜è¼‰ã—ã¾ã™ã€‚ å°šã€å¼Šç¤¾ã§ã¯RDBMSã¨ã—ã¦MySQLã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã®ã§ã€ã“ã®è¨˜äº‹ã¯MySQLã«é–¢ã™ã‚‹å†…å®¹ã«ãªã‚Šã¾ã™ã€‚ éšœå®³äº‹è±¡ ä»Šå¹´ã®å¤é ƒã€ç´„30åˆ†ã®é–“ã€NewsPicksã®ã»ã¼å…¨ã¦ã®ã‚µãƒ¼ãƒ“ã‚¹ãŒåœæ¢ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ã€ãã®é–“ã€ãƒã‚°ã‚¤ãƒ³ã‚‚ã€è¨˜äº‹ã‚’èªã‚€ã“ã¨ã‚‚ã€è¨˜äº‹ã«ã‚³ãƒ¡ãƒ³ãƒˆã™ã‚‹ã“ã¨ã‚‚ã§ããªã„çŠ¶æ…‹ã§ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚’é–‹ãã¨ã€ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã ã‘ã®çŠ¶æ…‹ã§ã€éšœå®³ã®è§£æ¶ˆã¾ã§ãšã£ã¨ãã®çŠ¶æ…‹ãŒç¶šã„ã¦ã„ã¾ã—ãŸã€‚ éšœå®³ã®ç›´æŽ¥åŽŸå› éšœå®³ã®ç›´æŽ¥ã®å¼•ãé‡‘ã«ãªã£ãŸã®ã¯ã€ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚ã‚‹é€šã‚ŠALTE
ikosin 2024/12/11
mysql

éšœå®³
ãƒªãƒ³ã‚¯
note ã® Aurora MySQL ã‚’ v2 ã‹ã‚‰ v3 ã¸ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã—ã¾ã—ãŸï½œtic40
note ã§ã¯ãƒ¡ã‚¤ãƒ³ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ Aurora MySQL ã‚’æŽ¡ç”¨ã—ã€æ—¥ã€…ç™ºç”Ÿã™ã‚‹è†¨å¤§ãªãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’å‡¦ç†ã—ã¦ã„ã¾ã™ã€‚Aurora MySQL v2 (MySQL 5.7 äº’æ›) ã®æ¨™æº–ã‚µãƒãƒ¼ãƒˆã¯2024/10/31 ã«çµ‚äº†ã™ã‚‹ãŸã‚ã€ã“ã‚Œã‚’æ©Ÿã« v3 (MySQL 8.0 äº’æ›) ã¸ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’è¡Œã„ã¾ã—ãŸã€‚ ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã¯ç„¡äº‹ã«å®Œäº†ã—ã¾ã—ãŸãŒã€ã„ãã¤ã‹ã®å•é¡Œã«ã‚‚ç›´é¢ã—ã¾ã—ãŸã€‚ã“ã‚Œã‚‰ã‚’å…±æœ‰ã™ã‚‹ã“ã¨ã§ã€ã“ã‚Œã‹ã‚‰ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹æ–¹ã¸å‚è€ƒã«ãªã‚Œã°ã¨æ€ã„ã¾ã™ã€‚ äº‹å‰ã«æ¤œè¨Žã—ãŸèª²é¡Œã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰å¾Œã«è‡´å‘½çš„ãªå•é¡ŒãŒèµ·ããŸã‚‰ã©ã†ã™ã‚‹ã‹v3 ã¸ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰å¾Œã« v2 ã¸åˆ‡ã‚Šæˆ»ã™ã“ã¨ã¯å®¹æ˜“ã§ã¯ãªãã€ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆãªã©ã‹ã‚‰ã®å¾©å…ƒãŒå¿…è¦ã«ãªã‚Šã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã™ã‚‹ã“ã¨ã«ãªã‚‹ãŸã‚ã€ãƒ¦ãƒ¼ã‚¶å½±éŸ¿ãŒæ¥µã‚ã¦å¤§ããé¿ã‘ãŸã„äº‹æ…‹ã§ã™ã€‚ ãã®ãŸã‚ã€åŸºæœ¬çš„ã«åˆ‡ã‚Šæˆ»ã—ã¯ã§ããªã„ã¨ã„ã†å‰æã§ã‚¢ãƒƒ
ikosin 2024/04/30
mysql
ãƒªãƒ³ã‚¯
é–‹ç™ºè€…å‘ã‘ MySQL å…¥é–€ / MySQL 101 for Developers
èƒŒæ™¯ãªã©ã¯ https://wrsn0.hatena blog.com/entry/2024/02/22/092703 ã¸
ikosin 2024/04/06
mysql
ãƒªãƒ³ã‚¯
MySQL(InnoDB)ã®SQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ã‚¨ãƒƒã‚»ãƒ³ã‚¹
ã¯ã˜ã‚ã« MySQL(InnoDB)ã§SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã™ã‚‹ã¨ãã«å½¹ã«ç«‹ã¤çŸ¥è˜ã‚’ã‚¨ãƒƒã‚»ãƒ³ã‚¹ã¨ã—ã¦ã¾ã¨ã‚ã¾ã—ãŸã€‚çµåˆ(JOIN)ã‚„B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æŽ¢ç´¢ã®ä»•çµ„ã¿ã€å®Ÿè¡Œè¨ˆç”»ã®åŸºæœ¬çš„ãªè¦‹æ–¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ æƒ³å®šã™ã‚‹èªè€…ã¯ã€SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ãŒå®Ÿè¡Œè¨ˆç”»ã‚’ã¿ã¦ã‚‚ã„ã¾ã„ã¡ãƒ”ãƒ³ã¨æ¥ãªã„æ–¹ã§ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆã®çµŒé¨“ã‚„ã€è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ã‚«ãƒ¼ãƒ‡ã‚£ãƒŠãƒªãƒ†ã‚£ã®çŸ¥è˜ãŒã‚ã‚‹ã“ã¨ã‚’å‰æã«ã—ã¦ã„ã¾ã™ã€‚ç›®æ¨™ã¯ã€å®Ÿè¡Œè¨ˆç”»ã®å†…å®¹ãŒã‚ˆãåˆ†ã‹ã‚‰ãªã„èªè€…ãŒã€å®Ÿè¡Œè¨ˆç”»ã‚’ã¿ãŸã ã‘ã§ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•ã‚Œã‚‹æ§˜åã‚’ã‚¤ãƒ¡ãƒ¼ã‚¸ã§ãã€è‡ªä¿¡ã‚’æŒã£ã¦ã‚¯ã‚¨ãƒªã®æ”¹å–„ã«ã‚ãŸã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ã“ã¨ã§ã™ã€‚ ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¯InnoDBã‚’å‰æã¨ã—ã¦ã„ã¾ã™ã€‚ã¾ãŸã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯B-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚å…¨æ–‡æ¤œç´¢ã®è»¢ç½®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚„ç©ºé–“æ¤œç´¢ã®R-treeã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯è§¦ã‚Œã¾ã›ã‚“ã€‚ ã‚¤ãƒ³
ikosin 2024/03/19
mysql

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

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ
ãƒªãƒ³ã‚¯
MySQLã® Innovation ã¨ Long-Term Support (LTS) ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ã”ç´¹ä»‹
ikosin 2024/03/15
mysql
ãƒªãƒ³ã‚¯
Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility) | Amazon Web Services
AWS Database Blog Upgrade to Amazon Aurora MySQL version 3 (with MySQL 8.0 compatibility) Amazon Aurora MySQL-Compatible Edition version 3 (with MySQL 8.0 compatibility) is the most current major version supported on Amazon Aurora MySQL. You can use Amazon Aurora MySQL version 3 to get the latest MySQL-compatible features and performance improvements. MySQL 8.0 introduces several new features, inc
ikosin 2024/01/29
aws

MySQL
ãƒªãƒ³ã‚¯
yokuã•ã‚“ã«utf8â†’utf8mb4binã®ã¨ãã«æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸä¾¿åˆ©Tips
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
ikosin 2023/12/14
MySQL
ãƒªãƒ³ã‚¯
PostgreSQLã¨MySQLã®ãƒ¡ã‚¸ãƒ£ãƒ¼ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ãŸã‚ã®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆä½œã£ãŸ - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼š in å²¡å±±ã®ç™»å£‡è³‡æ–™ã§ã™ã€‚ ãã®ã†ã¡ã“ã“ã§ç™»å£‡å‹•ç”»ãŒå…¬é–‹ã•ã‚Œã‚‹ã“ã¨ã§ã—ã‚‡ã†ã€‚ è‚å¿ƒãªãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã¯ä»¥ä¸‹ã®ã¨ãŠã‚Šã€‚ PostgreSQL gist.github.com MySQL gist.github.com ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã ã‘ã˜ã‚ƒã‚ã‹ã‚‰ãªã„ï¼å›°ã£ã¦ã‚‹ï¼ Have Fun TechãŒãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã®ã‚µãƒãƒ¼ãƒˆã—ã¾ã™ã®ã§ãŠæ°—è»½ã«ã”ç›¸è«‡ãã ã•ã„ã€‚ have-fun.tech ã¾ã¨ã‚ ã‚„ã£ã±ä¸å›½åœ°æ–¹DBå‹‰å¼·ä¼šã¯æœ€é«˜ã ãœï¼
ikosin 2023/10/09
mysql

postgresql
ãƒªãƒ³ã‚¯
MySQLã§Nested Loopãªã‚¯ã‚¨ãƒªã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã©ã†è¾¿ã£ã¦ã„ã‚‹ã‹ - $shibayu36->blog;
ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³çš„ãªã‚‚ã®ã‚’SELECTã ã‘ã§å®Ÿè£…ã—ã‚ˆã†ã¨æ€ã£ãŸæ™‚ã«ã€Nested Loopãªã‚¯ã‚¨ãƒªã§Using temporary; Using filesortãŒå‡ºã‚‹ã‚ˆã†ãªãã“ãã“é…ã„ã‚¯ã‚¨ãƒªã«ãªã‚‹ã€‚ãã®æ™‚ã«MySQLãŒã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã©ã†è¾¿ã£ã¦ã„ã‚‹ã‹ã‚’çŸ¥ã‚ŠãŸã‹ã£ãŸã®ã§èª¿ã¹ã¦ã¿ãŸã€‚MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯8.0.33ã€‚ ã‚ã¾ã‚Šè‡ªä¿¡ã¯ãªã„ã®ã§ã€ã‚‚ã—é–“é•ã£ãŸè©±ã‚’ã—ã¦ã„ãŸã‚‰æ•™ãˆã¦æ¬²ã—ã„ã€‚ ã©ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’æ¤œè¨¼ã™ã‚‹ã‹ ã‚¿ã‚¤ãƒ ãƒ©ã‚¤ãƒ³ã®å–å¾—ãŒã§ãã‚‹ã‚ˆã†ãªã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ãƒ»ãƒ•ã‚©ãƒãƒ¼é–¢ä¿‚ãƒ»æŠ•ç¨¿ã®3ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã¯æ¬¡ã®é€šã‚Šã€‚ CREATE TABLE users ( id INTEGER PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100) NOT NULL ); CREATE TABLE follows ( id INTEGER PRIMARY KEY AUTO_I
ikosin 2023/07/18
db

mysql
ãƒªãƒ³ã‚¯
MySQL with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
ikosin 2023/07/16
mysql

db

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Aurora Serverless v2ã‚’æœ¬ç•ªå°Žå…¥ã—ãŸè©± ã€œæ¤œè¨Žã‚„å°Žå…¥æ™‚ã®ãƒã‚¤ãƒ³ãƒˆãƒ»å¾—ã‚‰ã‚ŒãŸåŠ¹æžœã«ã¤ã„ã¦ã€œ - ZOZO TECH BLOG
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚SREéƒ¨ECãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ åŸºç›¤SREãƒ–ãƒãƒƒã‚¯ã®çŸ³ç”°ã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€Aurora Serverless v2ã‚’æœ¬ç•ªå°Žå…¥ã™ã‚‹ã«ã‚ãŸã£ã¦ã©ã®ã‚ˆã†ãªæ¤œè¨Žã‚’ã—ã€ã©ã®ã‚ˆã†ã«å°Žå…¥ã—ã¦ã„ã£ãŸã‹ã€ã¾ãŸå°Žå…¥å¾Œã«å¾—ã‚‰ã‚ŒãŸåŠ¹æžœã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« Aurora Serverless ã¨ã¯ èƒŒæ™¯ æ¯”è¼ƒæ¤œè¨Ž æ¯”è¼ƒå†…å®¹ æ–¹é‡ã®æ±ºå®š ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ å°Žå…¥ 1. Aurora Serverless v2ã‚’æ‰‹å‹•ã§æ§‹ç¯‰ 2. AWS CloudFormationã§Provisionedåž‹Aurora MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³3ã‚’å†æ§‹ç¯‰ 3. AWS CloudFormationã§Aurora Serverless v2ã«ç§»è¡Œ 4. è² è·è©¦é¨“ãƒ»éšœå®³è©¦é¨“ è² è·è©¦é¨“ éšœå®³è©¦é¨“ å°Žå…¥ã«ã‚ˆã‚Šå¾—ã‚‰ã‚ŒãŸåŠ¹æžœ æŸ”è»Ÿãªã‚¹ã‚±ãƒ¼ãƒªãƒ³ã‚° ã‚¤ãƒ³ãƒ•ãƒ©ã‚³ã‚¹ãƒˆ æœ€å¾Œã« Aurora Serverless ã¨ã¯ Aurora
ikosin 2023/03/17
aws

mysql
ãƒªãƒ³ã‚¯
MySQLã®æ©Ÿèƒ½ã§ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªé–¢é€£ã®è§£æžã‚’è¡Œã†æ–¹æ³•ã®ç´¹ä»‹ - ã‚¨ã‚ã‚µã‚¤ãƒˆ TechBlog.
ã¯ã˜ã‚ã« XTechã‚°ãƒ«ãƒ¼ãƒ— Advent Calendar 2021ã®16æ—¥ç›®ã¯ã€iXITæ ªå¼ä¼šç¤¾ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®è¦åãŒãŠé€ã‚Šã—ã¾ã™ã€‚ æœ€è¿‘ãƒãƒžã£ã¦ã„ã‚‹ã‚‚ã®ã¯éŸ³æ¥½ç³»Vtuberã§ã™ã€‚VIRTUAFREAKè‰¯ã‹ã£ãŸâ€¦ã€‚ qiita.com æœ¬é¡Œ ãƒ„ãƒ¼ãƒ«ãªã©ã‚’å°Žå…¥ã—ãªãã¦ã‚‚SlowQueryã‚’è§£æžã§ãã‚‹æ©Ÿèƒ½ãŒMySQLã«ã¯å˜åœ¨ã™ã‚‹ã®ã§ã€ä»Šå›žã¯ãã®ä¸€éƒ¨ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã¡ãªã¿ã«ç§ãŒé–‹ç™ºã—ã¦ã„ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã®MySQLãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯5.6ã§ã™ã€‚ 1. mysqldumpslow ä¸€è¨€ã§è¨€ã†ã¨ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è§£æžã—ã¦å†…å®¹ã®ã‚µãƒžãƒªãƒ¼ã‚’å‡ºåŠ›ã—ã¦ãã‚Œã‚‹æ©Ÿèƒ½ã§ã™ã€‚ å‰æã¨ã—ã¦ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒ¼ãƒã‚°ã‚’å‡ºåŠ›ã—ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ä½¿ã„æ–¹ ã‚³ãƒžãƒ³ãƒ‰ â€»åˆè¨ˆå®Ÿè¡Œæ™‚é–“ãŒé•·ã„é †ã«10ä»¶ã®SQLã‚’å‡ºåŠ›ã™ã‚‹ mysqldumpslow -s at -t 10 /opt/fio1/slog/sp-prd-db1-slow.
ikosin 2023/01/11
mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
GitHub - tkuchiki/slp: SlowLog Profiler for MySQL and PostgreSQL
$ slp --help slp is a MySQL/PostgreSQL SlowLog Profiler Usage: slp [flags] slp [command] Available Commands: completion Generate the autocompletion script for the specified shell diff Show the difference between the two profile results help Help about any command my Profile the slowlogs for MySQL pg Profile the slowlogs for PostgreSQL Flags: --config string The configuration file -h, --help help f
ikosin 2022/07/26
mysql
ãƒªãƒ³ã‚¯
GitHub - sqldef/sqldef: Idempotent schema management for MySQL, PostgreSQL, and more
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
ikosin 2022/07/25
mysql

postgresql

é‹ç”¨
ãƒªãƒ³ã‚¯
æŽ’ä»–åˆ¶å¾¡ã®ãŸã‚ã ã‘ã« Redis æ¸‹ã€…ä½¿ã£ã¦ã¾ã›ã‚“ã‹ï¼Ÿãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å˜ç‹¬ã§ã‚¢ãƒ‰ãƒã‚¤ã‚¶ãƒªãƒ¼ãƒãƒƒã‚¯ã§ãã‚‹ã‚ˆï¼
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã¤ã„ã¦ã®æ•™é¤ŠãŒã‚ã£ãŸã»ã†ãŒã“ã®è¨˜äº‹ã®å†…å®¹ã‚’ç†è§£ã—ã‚„ã™ã„ãŸã‚ï¼Œå¿…è¦ã«å¿œã˜ã¦ã¾ãšä»¥ä¸‹ã‚’å‚ç…§ã•ã‚ŒãŸã„ã€‚ èƒŒæ™¯ ä»¥å‰ï¼Œ Qiita ã§ä»¥ä¸‹ã®è¨˜äº‹ã‚’æŠ•ç¨¿ã—ãŸã€‚ä»Šå›žã®è°é¡Œã«ç›´æŽ¥çš„ãªé–¢ä¿‚ã¯ãªã„ãŒï¼Œé–¢é€£ã—ã¦ã„ã‚‹éƒ¨åˆ†ãŒã‚ã‚‹ãŸã‚å¼•ç”¨ã™ã‚‹ã€‚ MySQL/Postgres ã¨ã‚‚ï¼Œ MVCC ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®æ©æµã§ï¼Œ SELECT ã¨ UPDATE ã¯åŸºæœ¬çš„ã«ã¯ç«¶åˆã—ãªã„ã€‚ å˜ä¸€ãƒ¬ã‚³ãƒ¼ãƒ‰ã®ã‚·ãƒ³ãƒ—ãƒ«ãª UPDATE ã§ã‚‚æŽ’ä»–ãƒãƒƒã‚¯ã•ã‚Œï¼ŒæŽ’ä»–ãƒãƒƒã‚¯ä¸ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã¸ã® UPDATE ã§ã®å¤‰æ›´æ“ä½œã¯ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã«ã‚ˆã‚‰ãš ãƒ–ãƒãƒƒã‚¯ã•ã‚Œã‚‹ã€‚UPDATE æ–‡ã«å«ã¾ã‚Œã‚‹ WHERE å¥ã§ã®æ¤œç´¢ã‚‚ãƒ–ãƒãƒƒã‚¯ã•ã‚Œï¼Œã“ã‚Œã¯ãƒ–ãƒãƒƒã‚¯ã•ã‚Œãªã„ SELECT ã«ã‚ˆã‚‹æ¤œç´¢ã¨ã¯åˆ¥æ‰±ã„ã«ãªã‚‹ã€‚ ä½†ã— UPDATE æ–‡ã® WHERE å¥ä¸Šã§ï¼Œæ›´æ–°å¯¾è±¡ã‚’ã‚µãƒ–ã‚¯ã‚¨ãƒªã® SELECT ã‹ã‚‰è‡ªå·±å‚ç…§ã—ã¦ã„ã‚‹å ´åˆã¯ä¾‹å¤–ã€‚
ikosin 2022/07/07
mysql

redis

postgresql

db

è¨è¨ˆ
ãƒªãƒ³ã‚¯
The ultimate MySQL database platform
Scale, performance, and reliabilityScale, performance, and reliabilitypowered by Vitess The MySQL database platform built for scalePlanetScale is built on Vitess and unlocks performance, scalability, and cost optimization for hyperscale databases through horizontal sharding.
ikosin 2022/01/19
db

mysql
ãƒªãƒ³ã‚¯
Aurora MySQL version 3 compatible with MySQL 8.0 - Amazon Aurora
You can use Aurora MySQL version 3 to get the latest MySQL-compatible features, performance enhancements, and bug fixes. Following, you can learn about Aurora MySQL version 3, with MySQL 8.0 compatibility. You can learn how to upgrade your clusters and applications to Aurora MySQL version 3. Some Aurora features, such as Aurora Serverless v2, require Aurora MySQL version 3. Features from MySQL 8.0
ikosin 2021/11/19
aws

MySQL
ãƒªãƒ³ã‚¯
6.2.21Â MySQL ã¸ã®æŽ¥ç¶šã®å•é¡Œã®ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°
ikosin 2021/09/24
MySQL
ãƒªãƒ³ã‚¯
MySQLã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’UUIDã«ã™ã‚‹å‰ã«çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã“ã¨ | Raccoon Tech Blog [æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ æŠ€è¡“æˆ¦ç•¥éƒ¨ãƒ–ãƒã‚°]
æ ªå¼ä¼šç¤¾ãƒ©ã‚¯ãƒ¼ãƒ³ãƒ›ãƒ¼ãƒ«ãƒ‡ã‚£ãƒ³ã‚°ã‚¹ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢/ãƒ‡ã‚¶ã‚¤ãƒŠãƒ¼ã‹ã‚‰æŠ€è¡“æƒ…å ±ã‚’ã¯ã˜ã‚ã€ä¸–ã®ä¸ã®ãŸã‚ã«ãªã‚‹ã“ã¨ã‚„ç¤¾å†…ã®ã“ã¨ãªã©ã‚’ç™ºä¿¡ã—ã¦ã¾ã™ã€‚ bashãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹MySQLInnoDB DBè¨è¨ˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ ã“ã‚“ã«ã¡ã¯ã€ç¾½å±±ã§ã™ã€‚ ä»Šå›žã¯ MySQL ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã« UUID ã‚’æŽ¡ç”¨ã™ã‚‹å ´åˆã«èµ·ãã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®å•é¡Œã‚’ä»•çµ„ã¿ã‹ã‚‰è§£èª¬ã—ã¾ã™ã€‚ MySQL(InnoDB) & UUID ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«ã¤ã„ã¦ã¯å„æ‰€ã§ã•ã‚“ã–ã‚“è°è«–ãƒ»æ¤œè¨¼ã•ã‚Œã¦ã„ã¾ã™ãŒã€è«–ç†çš„ã«è§£èª¬ã—ãŸè¨˜äº‹ãŒå°‘ãªã‹ã£ãŸã‚Šä¸€éƒ¨ã«ã¯èª¤è§£ã‚’æ‹›ãã‚ˆã†ãªã‚‚ã®ã‚‚ã‚ã‚‹ãŸã‚ã€ã—ã£ã‹ã‚Šã¨ç†ç”±ã‹ã‚‰ç†è§£ã™ã‚‹ãŸã‚ã®æƒ…å ±ã¨ã—ã¦å½¹ç«‹ã¤ã“ã¨ãŒã§ãã‚Œã°ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ UUID ã¨æ¯”è¼ƒã•ã‚Œã‚‹å¤ãè‰¯ãæ˜‡é †/é™é †ã®ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã¯ã¨ã„ã†ã¨ã€ MySQL ã® InnoDB ã«ãŠã„ã¦è‰¯ã„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‡ºã™ãŸã‚ã«ç¸ã®ä¸‹ã®åŠ›æŒã¡ã®ã‚ˆã†ãªåƒãã‚’ã—ã¦ãã‚Œã¦ã„ã‚‹ã‚±ãƒ¼ã‚¹ãŒå®Ÿã¯å°‘ãª
ikosin 2021/09/01
mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸