MySQLã³ãã¥ããã£ããã¼ã¸ã£ã®Morgan Tockeræ°ã«ãããMySQL 5.6ãã¤ã³ã¹ãã¼ã«ããå¾ã«ããã©ã«ãå¤ããå¤æ´ããæ¹ããããã©ã¡ã¼ã¿ã®è§£èª¬ã æ°ã ã®ããã©ã«ãå¤ã®æ¹åã«ãã£ã¦ãéå»ã®ãã¼ã¸ã§ã³ã¨æ¯ã¹ã¦MySQL 5.6ã§ã¯è¨å®ããªãã¦ã¯ãªããªãå¤ãããªãæ¸ã£ããã¨ã¯è¨ããå¤æ´ãã¹ããã®ã«ã¤ãã¦ããã§æ¸ãã¦ããããã InnoDBã®è¨å® innodb_buffer_pool_size - ããã©ã«ãã¯128Mãããã¯ãã¡ã¢ãªã«ãã¼ãããããã¼ã¿ã¨ã¤ã³ããã¯ã¹ã®ããã«InnoDBãã©ã®ãããã¡ã¢ãªã使ãããæå®ãããã®ãªã®ã§ãè¨å®ãã¹ãéè¦ãªå¤ã ãMySQLã®å°ç¨ãµã¼ããªããæè¼ããã¦ããã¡ã¢ãªã®50%ãã80%ãæ¨å¥¨ãããè¨å®å¤ã ãä¾ãã°ã64GBã®RAMãæè¼ãã¦ãããµã¼ããªãããããã¡ãã¼ã«ã¯50GBç¨åº¦ã«ãã¹ãã ããã innodb_log_file_size -
{{#tags}}- {{label}}
{{/tags}}