MySQL 5.7ã®optimizer_switchã€derived_mergeã¨ã¯ä½•ãžã‚„ - ã‹ã¿ã½ã‚ーるã“ã®ã‚¨ãƒ³ãƒˆãƒªã¯MySQL Casual Advent Calendar 2015ã®8日目ã§ã™ã€‚ MySQL 5.7.6ã‹ã‚‰optimizer_switchã«derived_mergeãŒè¿½åŠ ã•ã‚Œãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§æœ‰åŠ¹ã«ãªã£ã¦ã„る。基本的ã«ã“ã‚Œã¯ã»ã£ã¨ã„ãŸã‚‰ã ã„ãŸã„サブクエリãŒé€Ÿããªã‚‹ã‚„ã¤ãªã®ã§æ°—ã«ã—ãªãã¦ã‚‚ã„ã„ã‚“ã§ã™ãŒã€ã¡ã‚‡ã£ã¨éžäº’æ›ãŒã‚ã‚‹ã®ã§ã•ãã£ã¨èª¬æ˜Žã—ã¾ã™ã€‚ root@localhost [mysqlcasual] > CREATE TABLE t1 (a int); Query OK, 0 rows affected (0.03 sec) root@localhost [mysqlcasual] > CREATE TABLE t2 (b int); Query OK, 0 rows affected (0.03 sec) root@localhost [mysqlcasual] > INS
pt-online-schema-changeã¨5.6 InnoDBã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ALTER TABLE使ã„分ã‘
二åƒä¸‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚るテーブルã¸ã®alterをサービスをæ¢ã‚ãšã«æµã™ | All Your Bugs Are Belong To Ass
Cloudcraft – Draw AWS diagrams
超便利ãªDB用GUIツール『0xDBEã€ãŒã€ŽDataGrip 1.0ã€ã¨ã—ã¦æ£å¼ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—㟠| DevelopersIO
Homebrewã®MySQL 5.7.9ã§SSL接続ã™ã‚‹ã¨ã‚³ã‚±ã‚‹ã®ã§æ°—ã‚’ã¤ã‘よㆠ- ã‹ã¿ã½ã‚ーる
{{#tags}}- {{label}}
{{/tags}}