[B! my.cnf] MAXIMUM-PROã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

MAXIMUM-PRO id:MAXIMUM-PRO

my.cnfã«é–¢ã™ã‚‹MAXIMUM-PROã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

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

MySQL ã® unknown option ã‚¨ãƒ©ãƒ¼ã¯ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã« loose- ãƒ—ãƒ¬ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã‚’ã¤ã‘ã‚‹ã¨å›žé¿ã§ãã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ã‚‚ã†MySQL 5.5 GAãŒå‡ºã¦ã‹ã‚‰ï¼‘å¹´ä»¥ä¸ŠãŒçµŒã¡ã€ã¤ã„å…ˆæ—¥ã¨ã†ã¨ã†MySQL 5.6 GAã‚‚å‡ºãŸæ˜¨ä»Šã€ã“ã‚Œã‹ã‚‰å…ˆãƒ‘ãƒ¼ã‚½ãƒŠãƒ«ãƒ¦ãƒ¼ã‚¹ã§ã“ã‚Œã‚ˆã‚Šä»¥å‰ã®MySQLãªã©ä½¿ã†ã“ã¨ã¯ãªã„ã ã‚ã†ã¨~/.my.cnfã‚’æ›¸ã„ã¦ã„ãŸã®ã ã‘ã©ã€æ˜¨æ—¥ã¡ã‚‡ã£ã¨ã—ãŸã‚¢ãƒ¬ã§MySQL 5.1ã‚’å…¥ã‚ŒãŸã‚‰MySQLãŒé€²åŒ–ã—ã™ãŽã¦ã¦ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆã—ã¾ãã‚‰ãªã„ã¨å‹•ã‹ãªã„ã‚ãƒ¼ã¨ã‹ã„ã£ã¦ãŸã‚‰loose-ã¤ã‘ã‚‹ã¨ã„ã„ã§ã™ã‚ˆã£ã¦æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã€‚ my.cnfã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³åã®é ã«loose-ã¨æ›¸ã„ã¦ãŠãã¨ã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå˜åœ¨ã—ãªãã¦ã‚‚WARNINGã§ERRORã«ãªã‚‰ãšã«æ¸ˆã¿ã¾ã™ã‚ˆãƒ¼ã€‚loose-log-slow-queriesloose-slow-query-logã¨æ›¸ãã¨5.1ã§ã‚‚5.5ã§ã‚‚ä½¿ãˆã‚‹ã€ã¿ãŸã„ãªã€‚â€” ts. yoku (@yoku0825) February 6, 2013 ã“ã‚Œã¯çŸ¥ã‚‰ãªã‹ã£ãŸï¼ MySQL 5.
MAXIMUM-PRO 2013/02/08
MySQL

my.cnf

ã‚ªãƒ—ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
MySQLã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ« my.cnf ã‚’githubã«ã¦å…¬é–‹ã—ã¾ã—ãŸ & ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒã‚¤ãƒ³ãƒˆã®ç´¹ä»‹ - blog.nomadscafe.jp
YAPC::Asiaã®ã‚¹ãƒ©ã‚¤ãƒ‰ã§äºˆå‘Šã—ã¦ã„ãŸé€šã‚Šã€å®Ÿéš›ã«å¼Šç¤¾ã®ã„ãã¤ã‹ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ä½¿ã£ã¦ã„ã‚‹ my.cnf ã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ github: https://github.com/kazeburo/mysetup/tree/master/mysql ä»Šå›žã€å…¬é–‹ã—ãŸç†ç”±ã¯MySQl Beginners Talksã®ç™ºè¡¨ã®ä¸ã§ã‚‚è§¦ã‚Œã¦ã„ã‚‹é€šã‚Šã§ã™ã€‚MySQLã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ä¸ã«å«ã¾ã‚Œã‚‹ã‚µãƒ³ãƒ—ãƒ«ã®my.cnfãŒæœ€è¿‘ã®ã‚µãƒ¼ãƒãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„é‹ç”¨ã«åˆã‚ãªããªã£ã¦æ¥ã¦ã„ã‚‹ã¨ã„ã†çŠ¶æ³ã§ã€è‡ªåˆ†ã®è¨å®šã«ã‚¤ãƒžã‚¤ãƒè‡ªä¿¡ãŒæŒã¦ã¦ã„ãªã„äººã¯å°‘ãªããªã„ã¯ãšã€‚ãã“ã§å„ç¤¾ç§˜ä¼ã®ã‚¿ãƒ¬çš„ãª my.cnf ã‚’Open & Shareã™ã‚‹ã“ã¨ã§ã€ãƒ¢ãƒ€ãƒ³ãªmy.cnfã‚’ä½œã‚Šä¸Šã’ã‚‹äº‹ãŒã§ãã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ã¨ã„ã†è€ƒãˆã®ä¸‹ã€ä»Šå›ž github ã«ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã¯4ã¤ã‚ã‚Šã€ãã‚Œãžã‚Œ MySQL 4.0ã€5.1ã€5.5ã€ãã—ã¦ãƒ†ã‚¹ãƒˆä¸
MAXIMUM-PRO 2012/10/05
MySQL

è¨å®š

my.cnf

tuning
ãƒªãƒ³ã‚¯
MySQL 5.1â†’5.6ã®my.cnfã®å·®åˆ†ã¨ã‹ - ï¼ˆã²ï¼‰ãƒ¡ãƒ¢
MySQL 5.1ã§ä½¿ã£ã¦ãŸmy.cnfã‚’è©¦ã—ã«5.6ã§å‹•ãã‚ˆã†ã«ã—ãŸã¨ãã®å·®åˆ†ã™ã€‚ç¶²ç¾…çš„ã«ã¯èª¿ã¹ã¦ãªã„ã‚“ã§ä»–ã«ã‚‚å»ƒæ¢ã«ãªã£ãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ã‚ã‚‹ã‹ã‚‚ã§ã™ã€‚ã‚ãã¾ã§å‚è€ƒã¾ã§ã«ã€‚ # log-binã«ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æŒ‡å®šã—ãªã„ã¨æ€’ã‚‰ã‚Œã¾ã™ -log-bin +log-bin = mysqld-bin # old-passwordsã¯ã‚ªãƒ³ã€ã‚ªãƒ•ã ã‘ã˜ã‚ƒãªãã¦å¼•æ•°(0, 1, 2)ãŒå¿…é ˆã«ãªã£ã¦ã€å¼•æ•°ã®å€¤ã«ã‚ˆã£ã¦æŒ™å‹•ãŒã‹ã‚ã‚Šã¾ã™ã€‚ -old-passwords +old-passwords = 1 # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€ãƒªãƒ¢ãƒ¼ãƒˆã‹ã‚‰ã®pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™ +skip-secure-auth # ã“ã‚ŒæŒ‡å®šã—ãªã„ã¨ã€pre-4.1ãªèªè¨¼æ–¹æ³•ã§æŽ¥ç¶šã§ããªã„ã§ã™â˜…ä¸‹ã«è¿½è¨˜ã‚ã‚Š +default-authentication-plugin = mysql_old_password # ãƒ‘ãƒ©ãƒ¡ãƒ¼
MAXIMUM-PRO 2012/10/03
MySQL

my.cnf
ãƒªãƒ³ã‚¯
mysql 5.1ã§å¤‰æ›´ã«ãªã£ãŸãƒã‚°é–¢é€£ã®my.cnfã®è¨å®š - ã†ã¾ã„ã¼ã†ã¶ã‚ã
å¤‰æ›´ã«ãªã£ãŸã¨ã„ã†ã‹æ£ç¢ºã«ã¯ã€mysql 7.0deprecatedã«ãªã‚‹ã‚ˆã¨ã„ã†warningãŒå‡ºã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã‚‚ã¡ã‚ã‚“ã€warningãªã ã‘ãªã®ã§5.0ä»¥å‰ã®è¨å®šã§ã‚‚å‹•ãã‘ã©ã€‚ã›ã£ã‹ããªã®ã§æ–°ã—ã„æ›¸å¼ã«ãªãŠãã†ã€‚ 5.0å‰ã¾ã§ã¯ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«åã®ã¿ã‚’my.cnfã«è¨˜è¿°ã—ã¦ã„ãŸã®ã«å¯¾ã—ã¦ã€5.1ä»¥é™ã ã¨ãƒ•ã‚¡ã‚¤ãƒ«å + ãƒã‚®ãƒ³ã‚°ã™ã‚‹ã‹ã©ã†ã‹ã®flagã®è¨å®šãŒè¿½åŠ ã•ã‚ŒãŸæ„Ÿã˜ã‹ãªï¼Ÿ ã‚ã¨general_logã€slow_query_logã¯"On"ã ã¨æœ‰åŠ¹ã«ãªã‚‰ãªãã¦ã€"1"ã˜ã‚ƒãªã„ã¨ãƒ€ãƒ¡ã ã£ãŸã€‚set variablesã§ç›´æŽ¥ å€¤ã‚’æ›´æ–°ã™ã‚‹ã¨ãã¯"On"ã§ã‚‚ã„ã‘ãŸã®ã«ãªãƒ¼ã€‚å¾®å¦™ã ã€‚ ä¸€èˆ¬ãƒã‚° 5.0ä»¥å‰ log = /path/to/mysql.log 5.1 general_log = 1 general_log_file = /path/to/mysql.log slow query ãƒ
MAXIMUM-PRO 2012/08/01
mysql

my.cnf
ãƒªãƒ³ã‚¯
1