[B! *db] webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

webmarksjp id:webmarksjp

*dbã«é–¢ã™ã‚‹webmarksjpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬
ã“ã®æ–‡æ›¸ã¯ã€æŠ€è¡“è©•è«–ç¤¾åˆŠã€ŽWEB+DB PRESS Vol.22ã€ã«åŸ·ç†ã—ãŸè¨˜äº‹ã‚’æŠ€è¡“è©•è«–ç¤¾ã® è¨±å¯ã‚’å¾—ã¦WWWã§å…¬é–‹ã—ã¦ã„ã‚‹ã‚‚ã®ã§ã™ã€‚ ã“ã®WWWç‰ˆã¯æ ¡æ£å‰ã®åŽŸç¨¿ã‚’å…ƒã«ã—ã¦ã„ã‚‹ç‚¹ã€WWWå…¬é–‹å¾Œã«å¿…è¦ãŒã‚ã‚Œã°ä¿®æ£ã™ã‚‹ç‚¹ã§ã€é›‘èªŒç‰ˆã®æ–‡ç« ã¨ã¯ç•°ãªã‚‹éƒ¨åˆ†ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å›³è¡¨ã‚‚é›‘èªŒç‰ˆã¨ã¯ç•°ãªã‚Šã¾ã™ã€‚ äºˆã‚ã”äº†æ‰¿ãã ã•ã„ã€‚ ã¾ãŸã€ã“ã®æ–‡ç« ãŒå¯¾è±¡ã—ã¦ã„ã‚‹ã®ã¯MySQL 4.0ç³»ãªã®ã§ã€æœ€æ–°ã®ãƒªãƒªãƒ¼ã‚¹ç‰ˆã¨æ¯”ã¹ã‚‹ã¨èª¬æ˜Žä¸è¶³ãªç‚¹ãªã©ãŒå¤šã€…ã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®åŸºæœ¬ã‚’ãŠã•ãˆã‚‹ã«ã¯ã€ã“ã®æ–‡æ›¸ã¯ã¾ã æœ‰ç›Šã ã¨æ€ã„ã¾ã™ãŒã€è¨å®šãƒ¬ãƒ™ãƒ«ã®èª¬æ˜Žã¯æœ€æ–°ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚ç…§ã™ã‚‹ã‚ˆã†ã«ã—ã¦ãã ã•ã„ã€‚
webmarksjp 2008/07/15
MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

database

performance

replication

tips

*db
ãƒªãƒ³ã‚¯
BKCon 2006 - ã«ã½ãŸã‚“ç ”ç©¶æ‰€
æ˜¨æ—¥ã¯ BKCon 2006 ã«è¡Œã£ã¦ããŸã€‚ BK ã¨ã„ã†ã®ã¯ã€Œä¸€èˆ¬çš„ã«ã¯ãƒãƒƒãƒ‰ãƒŽã‚¦ãƒã‚¦ã®äº‹ã€ãªã‚“ã§ã™ãŒã€æ˜¨æ—¥ã®ã¯ã€BKCon ã¨è¨€ã£ã¦ã‚‚ã€ã‹ã¤ã¦é–‹å‚¬ã•ã‚ŒãŸ Bad Knowhow Conference 2004 ã®ç¶šç·¨ã¨ã‹ã§ã¯ãªãã€"B"atara "K"esuma "Con"ference 2006 ã§ã™ã€‚ â€»æ£ã—ãã¯æ¨ªæµœ Linux ãƒ¦ãƒ¼ã‚¶ã‚°ãƒ«ãƒ¼ãƒ—ä¸»å‚¬ã®ã€Œç¬¬ 65 å›žã‚«ãƒ¼ãƒãƒ«èªæ›¸ä¼šã€ã®ãƒ†ãƒ¼ãƒž "mixi.jp: Scaling Out With Open Source" ã§ã™ã€‚ ã¡ãªã¿ã«ã€Batara Kesuma ã•ã‚“ã¨ã„ã†ã®ã¯ã€æ ªå¼ä¼šç¤¾ãƒŸã‚¯ã‚·ã‚£ã®å–ç· å½¹ã€‚ mixi ã®è£å´ã‚’è¦‹ã›ã¾ã™ã¨ã„ã†ã‹ã€ã¡ã‚‡ã£ã¨ hip ãªè¨€ã„ã‹ãŸã‚’ã™ã‚Œã° "Inside mixi's backend" ã£ã¦ã‚«ãƒ³ã‚¸ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšã€ãƒ—ãƒ¬ã‚¼ãƒ³å†…å®¹ã¯ YAPC::Asia ã®æ™‚ã¨å¤§å‡¡åŒã˜ã§ã—ãŸãŒã€ãƒ—ãƒ¬ã‚¼ãƒ³ã®æŒã¡
webmarksjp 2008/07/14
database

mysql

tuning

optimize

mixi

db

commu

*db
ãƒªãƒ³ã‚¯
WEBã‚¢ãƒ—ãƒªç”¨ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹ã‚‚ã®è‰²ã€…:phpspoté–‹ç™ºæ—¥èªŒ
Test (Sample) Data Generators Sample / test data is an effective way to test web projects & applications. WEBã‚¢ãƒ—ãƒªç”¨ã®ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ä½œã‚‹ã‚‚ã®è‰²ã€…ã€‚ ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã®ç”Ÿæˆã¯çµæ§‹é¢å€’ã§ã™ãŒã€ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ãˆã°ç°¡å˜ã€ã¨ã„ã†ã“ã¨ã§ï¼‘ã¤ã¯ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”ŸæˆãŸã‚ã®ãƒ„ãƒ¼ãƒ«ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã§ã™ãã€‚ ä»¥ä¸‹ã«åˆ—æŒ™ generatedata.com ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’HTMLã€Excelã€XMLã€CSVã€SQLã®å½¢å¼ã§å‡ºåŠ›å¯èƒ½ã€‚ å‡ºåŠ›ãƒ‡ãƒ¼ã‚¿ã‚‚ã€å€‹äººæƒ…å ±ãƒ‡ãƒ¼ã‚¿ã‚„ã€ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚’é¸æŠžã—ã¦å‡ºåŠ›ã§ãã¾ã™ã€‚ DatageneratorÂ - GUIã§å‹•ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿ãƒ¼ DBMonster ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ©ãƒ³ãƒ€ãƒ ç”Ÿæˆãƒ‡ãƒ¼ã‚¿ã‚’å…¥ã‚Œã‚‰ã‚Œã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆ CSV data generator Ruby
webmarksjp 2008/07/14
ã‚µãƒ¼ãƒ“ã‚¹

tool

test

*ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º

ãƒ†ã‚¹ãƒˆ

ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«

ãƒ‡ãƒ¼ã‚¿

ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿

*webé–‹ç™º

*db
ãƒªãƒ³ã‚¯
MySQL (InnoDB) ã«ãŠã‘ã‚‹è¡Œã®ã‚µã‚¤ã‚ºã¨é€Ÿåº¦ã®é–¢ä¿‚ã«ã¤ã„ã¦ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
é›†ç´„æ¼”ç®—ã‚’è¡Œã†ã‚±ãƒ¼ã‚¹ã§ã¯ã€è¡Œã®ã‚µã‚¤ã‚ºã‚’å°ã•ãä¿ã¤ã“ã¨ã¯ã¨ã¦ã‚‚é‡è¦ã€‚ã‚¢ã‚¯ã‚»ã‚¹é »åº¦ãŒä½Žã„ã‚³ãƒ©ãƒ ã¯åˆ¥ãƒ†ãƒ¼ãƒ–ãƒ«ã«è¿½ã„å‡ºã™ã¨ã‹ã—ãŸã»ã†ãŒã„ã„ãã‚‰ã„ã€‚ ä¸€æ–¹ã€é›†ç´„æ¼”ç®—ã‚’è¡Œã‚ãªã„ã‚±ãƒ¼ã‚¹ (å˜ä¸€è¡Œã® insert, update ç‰ã‚’å«ã‚€) ã®å ´åˆã¯ã€(ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¨ã®é€šä¿¡ã®ãŸã‚ã®) ã‚·ã‚¹ãƒ†ãƒ ã‚³ãƒ¼ãƒ«ãŒã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ã«ãªã‚‹ã®ã§ã€å°ã•ãªãƒ†ãƒ¼ãƒ–ãƒ«ã«ãŸãã•ã‚“ã‚¢ã‚¯ã‚»ã‚¹ã‚’ã™ã‚‹ã‚ˆã‚Šã‚‚ã€é•·ã„è¡Œã‚’æŒã¤ãƒ†ãƒ¼ãƒ–ãƒ«ã«ï¼‘å›žã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã»ã†ãŒè‰¯ã„ã€‚ ãŸã¨ãˆã°æ‰‹å…ƒã®ç’°å¢ƒã§ã® insert on duplicate key update ã®é€Ÿåº¦ã¯ã€ è¡Œã®ã‚µã‚¤ã‚º å¿…è¦æ™‚é–“ 0KB 1 3KB 4 6KB 7 9KB 13 12KB 13 ã¨ã‹ãã‚“ãªæ„Ÿã˜ (ç’°å¢ƒã‚„ã‚¯ã‚¨ãƒªã«ã‚ˆã‚‹å¤‰ã‚ã‚‹ã®ã§è‡ªåˆ†ã§æ¸¬å®šã—ã¦ãã€‚9KB ã®é€Ÿåº¦ä½Žä¸‹ã¯ãƒšãƒ¼ã‚¸ã‚µã‚¤ã‚ºã®1/2ã‚’è¶…ãˆãŸã‹ã‚‰ã‹ãª)ã€‚ã¤ã¾ã‚Šã€è¡Œã®ã‚µã‚¤ã‚ºãŒ1KBç¨‹åº¦ã ã¨ã€é€šä¿¡ã®ã‚ªãƒ¼ãƒãƒ¼ãƒ˜ãƒƒãƒ‰ãŒå¤§ãã„ã‹ã‚‰ã‚ã¾ã‚Šå•é¡Œã«
webmarksjp 2008/07/14
db

mysql

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹

innodb

*db

database

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
PHPã¨MySQLã®å€‹äººçš„ã¾ã¨ã‚ - ã±ã‚“ã´ãƒ¼ã¾ã£ã—ãã‚‰
Don't let me cryï¼ˆå³æ‰‹ã‚’å›žã—ã¦æ‹³ã®ã¤ãã‚ã’ï¼‰ Don't let me sighï¼ˆ å·¦æ‰‹ã‚’å›žã—ã¦æ‹³ã®ã¤ãã‚ã’ï¼‰å‘ªæ–‡ã®ã‚ˆã†ã«å”±ãˆã¦ï¼ˆä¸¡æ‰‹ã‚’é ã®ä¸Šã§ã‚¯ãƒ©ãƒƒãƒ—ã‚¸ãƒ£ãƒ³ãƒ—ï¼‰ MySQLã§ã¯ã¾ã£ãŸã“ã¨ MySQLã®æ–‡å—åŒ–ã‘ ä»Šã•ã‚‰ä½•ã„ã£ã¦ã‚“ã®ã‚³ã‚¤ãƒ„ã¨ã‹ãã“è¨€ã‚ãªã„ã€‚ æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’ç¢ºèªã™ã‚‹SQLæ–‡ã€ŒSHOW VARIABLES LIKE 'char%';ã€ MySQL4.1ä»¥é™ã¯ã‚µãƒ¼ãƒã¨ã¯åˆ¥ã«ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒè¨å®šã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€ã‚µãƒ¼ãƒé–“ã§é•ã†æ–‡å—ã‚³ãƒ¼ãƒ‰ãŒã‚»ãƒƒãƒˆã•ã‚Œã¦ã„ã‚‹ã¨ã€ä¸€åº¦ucs2å¤‰æ›ã‚’é€šã‚‹ã€‚ ã‚ˆã£ã¦ã€ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã€ã‚µãƒ¼ãƒé–“ã§é•ã†æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã™ã‚‹ã“ã¨ã¨ãªã‚Šæ–‡å—åŒ–ã‘ãŒèµ·ã“ã‚‹å¯èƒ½æ€§ãŒã‚ã‚‹ã€‚ PHPã¯my.cnfã§[mysql]ã€[client]ã‚’è¨å®šã—ã‚ˆã†ãŒã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ãƒ“ãƒ«ãƒ‰æ™‚ã«æŒ‡å®šã•ã‚ŒãŸã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆ(é€šå¸¸latin1)ã€‚ my
webmarksjp 2008/07/13
æ–‡å—ã‚³ãƒ¼ãƒ‰

MySQL

*DB

æ–‡å—åŒ–ã‘

skip-chara

Client

character

charactercode

code
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼šPostgreSQL ã¨ MySQL ã®ç´¹ä»‹ (1/4)
åŒ»ç™‚DXã®ãƒ˜ãƒ³ãƒªãƒ¼ã®é–‹ç™ºãƒˆãƒƒãƒ—ã«ã‚¤ãƒ³ã‚¿ãƒ“ãƒ¥ãƒ¼ã€‚ãƒ¢ãƒŽãƒªã‚¹ã‹ã‚‰ãƒžã‚¤ã‚¯ãƒã‚µãƒ¼ãƒ“ã‚¹ã«å›žå¸°ã™ã‚‹èƒŒæ™¯ã¨ã¯ï¼Ÿ 1æœˆ5æ—¥ 6:01
webmarksjp 2008/07/12
db

mysql

postgresql

*db

æ¯”è¼ƒ

æ©Ÿèƒ½
ãƒªãƒ³ã‚¯
ã€MySQLã‚¦ã‚©ãƒƒãƒã€‘ç¬¬7å›ž å¤§è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã‚’æ”¯ãˆã‚‹MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ï¼šITpro
ã“ã®ã¨ã“ã‚æ¥½å¤©ã‚’ã¯ã˜ã‚ã¨ã—ã¦ï¼ŒMySQLã‚’æ´»ç”¨ã—ãŸå¤§è¦æ¨¡ãªäº‹ä¾‹ãŒå¢—ãˆã¦ã„ã‚‹ï¼ˆé–¢é€£è¨˜äº‹ï¼‰ã€‚ã“ã®ã‚ˆã†ãªå¤§è¦æ¨¡ï¼Œã‹ã¤ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã®è¨±ã•ã‚Œãªã„ã‚·ã‚¹ãƒ†ãƒ ã‚’æ”¯ãˆã¦ã„ã‚‹ã®ãŒï¼ŒMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã§ã‚ã‚‹ã€‚ ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¨ã¯ï¼Œå¯¾è±¡ç‰©ã¨ã¾ã£ãŸãåŒã˜ç‰©ã‚’è£½ä½œã™ã‚‹å‡¦ç†ã ã€‚åŒã˜ã‚ˆã†ãªæ„å‘³ã«ã€ŒãƒŸãƒ©ãƒ¼ã€ãŒã‚ã‚‹ãŒï¼Œæ„å‘³ã™ã‚‹ã¨ã“ã‚ã¯ç‰©ç†çš„ãªã‚³ãƒ”ãƒ¼ã§ã‚ã‚‹ã€‚ã€Œãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã€ã¯ï¼Œè«–ç†çš„ãªè¤‡è£½ã§ã‚ã‚Šï¼Œå¯¾è±¡ç‰©ã®å…¨ä½“ã‚„ä¸€éƒ¨ã¨ã„ã£ãŸç¯„å›²ã‚’é™å®šã§ãã‚‹ç‚¹ãŒç•°ãªã‚‹ã€‚ ã“ã®ã‚ˆã†ãªæ©Ÿèƒ½ã¯ï¼Œå¤§ãŒã‹ã‚Šãªæº–å‚™ã¨é«˜åº¦ãªæŠ€è¡“ãŒå¿…è¦ã¨è€ƒãˆã¦ã„ã‚‹æ–¹ã‚‚å¤šã„ã ã‚ã†ã€‚ã—ã‹ã—ï¼ŒMySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ï¼Œéžå¸¸ã«ç°¡å˜ã«åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ä»Šå›žã¯ï¼Œç¾è¡Œãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã‚‚åˆ©ç”¨å¯èƒ½ãªãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã‚’è§£èª¬ã™ã‚‹ã€‚ Masterã®æ›´æ–°ãŒSlaveã«åæ˜ ã•ã‚Œã‚‹ MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ï¼ŒMasterã¨Slaveã«å½¹å‰²ãŒåˆ†ã‹ã‚Œã‚‹ï¼ˆå›³1[æ‹¡å¤§
webmarksjp 2008/07/12
mysql

replication

Administrator

*DB

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³

db
ãƒªãƒ³ã‚¯
1