[B! mysql] rightgo09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

rightgo09 id:rightgo09

mysqlã«é–¢ã™ã‚‹rightgo09ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (32)

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

Ubuntuä¸Šã§MySQLãƒ‡ãƒ¼ã‚¿ã‚’tmpfsä¸Šã«é…ç½®ã™ã‚‹ - TrinityT's BLOG
ãƒ†ã‚¹ãƒˆãŒå¢—ãˆã¦Rspecãƒ•ãƒ«å®Ÿè¡ŒãŒ10åˆ†ä»¥ä¸Šã‹ã‹ã‚‹ã€‚ä½•ã¨ã‹ã—ãŸã„ã€‚ â†’MySQLãƒ‡ãƒ¼ã‚¿ãƒ¡ãƒ¢ãƒªä¸Šã«ç½®ã„ã¦é€Ÿãã™ã‚Œã°è‰¯ã„ã‚“ã˜ã‚ƒãï¼Ÿ ã¨ã„ã†ã“ã¨ã§ã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ•ã‚¡ã‚¤ãƒ«ã‚’tmpfsã«ç½®ãã“ã¨ã§é€Ÿåº¦å‘ä¸Šã‚’è¨ˆã£ã¦ã¿ãŸã€‚ å‰æ Ubuntu11.10 MySQL5.1 æ‰‹é † tmpfsã®ãƒžã‚¦ãƒ³ãƒˆ sudo mount -t tmpfs -o size=512m tmpfs /mnt/mysql_tmpfs/ MySQLãƒ‡ãƒ¼ã‚¿ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— sudo service mysql stop sudo mv /var/lib/mysql /var/lib/mysql_backup MySQLãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ï¼†ã‚·ãƒ³ãƒœãƒªãƒƒã‚¯ãƒªãƒ³ã‚¯ä½œæˆ sudo mkdir /mnt/mysql_tmpfs/mysql sudo cp -rf /var/lib/mysql_backup/* /mnt/mysql_tmpfs/
rightgo09 2014/09/09
mysql
ãƒªãƒ³ã‚¯
MySQL 5.5ã®ç§˜ä¼ã®ã‚¿ãƒ¬ãŒ5.6ã§ã¯è…ã£ã¦ã„ãŸã¯ãªã— | GMOãƒ¡ãƒ‡ã‚£ã‚¢ ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã‚‚ã†å¯’ã®å…¥ã‚Šã‚’éŽãŽã¾ã—ãŸãã€‚DBAã®ãŸãªã‹ã§ã™ã€‚ GAã‹ã‚‰ã‚‚ã†ã™ã1å¹´ã€ç¤¾å†…ã§ã¯ã‚‚ã†ç›¸å½“ã‚«ã‚¸ãƒ¥ã‚¢ãƒ«ã«MySQL 5.6ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚ä»Šã¾ã§ã¯æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹(ã‚„ã€æ–°è¦æ©Ÿèƒ½)ã§ã®å°Žå…¥ãŒã»ã¨ã‚“ã©ã ã£ãŸ5.6ã‚’ã€ã“ã®ãŸã³ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¬ãƒ³ã‚¬ãƒ³ã®ã‚µãƒ¼ãƒ“ã‚¹ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã§å°Žå…¥ã—ã¾ã—ãŸï¼ˆã¨ã€å‰ãã†ã«è¨€ã£ã¦ã„ã¾ã™ãŒç§ã§ãªã„åˆ¥ã®DBAæ°ãŒä¸»æ‹…å½“ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ï¼‰ ä¸»ãªç†ç”±ã¯InnoDB Compressedã‚’ä½¿ã£ã¦ã„ãŸã®ã§ãã®æ€§èƒ½ã‚¢ãƒƒãƒ—ã«æœŸå¾…â€¦ã¨ã„ã†ã¨ã“ã‚ã ã£ãŸã‚“ã§ã™ãŒã€å¼Šç¤¾DBAãŒç¥žä»£ã®æ™‚ä»£ã‚ˆã‚Šè©¦è¡ŒéŒ¯èª¤ã‚’é‡ããŸã©ã‚Šç€ã„ãŸç©¶æ¥µã®my.cnf(?)ã€ã„ã‚ã‚†ã‚‹ç§˜ä¼ã®ã‚¿ãƒ¬ãŒ æ®‹ã€€å¿µã€€ãªã€€ãŒã€€ã‚‰ã€€è…ã€€ã£ã€€ã¦ã€€ãŠã€€ã‚Š å¤œã‚’å¾¹ã—ã¦ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ä½œæ¥ã‚’ã—ã¦ã„ãŸæ‹…å½“DBAæ°ãŒé’ã„é¡”(æŽ¨å®šã€‚ãƒãƒ£ãƒƒãƒˆã ã£ãŸ)ã§ ã‚¹ã€€ãƒã€€ãƒ¼ã€€ã‚¯ã€€ã‚¨ã€€ãƒªã€€ãƒ¼ã€€ãŒã€€1ã€€0ã€€å€ã€€ãã€€ã‚‰ã€€ã„ã€€ã«ã€€ãªã€€ã£ã€€ãŸã€€ã‚“ã€€ã ã€€ã‘ã€€ã©ã€€â€¦ ã¨è¨´ãˆã€å½¼ã¯ãã®
rightgo09 2014/01/14
ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚»ãƒ³ã‚¹ã‚’æ„Ÿã˜ãŸ

MySQL
ãƒªãƒ³ã‚¯
mysqldumpã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã™ã‚‹æ™‚ã«ã¤ã‘ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ - oinume journal
MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã™ã‚‹éš›ã«mysqldumpã‚’ä½¿ç”¨ã—ã¾ã™ãŒã€å€‹äººçš„ã«ã€Œã“ã‚Œã¯ã¤ã‘ãŸã‚‰ã‚ˆã•ãã†ã€ã¨æ€ã£ã¦ã„ã‚‹ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ --opt --quick --add-drop-table --add-locks --extended-insert --lock-tables ã‚’æŒ‡å®šã™ã‚‹ã®ã¨åŒã˜ã§ã™ã€‚ãƒ€ãƒ³ãƒ—ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQL ã‚µãƒ¼ãƒã«èªã¿è¾¼ã‚€ãŸã‚ã®æœ€é€Ÿãƒ€ãƒ³ãƒ—ã‚’æä¾›ã—ã¾ã™ã€‚(ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãã®ã¾ã‚“ã¾) --single-transaction ãƒ€ãƒ³ãƒ—ã™ã‚‹éš›ã«å…ˆé ã«BEGINã‚’ã¤ã‘ã‚‹ãŸã‚ã€ãƒ€ãƒ³ãƒ—æ™‚ã®ãƒ‡ãƒ¼ã‚¿ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ä¸€è²«æ€§ã‚’ä¿ã¤ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã ã—InnoDBãªã©ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒæœ‰åŠ¹ãªã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã¯ãªã„ã¨æ„å‘³ãŒãªã„ã§ã™ã€‚ --flush-logs ãƒ€ãƒ³ãƒ—ã‚’é–‹å§‹ã™ã‚‹å‰ã«ã€MySQL ã‚µãƒ¼ãƒå†…ã®ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã—ã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’ä¿å˜ã™ã‚‹ã‚ˆã†
rightgo09 2013/12/06
mysql
ãƒªãƒ³ã‚¯
[D14] MySQL 5.6æ™‚ä»£ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€€*db tech showcase 2013 Tokyo
1. 1 Copyright Â© 2013, Oracle and/or its affiliates. All rights reserved. MySQL 5.6æ™‚ä»£ã® ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ å±±å´Ž ç”±ç« / MySQL Senior Sales Consultant, Asia Pacific and Japan 2. 2 Copyright Â© 2013, Oracle and/or its affiliates. All rights reserved. ä»¥ä¸‹ã®äº‹é …ã¯ã€å¼Šç¤¾ã®ä¸€èˆ¬çš„ãªè£½å“ã®æ–¹å‘æ€§ã«é–¢ã™ã‚‹æ¦‚è¦ã‚’èª¬æ˜Žã™ã‚‹ã‚‚ã®ã§ã™ã€‚ ã¾ãŸã€æƒ…å ±æä¾›ã‚’å”¯ä¸€ã®ç›®çš„ã¨ã™ã‚‹ã‚‚ã®ã§ã‚ã‚Šã€ã„ã‹ãªã‚‹å¥‘ç´„ã«ã‚‚çµ„ã¿è¾¼ã‚€ã“ã¨ã¯ ã§ãã¾ã›ã‚“ã€‚ä»¥ä¸‹ã®äº‹é …ã¯ã€ãƒžãƒ†ãƒªã‚¢ãƒ«ã‚„ã‚³ãƒ¼ãƒ‰ã€æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ã‚³ãƒŸãƒƒãƒˆãƒ¡ãƒ³ ãƒˆï¼ˆç¢ºç´„ï¼‰ã™ã‚‹ã‚‚ã®ã§ã¯ãªã„ãŸã‚ã€è³¼è²·æ±ºå®šã‚’è¡Œã†éš›ã®åˆ¤æ–ææ–™ã«ãªã•ã‚‰ãªã„ã§ä¸‹
rightgo09 2013/11/18
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
http://www.mysqlpracticewiki.com/index.php/Extra_field
rightgo09 2013/11/13
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®EXPLAINã‚’å¾¹åº•è§£èª¬!!
ä»¥å‰ã€MySQLã‚’é«˜é€ŸåŒ–ã™ã‚‹10ã®æ–¹æ³•ã¨ã„ã†æŠ•ç¨¿ã§ã€ŒEXPLAINã®è¦‹æ–¹ã«ã¤ã„ã¦ã¯ã„ãšã‚Œè§£èª¬ã—ã‚ˆã†ã¨æ€ã†ã€ã¨æ›¸ã„ã¦ã—ã¾ã£ãŸã®ã§ã€ä»Šæ—¥ã¯ãã®å…¬ç´„ï¼Ÿã‚’æžœãŸãã†ã¨æ€ã†ã€‚ MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã§æœ€ã‚‚å¤§åˆ‡ãªã®ã¯ã€ã‚¯ã‚¨ãƒªã¨ã‚¹ã‚ãƒ¼ãƒžã®æœ€é©åŒ–ã§ã‚ã‚‹ã€‚ã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆã¯ä¸€åº¦æ±ºã‚ã¦ã—ã¾ã†ã¨ãã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’åˆ©ç”¨ã™ã‚‹å…¨ã¦ã®ã‚¯ã‚¨ãƒªã«å½±éŸ¿ã—ã¦ã—ã¾ã†ãŸã‚ãªã‹ãªã‹å¤‰æ›´ã™ã‚‹ã“ã¨ã¯å‡ºæ¥ãªã„ãŒã€ã‚¯ã‚¨ãƒªã¯ãã®ã‚¯ã‚¨ãƒªã ã‘ã‚’æ›¸ãç›´ã›ã°è‰¯ã„ã®ã§å¤‰æ›´ã®æ•·å±…ã¯ä½Žã„ã€‚ãã—ã¦é…ã„ã‚¯ã‚¨ãƒªã‚’ãªãã™ã“ã¨ã¯ã€æ€§èƒ½ã‚’å¤§å¹…ã«å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®æœ€ã‚‚æœ‰åŠ¹ãªæ‰‹æ®µã§ã‚ã‚‹ã€‚å¾“ã£ã¦ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ€§èƒ½ã‚’å‘ä¸Šã•ã›ãŸã„ãªã‚‰ã€ã¾ãšæœ€åˆã«ã‚¯ã‚¨ãƒªã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’æ¤œè¨Žã™ã‚‹ã¹ããªã®ã§ã‚ã‚‹ã€‚ æœ€é©åŒ–ã™ã‚‹ã¹ãã‚¯ã‚¨ãƒªã¯ã‚¹ãƒãƒ¼ã‚¯ã‚¨ãƒªãƒã‚°ã‚„ã‚¯ã‚¨ãƒªã‚¢ãƒŠãƒ©ã‚¤ã‚¶ã§è¦‹ä»˜ã‘ã‚‰ã‚Œã‚‹ãŒã€ã§ã¯ãã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªãŒè¦‹ã¤ã‹ã£ãŸå ´åˆã«ã¯ã©ã®ã‚ˆã†ã«æœ€é©åŒ–ã™ã‚Œã°ã„ã„ã®ã‹ï¼Ÿãã®ãŸã‚ã«ã¯ã¾ãšç¾åœ¨ã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªãŒå®Ÿè¡Œã•
rightgo09 2013/11/13
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQLã®å¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã§ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹10ã®æ–¹æ³• | Yakst
MySQLã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ãƒžãƒãƒ¼ã‚¸ãƒ£ã®Morgan Tockeræ°ã«ã‚ˆã‚‹ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºãŒå¤§ãããªã‚‹ã«ã¤ã‚Œã¦INSERTã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒè½ã¡ã¦ãã¦ã—ã¾ã†ã“ã¨ã‚’é˜²ãæ§˜ã€…ãªæ–¹æ³•ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã€‚ ä»Šæ—¥ã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å•é¡Œã‚’å¼•ãèµ·ã“ã™åŽŸå› ã«ãªã‚‹ã€ã‚µã‚¤ã‚ºã®å¤§ãã„ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®ã‚¢ãƒ‰ãƒã‚¤ã‚¹ã®ã†ã¡ã®ã„ãã¤ã‹ã¯ã€ãŸãã•ã‚“ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã¾ã¨ã‚ã¦å¤§ãããªã£ã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚‚é©ç”¨ã§ãã‚‹ãŒã€å¤§æŠµã®å ´åˆã€ç‹¬ç«‹ã—ãŸå¤§ããªãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã„ã†ã®ã¯ç‰¹ã«å•é¡Œã«ãªã‚Šã‚„ã™ã„ã‚‚ã®ã ã€‚ ä¸€èˆ¬çš„ã«çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ã¨æ€ã‚ã‚Œã‚‹ã®ã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’å¤‰æ›´ã™ã‚‹æ™‚ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã¯ã€ãã®ã‚µã‚¤ã‚ºãŒå¤§ãããªã‚‹ã«ã¤ã‚Œã¦é…ããªã‚‹ã“ã¨ã ã€‚ä»¥ä¸‹ã®å›³ã¯ã€ä¸€èˆ¬çš„ãªB+ãƒ„ãƒªãƒ¼ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’æ™‚ç³»åˆ—ã§è¦‹ãŸã‚‚ã®ã ã€‚ ã“ã®ã‚°ãƒ©ãƒ•ã¯ã€MySQL@Facebookã®è¨˜äº‹ã‹ã‚‰æ‹å€Ÿã—ãŸã‚‚ã®ã ã€‚ã“ã‚Œã¯ã€insert buffe
rightgo09 2013/11/12
mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
Ubuntu/mysql - TOBY SOFT wiki
ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« â€ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã®Software selection ã« LAMPã‚’ã‚»ãƒ¬ã‚¯ãƒˆã—ã¦ãŠãã¨ã€ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ã‚‹ã¯ãšã§ã™ã€ã¾ãŸèµ·å‹•æ™‚ã«è‡ªå‹•ã§ç«‹ã¡ä¸ŠãŒã£ã¦ã„ã‚‹ã¯ãšã§ã™ã€‚ (ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªå¯ã§ã™ã€‚ dpkg -l | grep mysql â†‘ã“ã‚Œã§ä½•ã‚‚å‡ºåŠ›ã•ã‚Œãªã‘ã‚Œã°mysqlã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¦ã„ãªã„ã¯ãšã§ã™ (dpkg -lã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å‡ºåŠ›ã€| ã®ãƒ‘ã‚¤ãƒ—ã§å‡ºåŠ›ã‚’æ¬¡ã®grepã«æ¸¡ã—ã¦ã„ã¾ã™ã€‚grep mysqlã§ä¸€è¦§ã®ä¸ã«mysqlã¨ã„ã†æ–‡å—åˆ—ãŒã‚ã‚Œã°å‡ºåŠ›ã—ã¾ã™ï¼ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å‡ºåŠ›ã«mysqlãŒå«ã¾ã‚Œã¦ã„ãªã„) ã¾ãŸã¯ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã§èµ·å‹•ã•ã‚Œã¦ã„ã‚‹ã‹ç¢ºèªã§ãã¾ã™ã€‚ /usr/sbin/mysqld ãŒã‚ã‚Œã°ã€ã™ã§ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œèµ·å‹•ã—ã¦ã„ã¾ã™ã€‚ ps ax | grep mysql ) sudo aptitude install my
rightgo09 2013/07/31
mysql
ãƒªãƒ³ã‚¯
MySQL5.6ã§ä»Šã¾ã§ã®Verã§ã¯å•é¡Œç„¡ã‹ã£ãŸSQLæ–‡ãŒã‚¨ãƒ©ãƒ¼ã«ãªã£ãŸå ´åˆã®å¯¾å‡¦æ³• - oranie's blog
è¿½è¨˜ï¼šè¨˜äº‹ã®æ–‡ä¸ã§5.6ã®sql_modeãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«ã¤ã„ã¦è‹¥å¹²å®Ÿéš›ã®æŒ™å‹•ã¨ç•°ãªã‚‹è¡¨è¨˜ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚rpmã§installã™ã‚‹ã¨/usr/my.cnfã¨ã„ã†ã®ãŒã²ã‚‡ã£ã“ã‚Šã„ã¦ã€ã“ã®ä¸ã« [mysqld] sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES ã¨ã„ã†è¨˜è¿°ãŒã‚ã‚Šã€ã“ã‚Œã‚’/etc/my.cnfã¨åˆã‚ã›ã¦è¨å®šã—ã¦ã„ã‚‹æ§˜ã§ã™ã€‚ã§ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã«ã¤ã„ã¦ã¯5.6.6ä»¥é™ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ãŒã€ŒThe default SQL mode in MySQL 5.6.6 and later is NO_ENGINE_SUBSTITUTION;ã€ã§ãã‚Œä»¥å‰ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã¯ã€ŒMySQL 5.6.5 and earlier, it was empty (no modes set)ã€ã¨ãªã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ãã€‚ è©³ã—ãã¯ http://yoku0825.blo
rightgo09 2013/06/14
mysql
ãƒªãƒ³ã‚¯
MySQLã®æ—¥ä»˜åž‹ã«INSERTã§ãã‚‹æ–‡å—åˆ—ã®æ›¸å¼
è‡ªå·±ç´¹ä»‹ã§ã€ŒæŠ€è¡“ç³»ã®ã“ã¨ã‚’æ›¸ããŸã„ã€çš„ãªã“ã¨ã‚’è¨€ã£ãŸã®ã«ã€ãã‚Œã‚‰ã—ã„ã“ã¨ã‚’ã•ã£ã±ã‚Šæ›¸ã„ã¦ãªã‹ã£ãŸã®ã§çŒ›çœã€‚
rightgo09 2013/05/10
mysql
ãƒªãƒ³ã‚¯
ã¯ã¦ãªãƒ–ãƒã‚° | ç„¡æ–™ãƒ–ãƒã‚°ã‚’ä½œæˆã—ã‚ˆã†
æ¯Žæ—¥ãƒ–ãƒã‚°ã‚’æ›¸ãã‚ˆã†ã«ã—ãŸã‚‰ä½“èª¿ãŒè‰¯ããªã£ãŸ ã‚ã‚‹æ—¥ãµã¨ã€ã€Œæœ€è¿‘ã®è‡ªåˆ†ã¯ã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã«è‡†ç—…ã«ãªã£ã¦ã„ã‚‹ãªãƒ¼ã€ã¨æ„Ÿã˜ã€ã“ã†ã„ã†ã‚¨ãƒ³ãƒˆãƒªã‚’æ›¸ã„ãŸã€‚ daiksy.hatena blog.jp å†…å®¹ã¯ã€é›‘ãªã‚¢ã‚¦ãƒˆãƒ—ãƒƒãƒˆã§ã€Œã ã„ãã—ãƒ¼ã•ã‚“è€ƒãˆãŒæµ…ã„ãªã€ã¿ãŸã„ãªã€ŒåŒ–ã‘ã®çš®ãŒå‰¥ãŒã‚Œã‚‹ã€ã“ã¨ã‚’æã‚Œã¦ã„ã‚‹ãŒã€è‡ªåˆ†ãŒéŽå‰°ã«æ„è˜ã™ã‚‹ã»ã©â€¦
rightgo09 2012/05/03
homebrew

mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒˆãƒªã‚¬ã§ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ã§ã®è‡ªå‹•æŽ¡ç•ªã‚’å®Ÿç¾ã™ã‚‹ - spiritlooseã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
åŒã˜ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é•ã†ãƒ†ãƒ¼ãƒ–ãƒ«ã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã‚’é‡è¤‡ã•ã›ãŸããªã„å ´åˆã‚„ã€ ã‚¯ãƒ©ã‚¹ã‚¿åŒ–ã—ãŸå ´åˆã¨ã‹ã§ AUTO_INCREMENT ãŒä½¿ãˆãªã„å ´åˆã€‚ ã„ã‚ã‚†ã‚‹æŽ¡ç•ªãƒ†ãƒ¼ãƒ–ãƒ«ã£ã¦ã‚„ã¤ã€‚ DBICã¨ã‹ã§ sub nextval { my $self = shift; my $dbh = $self->result_source->storage->dbh; my $sql = 'UPDATE sequence SET id = LAST_INSERT_ID(id + 1)'; my $sth = $dbh->prepare($sql); $sth->execute; my $id = $sth->{mysql_insertid}; $sth->finish; $id; } ã¨ã‹æ‰‹å‹•ã§ã‚„ã£ã¦ã‚‚ã‚ˆã‹ã£ãŸã‚“ã ã‘ã©ã€ã›ã£ã‹ããªã®ã§MySQLã®ãƒˆãƒªã‚¬ãƒ¼ã§ã‚„ã£ã¦ã¿ãŸã€‚ DROP TABLE IF EXISTS
rightgo09 2011/12/17
ãªã‚‹ã»ã©ãªã€œã€‚

mysql
ãƒªãƒ³ã‚¯
Homebrewã§MySQLã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - nashiwaterã®æ—¥è¨˜
Mac, MySQL MacPortsã‹ã‚‰Homebrewã«ç§»è¡Œã—ã¦ã¿ãŸã®ã§ã€MySQLã‚‚å†åº¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ $ brew install mysql ã‚ã‚“ã¾è¦šãˆã¦ã„ãªã„ã‘ã©ã€MacPortsã§å…¥ã‚ŒãŸã¨ãã¨æ¯”ã¹ãŸã‚‰ã¯ã‚„ã„ã€‚å®Œäº†ã—ãŸã‚‰ã„ã‚ã„ã‚ã¨æ•™ãˆã¦ãã‚Œã‚‹ã€‚Set up databases with: unset TMPDIR mysql_install_dbIf this is your first install, automatically load on login with:cp /usr/local/Cellar/mysql/5.1.54/com.mysql.mysqld.plist ~/Library/LaunchAgents launchctl load -w ~/Library/LaunchAgents/com.mysql.mysqld.plistIf this is an
rightgo09 2011/12/03
homebrew

MySQL
ãƒªãƒ³ã‚¯
MySQLã‚’master:slave=1:1æ§‹æˆã«ã—ã¦å‚ç…§ã‚’slaveã«å‘ã‘ã‚‹ã®ãŒãªãœè‰¯ããªã„ã‹ - é…’æ—¥è¨˜ ã¯ã¦ãªæ”¯åº—
MySQLã®masterã¨slave 1:1ã«ã—ã¦å‚ç…§ã‚’slaveå‘ã‘ã‚‹ã®ã£ã¦ã‚„ã‚ŠãŸãŒã‚‹äººå¤šã„ã¿ãŸã„ã ã‘ã©ã€æ€§èƒ½ãŸã„ã—ã¦ä¸ŠãŒã‚‰ãªã„å‰²ã«å¯ç”¨æ€§è½ã¡ã‚‹ã ã‘ã ã‹ã‚‰ã‚„ã‚ã‚ˆã†ã‚ãƒ£ãƒ³ãƒšãƒ¼ãƒ³ 2011-06-19 00:16:30 via YoruFukurou MySQL ã¯ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒç°¡å˜ã«æ§‹æˆã§ãã‚‹ã®ã§ã™ãŒã€æ™‚æŠ˜ master 1å° ã«å¯¾ã—ã¦ slave 1å°ã€æ›´æ–°å‡¦ç†ã¯ master ã«ã€å‚ç…§ã¯ slave ã«ã€ã¨ã„ã†æ§‹æˆã‚’ç›®ã«ã—ã¾ã™ã€‚ å€‹äººçš„ã«ã¯ã“ã®æ§‹æˆã¯ãŠå‹§ã‚ã§ãªã„ã¨æ€ã£ã¦ã„ã‚‹ã®ã§ã€ãã®ç†ç”±ã‚’è€ƒå¯Ÿã—ã¦ã¿ã¾ã™ã€‚ 1. å¯ç”¨æ€§ãŒè½ã¡ã‚‹ å½“ç„¶ã§ã™ãŒã€master, slave ã®ã©ã¡ã‚‰ãŒè½ã¡ã¦ã‚‚å½±éŸ¿ã‚’å—ã‘ã‚‹ãŸã‚ã«å¯ç”¨æ€§ãŒä½Žä¸‹ã—ã¾ã™ã€‚ 2. å…¨ä½“ã®æ€§èƒ½ãŒã»ã¨ã‚“ã©ä¸ŠãŒã‚‰ãªã„ master 1å°ã§ã™ã¹ã¦ã®ã‚¯ã‚¨ãƒªã‚’å‡¦ç†ã™ã‚‹å ´åˆã¨æ¯”ã¹ã¦ã€å¯ç”¨æ€§ãŒè½ã¡ã‚‹å¼•ãæ›ãˆã¨ã—ã¦è¦‹åˆã£ãŸæ€§èƒ½å‘ä¸ŠãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã€ã¨ã„ã†
rightgo09 2011/06/20
mysql

ã‚·ã‚¹ãƒ†ãƒ
ãƒªãƒ³ã‚¯
rightgo09 2011/06/14
åŠ©ã‹ã‚Šã¾ã—ãŸ! thx!

mac

mysql
ãƒªãƒ³ã‚¯
Installing MySQL on Snow Leopard using MacPorts
I am trying to install MySQL5 on Snow Leopard, but I am having some trouble. Here is my terminal log: users-MacBook-Pro:~ sam$ sudo port install mysql5Password: ---> Computing dependencies for mysql5 ---> Fetching mysql5 ---> Verifying checksum(s) for mysql5 ---> Extracting mysql5 ---> Applying patches to mysql5 ---> Configuring mysql5 ---> Building mysql5 ---> Staging mysql5 into destroot ---> In
rightgo09 2011/06/14
mysql

mac
ãƒªãƒ³ã‚¯
ï¼»MySQLã‚¦ã‚©ãƒƒãƒï¼½ç¬¬20å›ž MySQL 5.0ã§ä¸€æŒ™ã«å¢—åŠ ï¼Œæ§˜ã€…ãªç‰¹å¾´ã‚’æŒã¤ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³
MySQL 4.0ã§ã¯ï¼Œè¤‡æ•°ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ãŒé¸æŠžã§ãã‚‹ã€‚ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã¯ï¼Œç‰©ç†çš„ãªãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´æ–¹æ³•ã‚„ãƒ‡ãƒ¼ã‚¿å‡¦ç†ã®æ©Ÿèƒ½ãŒç•°ãªã£ã¦ã„ã‚‹ã€‚ã“ã®ã‚ˆã†ã«ç•°ãªã£ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã‚’ã‚µãƒãƒ¼ãƒˆã§ãã‚‹ã®ã¯ï¼Œç•°ãªã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æŒã£ã¦ã„ã‚‹ã‹ã‚‰ã§ã‚ã‚Šï¼ŒMySQLã®å¤§ããªç‰¹å¾´ã§ã‚‚ã‚ã‚‹ã€‚ ã¾ã‚‚ãªããƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹MySQL 5.0ã§ã¯ï¼Œã•ã‚‰ã«å¤šãã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’æè¼‰ã™ã‚‹ã€‚ä»Šå›žã¯ï¼ŒMySQL 5.0ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ã“ã‚Œã¾ã§ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ ã¾ãšï¼ŒMySQL 4.0ã«æè¼‰ã•ã‚Œã¦ã„ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èª¬æ˜Žã™ã‚‹ã€‚MySQL 4.0ã§ã¯ï¼Œè¡¨1ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ—ã«å¯¾å¿œã—ãŸã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ãƒ»ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ç”¨ã§ãã‚‹ã€‚ è¡¨1â—MySQL 4.0ã§ä½¿ç”¨ã§ãã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— ã‚«ãƒ†ã‚´ãƒª ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¿ã‚¤ãƒ— æ¦‚ç•¥
rightgo09 2011/01/21
mysql
ãƒªãƒ³ã‚¯
PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼:phpspoté–‹ç™ºæ—¥èªŒ
Windowsã‚¢ãƒ—ãƒªã®ãƒ„ãƒªãƒ¼ãƒ“ãƒ¥ãƒ¼ã£ã½ã„UIã‚’WEBä¸Šã§ç°¡å˜å®Ÿè£…ã§ãã‚‹jQueryãƒ—ãƒ©... æ¬¡ã®è¨˜äº‹ â‰«ï¼šã‚·ãƒ³ãƒ—ãƒ«ã•ãŒã„ã„æ„Ÿã˜ã®ï¼‘ï¼•ï¼”ç¨®é¡žã®ã‚¢ã‚¤ã‚³ãƒ³ã‚»ãƒƒãƒˆ Top 10 MySQL Mistakes Made by PHP Developers PHPé–‹ç™ºè€…ã®MySQLã®é–“é•ã„ãƒˆãƒƒãƒ—ï¼‘ï¼ã€‚ æ‰‹æ…£ã‚Œã¦ã„ã‚‹äººã«ã¨ã£ã¦ã¯çŸ¥ã£ã¦ã‚‹ã“ã¨ã‚‚å¤šã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ãŒã€åˆå¿ƒè€…ãŒå½¹ç«‹ã£ãŸã‚Šã€çŸ¥ã‚‰ãªã„éƒ¨åˆ†ã®ã‚«ãƒãƒ¼ã¨ã—ã¦ãƒ¡ãƒ¢ã¨ã—ã¦æ›¸ã„ã¦ã¿ã¾ã™ MyISAMã‚’ä½¿ã£ã¦ã„ã‚‹ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«MyISAMã ã‘ã©InnoDBã‚’ä½¿ãŠã† ãƒªã‚«ãƒãƒªå¯èƒ½ã§ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ©Ÿèƒ½ã€å¤–éƒ¨ã‚ãƒ¼åˆ©ç”¨å¯èƒ½ãªInnoDBãŠã™ã™ã‚ è©³ç´°ï¼šOpen database life: MyISAMã¨InnoDBã®ã©ã¡ã‚‰ã‚’ä½¿ã†ã¹ãã‹ PHPã®MySQLé–¢æ•°ã‚’ä½¿ã£ã¦ã„ã‚‹ mysql_* é–¢æ•°ã‚’ä½¿ã‚ãšã€PDOç‰ã§ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¤‰æ›´ã«å¯¾å¿œã—ã‚ˆã†
rightgo09 2010/11/25
php

mysql
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ | BLOG - DeNA Engineering
ã“ã‚“ã«ã¡ã¯ã“ã‚“ã«ã¡ã¯ã€‚æœ€è¿‘ãŠè…¹ç—›ã„ã°ã£ã‹ã‚Šè¨€ã£ã¦ã‚‹ã“ã¨ã§æœ‰åãªiwanagaã§ã™ã€‚ DeNAã¯å¤–éƒ¨çš„ã«ã¯ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ çš„ãªéƒ¨åˆ†ã®æ–¹ãŒãƒ•ã‚£ãƒ¼ãƒãƒ£ãƒ¼ã•ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã§ã™ãŒã€å®Ÿã¯ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®æä¾›ã‚‚è¡Œã£ã¦ã„ã¾ã™ã€‚æ€ªç›—ãƒãƒ¯ã‚¤ãƒ¤ãƒ«ã¨ã‹ã€ã©ã“ã‹ã§èžã„ãŸã“ã¨ãŒã‚ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ åƒ•ã¯DeNAã§ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ãŒèª•ç”Ÿã—ãŸè¾ºã‚Šã‹ã‚‰ãšã£ã¨ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã‚’è¦‹ã¦ãã¾ã—ãŸãŒã€ãã‚“ãªé‹ç”¨ã®ä¸ã§è‡ªåˆ†ãŒè²¯ã‚ã¦ããŸçŸ¥è¦‹ã¨ã‹TIPSã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‹ã‚Œã“ã‚Œ10ã‚¿ã‚¤ãƒˆãƒ«è¿‘ãã¯ãƒ¬ãƒ“ãƒ¥ãƒ¼ã—ãŸã‚Šé‹ç”¨ã—ãŸã‚Šã—ã¦ã‚‹ãŸã‚çµæ§‹è¨€ã„ãŸã„ã“ã¨ã¯ã„ã£ã±ã„ã‚ã‚‹ã®ã§ã€å°å‡ºã—ã«ã—ã¤ã¤è©•åˆ¤ã‚ˆã‘ã‚Œã°æ¬¡ã‚‚æ›¸ãã¾ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ä¸€è¦§ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€ - Techno logy of DeNA ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ãŸã‚ã®MySQLå…¥é–€2 - Techno logy of DeNA ã€ŒMySQL
rightgo09 2010/11/15
ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã£ã¦ãã†ã„ã†ä½¿ã„æ–¹ã‚‚ã‚ã‚Šãªã®ã‹ã€‚

mysql
ãƒªãƒ³ã‚¯
NoSQLã¨ã—ã¦MySQLã‚’ä½¿ã†DeNAãŒã€memcachedã‚ˆã‚Šã‚‚é«˜é€Ÿãª75ä¸‡ã‚¯ã‚¨ãƒªï¼ç§’ã‚’å®Ÿç¾
ãƒ¢ãƒã‚²ãƒ¼ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã¯ã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«NoSQLã‚’ä½¿ã£ã¦ã„ã¾ã›ã‚“ã€‚ãªãœã‹ï¼Ÿ ãã‚Œã¯MySQL/InnoDB 5.1ã®ç’°å¢ƒã§ç§’é–“75ä¸‡ã‚¯ã‚¨ãƒªã¨ã„ã†ã€å¤šãã®NoSQLã§ã‚‚å®Ÿç¾ã§ããªã„ã‚ˆã†ãªé«˜æ€§èƒ½ã‚’å®Ÿç¾ã—ã¦ã„ã‚‹ã‹ã‚‰ã€‚DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ã¯ã€è‡ªèº«ã®ãƒ–ãƒã‚°ã«ã“ã‚“ãªå†…å®¹ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒUsing MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity serverã€ï¼ˆè‹±èªžï¼‰ã‚’ãƒœã‚¹ãƒˆã—ã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Using MySQL as a NoSQL - A story for exceeding 750,000 qps on a commodity server æ¾ä¿¡æ°ãŒæŒ‡æ‘˜ã™ã‚‹ã‚ˆã†ã«ã€å¤§è¦æ¨¡ãªãƒãƒƒãƒˆã‚µãƒ¼ãƒ“ã‚¹ã‚’æä¾›ã—ã¦ã„ã‚‹ä¼æ¥ã®å¤šãã¯åˆ†æ•£ç’°å¢ƒã§
rightgo09 2010/10/27
SQLã‚’ãƒ‘ãƒ¼ã‚¹ã›ãšã«ã‚¬ãƒã§ã‚¨ãƒ³ã‚¸ãƒ³ã«ã‚¢ã‚¯ã‚»ã‚¹ã€‚å¤‰ãªSQLã¯çµ¶å¯¾å…¥ã‚Œãªã„ã£ã¦ã“ã¨ã‹ãª

mysql

ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸