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

akatuki_sato id:akatuki_sato

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

${{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ã®caseæ–‡ã§è¤‡æ•°ã®æ¡ä»¶ã‚’æŒ‡å®šã™ã‚‹
mysqlåˆå¿ƒè€…ã§ã™ã€‚ä»¥ä¸‹ã®ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰å‹¤å‹™æ™‚é–“ï¼ˆend_time-start_time-break _timeï¼‰ãŒï¼˜æ™‚é–“ä»¥ä¸Šã€ã‹ã¤çµ‚äº†æ™‚é–“ãŒï¼’ï¼’æ™‚ä»¥é™ã®å ´åˆã€ï¼ˆend_time-22:00ï¼‰ã‚’æ·±å¤œæ®‹æ¥æ™‚é–“ã¨ã—ã¦ã€æ·±å¤œæ®‹æ¥æ™‚é–“ã‚’è¨ˆç®—ã—ãŸã„ã®ã§ã™ãŒã€caseæ–‡ã§å ´åˆåˆ†ã‘ã—ã¦Aã‹ã¤Bã®å ´åˆã¨ã„ã†ã‚ˆã†ãªæ›¸ãæ–¹ã¯ã©ã®ã‚ˆã†ã«æ›¸ã„ãŸã‚‰ã„ã„ã§ã—ã‚‡ã†ã‹ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ nameã€€ã€€start_timeã€€ã€€end_timeã€€ã€€break_time ç”°ä¸ã€€ã€€ã€€9:00ã€€ã€€ã€€ã€€ã€€ã€€22:30ã€€ã€€ã€€ã€€1:00 ä½è—¤ã€€ã€€ã€€9:00ã€€ã€€ã€€ã€€ã€€ã€€21:00ã€€ã€€ã€€ã€€1:00 æ¸¡è¾ºã€€ã€€ã€€ï¼‘0:00ã€€ã€€ã€€ã€€ã€€24:00ã€€ã€€ã€€ã€€1:00 è—¤åŽŸã€€ã€€ã€€9:00ã€€ã€€ã€€ã€€ã€€ã€€18:00ã€€ã€€ã€€ã€€1:00
akatuki_sato 2013/11/15
MySQL
ãƒªãƒ³ã‚¯
ã€MySQLã€‘GROUP_CONCAT()ã‚’ä½¿ã£ã¦ã¿ã‚‹ at softelãƒ¡ãƒ¢
ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒã‚ã‚‹ã¨ã—ã¾ã™ã€‚ ï¼¡ãƒ†ãƒ¼ãƒ–ãƒ« ï¼¢ãƒ†ãƒ¼ãƒ–ãƒ« ä»¥ä¸‹ã®ã‚ˆã†ãªSQLã‚’æµã™ã¨ã€ SELECT A.id, GROUP_CONCAT(B.bname) as namae FROM A, B WHERE A.id = B.aid GROUP BY A.id ã“ã‚“ãªé¢¨ã«ã€ã¾ã¨ã‚ã¦ãã‚Œã¾ã—ãŸã€‚ ãã®ã»ã‹ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã“ã¨ã‚‚ã§ãã¾ã™ã€‚ æ˜‡é †ãƒ»é™é †ã«ä¸¦ã¹ã¦ãã‚Œã‚‹ GROUP_CONCAT(B.bname order by B.id) é‡è¤‡ã™ã‚‹åå‰ã‚’ã¾ã¨ã‚ã¦ãã‚Œã‚‹ GROUP_CONCAT(distinct(B.bname)) åŒºåˆ‡ã‚Šæ–‡å—æŒ‡å®šã‚‚ã§ãã‚‹ GROUP_CONCAT(B.bname separator '/') å‚è€ƒ ãƒ» MySQLã®ç‹¬è‡ªã®é–¢æ•°ãªã®ã§ã€ä»–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã†å ´åˆã¯è¦æ¤œè¨Žï¼ˆOracleã ã¨wmsys.wm_concatãŒã‚ã‚‹ãªã©ï¼‰ã€‚ ãƒ» NULLã‚’å«ã‚€å ´åˆæ³¨æ„ã€‚ ã“ã®
akatuki_sato 2013/09/20
åŠ©ã‹ã£ãŸã

MySQL

è¨å®š
ãƒªãƒ³ã‚¯
Devsã®å¸¸è˜ã€DBAã¯éžå¸¸è˜
1. MySQL Admin ãŒè¦‹ãŸ Devs ã®å¸¸è˜ã€ DBA ã¯éžå¸¸è˜ 2013/09/14 yoku0825@MyNA PHP Conference 2013 2. ï¼¼ã“ã‚“ã«ã¡ã¯ï¼ï¼ â— yoku0825 â— ã¨ã‚ã‚‹ä¼æ¥ã® DBA â— MySQL æ´ 5 å¹´ãã‚‰ã„ â— ã‚ªãƒ©ã‚¯ã‚Œãªã„ â— ãƒã‚¹ã‚°ã‚Œãªã„ â— å«ã®å¤« â— ã›ãŒã‚Œã®çˆ¶ â— æ—¥æœ¬ MySQL ãƒ¦ãƒ¼ã‚¶ä¼š (MyNA) ã®ã‚¹ãƒ™ã‚Šæ‹…å½“ 3. ï¼¼ã—ã‚ƒã¹ã‚‹ã“ã¨ï¼ï¼ â— æ—¥å¸¸çš„ã« MySQL ã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã«è§¦ã‚Œã‚‹å¤‰æ…‹ DBA ãŒãƒ•ãƒ„ãƒ¼ã® Devs ã«æŠ•ã’ãŸæ„›ã®ãƒžã‚µã‚«ãƒªé›† ( ã®ã¤ã‚‚ã‚Š ) â— ã‚¦ãƒã®é–‹ç™ºè¨€èªžã¯ PHP > Java >> Ruby ã‚‰ã—ã„ã§ã™ â— ã‚¦ãƒã§ã¯ DBA ãŒã‚µãƒ¼ãƒãƒ¼ã®æ§‹ç¯‰ã€ Devs ãŒè¨è¨ˆãƒ» ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹ç¯‰ãƒ»é‹å–¶ã€ DBA ã¯ãƒˆãƒ©ãƒ–ãƒ«ã‚·ãƒ¥ãƒ¼ãƒˆã‚„æ”¹ å–„ææ¡ˆ ( é‹ç”¨ ) ã€ã¨ã„ã†ã‚µã‚¤ã‚¯ãƒ«ã§å›žã—ã¦ã„ã¾ã™ã€‚
akatuki_sato 2013/09/16
MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL 5.6 ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æ¤œè¨Žä¼š - SH2ã®æ—¥è¨˜
7æœˆ29æ—¥ã«MyNA(æ—¥æœ¬MySQLãƒ¦ãƒ¼ã‚¶ä¼š)ä¼š 2013å¹´7æœˆãŒè¡Œã‚ã‚Œã€Oracle ACE Directorã®@sheeriã•ã‚“ã€MyNAä¼šé•·ã®@tmtmsã•ã‚“ã«æ··ã–ã£ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚é‹å–¶ã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã„ã¤ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ Performance Schema - Sheeri Cabral (PDF) MyNAä¼š2013å¹´7æœˆ ã«è¡Œã£ã¦æ¥ã¾ã—ãŸ - MySQLã®ãƒ—ãƒãƒˆã‚³ãƒ«è§£èª¬ - @tmtms ã®ãƒ¡ãƒ¢ ä»Šå›žã¯@yoku0825ã•ã‚“ã€@yyamasaki1ã•ã‚“ãŒãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯ã‚’ã•ã‚Œã¾ã—ãŸã€‚@yoku0825ã•ã‚“ã‚¢ã‚¤ã‚¹ã”ã¡ãã†ã•ã¾ã§ã—ãŸã€‚ æ—¥ã€…ã®è¦šæ›¸: MyNAä¼š2013å¹´7æœˆã«è¡Œã£ã¦ãã¾ã—ãŸ 5åˆ†ã§ä½œã‚‹MySQL Clusterç’°å¢ƒ ç§ã¯ç™ºè¡¨å†…å®¹ã«ã¤ã„ã¦æ‡‡è¦ªä¼šã§ã„ã‚ã„ã‚å®¿é¡Œã‚’ã‚‚ã‚‰ã£ã¦ã—ã¾ã„ã€ã—ã°ã‚‰ãå¾©ç¿’ã‚’ã—ã¦ã„ã¾ã—ãŸã€‚ã‚ˆã†ã‚„ãä¿®æ£ãŒçµ‚ã‚ã‚Šã¾
akatuki_sato 2013/08/06
ã‚ã¨ã§èªã‚€

ã‚ã¨ã§èªã‚€

MySQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - ãªã‚“ã¨3æ–‡å—ã§èªè¨¼å›žé¿ãŒå¯èƒ½ã«
æ˜¨æ—¥ã®ã‚¨ãƒ³ãƒˆãƒªã€ŒSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚´ãƒ«ãƒ• - èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ã¯ã©ã“ã¾ã§çŸãã§ãã‚‹ã‹?ã€ã«ã¦ã€èªè¨¼å›žé¿ã®æ”»æ’ƒæ–‡å—åˆ—ãŒ5æ–‡å—ã«ã§ãã‚‹ï¼ˆã€Œ'OR'1ã€ï¼‰ã“ã¨ã‚’ç¤ºã—ã¾ã—ãŸãŒã€@masa141421356ã•ã‚“ã¨ã€ã‚„ã¾ã–ãã•ã‚“ï¼ˆãŠäºŒäººã¨ã‚‚æ‹™è‘—ã®ãƒ¬ãƒ“ãƒ¥ã‚¢ãƒ¼ã§ã™ï¼‰ã‹ã‚‰ã€idã¨pwdã«ã¾ãŸãŒã£ãŸæ”»æ’ƒä¾‹ã‚’ç¤ºã—ã¦ã„ãŸã ãã¾ã—ãŸã€‚ã‚„ã¾ã–ãã•ã‚“ã®ä¾‹ã¯ã€MySQLé™å®šãªãŒã‚‰ã€ãªã‚“ã¨3æ–‡å—ã§ã™ã€‚ã“ã‚Œã¯ã™ã”ã„ã€‚ @masa141421356ã•ã‚“ã®æ”»æ’ƒä¾‹ @masa141421356ã•ã‚“ã®ãƒ„ã‚¤ãƒ¼ãƒˆã‚’å¼•ç”¨ã—ã¾ã™ã€‚ @ockeghem å¤§æŠµã®DBã§id=''OR' AND pwd='>' ' ãŒé€šã‚‹ã¨æ€ã„ã¾ã™ï¼ˆidå´ã«ã€Œ'ORã€, pwdå´ã«ã€Œ>' ã€ã§6æ–‡å—ï¼‰ã€‚é•·ã•0ã®æ–‡å—åˆ—ãŒNULLæ‰±ã„ã•ã‚Œãªã„DBãªã‚‰æœ€å¾Œã®ã‚¹ãƒšãƒ¼ã‚¹ã‚’æ¶ˆã—ã¦5æ–‡å—ã§ã™ã€‚ â€” masa141421356 (@masa141421356) June
akatuki_sato 2013/06/25
MySQL
ãƒªãƒ³ã‚¯
MySQL 5.5ã§ã€Œdefault-character-setã€ãŒä½¿ãˆãšæ–‡å—åŒ–ã‘ã™ã‚‹â†’ã€Œcharacter-set-serverã€ã«ã™ã‚‹ã¨OK | KennyQi PHP Blog
MySQLã‚’5.5ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¾ã—ãŸã€‚ MySQLã‚’èµ·å‹•ã™ã‚‹ã¨ã€ Faildã«ï¼ï¼ï¼ï¼ ãƒã‚°ã‚’èª¿ã¹ã¦ã¿ãŸã‚‰ã€Œdefault-character-setã€ã£ã¦ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã¦ä½•ï¼Ÿã¿ãŸã„ãªã®ãŒå‡ºã¦ã¾ã—ãŸã€‚ã€‚ ã§ã€èª¿ã¹ãŸã‚‰è§£æ±ºã—ã¾ã—ãŸã®ã§ãƒ¡ãƒ¢ã€‚ [mysql]MySQL 5.5.3-m3, 5.5.4-m3 åŒæ™‚ãƒªãƒªãƒ¼ã‚¹ ã“ã“ã«æ›¸ã„ã¦ã‚ã‚‹ã¨ãŠã‚Šã€MySQLã‚µãƒ¼ãƒã®ã»ã†ã¯ ã€Œdefault-character-setã€ã¨ã„ã†ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãŒå»ƒæ¢ã•ã‚Œã¦ã€ ã€Œcharacter-set-serverã€ã«ãªã£ãŸæ¨¡æ§˜ã€‚ ã§ã€ä¸‹è¨˜ã®ã‚ˆã†ã«my.cnfã‚’ä¿®æ£ã—ã¦MySQLã‚’èµ·å‹•ã—ãŸã‚‰ç„¡äº‹ã«å†èµ·å‹•ã§ãã¾ã—ãŸã€‚ # vi /etc/my.cnf # default-character-set=utf8 â†ã“ã“ã¯ã‚³ãƒ¡ãƒ³ãƒˆã‚¢ã‚¦ãƒˆ character-set-server=utf8 # ã“ã“ã‚’è¿½åŠ ã¡ãªã¿
akatuki_sato 2013/05/13
mysql

MySQL
ãƒªãƒ³ã‚¯
MySQLã¨è‹±èªžã®ãƒªã‚¹ãƒ‹ãƒ³ã‚°ã‚’åŒæ™‚ã«å‹‰å¼·ã™ã‚‹æ–¹æ³•ã€‚
è‹±èªžã‚’å‹‰å¼·ã—ãŸã„ãŒæŠ€è¡“ã‚‚å‹‰å¼·ã—ãŸã„ã€‚ãã‚Œã¯æŠ€è¡“è€…ã«ã¨ã£ã¦æ‚©ã¾ã—ã„æ‚©ã¿ã§ã¯ã„ã ã‚ã†ã‹ã€‚ãã‚“ãªæ‚©ã‚ã‚‹æŠ€è¡“è€…è«¸å›ã«ã¨ã£ã¦å–œã°ã—ã„çŸ¥ã‚‰ã›ãŒã‚ã‚‹ã€‚MySQLã®å‹‰å¼·ã‚‚è‹±èªžã®ãƒªã‚¹ãƒ‹ãƒ³ã‚°ã‚‚åŒæ™‚ã«ã§ãã‚‹ã€ãã†OurSQL Database Community Podcastãªã‚‰ãã€‚ OurSQL: The MySQL Database Community Podcast ã ã„ãŸã„1å›ž30åˆ†å‰å¾Œã§MySQLã«ã¤ã„ã¦æ§˜ã€…ãªãƒˆãƒ”ãƒƒã‚¯ã«ã¤ã„ã¦ã®ãƒ‡ã‚£ã‚¹ã‚«ãƒƒã‚·ãƒ§ãƒ³ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚æ—¢ã«ã‚¨ãƒ”ã‚½ãƒ¼ãƒ‰69ã¾ã§ãŸã¾ã£ã¦ã„ã‚‹ã®ã§ã¾ã•ã«èžãæ”¾é¡Œã ï¼Webãƒšãƒ¼ã‚¸ä¸Šã§ç›´æŽ¥è´ãã“ã¨ã‚‚ã§ãã‚‹ã—ã€ãŠæ°—ã«å…¥ã‚Šã®ãƒŸãƒ¥ãƒ¼ã‚¸ãƒƒã‚¯ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã§è´ããªã‚‰ä¸‹è¨˜ã®Podcast Feedã®URLã‚’ç™»éŒ²ã™ã‚Œã°è‰¯ã„ã€‚ç†è€…ã¯Amarokã§è´ã„ã¦ã„ã‚‹ã€‚ http://technocation.org/audio/feed Enjoy!!
akatuki_sato 2011/12/16
å¾Œã§iPhoneã§èžã„ã¦ã¿ã‚‹

MySQL

å‹‰å¼·

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

è‹±èªž
ãƒªãƒ³ã‚¯
MySQLã®ã‚³ãƒžãƒ³ãƒ‰ãŸã¡ - ã™ãŽã‚ƒãƒ¼ã‚“ãƒ¡ãƒ¢
http://mysql-casual.org/2011/11/mysql-casual-advent-calendar-2011.html ã®6æ—¥ç›®ã®è¨˜äº‹ã¨ã—ã¦æ›¸ã‹ã›ã¦ã„ãŸã ãã¾ã™ã€sugyanã§ã™ã€‚ å‹¢ã„ã§å‚åŠ è¡¨æ˜Žã—ã¦ã—ã¾ã„ã€ä»Šæ—¥æ…Œã¦ã¦ä¹…ã—ã¶ã‚Šã«MySQLã‚’è§¦ã‚Šã¾ã—ãŸã€‚ MySQLã§FizzBuzz ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã£ã¦ä½¿ã£ãŸã“ã¨ç„¡ã‹ã£ãŸã®ã§åˆã‚ã¦è§¦ã£ã¦ã¿ã¾ã—ãŸã€‚ DROP PROCEDURE IF EXISTS FizzBuzz; delimiter // CREATE PROCEDURE FizzBuzz(n INT) BEGIN DECLARE i INT DEFAULT 1; WHILE i <= n DO SELECT CASE WHEN i % 3 = 0 AND i % 5 = 0 THEN 'FizzBuzz' WHEN i % 5 = 0 THEN 'Buzz'
akatuki_sato 2011/12/07
MySQL

ã‚³ãƒžãƒ³ãƒ‰
ãƒªãƒ³ã‚¯
3000req / sec ã¨æˆ¦ã† - ã ã‚‹ã‚ã
ã–ã£ãã‚Šæ¦‚è¦ ãƒ”ãƒ¼ã‚¯ã§3000req / sec æ¯Žåˆ†ã‚³ãƒ³ãƒ†ãƒ³ãƒ„æ›´æ–°è¦æ±‚ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„æ›´æ–°ã®éš›ã¯ä»–æ‰€ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’apiçµŒç”±ã§å—ã‘å–ã‚‹ ã‚³ãƒ³ãƒ†ãƒ³ãƒ„æ›´æ–°ã«ã¯TheSchwartzã‚’ä½¿ç”¨ ãªã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚’è‰²ã€…ã—ã¦ããŸãƒã‚°ã€‚ å°šã€ã“ã“ã«æ›¸ãæŠ€è¡“ã¯å¤§åŠãŒå‘¨å›²ã®ã‚®ãƒ¼ã‚¯ãªæ–¹ã€…ã«ã‚µãƒãƒ¼ãƒˆã—ã¦ã‚‚ã‚‰ã£ãŸã‚‚ã®ã§ã€åƒ•è‡ªèº«ãŒä½•ã‹ã—ãŸã‚ã‘ã§ã¯ãªã„ã€‚æ®‹å¿µã™ãŽã‚‹ã€‚ æ§‹æˆ internet -> www(squid -> apache) -> app(memcached -> app) -> db ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ wwwã‚µãƒ¼ãƒãŒapacheã¨squidã‚’å‹•ã‹ã—ã¦ã„ã‚‹ã€‚apacheãŒãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å—ã‘ã€squidã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæœ‰ã‚Œã°ãã‚Œã‚’è¿”ã—ã€ç„¡ã‘ã‚Œã°ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã®appã‚µãƒ¼ãƒã¸proxyã€‚ ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ appã‚µãƒ¼ãƒãŒmemcachedã¨ã‚¢ãƒ—ãƒªã‚’å‹•ã‹ã—ã¦ã„ã‚‹ã€‚ ãã‚Œãžã‚Œå†—é•·åŒ–ã—ã¦ã‚‹ã‘ã©ã€ãƒªã‚¯ã‚¨ã‚¹ãƒˆæ•°ã®å‰²ã«å°æ•°ã¯å°‘ãªã„ã€‚ æŠ€è¡“ãŒã‚
akatuki_sato 2011/09/25
ã‚µãƒ¼ãƒ

Apache

memcached

MySQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ–ã‚µãƒŸ2010ã€Œé«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã®Linux-DBã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰/é‹ç”¨æŠ€è¡“ã€è¡Œã£ã¦ããŸ - hiroyã®ãƒ–ãƒã‚°
ãƒ‡ãƒ–ã‚µãƒŸã«ä¼šç¤¾ã‚’æŠœã‘å‡ºã—ã¦è¡Œã£ã¦ããŸã€‚å‚åŠ ã—ãŸã®ã¯1ã¤ã ã‘ã ã‘ã©ã€‚æ°—ã«ãªã£ãŸéƒ¨åˆ†ã¨ã‹ã®ãƒ¡ãƒ¢ã‚’å…¬é–‹ã€‚ DBè£½å“ã®å“è³ªã€ã¨ã„ã†è¦³ç‚¹ãŒé‡è¦ ä¸€èˆ¬è§£ã‚’æ±‚ã‚ã™ãŽãªã„ã“ã¨ ç¤¾å†…æ¨™æº–ã§å…¨éƒ¨æƒãˆã‚ˆã†ã¨ã—ãŸã‚Šã™ã‚‹ã¨åŠ¹çŽ‡ãŒæ‚ªã„ã“ã¨ã‚‚ ã‚¢ãƒ—ãƒªã®æ€§è³ªã«ã‚ˆã£ã¦è¨å®šã¯å¤‰ãˆã‚‹ã¹ã ã‚ˆã„ã¨ã“ã‚ã‚ˆã‚Šæ‚ªã„ã¨ã“ã‚ã‚’è¦‹ã‚ˆã† å®‰å®šæ€§é‡è¦ ãƒ¡ãƒ¢ãƒª ãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆI/Oã‚’ä½¿ãŠã† innodb_flush_method = O_DIRECT ã‚¹ãƒ¯ãƒƒãƒ—/OOMã‚ãƒ©ãƒ¼ã‚’é¿ã‘ã‚‹ vm.swappiness = 0 Innodb Pluginãªã‚‰mallocã®è¨å®šãŒã§ãã‚‹ innodb_use_sys_malloc I/Oã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ© noopã‚„deadlineã«å¤‰æ›´ã™ã‚‹ã®ã‚‚ã„ã„ã‹ã‚‚ï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã¯cfqï¼‰ MySQL 5.4ã ã¨å¤§å·®ãªã„ã‘ã© MySQL 5.1ã ã¨ãã‚Œãªã‚Šã«å·®ãŒã‚ã‚‹ I/Oã‚¹ãƒ¬ãƒƒãƒ‰ã®æ•°ã«å·®ãŒã‚ã‚‹ãŸã‚ MyISAMãªã‚‰I/Oã®ã‚ãƒ¥ãƒ¼ã‚µ
akatuki_sato 2011/06/24
MySQL

DB

è¨å®š
ãƒªãƒ³ã‚¯
MySQLã®æŽ¥ç¶šæ•°ã‚’èª¿ã¹ã‚‹æ–¹æ³• - hiroyã®ãƒ–ãƒã‚°
MySQLã®æŽ¥ç¶šæ•°ã¨ã‹èª¿ã¹ã‚‹æ–¹æ³•ã€‚ mysqladmin -u root extended-status | grep -E 'Max|Threads'ã“ã‚Œã§Max_used_connectionsã€Threads_cachedã€Threads_connectedã€Threads_createdã€Threads_runningã®å€¤ãŒä¸€åº¦ã«ã¨ã‚Œã‚‹ã€‚
akatuki_sato 2011/06/24
MySQL
ãƒªãƒ³ã‚¯
skip-name-resolveé‡è¦ - hiroyã®ãƒ–ãƒã‚°
MySQLã‚’ä½¿ã£ã¦ã„ã¦ã€ã‚µãƒ¼ãƒãƒ¼ã®è² è·ã¯é«˜ããªã„ã®ã«æŽ¥ç¶šã§ããªã„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒç™ºç”Ÿã€çŠ¶æ³ã‚’è¦‹ã‚ˆã†ã¨show processlistã™ã‚‹ã¨unauthenticated userãŒãŸãã•ã‚“ã„ã‚‹ã“ã¨ãŒã‚ã‹ã£ãŸã€‚ãã®ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ãµã‚Œã¦max connectionsã«åˆ°é”ã€æŽ¥ç¶šã§ããªã„ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆãŒã‚ã‚‹ã‚‰ã—ã‹ã£ãŸã€‚ ã„ã‚ã„ã‚èª¿ã¹ã¦ã¿ã‚‹ã¨ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®IPã‚¢ãƒ‰ãƒ¬ã‚¹ã®DNSé€†å¼•ãã‚’ã—ã¦ã„ã¦ã€ãã®å‡¦ç†ãŒè¿½ã„ã¤ã‹ãªããªã‚‹ã¨ãã†ãªã‚‹ã‚‰ã—ãã€è§£æ±ºæ–¹æ³•ã¨ã—ã¦ã¯2ã¤ã‚ã£ãŸã€‚ /etc/hostsã§ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®åå‰è§£æ±ºã‚’ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ /etc/my.cnfã«skip-name-resolveã‚’è¨å®šã—ã¦MySQLã‚’restart /etc/hostsã§ã®å¯¾ç–ã¯ãŠæ‰‹è»½ã ãŒãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ãŒé¢å€’ãªæ„Ÿã˜ã€‚ skip-name-resolveã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ä»˜ã‘ã¦ã„ãªã‹ã£ãŸã£ã‘â€¦ã¨èª¿ã¹ãŸã‚‰ä»˜ã„ã¦ã„ãªã„ã“ã¨ãŒç™ºè¦šã€‚/etc/
akatuki_sato 2011/06/24
MySQL

DNS

è¨å®š
ãƒªãƒ³ã‚¯
DeNAã«ã‚ˆã‚‹å¤§è¦æ¨¡ãªMySQLãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—é‹ç”¨ã®è£å´ã«ã‚ã‚‹ã€ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«
4æœˆ11æ—¥ã‹ã‚‰ç±³ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§è¡Œã‚ã‚ŒãŸã€ŒMySQL Conference & Expo 2011ã€ã€‚ã“ã®ã‚¤ãƒ™ãƒ³ãƒˆã§DeNAã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒã€åŒç¤¾ã®å¤§è¦æ¨¡ãªMySQLã®é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹æŠ€è¡“ã¨ãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒAutomated, Non-Stop MySQL Operations and Failoverã€ã‚’è¡Œã„ã¾ã—ãŸã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³ã®ä¸ã§ã€ç¤¾å†…ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã®è‡ªå‹•åŒ–ãƒ„ãƒ¼ãƒ«ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹åŒ–ã™ã‚‹ã“ã¨ã«ã‚‚è§¦ã‚Œã¦ã„ã¾ã™ï¼ˆè‹±èªžã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚‚ä½œæˆä¸ã¨ã®ã“ã¨ï¼‰ã€‚ MySQLã®å¤§è¦æ¨¡é‹ç”¨ã«ãŠã‘ã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ã¯ã€ç‰¹ã«ã‚¯ãƒ©ã‚¦ãƒ‰ã§ã®MySQLã®åˆ©ç”¨ãŒå¢—ãˆã‚‹ã«ã¤ã‚Œã¦ãƒ‹ãƒ¼ã‚ºãŒé«˜ã¾ã‚‹åˆ†é‡Žã¨æ€ã‚ã‚Œã¾ã™ã€‚ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã®ã§ã€ãã®ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ è‡ªå‹•åŒ–ã•ã‚ŒãŸãƒŽãƒ³ã‚¹ãƒˆãƒƒãƒ—ãªMySQLã®é‹ç”¨ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã§ã¯é«˜å¯ç”¨æ€§ãŒå¼·ãæ±‚
akatuki_sato 2011/04/15
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

MySQL

dena
ãƒªãƒ³ã‚¯
MySQL 5.6ç™»å ´ï¼ï¼æ–°æ©Ÿèƒ½é€Ÿæ”»ãƒ¬ãƒ“ãƒ¥ãƒ¼
ç¾åœ¨ã€ç±³å›½ã§è¡Œã‚ã‚Œã¦ã„ã‚‹MySQL Conference & Expoã«ã‚ã‚ã›ã¦ã€æ–°ã—ã„é–‹ç™ºç‰ˆã§ã‚ã‚‹MySQL 5.6ãŒç™ºè¡¨ã•ã‚ŒãŸã€‚MySQL 5.5ã«ãŠã‘ã‚‹æ–°æ©Ÿèƒ½ã‚‚ã‹ãªã‚Šã®ã‚‚ã®ã ã£ãŸãŒã€MySQL 5.6ã®é€²åŒ–ã¯è³ªãƒ»é‡ã¨ã‚‚ã«å‹ã¨ã‚‚åŠ£ã‚‰ãªã„å†…å®¹ã¨ãªã£ã¦ã„ã‚‹ã€‚ãã“ã§ã€ä»Šæ—¥ã¯ç°¡å˜ã«ã€MySQL 5.6ã§è¿½åŠ ã•ã‚ŒãŸæ–°æ©Ÿèƒ½ã®æ¦‚è¦ã«ã¤ã„ã¦è¦‹ã¦ã¿ã‚ˆã†ã€‚é–‹ç™ºç‰ˆãªã®ã§åˆ©ç”¨ã«ã‚ãŸã£ã¦ã¯ååˆ†ãªæ³¨æ„ãŒå¿…è¦ï¼ˆäºˆæœŸãªãäºˆå®šãŒå¤‰æ›´ã•ã‚Œã‚‹å¯èƒ½æ€§ã‚ã‚Šï¼‰ã ãŒã€æ¬¡æœŸæ£å¼ç‰ˆã®ãƒªãƒªãƒ¼ã‚¹ã«å‘ã‘ã¦æ˜¯éžè©¦ã—ã¦ã¿ã¦æ¬²ã—ã„ã€‚ InnoDBé–¢é€£MySQL 5.5ã§å¤§å¹…ãªé€²åŒ–ã‚’é‚ã’ãŸInnoDBã ãŒã€ãã®å‹¢ã„ã¯ã¾ã£ãŸãè¡°ãˆã‚‹ã“ã¨ã‚’çŸ¥ã‚‰ãªã„ã€‚æ€§èƒ½ã®å¼·åŒ–ã ã‘ã§ãªãã€ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šãä¾¿åˆ©ãªæ©Ÿèƒ½ãŒè¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã€‚ ãƒ€ãƒ¼ãƒ†ã‚£ãƒšãƒ¼ã‚¸ã®ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ã‚’ã™ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã€‚ä»¥å‰ã¯ãƒžã‚¹ã‚¿ãƒ¼ã‚¹ãƒ¬ãƒƒãƒ‰å†…ã§ãƒ•ãƒ©ãƒƒã‚·ãƒ¥ãŒè¡Œã‚ã‚Œã¦ã„ãŸãŒã€ã‚¹ãƒ¬ãƒƒãƒ‰ãŒç‹¬ç«‹ã—ãŸã“ã¨ã«ã‚ˆã£
akatuki_sato 2011/04/12
MySQL
ãƒªãƒ³ã‚¯
1