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

serihiro id:serihiro

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

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

http://labs.cybozu.co.jp/blog/kazuho/archives/2008/06/friends_timeline.php
serihiro 2015/11/02
MySQL

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

æŠ€è¡“
ãƒªãƒ³ã‚¯
UIãƒ‡ã‚¶ã‚¤ãƒ³ã®ã‚¢ãƒ‹ãƒ¡ãƒ¼ã‚·ãƒ§ãƒ³ã¾ã§å…±æœ‰ã§ãã‚‹ãƒ¢ãƒƒã‚¯ä½œæˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ | Goodpatch Blog
å…ˆæ—¥ã€Goodpatchä»£è¡¨ã®åœŸå±‹ãŒWebSigä¼šè°ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§è¬›æ¼”ã‚’ã—ã¾ã—ãŸã€‚è¬›æ¼”ã¯ã€Œãƒãƒ¼ãƒˆã«éŸ¿ãUIã‚’ç”Ÿã¿å‡ºã™ãŸã‚ã®ãƒ‡ã‚¶ã‚¤ãƒ³ãƒ—ãƒã‚»ã‚¹ã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§è¡Œã‚ã‚Œã€èµ·æ¥ã¾ã§ã®ã‚¹ãƒˆãƒ¼ãƒªãƒ¼ã€Goodpatchã®UIè¨è¨ˆãƒ—ãƒã‚»ã‚¹ãªã©ã«ã¤ã„ã¦è©±ã—ã¾ã—ãŸã€‚è¬›æ¼”å†…å®¹ã¯â†“ã®slideshareã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ãã®è¬›æ¼”ã®ä¸ã§Goodpatchã¯ãƒ‡ã‚¶ã‚¤ãƒ³ã™ã‚‹éš›ã«ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‚’ä½œæˆã—ã¦ã„ã‚‹ã¨è©±ã—ã¾ã—ãŸã€‚ä»¥å‰ã«MEMOPATCHã§ã‚‚ã‚¤ãƒ³ã‚¿ãƒ©ã‚¯ã‚·ãƒ§ãƒ³ã‚„å°Žç·šã®å‹•ãã‚’ä¼ãˆã‚‹ä¸Šã§ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ä½œæˆãŒé‡è¦ã¨ã„ã†è¶£æ—¨ã®è¨˜äº‹ã‚’ã‚¢ãƒƒãƒ—ã—ã¦ã„ã¾ã™ã€‚ ï¼ˆå‚è€ƒ: ã“ã‚Œã‹ã‚‰ã®UIãƒ‡ã‚¶ã‚¤ãƒ³ã®ãŸã‚ã«ã€ãƒ‡ã‚¶ã‚¤ãƒ³ã‚«ãƒ³ãƒ—ã‚’ã‚„ã‚ã¦ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ã‚’ä½œã‚ã†ï¼ˆå‰ç·¨ï¼‰, ï¼ˆå¾Œç·¨ï¼‰ï¼‰ ãƒ—ãƒãƒˆã‚¿ã‚¤ãƒ—ä½œæˆã¨ã„ã†ã¨HTML, CSS, JavaScriptã§å®Ÿè£…ã™ã‚‹æ–¹æ³•ãŒãƒ¡ã‚¸ãƒ£ãƒ¼ã‹ã¨æ€ã„ã¾ã™ãŒã€ã“ã‚Œã ã¨ãƒªã‚½ãƒ¼ã‚¹ã‚’ã‹ãªã‚Šå‰²ãã“ã¨ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãã“ã§ä»Šå›žã¯
serihiro 2013/07/09
jQueryãƒ—ãƒ©ã‚°ã‚¤ãƒ³

MySQL

ãƒ„ãƒ¼ãƒ«

UI
ãƒªãƒ³ã‚¯
ã€é€²æ’ƒã®å·¨å¤§ãƒ‡ãƒ¼ã‚¿ã€‘Logé›†è¨ˆç”¨DBã¨ã‚·ã‚¹ãƒ†ãƒ æ§‹æˆã®ç¾Žã—ã„è¨è¨ˆã‚’è€ƒãˆã‚‹ - Y's note
[:W560] Logé›†è¨ˆç”¨DBè¨è¨ˆ è€ƒãˆã‚‹å•é¡Œ Documentç„¡ã—ã®Agileé–‹ç™ºã‚’ã‚¬ãƒã§æŽ¨å¥¨ã—ãŸã„@yutakikuchi_ã§ã™ã€‚ã€é€²æ’ƒã®å·¨å¤§ãƒ‡ãƒ¼ã‚¿ã€‘ã®ç¬¬2å›žç›®ã¨ã—ã¦å·¨å¤§ã‚¢ã‚¯ã‚»ã‚¹Logé›†è¨ˆç”¨DBã®è¨è¨ˆã«ã¤ã„ã¦å‹‰å¼·ã—ãŸå†…å®¹ã«ã¤ã„ã¦ãƒ¡ãƒ¢ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚DBå‘¨ã‚Šã¯ãã“ã¾ã§è©³ã—ãç„¡ã„ã®ã§è©³ã—ã„çš†æ§˜ã‹ã‚‰ã®çªã£è¾¼ã¿å¤§æ“è¿Žã§ã”ã–ã„ã¾ã™ã€‚ã¾ãŸå›³ã€…ã—ã„ã§ã™ãŒçŸ¥æµã‚’ãã ã•ã„(ç¬‘)ã€‚ ä»Šæ—¥ã®ä¸»ç›®çš„ã¯ä¸‹ã®2è¦ä»¶ã‚’å¶ãˆã‚‹ãŸã‚ã®DBè¨è¨ˆã‚’è€ƒãˆã‚‹äº‹ã§ã™ã€‚ç‰¹ã«å•é¡Œã«ãªã‚‹ã®ãŒRealTimeã®è©±ã§Tableã«LogDataã‚’æ›¸ãè¾¼ã‚€å‡¦ç†ã¨é›†è¨ˆã®SQLã‚’ã©ã®ã‚ˆã†ã«çµ„ã¿ç«‹ã¦ã‚‹ã‹ã€ãã‚Œä»¥å¤–ã«ã‚‚SystemPerformanceã¨Architectureã«ã‚‚é–¢ã‚ã£ã¦ãã¾ã™ã€‚ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’é›†è¨ˆã—ãŸã„ å®šæœŸå‡¦ç†ã§å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’é›†è¨ˆã—ãŸã„ ä½¿ã†ã‚‚ã® Fluentd : Fluentd: Open Source Log
serihiro 2013/07/09
ã‚ã¨ã§èªã‚€

MySQL

DB

ãƒã‚°è§£æž

fluentd

mysql
ãƒªãƒ³ã‚¯
MySQLã§é«˜é€Ÿæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢
Mroongaã«ã¤ã„ã¦ Mroongaã¯MySQLç”¨ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§ã™ã€‚ã™ã¹ã¦ã®MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ã«é«˜é€Ÿãªæ—¥æœ¬èªžå…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã‚’æä¾›ã—ã¾ã™ã€‚Mroongaã¯ä»¥å‰ã¯Groongaã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¨å‘¼ã°ã‚Œã¦ã„ã¾ã—ãŸã€‚ ç‰¹å¾´ æœ€æ–°ãƒªãƒªãƒ¼ã‚¹ 2025-02-09ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸ15.00ãŒæœ€æ–°ãƒªãƒªãƒ¼ã‚¹ã§ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« æœ€æ–°è¨˜äº‹ Mroonga 15.00ãƒªãƒªãƒ¼ã‚¹ï¼ (2025-02-09) Mroonga 14.14ãƒªãƒªãƒ¼ã‚¹ï¼ (2025-01-31) Mroonga 14.13ãƒªãƒªãƒ¼ã‚¹ï¼ (2025-01-29) Mroonga 14.12ãƒªãƒªãƒ¼ã‚¹ï¼ (2024-12-25) Mroonga 14.10ãƒªãƒªãƒ¼ã‚¹ï¼ (2024-11-12) Mroonga 14.08ãƒªãƒªãƒ¼ã‚¹ï¼ (2024-09-25) Mroonga 14.07ãƒªãƒªãƒ¼ã‚¹ï¼ (2024-09-06) Mroonga 14
serihiro 2012/08/10
mysql

MySQL

full text search

å…¨æ–‡æ¤œç´¢
ãƒªãƒ³ã‚¯
1