å°ã•ãªãƒ†ãƒ¼ãƒ–ルã¸ã®ALTER TABLE一撃ã§ã‚µãƒ¼ãƒ“スåœæ¢ã€‚ãã“ã‹ã‚‰å¦ã‚“ã 惨事を繰り返ã•ãªã„ãŸã‚ã®ãƒ«ãƒ¼ãƒ«ä½œã‚Š - Qiitaã“ã¡ã‚‰ã¯ NewsPicksアドベントカレンダーã®9日目ã®è¨˜äº‹ã§ã™ã€‚ ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚NewsPicks エンジニアã®é¶´æˆ¿ã§ã™ã€‚ フãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã®åˆ·æ–°ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã«ãŠã„ã¦ã€ä¸»ã«ã‚¤ãƒ³ãƒ•ãƒ©ã¨ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚’担当ã—ã¦ã„ã¾ã™ã€‚ 今回ã¯ç§ãŒä»¥å‰èµ·ã“ã—ã¦ã—ã¾ã£ãŸã‚µãƒ¼ãƒ“ス全åœæ¢ã®éšœå®³ã®åŽŸå› ã¨ã€ãã®å†ç™ºé˜²æ¢ç–ã«é–¢ã—ã¦è¨˜è¼‰ã—ã¾ã™ã€‚ å°šã€å¼Šç¤¾ã§ã¯RDBMSã¨ã—ã¦MySQLを利用ã—ã¦ã„ã‚‹ã®ã§ã€ã“ã®è¨˜äº‹ã¯MySQLã«é–¢ã™ã‚‹å†…容ã«ãªã‚Šã¾ã™ã€‚ 障害事象 今年ã®å¤é ƒã€ç´„30分ã®é–“ã€NewsPicksã®ã»ã¼å…¨ã¦ã®ã‚µãƒ¼ãƒ“スãŒåœæ¢ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ユーザーã¯ã€ãã®é–“ã€ãƒã‚°ã‚¤ãƒ³ã‚‚ã€è¨˜äº‹ã‚’èªã‚€ã“ã¨ã‚‚ã€è¨˜äº‹ã«ã‚³ãƒ¡ãƒ³ãƒˆã™ã‚‹ã“ã¨ã‚‚ã§ããªã„状態ã§ã—ãŸã€‚ アプリを開ãã¨ã€ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒè¡¨ç¤ºã•ã‚Œã‚‹ã ã‘ã®çŠ¶æ…‹ã§ã€éšœå®³ã®è§£æ¶ˆã¾ã§ãšã£ã¨ãã®çŠ¶æ…‹ãŒç¶šã„ã¦ã„ã¾ã—ãŸã€‚ 障害ã®ç›´æŽ¥åŽŸå› 障害ã®ç›´æŽ¥ã®å¼•ã金ã«ãªã£ãŸã®ã¯ã€ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚る通りALTE
MySQL ã® UPDATE 㧠IN å¥ã®è¦ç´ ãŒå¤šã™ãŽã¦ãƒ‡ãƒƒãƒ‰ãƒãƒƒã‚¯ã—ãŸè©± #LayerXテックアドカレ - LayerX エンジニアブãƒã‚°
MySQL 8.0アップグレード後ã«æ€§èƒ½åŠ£åŒ–ã—ãŸã‚¯ã‚¨ãƒª: セミジョイン編 - inSmartBank
utf8mb4ã®COLLATEã®é•ã„ã«ã¤ã„㦠- らã¼ã‚‹ã¦ã£ã。
MySQL 8.0 ã§ã‚‚ utf8mb4_general_ci を使ã„続ã‘ãŸã„僕ら㯠- mita2 database life
MySQL8.0ã§SELECT COUNT(*)ãŒä½Žé€Ÿã«ãªã‚‹å‹•ä½œã¯8.0.37ã§è§£æ¶ˆã•ã‚Œã¦ã„ãŸï¼ - CyberAgent SRG #ca_srg
[Rails] has_oneã§æœ€æ–°ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã§ãるよã†ã«ã—ã¦eager_loadã—ãŸã„![[Rails] has_oneã§æœ€æ–°ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã§ãるよã†ã«ã—ã¦eager_loadã—ãŸã„](https://cdn-ak-scissors.b.st-hatena.com/image/square/490a4820e6c0faad8162df2733a0d7fc773fd9dc/height=288;version=1;width=512/https%3A%2F%2Fres.cloudinary.com%2Fzenn%2Fimage%2Fupload%2Fs--SHTYOo35--%2Fc_fit%252Cg_north_west%252Cl_text%3Anotosansjp-medium.otf_55%3A%25255BRails%25255D%252520has_one%2525E3%252581%2525A7%2525E6%25259C%252580%2525E6%252596%2525B0%2525E3%252581%2525AE%2525E3%252583%2525AC%2525E3%252582%2525B3%2525E3%252583%2525BC%2525E3%252583%252589%2525E3%252582%252592%2525E5%25258F%252596%2525E5%2525BE%252597%2525E3%252581%2525A7%2525E3%252581%25258D%2525E3%252582%25258B%2525E3%252582%252588%2525E3%252581%252586%2525E3%252581%2525AB%2525E3%252581%252597%2525E3%252581%2525A6eager_load%2525E3%252581%252597%2525E3%252581%25259F%2525E3%252581%252584%252Cw_1010%252Cx_90%252Cy_100%2Fg_south_west%252Cl_text%3Anotosansjp-medium.otf_37%3Ayagince%252Cx_203%252Cy_121%2Fg_south_west%252Ch_90%252Cl_fetch%3AaHR0cHM6Ly9saDMuZ29vZ2xldXNlcmNvbnRlbnQuY29tL2EtL0FPaDE0R2dlSHBvV3FEWmVSamhpUnlUQm4wMnk0MkxwMUdCa0pNMEtHdW5SMnc9czI1MC1j%252Cr_max%252Cw_90%252Cx_87%252Cy_95%2Fv1627283836%2Fdefault%2Fog-base-w1200-v2.png)
Always bigint id changes operations after upgrading from MySQL 5.7 to MySQL 8.0 · Issue #455 · ridgepole/ridgepole
MySQLã§Inå¥ã«å¤§é‡ã®è¦ç´ を渡ã™ã¨ã¾ãšã„ç†ç”±
MySQL :: MySQL 8.0 リファレンスマニュアル :: 2.11.4 MySQL 8.0 ã§ã®å¤‰æ›´
Aurora MySQL 2 ã® EOS ã«å‚™ãˆã¦ DB ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—テストを行ㆠ- Qiita
Amazon Aurora MySQL ãƒãƒ¼ã‚¸ãƒ§ãƒ³ 3 ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã®æ›´æ–° - Amazon Aurora
MySQL 8.0.15 ã®å‰å¾Œã§å¤‰ã‚ã£ãŸæ–‡å—列㨠DATE åž‹ã®æ¯”較ã«ã¤ã„㦠- ãã‚ŒãŒåƒ•ã«ã¯æ¥½ã—ã‹ã£ãŸã‚“ã§ã™ã€‚
Aurora MySQL 2ã‹ã‚‰3ã¸ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã§æŒ™å‹•ãŒå¤‰ã‚ã‚‹SQL(2) - Qiita
MySQL8ã§Out of sort memoryãŒç™ºç”Ÿã™ã‚‹ã‚ˆã†ã«ãªã£ãŸ
INSERT...SELETC ã§auto_increment値ãŒé£›ã¶è©± - amamanamam
MySQLå…¬å¼ã®Dockerリãƒã‚¸ãƒˆãƒªãŒcontainer-registry.oracle.comã«å¼•ã£è¶Šã—ã¦ã„ãŸ
ã€Docker】Mysql ãŒç«‹ã¡ä¸ŠãŒã‚‰ãªã„（ユーザè¨å®šã‚¨ãƒ©ãƒ¼ï¼‰
MySQL/MariaDBã§INTO OUTFILEã§/tmpã«ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ã§ ERROR 1086 (HY000): File already exists エラー
Aurora MySQL ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå˜åœ¨ã™ã‚‹ã®ã« SELECT ã™ã‚‹ã¨ Empty set ãŒè¿”ã£ã¦ãる事象を調査ã—ãŸè©±
{{#tags}}- {{label}}
{{/tags}}