Google ã®ã¦ã§ããã°å ¬éãã¼ã«ã使ã£ã¦ãããã¹ããåçãåç»ãå ±æã§ãã¾ãã
Google ã®ã¦ã§ããã°å ¬éãã¼ã«ã使ã£ã¦ãããã¹ããåçãåç»ãå ±æã§ãã¾ãã
ããã«ã¡ã¯ãDBAã§ãã MySQL5.6ã®ãªã³ã©ã¤ã³ALTER TABLEã§ããã£ãæã®ãã¯ãªãã§ãã 5.6ã«ã¯ãªã³ã©ã¤ã³ALTER TABLEé¢é£ã®ãã©ã¡ã¼ã¿ã¼ã«Â innodb_sort_buffer_size ã¨ãããã®ã追å ããã¦ãã(5.5以åã¯fast index creationãå¹ãæã«ä½¿ããããã©ã¡ã¼ã¿ã¼ã¨ãã¦å é¨çã«1Mã§ãã¼ãã³ã¼ãããã¦ãããã®ããè¨å®å¯è½ã«ãªã£ã)ãåã«ãã£ãã試ããã¨ãã 大ããããã°ä¸å¿ãããªãã®æ©æµã¯åããããããªã®ã§å¤§ãããããã§ããã æ¯æ¥ã®å®æãããã§ç大ã«InnoDBã®ãã¼ãã«ã«ãã«ã¯ã¤ã³ãµã¼ãããããå¾ã«ALTER TABLEã§ã¤ã³ããã¯ã¹ããã£ã¤ãã¦RENAME TABLEã§ãã¼ãã«ãåãæ¿ããâ¦ãªãã¦ãã¨ããã£ã¦ãããµã¼ãã¹ã«ã¯æã£ã¦ã¤ãã ã¨æã£ãããã§ãï¼ãããããã®ããæ¹ã®åæªã«ã¤ã㦠ãã㦠DBA㯠èãããã¨ãæ¢ãã
ä¼è¤ç´ä¹æ°ãèªããä»äºã®æµåãã®ç¬¬3åã¯ãæé»ç¥ãä½ããªãçµç¹ã®ä½ãæ¹ããªã¼ãã³ã½ã¼ã¹ã®ã¹ã¿ã¤ã«ã§çµç¹ãä½ãã°ããã¨ããç´ä¹æ°ã¯ãKAIZEN platform Inc.ã«ããã¦ãã©ã®ãããªè¡åãã¨ã£ã¦ããã®ãã ããåãçµã¿ã«ãã£ã¦ãKAIZENæµã®è¡åå²å¦ãçã¾ããã¨ããäºä¾ããã¨ã«èªã£ã¦ããã ããã by é¦¬å ´ç¾ç±ç´ ï¼CodeIQä¸ã®äººï¼ æé»ç¥ãä½ããªããã¹ã¦ãå½¢å¼ç¥ã«å¤ãã ååã¯ãSqwiggleãæ´»ç¨ãããªã¢ã¼ãã¯ã¼ã¯ãGitHubãæ´»ç¨ããéçºã«ã¤ãã¦è¿°ã¹ã¾ããã éçºããã»ã¹ã¯ãã¾ãã¢ã¸ã£ã¤ã«éçºã£ã½ãã§ãããã¢ã¸ã£ã¤ã«éçºã¨ããããã¹ã¯ã©ã ã§æ±ãããã¦ããä»ã®ãã©ã¯ãã£ã¹ã«ã¤ãã¦ãKAIZENã®ãªã¢ã¼ãã¯ã¼ã¯ã§ã¯ã©ã®ããã«ãã£ã¦ããããããå°ã説æããã¨ãã¾ããã¤ãªã¼ã¹ã¿ã³ãã¢ãããããããæä¼ã§ãããªã¢ã¼ãã§ãã£ã¦ãã®ã§ãã¹ã¿ã³ãã¢ããã¨ããã¤ã¤ç«ã£ã¦ã¯ããªããã§ã
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ã©ã³ãã³ã°
ãªãªã¼ã¹ãé害æ å ±ãªã©ã®ãµã¼ãã¹ã®ãç¥ãã
ææ°ã®äººæ°ã¨ã³ããªã¼ã®é ä¿¡
å¦çãå®è¡ä¸ã§ã
j次ã®ããã¯ãã¼ã¯
kåã®ããã¯ãã¼ã¯
lãã¨ã§èªã
eã³ã¡ã³ãä¸è¦§ãéã
oãã¼ã¸ãéã
{{#tags}}- {{label}}
{{/tags}}