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

nasust id:nasust

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

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

IDç”Ÿæˆæ–¹æ³•ã«ã¤ã„ã¦ã‚ã‚Œã“ã‚Œ
IDç”Ÿæˆã«ã¤ã„ã¦èžã‹ã‚Œã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã€ç‹¬è‡ªã®è¦³ç‚¹ã§ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ã‚¿ã‚¤ãƒˆãƒ«ã¯é©å½“ã§ã™â€¦ã€‚ DBã¯MySQL(InnoDB)ã‚’æƒ³å®šã—ã¦ã„ã¾ã™ã€‚ã‚ã—ã‹ã‚‰ãšã€‚ IDç”Ÿæˆã‚’çŸ¥ã‚ŠãŸã„ãªã‚‰ IDç”Ÿæˆã«é–¢ã—ã¦ã¯ä»¥ä¸‹ã®è¨˜äº‹ãŒã‚ˆãã¾ã¨ã¾ã£ã¦ã„ã‚‹ã®ã§å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ã€‚å€¤å½¢å¼ãªã©è©³ã—ãæ›¸ã‹ã‚Œã¦ã„ã¾ã™ã€‚ IDç”Ÿæˆå¤§å…¨ Facebook, Twitter, Instagramç‰ãŒã©ã†ã‚„ã£ã¦IDã‚’ç”Ÿæˆã—ã¦ã„ã‚‹ã®ã‹ ã¾ã¨ã‚ IDç”Ÿæˆæ–¹æ³• ä»¥ä¸‹ã®IDç”Ÿæˆæ–¹æ³•ã¯ã€ãŠæ‰‹è»½ã«æŽ¡ç”¨ã—ã‚„ã™ã„ã‚‚ã®é †ã§åˆ—æŒ™ã—ã¾ã™ã€‚ DBæŽ¡ç•ª/é€£ç•ªåž‹ AUTO_INCREMENT DBã®AUTO_INCREMENTã§æŽ¡ç•ªã™ã‚‹æ–¹æ³•ã€‚ Pros æ•°å€¤åž‹ã§æ‰±ãˆã‚‹ æ™®é€šã¯64ãƒ“ãƒƒãƒˆã®æ•´æ•°åž‹ã‚’æŽ¡ç”¨ã™ã‚‹ã“ã¨ãŒå¤šã„ å˜èª¿å¢—åŠ ã™ã‚‹é€£ç•ªã§ã™ã®ã§ã€ã‚½ãƒ¼ãƒˆå¯èƒ½ã§ã‹ã¤ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ç©ºé–“åŠ¹çŽ‡ãŒã‚ˆã„ å˜èª¿å¢—åŠ ã™ã‚‹ã®ã§ã€ã‚ãƒ£ãƒ‘ã‚·ãƒ†ã‚£ã‚’äºˆæ¸¬ã—ã‚„ã™ã„ 64ãƒ“ãƒƒãƒˆã‚ã‚Œã°ã‚ã¾ã‚Šæ°—ã«
nasust 2020/10/12
mysql

db

é–‹ç™º
ãƒªãƒ³ã‚¯
https://developer.hatenastaff.com/entry/2019/01/15/120431
nasust 2019/01/15
mysql

ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒãƒ¼ãŒå®Œè†šãªãã¾ã§ã«æ»ã‚“ã§ã‚‚MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤±ã‚ãªã„ãŸã‚ã®è¡¨æŠ€
ã‚µãƒ¼ãƒãƒ¼ãŒå®Œè†šãªãã¾ã§ã«æ»ã‚“ã§ã‚‚MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤±ã‚ãªã„ãŸã‚ã®è¡¨æŠ€ 1. ã‚µãƒ¼ãƒãƒ¼ãŒå®Œè†šãªãã¾ã§ã«æ»ã‚“ã§ã‚‚ MySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤±ã‚ãªã„ãŸã‚ã®è¡¨ æŠ€ ãã‚Œã§ã‚‚å¤±ã£ãŸã‚‰ç”³ã—è¨³ãªã„ 2018/03/10 yoku0825 PHPerKaigi 2018 2. ã“ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã£ãŸç†ç”± ã¿ãªã•ã‚“ã¯ ãŠé¡Œç®± ã¨ã„ã†ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”å˜çŸ¥ã§ã™ã‹ï¼Ÿ ä¿ºã¯ã‚ˆãçŸ¥ã‚Šã¾ã›ã‚“ï¼ˆï¼‰ Peing -è³ªå•ç®±- ã¨åˆ¥ã®ã‚‚ã®ã ã¨ã„ã†ã“ã¨ã ã‘çŸ¥ã£ã¦ã„ã¾ã™ 1/87 3. ã“ã®è©±ã‚’ã—ã‚ˆã†ã¨æ€ã£ãŸç†ç”± 1æœˆ6æ—¥ 19æ™‚é ƒã«ã‚µãƒ¼ãƒä¼šç¤¾æ§˜ï¼ˆConoHaæ§˜ï¼‰ã«ã¦ç™ºç”Ÿ ã—ãŸéšœå®³ãŒåŽŸå› ã§ã€ãŠé¡Œç®±ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒã®ã‚·ã‚¹ ãƒ†ãƒ ãŒç ´æã—ã¦ã—ã¾ã„ã€æœ¬æ—¥ã¾ã§ã‚µãƒ¼ãƒ“ã‚¹ãŒç¨¼åƒã§ããª ã„çŠ¶æ³ã«ãªã£ã¦ãŠã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒä¼šç¤¾ã®æ‹…å½“è€…æ§˜ã®ã”å°½åŠ›ã‚‚ã‚ã‚Šã€1æœˆ9æ—¥ 17æ™‚ç¾ åœ¨ã€ã²ã¨ã¾ãšå¾©æ—§ã™ã‚‹ã“ã¨ãŒã§ãã¾ã—ãŸã“ã¨ã‚’ã”å ±å‘Šã„ ãŸã—ã¾ã™ã€‚ 1/6 19æ™‚é ƒ
nasust 2018/03/11
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã¯å¤§äº‹ã ã‚ˆãã€‚ã‚¦ã‚§ãƒ–ã‚µãƒ¼ãƒ“ã‚¹å»ºã¦ã‚‹æ™‚ã¯ã€å¿…ãšãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã„ã‚‹ã€‚

mysql
ãƒªãƒ³ã‚¯
å¯¿å¸=ãƒ“ãƒ¼ãƒ«å•é¡Œ : MySQL 8.0ã§ã®UTF8ã‚µãƒãƒ¼ãƒˆå…¥é–€ (MySQL Server Blogã‚ˆã‚Š) | Yakst
ã“ã‚Œã¾ã§ã®MySQLã§ã‚ˆãå•é¡Œã«ãªã£ãŸã€çµµæ–‡å—ã‚„æ—¥æœ¬èªžã®æ–‡å—ã®ç…§åˆã‚„ã‚½ãƒ¼ãƒˆé †åºã®å•é¡Œã«é–¢ã—ã¦ã€æ¥ãŸã‚‹MySQL 8.0ã§ã¯å¤§å¹…ãªæ”¹å–„ãŒåŠ ãˆã‚‰ã‚Œã‚‹äºˆå®šã«ãªã£ã¦ã„ã‚‹ã€‚ã“ã®å•é¡Œã®æ¦‚è¦ã¨ä»Šå¾Œã®æ”¹å–„æ–¹é‡ã«ã¤ã„ã¦ã€MySQLé–‹ç™ºãƒãƒ¼ãƒ ã‹ã‚‰ã®è§£èª¬ã€‚ å…è²¬äº‹é … ã“ã®è¨˜äº‹ã¯Manyi Luæ°ã«ã‚ˆã‚‹MySQL Server Blogã®æŠ•ç¨¿ã€ŒSushi = Beer ?! An introduction of UTF8 support in MySQL 8.0ã€(2017/1/13)ã‚’ãƒ¦ãƒ¼ã‚¶ãŒç¿»è¨³ã—ãŸã‚‚ã®ã§ã‚ã‚Šã€Oracleå…¬å¼ã®æ–‡æ›¸ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ MySQL 8.0ã§ã®ç§ãŸã¡ã®è¨ˆç”»ã¨ã—ã¦ã€utf8ã®ã‚µãƒãƒ¼ãƒˆã‚’å¤§å¹…ã«æ”¹å–„ã—ã¾ã™ã€‚utf8ã‚µãƒãƒ¼ãƒˆè‡ªä½“ã¯MySQL 4.1ã®é ƒã«ã•ã‹ã®ã¼ã‚Šã¾ã™ãŒã€ã„ãã¤ã‹ã®åˆ¶é™ãŒå˜åœ¨ã—ã¦ã„ã¾ã™ã€‚è¨˜äº‹ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚‚ã‚ã‚‹ã€Œå¯¿å¸ = ãƒ“ãƒ¼ãƒ«ã€å•é¡Œã¯ã€ãƒã‚°#76553ã®ã“ã¨ã‚’æŒ‡ã—ã¦ã„ã¾ã™ã€‚å°‘
nasust 2017/01/25
MySQL

unicode

utf8
ãƒªãƒ³ã‚¯
MySQLã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ¶å¾¡ãŒã‚ãƒ¢ã„è©± - ãªã‹ã‚‰ãªLife
MySQL Casual Advent Calendar 2016 - Qiitaã®5æ—¥ç›®ã®è¨˜äº‹ã§ã™ã€‚ AdventCalendarè‡ªä½“åˆå‚åŠ ã§ãƒ‰ã‚ãƒ‰ã‚ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é–‹å§‹ã¯ã€BEGINã—ãŸã¨ãã˜ã‚ƒãªã„ï¼ MySQLã§ã¯ã€BEGINï¼ˆSTART TRANSACTIONã€‚é•·ã„ã®ã§ã€ä»¥ä¸‹ã€ç‰¹ç†ã™ã¹ãå ´åˆä»¥å¤–ã¯ã€ŒBEGINã€ã§ï¼‰ã‚’å®£è¨€ã—ã¦ã‚‚ã€å†…éƒ¨çš„ã«ã¯ã¾ã ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’é–‹å§‹ã—ã¦ã¾ã›ã‚“ã€‚ SQLã‚’æŠ•ã’ãŸã‚¿ã‚¤ãƒŸãƒ³ã‚°ã§ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³é–‹å§‹ã«ãªã‚Šã¾ã™ã€‚ ã“ã®ã¨ãã€æ›´æ–°ã®ãªã„ã€FOR UPDATEã‚‚ãªã„SELECTæ–‡ã§ã‚‚ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒé–‹å§‹ã•ã‚Œã¾ã™ã€‚ ãªã«ãã‚Œãã‚‚ã„ã€‚ ã€ŒAutoCommit=ON/OFFã€ã«ã‚ˆã‚‹é•ã„ AutoCommit=ONã®ã¨ã ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯SQLã‚’ç™ºè¡Œã™ã‚‹ãŸã³ã«BEGIN/COMMITã§å®Œäº†ã—ã€ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ã§ãã¾ã›ã‚“ã€‚ è¤‡æ•°SQLã‚’æŸãã¦ï¼‘ã¤ã®ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³
nasust 2016/12/05
MySQL
ãƒªãƒ³ã‚¯
ã€Žã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã«ãŠã‘ã‚‹DBæ§‹æˆ&å¯¾å¿œè¨˜ã€
2ãƒ¶æœˆå‰ã«ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã¨ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã§ã²ã©ããƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘ãŸå¢—ç”°(@masudaK)ã§ã™ã€‚ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã¯2009å¹´2æœˆã«å§‹ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€FLASHãƒ»Javaã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«MySQLã‚’ç”¨ã„ã¦ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã‚ãŸãã—ãŒ2å¹´ã»ã©è¦‹ç¶šã‘ã¦ã„ã‚‹ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã®DBç’°å¢ƒã«ã¤ã„ã¦æ§‹æˆã‚„ã€æ—¥ã€…ã©ã®ã‚ˆã†ã«ã—ã¦å•é¡Œã¨å‘ãåˆã£ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚Šã®å†…å®¹ãŒå¤šã„ãŸã‚ã€ã‚¢ãƒ—ãƒªå¯„ã‚Šã®è©±ã¯å¼Šç¤¾ç”Ÿæ²¼ã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€‚ 1. æ§‹æˆã¨è¦æ¨¡ 1.1. æ§‹æˆ ã¾ãšæ§‹æˆã§ã™ãŒã€èªã¿æ›¸ãã¯ã™ã¹ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¸è¡Œã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯å‚ç…§ã‚’å‘ã‘ãšã€ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯2012å¹´ä¸æ—¬ã¾ã§ã¯5.0ã‚’ä½¿ã£ã¦ã¾ã—ãŸãŒã€DCç§»è»¢ã«ã‚ã‚ã›ã¦5.5ã«ã‚ã’ã¾ã—ãŸã€‚ãƒãƒƒã‚¯æ©Ÿèƒ½ã‚’ç”¨ã„ãŸã‚·ãƒ£ãƒ¼ãƒ‰æ§‹æˆã‚’ã—ã¦ã¾ã—ã¦ã€2014å¹´3æœˆç¾åœ¨6ã‚·ãƒ£ãƒ¼ãƒ‰ã«ãª
nasust 2014/05/22
ä»•äº‹

ã‚µãƒ¼ãƒ

mysql

web
ãƒªãƒ³ã‚¯
è»½é‡ãªTime-based IDç”Ÿæˆå™¨â€shakeflake(ä»®ç§°)â€ã«ã¤ã„ã¦ | SmartNewsé–‹ç™ºè€…ãƒ–ãƒã‚°
å¤§å¹³ã§ã™ã€‚ä»Šå›žã¯ã•ã ã¾ã•ã—ãƒã‚¿ã¯ç‰¹ã«ç„¡ã—ã§ã™ã€‚ å…ˆæ—¥ã€ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¯ãƒãƒ¼ãƒ©ãƒ¼ã§ä½¿ç”¨ã—ã¦ã„ã‚‹IDç”Ÿæˆå™¨ã«ã¤ã„ã¦ç½®ãæ›ãˆã‚’è¡Œã„ã¾ã—ãŸã€‚éžå¸¸ã«åœ°å‘³ãªè©±ã«ãªã‚Šã¾ã™ãŒã€æœ¬è¨˜äº‹ã§ã¯ãã®è¾ºã®å†…å¹•ã®è©±ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚Â IDç”Ÿæˆã«ã¾ã¤ã‚ã‚‹è‹¦æ‚© å¼Šç¤¾ã‚´ã‚¯ãƒã®æä¾›ã—ã¦ã„ã‚‹SmartNewsã¯è¡¨å‘ãã¯ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã§ã™ãŒã€è£å´ã®ä»•çµ„ã¿ã¯æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã«è¿‘ä¼¼ã—ã¦ã„ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æ–¹ã€…ã®èˆˆå‘³é–¢å¿ƒã‚„ã€ã‚¢ã‚¯ã‚»ã‚¹å‚¾å‘ã‚’ã‚¯ã‚¨ãƒªãƒ¼ã¨ã—ã€ãã®å†…å®¹ã«å¿œã˜ãŸè©±é¡Œã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’æ¤œç´¢çµæžœã¨ã—ã¦è¿”å´ã™ã‚‹ã€ã¨ã„ã†é¢¨ã«æ‰ãˆã¦ã„ãŸã ãã¨ã€ãªã‚“ã¨ãªãç§ãŒè¨€ã‚ã‚“ã¨ã—ã¦ã„ã‚‹äº‹ã‚’æƒ³åƒã—ã¦ã„ãŸã ã‘ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ SmartNewsã¯Twitterã®ã¤ã¶ã‚„ãæƒ…å ±ã‚’ç”¨ã„ãŸãƒˆãƒ¬ãƒ³ãƒ‰åˆ†æžã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ãŠã‚Šã€è©±é¡Œã«ãªã£ã¦ã„ã‚‹ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’é¸å®šã™ã‚‹ãŸã‚ã«ã¯ã€å¤§é‡ã®Twitterä¸Šã®tweetã€ãªã‚‰ã³ã«ãã®ä¸ã«å«ã¾ã‚Œã¦ã„ã‚‹URLã«å¯¾ã—ã¦ã‚¯ãƒãƒ¼ãƒ«ã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æ—¥ã€…
nasust 2013/08/03
MySQL

twitter

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
MariaDB in brief - MariaDB.org
MariaDB Server is a general purpose open source relational database management system. Itâ€™s one of the most popular database servers in the world, with notable users including Wikipedia, WordPress.com and Google. MariaDB Server is released under the GPLv2 open source licence and is guaranteed to rem ain open source. It can be used for high-availability transaction data, analytics, as an embedded se
nasust 2013/02/04
MySQL

database
ãƒªãƒ³ã‚¯
2012-06-19
ã¯ã¦ãª x DeNAåˆåŒä¼ç”»ã€€Mobage é‹ç”¨æŠ€è¡“å‹‰å¼·ä¼š 2012.06.19 å°é¢¨ã§ã™ãŒã€æ±ºè¡Œï¼ï¼çµ‚ã‚ã£ãŸã‚‰ã€Sakura Cafeã§æ‡‡è¦ªä¼šã€‚ ç™»å£‡è€…ï¼šDeNAå°é‡Žæ§˜ ã‚¤ãƒ³ãƒ•ãƒ©éƒ¨é–€ ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã¨MobageåŸºç›¤ ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¯ã€æ—¥æœ¬ã€USã€éŸ“å›½ã€ä¸å›½å‘ã‘ãŒã‚ã‚‹ ã‚µãƒ¼ãƒã®æ‹ ç‚¹ã¯ã€åå¤å±‹ã€æ±äº¬ã€ã‚µãƒ³ãƒ•ãƒ©ãƒ³ã‚·ã‚¹ã‚³ã€ä¸Šæµ· ç‰¹å¾´ 1. é«˜ã„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºåŠ› - Handler socket plugin - MySQL-MHA 2. éžå¯Œè±ªçš„æ„Ÿè¦š - ã‚µãƒ¼ãƒå°æ•°ã¯ã€ã‚°ãƒªãƒ¼ã®åŠåˆ†ãã‚‰ã„ã¨æ€ã‚ã‚Œã‚‹ Mobage Webã‚µãƒ¼ãƒæ©Ÿã®è³‡æºç®¡ç†ã«ã¤ã„ã¦ ç™»å£‡è€…ï¼šDeNAæ¨‹å£æ§˜ 2-1. Mobageã®ä½æ³¢éƒ¡æ§‹æˆã«ã¤ã„ã¦ 1. åŸºæœ¬ã€LAMP 2. Webã‚µãƒ¼ãƒã¨DBã‚µãƒ¼ãƒãŒå¤§éƒ¨åˆ† 3. Apache ã¨ FastCGI ãŒåŒå±… 4. FastCGIã¯ãƒžãƒ«ãƒãƒ—ãƒã‚»ã‚¹åž‹ã‚µãƒ¼ãƒ 5. ã‚²ãƒ¼ãƒ ã”ã¨ã«åˆ†é›¢ã•ã‚Œ
nasust 2013/01/29
mysql

ã‚µãƒ¼ãƒ

é‹ç”¨
ãƒªãƒ³ã‚¯
Nginx + WordPress RDSç¯‡ - ã‚µãƒ¼ãƒãƒ¼ãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€‚CSãƒãƒ¼ãƒ ã®å‚æœ¬ã§ã™ã€‚ ä»Šå›žã‚‚ã€å‰å›žã®ã€ŒNginx + WordPress S3ç¯‡ã€ã«å¼•ãç¶šãã€ã€ŒNginx + WordPress ãƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ç¯‡ã€ã®æ§‹æˆã§ã®é‹ç”¨ä¸Šã®å•é¡Œç‚¹ã‚’ã€AWSã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ã£ã¦è§£æ¶ˆã—ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ ç”»åƒã®ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰å…ˆã®å•é¡Œã¯è§£æ±ºã—ã¾ã—ãŸãŒã€MySQLã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼ãŒã¾ã SPOFï¼ˆå˜ä¸€éšœå®³ç‚¹ï¼‰ã¨ãªã£ã¦ã„ã¾ã™ã€‚EC2ã§ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ã‚‚ã†1å°èµ·å‹•ã—ã¦ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹ã“ã¨ã‚‚å¯èƒ½ã§ã™ãŒã€ä»Šå›žã¯AWSã®ã‚µãƒ¼ãƒ“ã‚¹ã€ŒAmazon RDSã€ã‚’ä½¿ã£ã¦ã“ã®å•é¡Œã‚’ç°¡å˜ã«è§£æ±ºã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ Amazon RDSã¨ã¯ï¼ŸMulti-AZã¨ã¯ï¼ŸRDSã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®ä½œæˆãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãƒªã‚¹ãƒˆã‚¢WordPressã®è¨å®šå¤‰æ›´ã¾ã¨ã‚ 1. Amazon RDSã¨ã¯ï¼Ÿ ä»Šå›žã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦åˆ©ç”¨ã™ã‚‹AWSã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã€ŒAmazon R
nasust 2013/01/25
WordPress

MySQL

aws
ãƒªãƒ³ã‚¯
Fusion-IO ioDriveã®éšœå®³ä¾‹ã¨èª¿æŸ»æ–¹æ³• | å¤–é“çˆ¶ã®åŒ
ã‚¤ãƒ³ãƒ•ãƒ©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«æ°¸é ã«ã¤ãã¾ã¨ã†ã€æœˆæ›œå‡ºç¤¾ç›´å¾Œã®éšœå®³å ±å‘Šã¨èª¿æŸ»ä¾é ¼ã€‚ ä»Šå›žã¯ioDriveæè¼‰ã‚µãƒ¼ãƒã®MySQLãŒæ€¥ã«è½ã¡ã¾ã—ãŸã¨ã„ã†ã“ã¨ã§ã€èª¿æŸ»ã—ã¦ã¿ã¾ã—ãŸã€‚ ã“ã‚Œã¾ã§ã€ioDriveã¯ä¸æ»…ã§ã™ã€‚çš„ãªã“ã¨ã°ã‹ã‚Šæ›¸ã„ã¦ã„ã¾ã—ãŸãŒã€ã¾ãã„ã¤ã‹ã¯ä½•ã‹èµ·ãã¾ã™ã‚ˆããƒ»ãƒ»ãƒ»ã£ã¦ã“ã¨ã§ã€ãƒ›ã‚¯ãƒ›ã‚¯ã—ãªãŒã‚‰ioDriveã®ãƒã‚¬ã‚ãƒ£ãƒ³ã€ã§ã¯ãªãã€ã“ã‚“ãªéšœå®³ä¾‹ãŒã‚ã‚Šã¾ã—ãŸã‚ˆã€ã“ã‚“ãªæ„Ÿã˜ã§èª¿ã¹ã¾ã—ãŸã‚ˆã¨ã„ã†ç´¹ä»‹ã‚’ã—ã¾ã™ã€‚ æœˆæ›œæœã®ã‚¹ã‚¿ãƒ¼ãƒˆåœ°ç‚¹ ä¾é ¼ä¸»ã‹ã‚‰ã‚‚ã‚‰ã£ãŸæƒ…å ±ã€‚ ã‚ã‚‹ioDriveæè¼‰ã‚µãƒ¼ãƒã®MySQLãŒæ€¥ã«è½ã¡ã¾ã—ãŸ éšœå®³æ™‚é–“ã¯ 2012/09/29 03:30 ã§ã™ ioDriveã®ãƒžã‚¦ãƒ³ãƒˆå…ˆ /fio ãŒåˆ©ç”¨ã§ããªã„çŠ¶æ…‹ã§ã™ ã‚‚ã†ã“ã®ã‚µãƒ¼ãƒã¯ä½¿ã£ã¦ã„ãªã„ã®ã§å¥½ãã«èª¿æŸ»ã—ã¦ãã ã•ã„ ä»Šå›žã¯ç„¡å„Ÿã§å—ã‘ã¦ã‚ã’ã¾ã—ãŸã€‚ ãã‚Œã§ã¯èª¿æŸ»é–‹å§‹ï¼ ãƒ‰ãƒ©ã‚¤ãƒãªã©ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç¢ºèª 2.2.3 ã‚’åˆ©ç”¨ã—ã¦ã„ã‚‹ã“ã¨ã‚’ç¢º
nasust 2012/11/22
MySQL

server
ãƒªãƒ³ã‚¯
ã€ãƒ¡ãƒ¢ã€‘MySQLã§ã®swapç™ºç”Ÿã¨NUMAã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ - FAT47ã®åº•è¾ºã‚¤ãƒ³ãƒ•ãƒ©è°äº‹éŒ²
DBã‚µãƒ¼ãƒã§ã¨ã‚ã‚‹æ—¥ã‚’å¢ƒã«swapãŒç™ºç”Ÿã—ã¦ã„ã‚‹ã“ã¨ã«æ°—ãŒã¤ãã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒã¯ãƒ¡ãƒ¢ãƒª32GBæè¼‰ã—ã¦ã„ã¦ã€ãã®ã†ã¡ã®24GBã‚’innodb_buffer_pool_sizeã«å‰²ã‚Šå½“ã¦ã¦ã„ã¾ã™ã€‚ ä»–ã®threadæ¯Žã®ãƒ¡ãƒ¢ãƒªè¨å®šå€¤ã‚’è¦‹ã¦ã‚‚ãŠã‹ã—ãã†ãªç‚¹ã¯ãªã‹ã£ãŸã®ã§ã‚°ã‚°ã£ã¦ã¿ã¾ã—ãŸã€‚ MySQL ã¨ NUMA ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ Swap Insanity MySQLã€€InnoDBã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ˆå¾Œç·¨ï¼‰ ãªã‚‹ã»ã©â€¦ã€‚ ãã‚Œãžã‚Œã®CPUãŒãƒãƒ¼ã‚«ãƒ«ã§ãƒ¡ãƒ¢ãƒªã‚’ç®¡ç†ã—ã¦ã„ã‚‹ã®ã§ã€ 2CPUç©ã‚“ã§ã„ã‚‹ã‚µãƒ¼ãƒã ã¨ã€Aã¨ã„ã†CPUã§å®Ÿè¡Œã•ã‚Œã¦ã„ã‚‹ã‚¹ãƒ¬ãƒƒãƒ‰ãŒã€Bã¨ã„ã†CPUãŒç¢ºä¿ã—ã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªé ˜åŸŸã«ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã«ã¯ã€Aã®CPUã‚’çµŒç”±ã—ãªã„ã¨ã„ã‘ãªã„ã‚ã‘ã§ã™ãã€‚ ã“ã®ãƒ¡ãƒ¢ãƒªã‚¢ã‚¯ã‚»ã‚¹ãŒä¸å‡ä¸€ã«ãªã‚‹æ–¹å¼ã‚’NUMAã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨ã„ã†ã¿ãŸã„ã§ã™ã€‚ NUMAã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã®ãƒ¡ãƒ¢ãƒªç®¡ç†ãŒã€ãƒŽãƒ¼ãƒ‰ã¨ã„ã†å˜
nasust 2012/11/21
MySQL
ãƒªãƒ³ã‚¯
TheSchwartz ã®ã‚ˆã†ãª RDBMS ã‚’ã¤ã‹ã£ãŸã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«å‡¦ç†ã™ã‚‹ã‚¢ã‚¤ãƒ‡ã‚£ã‚¢ - tokuhirom's blog
TheSchwartz ã®ã‚ˆã†ãª RDBMS ã‚’ã¤ã‹ã£ãŸã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚’ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«å‡¦ç†ã™ã‚‹ã‚¢ã‚¤ãƒ‡ã‚£ã‚¢ TheSchwartz ã®ã‚ˆã†ãª RDBMS ã‚’ã¤ã‹ã£ãŸ job queue ã¯ã€æ–°è¦ã« daemon ã‚’ãŸã¦ãŸã‚Šã™ã‚‹å¿…è¦ãŒãªã„ã®ã§æ¥½ã§ã„ã„ã®ã§ã™ãŒã€ä¸€æ–¹ã§ job ã®è¿½åŠ ã® timing ãŒ storage ã‹ã‚‰ push ã§ãŠãã‚‰ã‚Œã¦ã“ãªã„ã®ã§ã€è‹¥å¹²ã® delay ãŒç”Ÿã˜ã¦ã—ã¾ã†ã®ãŒé›£ç‚¹ã§ã—ãŸã€‚ ã“ã®å•é¡Œã‚’è§£æ±ºã™ã‚‹ãŸã‚ã«ã€mysql ã® binlog API ã‚’ç”¨ã„ã¦ã€å‡¦ç†ã—ã¦ã¿ã‚‹ãƒãƒƒã‚¯ã‚’è€ƒãˆã¦ã¿ã¾ã—ãŸã€‚ binlog API ã‚’åˆ©ç”¨ã™ã‚‹ã¨æ›´æ–°ã‚¯ã‚¨ãƒªã‚’ streaming ã§å‡¦ç†ã§ãã‚‹ã®ã§ã€ã“ã†ã„ã£ãŸãƒãƒƒã‚¯ã‚‚ç°¡å˜ã«ã§ãã¡ã‚ƒã„ã¾ã™ã€‚ãŠã‚‚ã—ã‚ã„ã€‚ use 5.016000; use MySQL::BinLog; use TheSchwartz; my $sch = TheSchwartz
nasust 2012/07/09
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ç‰ã§ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸å¤‰æ›´ã«å¯¾å¿œã—ã‚ˆã†
nasust 2011/01/25
ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°

MySQL

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

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

sql
ãƒªãƒ³ã‚¯
1