[B! Development][DB] yuichiro0526ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

yuichiro0526 id:yuichiro0526

Developmentã¨DBã«é–¢ã™ã‚‹yuichiro0526ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ã€ãƒãƒ©è£ã€‘ã‚ãªãŸã¯æœ¬å½“ã«ãã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ãŒå¥½ãã§ä½¿ã†ã‚“ã§ã™ã‹ï¼Ÿ - oranie's blog
ãƒãƒ©ã‚·ã®è£çš„ãªé›‘è¨˜ã§ã™ã€‚ ã‚µãƒ¼ãƒ“ã‚¹ã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’é¸ã¶éš›ã«ã“ã®è¾ºã‚’æƒ…ç†±ã‚’æŒã£ã¦èª¬æ˜Žã—ã¦ãã‚Œã‚‹äººãŒå¥½ãã€ã¨ã„ã†è©±ã§ã™ã€‚ ãã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã‚’ä½¿ã†ç†ç”±ã¯ãªã‚“ã§ã™ã‹ï¼Ÿã¿ã‚“ãªãŒä½¿ã„æ…£ã‚Œã¦ã„ã‚‹ç‰©ã‹ã‚‰å¤‰ãˆã‚‹ç†ç”±ã¯ã€Œæœ‰åãªä¼šç¤¾ãŒä½¿ã£ã¦ã„ã¦ï¼¾ï¼¾ã€ã€Œä»–ã®ãƒãƒ¼ãƒ ãŒä½¿ã£ã¦ã„ã¦ï¼¾ï¼¾ã€ã¨ã‹ã§ã¯ãªãã¦ã€æ—¢å˜ã®ç‰©ã§ã¯è§£æ±ºå‡ºæ¥ãªã„å•é¡Œã‚’è§£æ±ºã™ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã«ãªã£ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚‚ã—å˜ç´”ã«ã‚ãƒ£ãƒƒãƒã‚¢ãƒƒãƒ—ã—ã¦ãŠããŸã„ã¨ã„ã†ãƒ¬ãƒ™ãƒ«ãªã‚‰ã€ã‚ãªãŸã®è¶£å‘³ã§ä½œã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§é‹ç”¨ã™ã‚‹ã€ã§ã¯æ¬²æ±‚ã‚’æº€ãŸã›ã¾ã›ã‚“ã‹ï¼Ÿ åŒã˜ã‚ˆã†ãªãƒ—ãƒãƒ€ã‚¯ãƒˆã¯ä»–ã«ã‚‚ã‚ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ãã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ç„¡ã‘ã‚Œã°ã„ã‘ãªã„ç†ç”±ã¯ãªã‚“ã§ã™ã‹ï¼Ÿ ã¾ã æ–°ã—ã„ãƒ—ãƒãƒ€ã‚¯ãƒˆã ã£ãŸå ´åˆã€ã‚ãªãŸã¯ãã®ã‚³ãƒ¼ãƒ‰ã‚’èªã‚“ã§ã€ãƒã‚°ã‚’å ±å‘Šã—ã¦ã€å¿…è¦ã§ã‚ã‚Œã°ãƒ‘ãƒƒãƒã‚’æ›¸ãè¦šæ‚Ÿã‚’æŒã£ã¦ã„ã¾ã™ã‹ï¼Ÿ ã‚ãªãŸã¯ãƒãƒ¼ãƒ å†…ã§ãã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã®ç¬¬ä¸€äººè€…ã«ãªã‚‹ã€ã¨ã„ã†è¦šæ‚ŸãŒã‚ã‚Šã¾ã™ã‹ï¼Ÿä»–ã®ãƒ¡ãƒ³ãƒãƒ¼ã¸ã®å•“è’™ã‚„æƒ…å ±å…±æœ‰ã‚’çŽ‡å…ˆ
yuichiro0526 2013/05/23
work

DB

development

think
ãƒªãƒ³ã‚¯
Redis - The Real-time Data Platform
# Create a vector index using the HNSW algorithm, 768 dimension length, and inner product distance metric > FT.CREATE idx-videos ON HASH PREFIX 1 video: SCHEMA content_vector VECTOR HNSW 6 TYPE FLOAT32 DIM 768 DISTANCE_METRIC IP content TEXT metadata TEXT # Add a video vector with metadata > HSET video:0 content_vector â€œ\xa4q\t=\xc1\xdes\xbdZ$<\xbd\xd5\xc1\x99<b\xf0\xf2<x[â€¦\xf8<â€ content â€œSUMMARY:
yuichiro0526 2013/03/04
development

db

redis
ãƒªãƒ³ã‚¯
Online Casino Philippines
Best Online Casinos Gcash in Philippines - Licensed By Pagcor If youâ€™re looking for the best online casinos in the Philippines that accept GCash as a payment method, youâ€™ve come to the right place. In this article, we will introduce you to some top-notch online casinos that are licensed by Pagcor and offer a secure and enjoyable gambling experience. From exciting slot games to trusted live casinos
yuichiro0526 2012/12/01
db

development

migration

Tool
ãƒªãƒ³ã‚¯
ãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXã¯ã€Œä¸–ç•Œã¯ä¸€ã¤ã€ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã«ã©ã®ã‚ˆã†ãªã‚µãƒ¼ãƒæ§‹æˆã«ã—ã¦ã„ã‚‹ã®ã‹ï¼Ÿ
ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹ã®äººæ°—RPGã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆã€ã‚·ãƒªãƒ¼ã‚ºã®æœ€æ–°ä½œã€Œãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆXï¼ˆãƒ‰ãƒ©ã‚¯ã‚¨10ï¼‰ã€ã¯ã‚·ãƒªãƒ¼ã‚ºåˆã®ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ä½œå“ã¨ãªã‚Šã¾ã—ãŸãŒã€ãã®èˆžå°è£ã¯ä¸€ä½“ã©ã†ãªã£ã¦ã„ãŸã®ã‹ã€‚ã‚²ãƒ¼ãƒ ã®ä¸–ç•Œè¦³ã‚’æ”¯ãˆã‚‹ã‚µãƒ¼ãƒã‚·ã‚¹ãƒ†ãƒ ãŒã©ã®ã‚ˆã†ã«æ§‹æˆã•ã‚Œã¦ã„ã‚‹ã®ã‹ã¨ã„ã†ã“ã¨ã‚„ã€ãƒ‰ãƒ©ã‚´ãƒ³ã‚¯ã‚¨ã‚¹ãƒˆâ…©ãªã‚‰ã§ã¯ã®ä»•çµ„ã¿ã‚„æ©Ÿèƒ½ã‹ã‚‰é–‹ç™ºã®è‹¦åŠ´è©±ã¾ã§ã€æ ªå¼ä¼šç¤¾ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹é–‹ç™ºéƒ¨ãƒ—ãƒã‚°ãƒ©ãƒžæ£®å±±æœ‹è¼ã•ã‚“ãŒèªžã£ã¦ã„ã¾ã™ã€‚ ã‚¿ã‚¤ãƒˆãƒ« | CEDEC 2012 | Computer Entertaintment Developers Conference http://cedec.cesa.or.jp/2012/program/NW/C12_P0040.html æ£®å±±æœ‹è¼ï¼š çš†æ§˜ã€æœ¬æ—¥ã¯ãŠé›†ã¾ã‚Šé ‚ãã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’æ‹…å½“ã•ã›ã¦é ‚ãã¾ã™ã€æ ªå¼ä¼šç¤¾ã‚¹ã‚¯ã‚¦ã‚§ã‚¢ãƒ»ã‚¨ãƒ‹ãƒƒã‚¯ã‚¹é–‹ç™ºéƒ¨æ‰€å±žã®æ£®å±±æœ‹è¼ã¨
yuichiro0526 2012/08/25
development

game

db

system

CEDEC
ãƒªãƒ³ã‚¯
ã„ãã‚ãŸã‚Šã°ã£ãŸã‚Šã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã¨æ•™è¨“
ã‚¹ãƒ©ã‚¤ãƒ‰ã®ä½œè€…ã§ã‚ã‚‹Gleicon Moraesã¯ã€ã“ã‚Œã‚‰ã®å›³ã‚’ç¤ºã—ãŸä¸Šã§ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã‚¬ãƒ ãƒ†ãƒ¼ãƒ—ã®ã‚ˆã†ã«ã¤ãŽã¯ãŽã§ä½¿ãˆã‚‹ã‚ˆã†ãªä¸‡èƒ½è–¬ã§ã¯ãªã„ã€‚ã‚·ãƒ£ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚„éžæ£è¦åŒ–ãªã©ã¯æ¤œè¨Žã™ã¹ãã‚ˆã„é¸æŠžè‚¢ã§ã‚ã‚Šã€ã¾ãŸãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ä»¥å¤–ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚‚é¸æŠžè‚¢ã¨ã—ã¦ã„ã‚Œã‚‹ã¨ã‚ˆã„ã ã‚ã†ã¨èª¬ã„ã¦ã„ã¾ã™ã€‚ ãã—ã¦æ¬¡ã®ã‚ˆã†ãªã€Œãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“é•ã£ãŸä½¿ã„æ–¹10é …ç›®ã€ã‚’ç¤ºã—ã¦ã„ã‚‹ã®ã§ã™ï¼ˆè¨³ã¯å‰è¿°ã®è¨˜äº‹ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®é–“é•ã£ãŸä½¿ã„æ–¹10é …ç›®ã€ã‹ã‚‰ï¼‰ã€‚ Dynamic table creationï¼ˆå‹•çš„ãªãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆï¼‰ Table as cacheï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦ä½¿ã†ï¼‰ Table as queueï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ã‚ãƒ¥ãƒ¼ã¨ã—ã¦ä½¿ã†ï¼‰ Table as log fileï¼ˆãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ãƒã‚°ã¨ã—ã¦ä½¿ã†ï¼‰ Distributed Global Lockingï¼ˆåˆ†æ•£ã—ãŸã‚°ãƒãƒ¼ãƒãƒ«ãªãƒãƒƒã‚¯ï¼‰
yuichiro0526 2011/05/19
development

database

db

atode
ãƒªãƒ³ã‚¯
å¤ã„MySQLã‹ã‚‰MySQL5ã®æœ€æ–°ç‰ˆã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹éš›ã®æ–‡å—åŒ–ã‘ã‚’é˜²ããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚¹ãƒˆã‚¢æ–¹æ³•:phpspoté–‹ç™ºæ—¥èªŒ
å¤ã„MySQLã‹ã‚‰MySQL5ã®æœ€æ–°ç‰ˆã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹éš›ã®æ–‡å—åŒ–ã‘ã‚’é˜²ããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚¹ãƒˆã‚¢æ–¹æ³• 2011å¹´01æœˆ18æ—¥- å¤ã„MySQLã‹ã‚‰MySQL5ã®æœ€æ–°ç‰ˆã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã™ã‚‹éš›ã®æ–‡å—åŒ–ã‘ã‚’é˜²ããƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚¹ãƒˆã‚¢æ–¹æ³•ã€‚ ã¤ã„å…ˆæ—¥ã€ã¨ã‚ã‚‹ã‚µãƒ¼ãƒã®MySQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒç›¸å½“å¤ã4.1ã¨ã„ã†ã“ã¨ã ã£ãŸã®ã§æœ€æ–°GAã®5.5.8ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¾ã—ãŸã€‚ å¤§å¹…ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹å‘ä¸Šã‚„ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ãƒªã‚«ãƒãƒªã®é«˜é€ŸåŒ–ãªã©5.5ç³»ã«ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã®ãƒ¡ãƒªãƒƒãƒˆã¯å¤§ãã„ã§ã™ã (è©³ã—ãã¯å¥¥é‡Žã•ã‚“ã®ãƒ–ãƒã‚°ã‚’å‚ç…§) å°šã€ä¸€ã¤å‰ã®GAã§ã‚ã‚‹5.1ç³»ã¸ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã«ã‚‚ä½¿ãˆã¾ã™ å°šã€rpmãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰æ–¹æ³•ã§ã¯ãªãã€ã‚½ãƒ¼ã‚¹ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ãªã®ã§ã”æ³¨æ„ãã ã•ã„ã€‚(ãƒã‚¤ãƒŠãƒªãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ã‚‚ä½¿ãˆã¾ã™) ãã®éš›ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡Œã‚’ã™ã‚‹ãŸã‚ã€mysqldumpã‚’ä½¿ã„ é«˜é€Ÿã«ãƒãƒƒ
yuichiro0526 2011/01/19
MySQL

db

development

backup
ãƒªãƒ³ã‚¯
1