[B! mysql] clairvyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

clairvy id:clairvy

mysqlã«é–¢ã™ã‚‹clairvyã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Redirectingâ€¦
Redirectingâ€¦ Click here if you are not redirected.
clairvy 2016/08/02
mysql
ãƒªãƒ³ã‚¯
MySQLã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤Ž : ã²ã¨ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªã®æœ€é©åŒ–æ³• | Yakst
MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’åŠ¹æžœçš„ã«ä½¿ã†ã«ã¯ã©ã†ã—ãŸã‚‰ã„ã„ã®ã‹ã«ã¤ã„ã¦ã®åˆ†ã‹ã‚Šã‚„ã™ã„è§£èª¬ã€‚ãã‚‚ãã‚‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å½¹å‰²ã¯ã¨ã¯ä½•ã‹ã€ãã—ã¦ã©ã†ã™ã‚Œã°ãã®å½¹å‰²ã‚’æžœãŸã—ã¦ãã‚Œã‚‹ã®ã‹ã‚’èª¬æ˜Žã™ã‚‹ã€‚ ãŸã¨ãˆ1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã ã‘ã«å¯¾ã—ã¦å®Ÿè¡Œã•ã‚Œã‚‹ã‚¯ã‚¨ãƒªã§ã‚‚ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãŒæ‚ªã„ã¨ã„ã†ã®ã¯ã‚ˆãã‚ã‚‹ã“ã¨ã§ã™ã€‚ãã®ç†ç”±ã¯ç°¡å˜ã§ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œã‚Šæ–¹ãŒã¾ãšã„ãŸã‚ã€å®Ÿè¡Œè¨ˆç”»ãŒãŠã‹ã—ããªã£ã¦ã—ã¾ã†ã®ã§ã™ã€‚ã“ã“ã§ã¯ã€1ã¤ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®ã¿ã«å¯¾ã™ã‚‹è‰²ã€…ãªã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹ãŸã‚ã®ã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’æŒ™ã’ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ãŠã“ã¨ã‚ã‚Š : ã‚ã‚‰ã‚†ã‚‹çŠ¶æ³ã‚’ã‚«ãƒãƒ¼ã—ã‚ˆã†ã¨ã¯ã›ãšã€ä¸€èˆ¬çš„ãªã‚¬ã‚¤ãƒ‰ãƒ©ã‚¤ãƒ³ã‚’æç¤ºã™ã‚‹ã«ç•™ã‚ã‚‹ã¤ã‚‚ã‚Šã§ã™ã€‚ã“ã“ã§æŒ™ã’ãŸã‚‚ã®ãŒã†ã¾ãé©ç”¨ã§ããªã„ä¾‹ã‚’ç°¡å˜ã«è¦‹ã¤ã‘ã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã¯é–“é•ã„ãªã„ã§ã—ã‚‡ã†ãŒã€ã»ã¨ã‚“ã©ã®å ´åˆã¯ã“ã“ã«æ›¸ã„ãŸã“ã¨ãŒååˆ†ãªã®ã‚‚äº‹å®Ÿã§ã™ã€‚ã¾ãŸã€MySQL 5.6ä»¥ä¸Šã«ã‚ã‚‹Index Condition Pu
clairvy 2015/05/26
mysql

performance

Index
ãƒªãƒ³ã‚¯
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ
YouTubeãŒMySQLã‚’ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã™ã‚‹ã€ŒVitessã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã€‚Kubernetesã«å¯¾å¿œ Google Cloud Platformã®ãƒ–ãƒã‚°ã«æŠ•ç¨¿ã•ã‚ŒãŸè¨˜äº‹ã€ŒScaling MySQL in the cloud with Vitess and Kubernetesã€ã§ã€Vitessã¯æ¬¡ã®ã‚ˆã†ã«èª¬æ˜Žã•ã‚Œã¦ã„ã¾ã™ã€‚ At YouTube, we went on that journey as we scaled our MySQL deployment, which today handles the metadata for billions of daily video views and 300 hours of new video uploads per minute. To do this, we developed the Vitess platform,
clairvy 2015/03/23
mysql

kubernetes

vitess
ãƒªãƒ³ã‚¯
Goã¨MySQLã‚’ç”¨ã„ãŸã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œã‚‹ã¨ãã«è€ƒãˆãŸã“ã¨ - ã‚†ã†ã†ããƒ–ãƒã‚°
ã€è¿½è¨˜ã€‘2023å¹´3æœˆ21æ—¥ YAPC::Kyoto 2023ã§ã€ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼ã‚·ã‚¹ãƒ†ãƒ Fireworqã®è¨è¨ˆã¨é‹ç”¨å®Ÿç¸¾ã‚‚å«ã‚ã¦ç™ºè¡¨ã•ã‚Œã¾ã—ãŸã€‚id:tarao ++ ã€åŠ ç†ä¿®æ£ã€‘ 2020å¹´2æœˆ16æ—¥ åŸ·ç†æ™‚ã‹ã‚‰6å¹´ã‚‚çµŒéŽã—ã¦ã„ã¾ã™ãŒã€ãŸã¾ãŸã¾ã“ã®è¨˜äº‹ã‚’æŒ¯ã‚Šè¿”ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€æ—¥æœ¬èªžãŒãŠã‹ã—ã„ã¨ã“ã‚ã‚’ä¸€éƒ¨ä¿®æ£ã—ãŸã‚Šã€ä¸€ç·’ã«å–ã‚Šçµ„ã‚“ã æ–¹ã€…ã®åå‰ãŒæ›¸ã‹ã‚Œã¦ã„ãªã‹ã£ãŸã¨ã“ã‚ã‚’ä¿®æ£ã—ã¾ã—ãŸã€‚ ã€è¿½è¨˜ã€‘2017å¹´12å¹´24æ—¥ ã“ã®ã‚¨ãƒ³ãƒˆãƒªã®ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼å®Ÿè£…ãŒFireworqã¨ã„ã†åã§OSSã¨ã—ã¦å…¬é–‹ã•ã‚Œã¾ã—ãŸã€‚id:tarao ++ github.com ã“ã®è¨˜äº‹ã¯ã¯ã¦ãª ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚¢ãƒ‰ãƒ™ãƒ³ãƒˆã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼2014ã®4æ—¥ç›®ã§ã™ã€‚ å‰å›žã¯ Mackerelã§æŽ¡ç”¨ã—ã¦ã„ã‚‹æŠ€è¡“ä¸€è¦§ã¨ãã®ç´¹ä»‹ - Hatena Developer Blog ã§ã—ãŸã€‚ ç¤¾å†…ã®é–‹ç™ºåˆå®¿ã§ã€ id:taraoã•ã‚“ã€id:hakobe
clairvy 2014/12/05
golang

mysql

ã‚¸ãƒ§ãƒ–ã‚ãƒ¥ãƒ¼
ãƒªãƒ³ã‚¯
MySQLã®å†—é•·åŒ– 2013-01-24
ï¼œSKILL BASECAMP 2013ï¼ž MySQLã®å†—é•·åŒ–ï½žç„¡åœæ¢é‹ç”¨ã‚’å®Ÿç¾ã™ã‚‹ã«ã¯ï½ž http://www.pasonatech.co.jp/entry/index.jsp?mode=2&d=on&no=3756
clairvy 2014/10/13
mysql
ãƒªãƒ³ã‚¯
MySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ - SH2ã®æ—¥è¨˜
JPOUG> SET EVENTS 20140907 | Japan Oracle User Group (JPOUG)ã«å‚åŠ ã—ã¦ç™ºè¡¨ã‚’ã—ã¦ãã¾ã—ãŸã€‚IIJã•ã¾ã®ã‚»ãƒŸãƒŠãƒ«ãƒ¼ãƒ ã¯çª“ã‹ã‚‰ã®çœºã‚ãŒã™ã°ã‚‰ã—ã„ã§ã™ãã€‚JPOUGã®é‹å–¶ãƒ¡ãƒ³ãƒã®ã¿ãªã•ã¾ã€ä¼šå ´ã‚’æä¾›ã—ã¦ãã ã•ã£ãŸIIJã®ã¿ãªã•ã¾ã€å½“æ—¥ãŠè¶Šã—ã„ãŸã ã„ãŸã¿ãªã•ã¾ã€ã©ã†ã‚‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ç§ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ã€ŒMySQLã®ãƒãƒƒã‚¯ã«ã¤ã„ã¦ã€ã¨é¡Œã—ã¦ãƒã‚¯ã‚¹ãƒˆã‚ãƒ¼ãƒãƒƒã‚¯ãªã©ã®èª¬æ˜Žã‚’ã—ã¾ã—ãŸã€‚ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã¨ã€èª¿æŸ»ã®ãŸã‚ã«ä½œæˆã—ãŸãƒ„ãƒ¼ãƒ«ã‚’å…¬é–‹ã—ã¾ã™ã€‚ ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ (PDF) Lock Inspector 1.0 ãƒ—ãƒ¬ã‚¼ãƒ³ãƒ†ãƒ¼ã‚·ãƒ§ãƒ³è³‡æ–™ã‹ã‚‰ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã®ä¸€è¦§ã§ã™ã€‚ MySQL Lists: mysql: Re: InnoDB's inner workings + checkpoints éŽåŽ»è¨˜äº‹ã®è¨‚æ£ @kami
clairvy 2014/09/14
mysql
ãƒªãƒ³ã‚¯
GitHub - siddontang/mixer: a MySQL proxy powered by Go
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session. Dismiss alert
clairvy 2014/08/24
mysql

golang

mixer
ãƒªãƒ³ã‚¯
blog.nomadscafe.jp
PHPã®å‹‰å¼·ä¼šãªã®ã§ã€ã„ã¾ã¾ã§ãŠä¼šã„ã—ãŸã“ã¨ã®ãªã„æ–¹ã¨ãŠè©±ãŒã§ãã¦ã‚ˆã‹ã£ãŸã§ã™ã€‚ ç™ºè¡¨å†…å®¹ã¯å¤§ãããªã£ã¦ã—ã¾ã£ãŸmaster.phpãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã©ã†ã‚„ã£ã¦é«˜é€Ÿã«èªã‚€ã‹ã¨ã„ã†ãŠè©±ã§ã™ã€‚PHPã§ã¯ãƒªã‚¯ã‚¨ã‚¹ãƒˆã®çµ‚äº†ã¨ã¨ã‚‚ã«å…¨ã¦ã®ãƒ¡ãƒ¢ãƒªã‚’æ¨ã¦ã¦ã—ã¾ã†ã®ã§ã€å¤‰ã‚ã‚‰ãªã„ãƒ‡ãƒ¼ã‚¿ã‚‚ãƒªã‚¯ã‚¨ã‚¹ãƒˆã®åº¦ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‹ã‚‰ãƒãƒ¼ãƒ‰ã—ãªãã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚å¤§ããªphpãƒ•ã‚¡ã‚¤ãƒ«ãŒã‚ã‚Œã°å½“ç„¶æ¯Žå›žã®èªã¿è¾¼ã¿ãŒã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã¨ãªã£ã¦ãã¾ã™ã€‚ãã‚“ãªç’°å¢ƒã§ã©ã†ã‚„ã£ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ã‚ã’ã¦ã„ã£ãŸã®ã‹ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã®ä¸ã§file sizeã‚’å°ã•ãã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã¨æ›¸ãã¾ã—ãŸãŒã€@hnwã•ã‚“ã«ã‚ˆã‚‹ã¨ã€VMå‘½ä»¤ãŒå¤šéŽãŽã‚‹ã®ãŒå•é¡Œã§ã€æ§‹é€ ã‚’ç°¡å˜ã«ã—ãŸã“ã¨ã§VMå‘½ä»¤ãŒæ¸›ã£ãŸã®ãŒã‚ˆã‹ã£ãŸã®ã§ã¯ã¨ã®ã“ã¨ã§ã—ãŸã€‚éžå¸¸ã«å‚è€ƒã«ãªã‚Šã¾ã—ãŸã€‚ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸ ãã‚ãã‚å‚·ãŒç™’ãˆã¦ããŸã€‚ã€‚ ISUCON5ã®æœ¬é¸ã«ãƒ¡ãƒ«ã‚«ãƒªã®ã‚¤ãƒ³ãƒ•
clairvy 2014/08/11
mysql
ãƒªãƒ³ã‚¯
[Q&A]MySQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãƒŸã‚¹ | Yakst
Percona MySQL Webinarsã®ç™ºè¡¨(MYSQLé–‹ç™ºã§ã‚„ã£ã¦ã—ã¾ã„ãŒã¡ãªè‡´å‘½çš„ãªãƒŸã‚¹ã«ã¤ã„ã¦)ã®QAã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æœ¬ç™ºè¡¨ã¯SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³è‘—è€…ã®Bill Karwinã•ã‚“ã®ç™ºè¡¨ã§ã™ã€‚ ã‚ªãƒªã‚¸ãƒŠãƒ«: http://www.percona.com/resources/mysql-webinars/how-avoid-even-more-common-deadly-mysql-development-mistakes July 17, 2014 by Bill Karwin æ°´æ›œæ—¥ã«ã€ŒMySQLã‚’é–‹ç™ºã™ã‚‹ä¸Šã§ã‚ˆãèµ·ã“ã‚‹(ãã—ã¦è‡´å‘½çš„ãª)ãƒŸã‚¹ã‚’ã©ã®ã‚ˆã†ã«å›žé¿ã™ã‚‹ã‹ã€ã‚’Percona MySQL webinarsã§ç™ºè¡¨ã—ãŸã€‚ãŠè¦‹é€ƒã®éš›ã¯ã€ãƒ“ãƒ‡ã‚ªã¨ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’è¦‹ã‚‹ç‚ºã«ç™»éŒ²ã™ã‚Œã°ã¾ã ã”è¦§ã«ã„ãŸã ã‘ã‚‹ã€‚ å‚åŠ ã„ãŸã ã„ãŸçš†æ§˜ã€ãã—ã¦ã¨ã‚Šã‚ã‘ã™ã°ã‚‰ã—ã„è³ªå•ã‚’ã—ã¦ã„ãŸã ãã‚ã‚ŠãŒãŸãæ€ã£ã¦ã„ã‚‹
clairvy 2014/08/11
mysql

Q&A
ãƒªãƒ³ã‚¯
èª°ã‚‚æ•™ãˆã¦ãã‚Œãªã‹ã£ãŸMySQLã®éšœå®³è§£æžæ–¹æ³• - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article?
clairvy 2014/07/12
mysql

éšœå®³

å¯¾ç–
ãƒªãƒ³ã‚¯
ãµã¤ã†ã®Webé–‹ç™ºè€…ã®ãŸã‚ã®ã‚¯ã‚¨ãƒªãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
Your browser doesn't support the features required by impress.js, so you are presented with a simplified version of this presentation. For the best experience please use the latest Chrome or Safari browser. Firefox 10 (to be released soon) will also handle it.
clairvy 2014/07/12
ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

mysql
ãƒªãƒ³ã‚¯
ã€Žã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã«ãŠã‘ã‚‹DBæ§‹æˆ&å¯¾å¿œè¨˜ã€
2ãƒ¶æœˆå‰ã«ã‚¤ãƒ³ãƒ•ãƒ«ã‚¨ãƒ³ã‚¶ã¨ã‚¦ã‚£ãƒ«ã‚¹æ€§èƒƒè…¸ç‚Žã§ã²ã©ããƒ€ãƒ¡ãƒ¼ã‚¸ã‚’å—ã‘ãŸå¢—ç”°(@masudaK)ã§ã™ã€‚ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã¯2009å¹´2æœˆã«å§‹ã¾ã£ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã€FLASHãƒ»Javaã§ä½œã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ãã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã«MySQLã‚’ç”¨ã„ã¦ã¾ã™ã€‚æœ¬è¨˜äº‹ã§ã¯ã€ã‚ãŸãã—ãŒ2å¹´ã»ã©è¦‹ç¶šã‘ã¦ã„ã‚‹ã‚¢ãƒ¡ãƒ¼ãƒãƒ”ã‚°ã®DBç’°å¢ƒã«ã¤ã„ã¦æ§‹æˆã‚„ã€æ—¥ã€…ã©ã®ã‚ˆã†ã«ã—ã¦å•é¡Œã¨å‘ãåˆã£ã¦ã„ã‚‹ã‹ã‚’ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ã‚¤ãƒ³ãƒ•ãƒ©å¯„ã‚Šã®å†…å®¹ãŒå¤šã„ãŸã‚ã€ã‚¢ãƒ—ãƒªå¯„ã‚Šã®è©±ã¯å¼Šç¤¾ç”Ÿæ²¼ã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€‚ 1. æ§‹æˆã¨è¦æ¨¡ 1.1. æ§‹æˆ ã¾ãšæ§‹æˆã§ã™ãŒã€èªã¿æ›¸ãã¯ã™ã¹ã¦ãƒžã‚¹ã‚¿ãƒ¼ã¸è¡Œã†ã‚ˆã†ã«ã—ã¦ã„ã¾ã™ã€‚ãã®ãŸã‚ã€ã‚¹ãƒ¬ãƒ¼ãƒ–ã«ã¯å‚ç…§ã‚’å‘ã‘ãšã€ãƒ›ãƒƒãƒˆã‚¹ã‚¿ãƒ³ãƒã‚¤ã¨ã—ã¦ä½¿ã£ã¦ã„ã¾ã™ã€‚ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«é–¢ã—ã¦ã¯2012å¹´ä¸æ—¬ã¾ã§ã¯5.0ã‚’ä½¿ã£ã¦ã¾ã—ãŸãŒã€DCç§»è»¢ã«ã‚ã‚ã›ã¦5.5ã«ã‚ã’ã¾ã—ãŸã€‚ãƒãƒƒã‚¯æ©Ÿèƒ½ã‚’ç”¨ã„ãŸã‚·ãƒ£ãƒ¼ãƒ‰æ§‹æˆã‚’ã—ã¦ã¾ã—ã¦ã€2014å¹´3æœˆç¾åœ¨6ã‚·ãƒ£ãƒ¼ãƒ‰ã«ãª
clairvy 2014/05/22
mysql

ameba
ãƒªãƒ³ã‚¯
MySQLãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãŸã‚ã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºç¤ŽçŸ¥è˜ - ä¹…ä¿æ¸…éš†ã®ãƒ–ãƒã‚°
ä»•äº‹ã§MySQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ã„ã¦ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦åˆ†ã‹ã£ã¦ã„ãªã„ã“ã¨ãŒå¤šã‹ã£ãŸã®ã§èª¿ã¹ãŸã“ã¨ã‚’ãƒ¡ãƒ¢ã€‚åŸºæœ¬çš„ãªã¨ã“ã‚ã‹ã‚‰å¦ç¿’ã—ãªãŠã—ãŸã€‚ MySQLã®ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ã€ã‚«ãƒ©ãƒ ãŒç‰¹å®šã®å€¤ã‚’ã‚‚ã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã®è¿…é€Ÿãªæ¤œç´¢ã«ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ç”¨ã™ã‚Œã°ã€æ•°ç™¾ã¨ã‹æ•°å„„ã‚‚ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ãŒå…¥ã£ã¦ã„ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«ã‹ã‚‰ã€ä¸€çµ„ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿…é€Ÿã«è¦‹ã¤ã‘ã¦å–ã‚Šå‡ºã™ã“ã¨ãŒå¯èƒ½ã«ãªã‚‹ã€‚ ã—ã‹ã—ã€ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯é€Ÿåº¦ã‚’æ”¹å–„ã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ãŒã€æŒ¿å…¥ã®é‚ªé”ã«ãªã£ã¦é…ããªã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’é©åˆ‡ã«ä½¿ã†ãŸã‚ã«ã€ã¾ãšã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®åŸºæœ¬æ¦‚å¿µã‚’ãŠã•ãˆã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®æ¦‚å¿µ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã¯ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ã¾ãšMySQLãŒã©ã®ã‚ˆã†ã«ã‚¯ã‚¨ãƒªã«å¿œç”ã™ã‚‹ã‹ã‚’çŸ¥ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ ä¾‹ãˆã°ã€ SELECT * FROM phone_book WHERE last_name = 'Hoge'
clairvy 2013/01/19
mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°

Index
ãƒªãƒ³ã‚¯
MyTAP + my_prove + MySQL::Sandbox ã§å¿«é© SQL Unit Testing - æ—¥å‘å¤ç‰¹æ®Šå¿œæ´éƒ¨éšŠ
MyTAP ã¨ã„ã† MySQL ä¸Šã§ Test Anything Protocol ã‚’å®Ÿç¾ã—ã¦ã—ã¾ã†ã¨ã„ã†ãƒ—ãƒãƒ€ã‚¯ãƒˆãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã¨ TAP::Parser::SourceHandler::MyTAP ã«ä»˜å±žã—ã¦ã„ã‚‹ my_prove ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã†ã¨ã‹ãªã‚Šç°¡å˜ã« SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã§ãƒ†ã‚¹ãƒˆã‚’è¡Œã†äº‹ãŒå‡ºæ¥ã¾ã™ã€‚ ã¾ãŸ MySQL::Sandbox ã¯ã ã„ã¶éŽåŽ»ã®ã‚¨ãƒ³ãƒˆãƒª*1 *2ã§ç´¹ä»‹ã—ãŸäº‹ãŒã‚ã‚Šã¾ã™ãŒã€ç•°ãªã‚‹ version ã® mysqld ã‚’è‰²ã‚“ãªæ§‹æˆã§ç°¡å˜ã«ä½œã‚Œã¦ã—ã¾ã†å„ªã‚Œã‚‚ã®ã§ã™ã€‚ ä»Šå›žã¯ã“ã‚Œã‚‰ã‚’çµ„ã¿åˆã‚ã›ã¦ãƒ†ã‚¹ãƒˆã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¡ã‚ƒã„ã¾ã™ã€‚ MyTAP ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« MySQL::Sandbox ã‚’ä½¿ã£ã¦ä½œã£ãŸ sandbox ãŒ $HOME/sandboxes/rsandbox_5_1_58 ã«ã‚ã‚‹ã¨ã—ã¾ã™ã€‚ $ cd ~/sandboxes/rsandbox_
clairvy 2011/12/19
mysql

unittest
ãƒªãƒ³ã‚¯
1