[B! MySQL] gologo13ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

gologo13 id:gologo13

MySQLã«é–¢ã™ã‚‹gologo13ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (210)

${{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ã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã¯rows_examinedã§åˆ¤æ–ã™ã‚‹ - ã‹ã¿ã½ã‚ãƒ¼ã‚‹
ä»•äº‹ã‚„ã‚‰ãªã‚“ã‚„ã‚‰ã§MySQLã®ã‚¯ã‚¨ãƒªã®è‰¯ã—æ‚ªã—ã‚’åˆ¤æ–ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨ãã€EXPLAINã®å†…å®¹ã ã‘ã ã¨ã©ã®ãã‚‰ã„è‰¯ããªã£ãŸã‚Šæ‚ªããªã£ãŸã®ã‹åˆ†ã‹ã‚‰ãªã„ã®ã§ SET long_query_time = 0; ã—ã¦rows_examined (ãã®ã‚¯ã‚¨ãƒªã§rows_sentè¡Œã®çµæžœã‚’è¿”ã™ãŸã‚ã«ä½•è¡Œã«è§¦ã£ãŸã®ã‹)ã‚‚ä¸€ç·’ã«æç¤ºã™ã‚‹ã‚ˆã†ã«ã—ã¦ã„ã‚‹(å°‘ãªãã¨ã‚‚MySQL 5.7æ™‚ç‚¹ã§ã¯rows_examinedã¯slow_query_logã§ã—ã‹ç¢ºèªã§ããªã„ã¯ãšperformance_schemaãŒæœ‰åŠ¹ãªã‚‰events_statements_historyã‚„ãã®ä»²é–“ãŸã¡ã§ç¢ºèªã§ãã‚‹ã¨ã®ã“ã¨*1 MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 22.9.6 ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¹ã‚ãƒ¼ãƒžã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚¤ãƒ™ãƒ³ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«)ã€‚ ä¾‹: ä¸Šã®ä¾‹ã®Beforeã¯ã€ã‚‚ã¨ã‚‚ã¨DBAãŒæ›¸ã„ãŸæ¸©ã‹ã¿ã®ã‚ã‚‹SQLã§O
gologo13 2018/03/22
MySQL

database
ãƒªãƒ³ã‚¯
é‹ç”¨3å¹´ç›®ã‹ã‚‰å§‹ã‚ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ ~ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ»MySQLãƒ»Fastlyãƒ»ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³~
ã“ã‚“ã«ã¡ã¯ã€Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã® Shimpei Takamatsu ã§ã™ã€‚ãƒžãƒ³ã‚·ãƒ§ãƒ³ãƒžãƒ¼ã‚±ãƒƒãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°ã¯ä»Šå›žã‹ã‚‰Mediumã«ç§»è¡Œã—ã€ã“ã‚ŒãŒç§»è¡Œå¾Œ1æœ¬ç›®ã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã§ã™! ä»Šå›žã¯ç›´è¿‘2â€“3ãƒ¶æœˆã»ã©å–ã‚Šçµ„ã‚“ã§ã„ã‚‹ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æ”¹å–„ã®ãŠè©±ã§ã™ã€‚ æ¦‚è¦ç¾åœ¨ã®ãƒžãƒ³ã‚·ãƒ§ãƒ³ãƒžãƒ¼ã‚±ãƒƒãƒˆã®ã‚µã‚¤ãƒˆã¯åˆæœŸãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®ãƒªãƒªãƒ¼ã‚¹å¾Œã€ãƒªãƒ‹ãƒ¥ãƒ¼ã‚¢ãƒ«ã®ãŸã‚ã«ã‚¹ã‚¯ãƒ©ãƒƒãƒã§ä½œã‚Šç›´ã•ã‚Œã¦ãŠã‚Šã€ ç¾åœ¨ã®ãƒ¡ã‚¤ãƒ³ãƒªãƒã‚¸ãƒˆãƒªã¸ã®æœ€åˆã®ã‚³ãƒŸãƒƒãƒˆã¯2015/4/4ã§ã—ãŸã€‚ é–‹ç™ºé–‹å§‹ã‹ã‚‰ç´„2å¹´åŠãŒçµŒéŽã—ãŸãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã€ã¨ã„ã†ã“ã¨ã«ãªã‚Šã¾ã™ã€‚ ä»Šå›žã®ãƒã‚¹ãƒˆã§ã¯ã€é‹ç”¨3å¹´ç›®ã‚’è¿ŽãˆãŸç§é”ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹é¢ã§ç›´é¢ã—ãŸæ‚©ã¿ã‚’ç´¹ä»‹ã—ãŸå¾Œã€ å®Ÿéš›ã«ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã«ç§»ã—ãŸä»¥ä¸‹4ã¤ã®æ–½ç–ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ 1. ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ç†è§£ 2. ãƒ¢ãƒ‹ã‚¿ãƒªãƒ³ã‚°ãƒ»ç›£è¦– 3. ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ãƒ»ãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãƒ¬ãƒ™ãƒ«ã§ã®æ”¹å–„(MySQLãƒ»Fastly)
gologo13 2017/12/06
fastly

MySQL

performance
ãƒªãƒ³ã‚¯
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç–ï½œãƒã‚¤ã‚¯ãƒ©ã‚¹è»¢è·ãƒ»æ±‚äººæƒ…å ±ã‚µã‚¤ãƒˆ AMBIï¼ˆã‚¢ãƒ³ãƒ“ï¼‰
ãªãœã€SQLã¯é‡ãŸããªã‚‹ã®ã‹ï¼Ÿâ”€â”€ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ãŒæ•™ãˆã‚‹åŽŸå› ã¨å¯¾ç– ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã®æ¾æµ¦éš¼äººã•ã‚“ã«ã€8ã¤ã®ã€ŒSQLãŒé‡ãŸããªã‚‹åŽŸå› ã¨ãã®å¯¾ç–ã€ã‚’èžãã¾ã—ãŸã€‚ã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã‚‹ã‚ˆã†ãªã€Œå•é¡Œã®ã‚ã‚‹SQLã€ã‚’å›žé¿ã™ã‚‹ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã³ã¾ã—ã‚‡ã†ã€‚ ãƒ‡ãƒ¼ã‚¿ã®æ“ä½œã‚„å®šç¾©ã‚’ã™ã‚‹è¨€èªžã€ŒSQLã€ã¯ã€ã©ã®ã‚ˆã†ãªé ˜åŸŸã‚’æ‹…ã†ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã¨ã£ã¦ã‚‚å¿…ä¿®ç§‘ç›®ã§ã™ã€‚ã—ã‹ã—ã€ãã®ä»•æ§˜ã‚’ãã¡ã‚“ã¨ç†è§£ã—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å„ªã‚ŒãŸSQLã‚’æ›¸ã‘ã‚‹æ–¹ã¯ãã‚Œã»ã©å¤šãã‚ã‚Šã¾ã›ã‚“ã€‚å•é¡Œã®ã‚ã‚‹SQLã‚’æ›¸ã„ã¦ã—ã¾ã„ã€çŸ¥ã‚‰ã¬é–“ã«ãã‚ŒãŒã‚·ã‚¹ãƒ†ãƒ ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã«ãªã£ã¦ã—ã¾ã†äº‹æ…‹ã¯ã‚ˆãç™ºç”Ÿã—ã¾ã™ã€‚ ã§ã¯ã€ã©ã†ã™ã‚Œã°ãã†ã—ãŸäº‹æ…‹ã‚’å›žé¿ã§ãã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ãã®ãƒŽã‚¦ãƒã‚¦ã‚’å¦ã¶ãŸã‚ã€ä»Šå›žã¯ã€ŽSQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è©³è§£ã€ã®ç¿»è¨³è€…ã§ã‚ã‚Šã€è‡ªèº«ã‚‚ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚‚ã‚ã‚‹æ¾æµ¦éš¼äººï¼ˆã¾ã¤ã†ã‚‰ãƒ»ã¯ã‚„ã¨ï¼@dblmktï¼‰ã•ã‚“ã«8ã¤
gologo13 2017/06/28
å‰²ã¨æ™®é€šã®å†…å®¹ã€‚è¨è¨ˆæ€æƒ³ã¯å‚è€ƒã«ãªã£ãŸ

database

mysql
ãƒªãƒ³ã‚¯
MySQL with InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã‚ã‚ŠãŒã¡ãªé–“é•ã„ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºéƒ¨ã®è’å¼• (@a_bicky) ã§ã™ã€‚ çªç„¶ã§ã™ãŒã€RDBMS ã®æ—¢å˜ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’è¦‹ã¦ã¿ãŸã‚‰ã€Œä½•ã§ã“ã‚“ãªã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã ã‚‰ã‘ãªã®ï¼Ÿã€ã¿ãŸã„ãªçµŒé¨“ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿä¸è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯å®¹é‡ã‚’åœ§è¿«ã—ãŸã‚Šã€æŒ¿å…¥ãŒé…ããªã£ãŸã‚Šã¨è‰¯ã„ã“ã¨ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã‚“ãªã‚ã‘ã§ã€ä»Šå›žã¯ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ãŸã‚ã«å¿…è¦ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ã¨ã€ã‚ˆãè¦‹ã‹ã‘ã‚‹ä¸é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ã§ã¯ Rails ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ä¸»ã« MySQL 5.6ã€MySQL ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦ä¸»ã« InnoDB ã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã€MySQL 5.6 ã® InnoDB ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ InnoDB ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«é–¢ã™ã‚‹åŸºç¤ŽçŸ¥è˜ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ§‹é€ (B+ æœ¨) InnoDB ã§ã¯ B+ æœ¨ãŒä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚B+ æœ¨ã¯æ¬¡ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã£ãŸæœ¨æ§‹é€ ã§ã™ã€‚ æ¬¡æ•°ã‚’ b ã¨ã™ã‚‹ã¨ã€
gologo13 2017/06/23
innodb

database

mysql
ãƒªãƒ³ã‚¯
RDSã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¨JDBCã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒªãƒ³ã‚°ã§ãƒãƒžã£ãŸä»¶ - ãªã‹ã‚‰ãªLife
ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ç™ºç”Ÿã•ã›ãŸã‚‰ã€15åˆ†å›ºã¾ã£ãŸã€‚ Amazon RDS MySQL 5.6.23ï¼‹Tomcatï¼‹JavaServletï¼‹Connector/Jã§ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãƒ—ãƒ¼ãƒ«ã‚’åˆ©ç”¨ã—ãŸç’°å¢ƒã§ã€RDSã®ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼è©¦é¨“ã‚’ã™ã‚‹ã¹ãManagement Consoleã‹ã‚‰ã€ŒReboot with Failoverã€ã‚’ç™ºç”Ÿã•ã›ãŸã‚‰ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯æ•°åˆ†ã§å®Œäº†ã—ã¦ä»–ã®æ–°è¦æŽ¥ç¶šã‚‚å—ã‘ä»˜ã‘ã‚‰ã‚Œã¦ã„ã‚‹ã®ã«ã€å‰ã‹ã‚‰æŽ¥ç¶šã—ã¦ã„ãŸåˆ†ãŒå›ºã¾ã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãŒå§‹ã¾ã£ãŸç›´å¾Œã«æŠ•ã’ãŸãƒªã‚¯ã‚¨ã‚¹ãƒˆã®ã‚ã¨ã€ã†ã‚“ã¨ã‚‚ã™ã‚“ã¨ã‚‚è¨€ã‚ãªã„ã€‚ JDBCã®connectTimeoutã¯3ç§’ã«ã—ã¦ã‚ã£ã¦ã€SecurityGroupã®è¨å®šãƒŸã‚¹ãªã©ã§ã¤ãªãŒã‚‰ãªã„å ´åˆã¯5ç§’ã§ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆã™ã‚‹ã“ã¨ã¯ç¢ºèªæ¸ˆã¿ãªã®ã«ã€ã“ã®ã‚±ãƒ¼ã‚¹ã§ã¯ãŠè¿”äº‹ãŒå¸°ã£ã¦ã“ãªã„ã€‚ã€‚ã€‚ ããã£ã¦ã‚‚ã€æ–°è¦æŽ¥ç¶šæ™‚ã®ã‚¿ã‚¤ãƒ ã‚¢ã‚¦ãƒˆï¼ˆconnectTimeou
gologo13 2017/06/19
AWS

JDBC

Java

MySQL

RDS
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã«ã¤ã„ã¦è©±ã‚’ã—ã¦ããŸ #OSO2017 - ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³
å²¡å±±ã«ã¯ã‚ªãƒ¼ãƒ—ãƒ³ã‚»ãƒŸãƒŠãƒ¼å²¡å±±ã¨è¨€ã†æœ€é«˜ã®ã‚¤ãƒ™ãƒ³ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ okayama.open-seminar.org æ˜¨æ—¥ã¯ id:t-wada ã•ã‚“ã‚„ id:naoya ã•ã‚“ã®è³‡æ–™ãŒãƒ›ãƒƒãƒˆã‚¨ãƒ³ãƒˆãƒªãƒ¼å…¥ã‚Šã—ã¦ã¾ã—ãŸã€‚ ã“ã®ç™»å£‡ã¯ãã‚Œã¨åŒã˜ã‚¤ãƒ™ãƒ³ãƒˆã«ãªã‚Šã¾ã™ã€‚ ãã®ä»–ã®æ–¹ã‚‚è¶…è±ªè¯è¬›å¸«é™£ã®ä¸ã§ã€ç§ãŒå‡ºæ¥ã‚‹ç²¾ä¸€æ¯ã®çµŒé¨“ã‚‚è¸ã¾ãˆãŸãŠè©±ã‚’ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ speakerdeck.com ã“ã®ä¸ã§å‡ºã¦æ¥ã‚‹ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã¯æœ¬å½“ã«ç´ æ™´ã‚‰ã—ã„æœ¬ã§ã™ã€‚ Oracleãƒ™ãƒ¼ã‚¹ãªã®ã§ã™ãŒMySQLã ã‚ã†ãŒPostgreSQLã ã‚ã†ãŒå¿…ãšãŸã‚ã«ãªã‚‹æœ¬ã§ã™ã€‚ ã§ã™ãŒã€ã“ã®æœ¬ã¯æ—¢ã«å»ƒåˆŠã«ãªã£ã¦ãŠã‚Šå†è²©ã®äºˆå®šã‚‚ã‚ã‚Šã¾ã›ã‚“â€¦ åƒ•ã¯å¾Œä¸–ã«çµ¶å¯¾å¿…è¦ãªæœ¬ã®ä¸€ã¤ã ã¨æ€ã£ã¦ã„ã‚‹ã®ã§å†è²©ã®ãŸã‚ã«ã‚‚çš†ã•ã‚“ã®è¦æœ›ã®å£°ã‚’ä¸Šã’ã¦ã„ãŸã ã‘ã‚‹ã¨ã†ã‚Œã—ã„ã§ã™ã€‚ ãã—ãŸã‚‰ã‚‚ã—ã‹ã—ãŸã‚‰æœ¬ãŒä¸–ã«å¾©æ´»ã™ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ãŸSQLã‚¢ãƒ³ãƒãƒ‘ã‚¿
gologo13 2017/05/24
database

refactoring

RDBMS

mysql
ãƒªãƒ³ã‚¯
Nç§’é–“ã ã‘ã‚¯ã‚¨ãƒªå®Ÿè¡Œãƒã‚°ã‚’å–ã‚ŠãŸã„ - Hateburo: kazeburo hatenablog
pt-query-digestã ã£ãŸã‚Šèª¿æŸ»ã®ãŸã‚ã«ã€Nç§’é–“ã ã‘mysqlã®å…¨ã‚¯ã‚¨ãƒªã®ãƒã‚°ã‚’å–å¾—ã—ãŸã„ã¨ã„ã†ã“ã¨ã¯ã‚ˆãã‚ã‚Šã¾ã™ã‚ˆã ãã‚“ãªæ™‚ã¯ã“ã‚“ãªã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ç°¡å˜ã«æŒ‡å®šã®ç§’æ•°slowlogã‚’åˆ‡ã‚Šæ›¿ãˆã¦ä¿å˜ã€å–å¾—å¾Œã«å…ƒã«æˆ»ã—ã¦ãã‚Œã¾ã™ã€‚ $ slowlog.pl --duration 10 -- --default-extra-file=/hoge/my.cnf -uuser -- ã®ã‚ã¨ã¯mysqlã‚³ãƒžãƒ³ãƒ‰ã«æ¸¡ã™ã‚ªãƒ—ã‚·ãƒ§ãƒ³ ã‚½ãƒ¼ã‚¹ #!/usr/bin/perl use strict; use warnings; use IO::Handle; use Getopt::Long; use File::Spec; sub find_path { my $pg = shift; my $path; for ( split /:/, $ENV{PATH} ) { if ( -x "$_/$p
gologo13 2017/05/19
mysql
ãƒªãƒ³ã‚¯
MySQLã®AUTO_INCREMENTã«ã¤ã„ã¦è‰²ã€…ã¨èª¿ã¹ã¦ã¿ãŸã€‚ - Qiita
AUTO_INCREMENTã¨ã¯ ã‚«ãƒ©ãƒ ã«å€¤ãŒæŒ‡å®šã•ã‚Œãªã‹ã£ãŸå ´åˆã€MySQLãŒè‡ªå‹•çš„ã«å€¤ã‚’å‰²ã‚Šå½“ã¦ã‚‹ã€‚ ãƒ‡ãƒ¼ã‚¿åž‹ã¯æ•´æ•°ã€‚ å€¤ã¯1ãšã¤å¢—åŠ ã—ã¦é€£ç•ªã«ãªã‚‹ã€‚ åŸºæœ¬çš„ãªã“ã¨ã€‚ ãƒ†ã‚¹ãƒˆãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ mysql> CREATE TABLE fruit(id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, name VARCHAR(50), price INT); mysql> DESC fruit; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | id | in
gologo13 2017/05/16
mysql
ãƒªãƒ³ã‚¯
Troubleshooting Best Practices: Monitoring the Production Database Without Killing Performance
gologo13 2017/05/06
å„è«–ã¨ã„ã†ã‚ˆã‚Šã¯ã€ãƒžã‚¤ã‚°ãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®é€²ã‚æ–¹ã‚„å¿ƒå¾—çš„ãªè©±

migration

mysql

oracle
ãƒªãƒ³ã‚¯
innotopãŒæœ€è¿‘æ¯ã—ã¦ãªã„ãªãƒ¼ã¨æ€ã£ãŸã‚“ã
ä½¿ã£ã¦ã„ã‚‹äººå£ãŒã©ã‚Œãã‚‰ã„ã„ã‚‹ã‹ã‚ã‹ã‚‰ãªã„ã§ã™ãŒã€Â innotopÂ ã¨ã„ã†topãƒ©ã‚¤ã‚¯ã«MySQLã®çŠ¶æ³ã‚’è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ä¾¿åˆ©ã‚¹ã‚¯ãƒªãƒ—ãƒˆãŒä¸–ã®ä¸ã«ã¯å˜åœ¨ã—ã¦ã„ã¾ã™ã€‚ æ—¥ã€…ã®è¦šæ›¸: innotopãŒã™ã”ãä¾¿åˆ© ã‚‚ã¨ã‚‚ã¨Google Codeã«ãƒ›ã‚¹ãƒ†ã‚£ãƒ³ã‚°ã•ã‚Œã¦ãŸã‚“ã ã‘ã©ã€Google Codeã¯ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã—ã¡ã‚ƒã£ãŸã‹ã‚‰ï¼ˆã„ã¤ã‹ã‚‰ã‹çŸ¥ã‚‰ãªã„ã‘ã©ï¼‰GitHubã«ç§»è¡Œã—ã¦ã¦ã€ã²ã‚‡ã£ã¨ã—ãŸã‚‰ã“ã®ã¾ã¾ï¼ˆç§»è¡Œã ã‘ã—ã¦ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ã•ã‚Œãªããªã£ã¦ï¼‰æ¯ã‚’å¼•ãå–ã‚‹ã‚“ã˜ã‚ƒãªã„ã‹ç–‘æƒ‘ãŒå½“æ™‚ã‹ã‚‰ä¿ºã®ä¸ã«ã‚ã£ãŸã‚Šãªã‹ã£ãŸã‚Šã€‚ åŽŸå› ãŒãã‚Œã‹ã©ã†ã‹ã¯å…¨ãçŸ¥ã‚‰ãªã„ã‘ã‚Œã©ã€ innotopã¯5.6ã¾ã§ã¯å•é¡Œãªãä½¿ãˆã‚‹ï¼ˆ5.6ã§ä½¿ãˆãªããªã£ãŸæ™‚ã«ã¡ã‚ƒã‚“ã¨å¯¾å¿œã•ã‚ŒãŸï¼‰ã‚“ã ã‘ã©ã€5.7ã ã¨ `SHOW ENGINE INNODB STATUS` ã‚’ãƒ‘ãƒ¼ã‚¹ã§ããªããªã£ã¦ã„ã¦ï¼ˆãã‚Œä»¥å¤–ã¯ä½•ã¨ã‹ä½¿ãˆã‚‹ï¼‰ã€éšåˆ†å‰ã‹ã‚‰ã“ã‚Œã¯Issueã«ä¸ŠãŒã£
gologo13 2017/03/23
innodb

mysql
ãƒªãƒ³ã‚¯
Amazon Aurora äº‹ä¾‹ç¥ã‚Šï¼ˆ20170307ï¼‰ã«è¡Œã£ã¦ããŸãƒ¡ãƒ¢ | Hori Blog
Hori Blogãƒ•ãƒªãƒ¼ãƒ©ãƒ³ã‚¹ã§ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦æ´»å‹•ã—ã¦ã„ã‚‹ Ryota Hori ã®ãƒ–ãƒã‚°ã§ã™ã€‚ æœ€è¿‘ã¯ãƒ†ãƒƒã‚¯ç³»è¨˜äº‹ã‚ˆã‚Šé›‘è¨˜ãƒ–ãƒã‚°æ°—å‘³ã€‚ Amazon Aurora äº‹ä¾‹ç¥ã‚Š ã«è¡Œã£ã¦ããŸã®ã§ã€ãƒ¡ãƒ¢ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ç¤¾å†…å…±æœ‰ã§ Slack ã«è²¼ã‚ã†ã¨æ€ã£ã¦ã„ãŸãƒ¡ãƒ¢ãªã®ã§ã™ãŒã€é•·ããªã£ãŸã®ã§ãƒ–ãƒã‚°ã«å…¬é–‹ã—ã¾ã™ã€‚ æ¦‚è¦ Amazon Aurora äº‹ä¾‹ç¥ã‚Š ï¼ˆ2017 å¹´ 3 æœˆ 7 æ—¥é–‹å‚¬ï¼‰ | AWS ã‚»ãƒƒã‚·ãƒ§ãƒ³å†…å®¹ Amazon Aurora ã‚’ä½¿ã„ã“ãªã™ãŸã‚ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ã¨æœ€æ–°ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ @con_mame ã•ã‚“ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆ ç™»å£‡è³‡æ–™: [Aurora äº‹ä¾‹ç¥ã‚Š]Amazon Aurora ã‚’ä½¿ã„ã“ãªã™ãŸã‚ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹ é–‹ç™ºã‚µã‚¤ãƒ‰ã‹ã‚‰ã®çŸ¥è¦‹ã¨ä»Šå¾Œã®å±•æœ› PostgreSQL For Aurora ã§ã‚‹ã‚ˆï¼ 9.6.4 ã¨äº’æ› My
gologo13 2017/03/21
amazon

aurora

mysql
ãƒªãƒ³ã‚¯
[Auroraäº‹ä¾‹ç¥ã‚Š]Amazon Aurora ã‚’ä½¿ã„ã“ãªã™ãŸã‚ã®ãƒ™ã‚¹ãƒˆãƒ—ãƒ©ã‚¯ãƒ†ã‚£ã‚¹
2017/03/07é–‹å‚¬ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒAmazon Auroraäº‹ä¾‹ç¥ã‚Šã€ã§ã®è¡¨é¡Œã‚»ãƒƒã‚·ãƒ§ãƒ³è³‡æ–™ã§ã™ã€‚Read less
gologo13 2017/03/09
amazon

aurora

mysql
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ãƒ¼MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ç›£è¦–ã®ãƒ„ãƒœï¼ˆã‚¯ã‚¨ãƒªç·¨ï¼‰ ã“ã‚“ã«ã¡ã¯ã€ã‚¤ãƒ³ãƒ•ãƒ©æ‹…å½“æ–°äººã® nob ã§ã™ã€‚ ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã§ MySQL ã‚’ç›£è¦–ã—ã¦ã„ã‚‹ã®ã«ãƒ‡ãƒ¼ã‚¿ãŒå¤šã™ãŽã¦æ´»ç”¨ã—ã¦ã„ãªã„ã€‚ã¨ã„ã†æ–¹ã¯ã„ã¾ã›ã‚“ã‹ï¼Ÿãã®è±Šå¯Œãªãƒ‡ãƒ¼ã‚¿ã‚’ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ´»ç”¨ã—ãªã„æ‰‹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ä»Šå›žã¯ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ãƒ„ãƒ¼ãƒ«ã®ã‚°ãƒ©ãƒ•ã‚’èªã¿è§£ã„ãŸå®Ÿæˆ¦çµŒé¨“ã‚’å…ƒã«ã€ã€Œã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ã€ã¨ã„ã†ãƒ„ãƒœã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã ã‘è¦‹ã‚Œã°å¤§ä¸ˆå¤«ï¼ã€€ã‚¯ã‚¨ãƒªç·¨ã€€ï¼“ã¤ã®ã¤ã¼ã¨ï¼•ã¤ã®ã‚°ãƒ©ãƒ• ï¼ˆãã®ï¼‘ï¼‰ç›£è¦–ãƒ„ãƒ¼ãƒ«ãŒä½•ã‚’è¦‹ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚‹ ï¼ˆãã®ï¼’ï¼‰ç›£è¦–ã®ã‚ãƒ¢ã€ã‚°ãƒ©ãƒ•ï¼“ç‚¹ã‚»ãƒƒãƒˆ (Questions, Lock Waits ã¨ Transaction Handler) ï¼ˆãã®ï¼“ï¼‰ã‚°ãƒ©ãƒ•ã§ãƒã‚§ãƒƒã‚¯ã™ã‚‹ SQL ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ( Select Type ã¨ Handler) ã‚·ãƒ³ãƒ—ãƒ«ã§ãŠå‹§ã‚ã€ã‚µãƒ¼ãƒãƒ¼ç›£è¦–ã‚°ãƒ©ãƒ•åŒ–ãƒ„ãƒ¼ãƒ«
gologo13 2017/03/08
mysql

monitoring
ãƒªãƒ³ã‚¯
MySQL æ—¥ä»˜åˆ¥ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®é‹ç”¨ - 130å˜ä½
MySQL :: MySQL 5.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 15 ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° http://dev.mysql.com/doc/refman/5.1/ja/partitioning.html å®Ÿé¨“çš„ã«ã‚„ã£ã¦ã¿ãŸã ã‘ã§ãƒŽã‚¦ãƒã‚¦ã¨ã—ã¦å›ºã¾ã£ã¦ã¯ã„ãªã„ã®ã§ã™ãŒã€ç¾çŠ¶ã®çŸ¥è˜ã‚’ã¾ã¨ã‚ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ å‰æ MySQL 5.1ä»¥é™ æ¤œè¨¼ã—ãŸç’°å¢ƒã¯5.1.47 æ—¥ä»˜ã”ã¨ã«ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚° ã‚«ãƒ©ãƒ ã¯ä¸€æ„ãª"id"ã¨ä½œæˆæ—¥ä»˜ã®"created"ãŒã‚ã‚‹ã¨ã™ã‚‹ æº–å‚™ idã¨createdã‚’è¤‡åˆã§ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã«ã™ã‚‹ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã®æ¡ä»¶ã¯ãƒ—ãƒ©ã‚¤ãƒžãƒªã‚ãƒ¼ã«å«ã‚ã‚‹å¿…è¦ãŒã‚ã‚‹ idãŒAUTO_INCREMENTã§ã‚ã‚Œã°PRIMARY KEY (id, created)ã®é †ã®ã¿ createdã‚’TO_DAYS()ã—ã¦ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°ã™ã‚‹ å¤§æž ã¨å€‹åˆ¥ã®ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®ä¸¡æ–¹ã§TO_DAYS()ã™
gologo13 2017/03/01
purge

mysql

partitioning
ãƒªãƒ³ã‚¯
DEVShed
gologo13 2017/02/23
cool

mysql
ãƒªãƒ³ã‚¯
MySQL - 5.6 ç³»ã§ TIMESTAMP åž‹ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤è¦å‘Šï¼
[Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). timestamp åž‹ã®æš—é»™çš„ãªãƒ‡ãƒ•ã‚©ãƒ«ãƒˆå€¤ã¯éžæŽ¨å¥¨ã¨ã®ã“ã¨ã§ã€5.6.6 ã‹ã‚‰ã®è¦å‘Šã®ã‚ˆã†ã§ã™ã€‚ MySQL :: MySQL 5.6 Reference Manual :: 5.1.4 Server System Variables ä»¥ä¸‹ã€ç¾è±¡ç¢ºèªã¨å¯¾ç–ã«ã¤ã„ã¦ã®è¨˜éŒ²ã§ã™ã€‚ 0. å‰ææ¡ä»¶ Linux Mint 14 (64bit) ã§ã®ä½œæ¥ã‚’æƒ³å®šã—ã¦ã„ã‚‹ãŒã€OSãƒ»ãƒ‡ã‚£ã‚¹ãƒˆãƒªãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã¯å•ã‚ãªã„ã¯ãšã€‚ MySQL 5.6.11 ã§ã®ä½œæ¥ã‚’æƒ³å®šã€‚ 1. è¨å®šç¢ºèª MySQ
gologo13 2017/02/02
mysql
ãƒªãƒ³ã‚¯
MySQL5.6ã§å¢—ãˆãŸexplicit_defaults_for_timestamp - hiroi10ã®ãƒ–ãƒã‚°
ã‚ã¾ã‚Šããã£ã¦ã‚‚å‡ºã¦ã“ãªã‹ã£ãŸã®ã§ç°¡å˜ã«æ›¸ã„ã¦ã¿ã‚‹ã€‚ MySQL5.5ã®my.cnfã‚’ãã®ã¾ã¾æµç”¨ã—ã¦MySQL5.6ã‚’èµ·å‹•ã™ã‚‹ã¨ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒã‚¨ãƒ©ãƒ¼ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã«å‡ºåŠ›ã•ã‚Œã‚‹ã€‚é•·ã„ã®ã§æ”¹è¡Œã—ã¦ã„ã¾ã™ãŒå®Ÿéš›ã¯ä¸€è¡Œã€‚ 121104 22:29:57 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).ã“ã¡ã‚‰ã¯MySQL 5.6.6ã‹ã‚‰è¿½åŠ ã•ã‚ŒãŸexplicit_defaults_for_timestampã«ã‚ˆã‚‹ã‚‚ã®ã€‚ booleanã§ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯FALSE(0)ã€‚å‹•çš„å¤‰æ›´ã¯ä¸å¯ã¨ãªã‚Šã¾ã™ã€‚å…¬å¼Doc ã¨ã‚Šã‚ãˆãšFALSEã®
gologo13 2017/02/02
mysql
ãƒªãƒ³ã‚¯
MySQL 5.7ã«ã‚„ã‚‰ã‚Œãªã„ãŸã‚ã«ãŠã¼ãˆã¦ãŠã„ã¦ã»ã—ã„ã“ã¨
2015/10/03 phpcon 2015 updated at 2016/01/13 about default_password_lifetime's default will be 0Read less
gologo13 2017/02/02
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
gologo13 2017/02/02
MySQL
ãƒªãƒ³ã‚¯
MySQL 5.7ã®é‡è¦æ©Ÿèƒ½ã¾ã¨ã‚ | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚MySQL 5.7ã«ã¯ãŸãã•ã‚“ã®æ”¹å–„ã‚„æ–°æ©Ÿèƒ½ãŒç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã¾ã™ãŒã€ãã®ä¸ã§ã‚‚ç‰¹ã«é‡è¦ãªã‚‚ã®ã«ã¤ã„ã¦ã®ã¾ã¨ã‚ã€‚ ã‚ã‚‹æ—¥ã€Percona Supportã®é¡§å®¢ã¨MySQL 5.7ã®æ–°æ©Ÿèƒ½ã«ã¤ã„ã¦è°è«–ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã™ãŒã€ãã®å¾Œã€é‡è¦ãªæ©Ÿèƒ½ã‚’ã¾ã¨ã‚ãŸãƒªã‚¹ãƒˆãŒã‚ã£ãŸã‚‰ã„ã„ã‚“ã˜ã‚ƒãªã„ã‹ã¨è€ƒãˆã¾ã—ãŸã€‚æœ€æ–°ã®MySQL 5.7.6 ãƒªãƒªãƒ¼ã‚¹äºˆå®šç‰ˆ(RC)ãŒã€ç´ æ™´ã‚‰ã—ã„æ©Ÿèƒ½ã‚’è©°ã‚è¾¼ã‚“ã§å…¬é–‹ã•ã‚ŒãŸã°ã‹ã‚Šã€‚ã“ã‚ŒãŒMySQL 5.7ã®é‡è¦æ©Ÿèƒ½ä¸€è¦§ã§ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®æ‹¡å…… MySQL 5.7ã®æœ€é‡è¦æ©Ÿèƒ½ã®1ã¤ã¯ã€ãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã—ã‚‡ã†ã€‚ã“ã®æ©Ÿèƒ½ã§ã¯ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«å¯¾ã—ã¦è¤‡æ•°ã®ãƒžã‚¹ã‚¿ã‚’æŒ‡å®šã§ãã€ã“ã‚Œã¾ã§ã®ãƒžã‚¹ã‚¿ãŒ1å°ã®ã¿ã¨ã„ã†åˆ¶é™ãŒãªããªã‚Šã¾ã™ã€‚åŒåƒšãŒæ›¸ã„ãŸãƒžãƒ«ãƒã‚½ãƒ¼ã‚¹ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã®ã„ã„ãƒ–ãƒã‚°è¨˜äº‹(æ—¥æœ¬èªžè¨³)ãŒå½¹ã«ç«‹ã¤ã¯ãšã§ã™
gologo13 2017/02/02
mysql
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸