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

pitworks id:pitworks

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

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

DeNAæ¾ä¿¡ã•ã‚“ã®ã€ŒMySQLç’°å¢ƒã«ãŠã‘ã‚‹Fusion-ioæ¤œè¨¼çµæžœã¨DeNAã«ãŠã‘ã‚‹æ´»ç”¨ä¾¡å€¤ã€ã‚»ãƒƒã‚·ãƒ§ãƒ³ãƒ¡ãƒ¢ - å…ƒRX-7ä¹—ã‚Šã®é©å½“ãªæ—¥ã€…
å¼Šç¤¾ã®ä¸€éƒ¨ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚‚çµ¶è³›æ´»èºä¸ã®Fusion-ioç¤¾ã®ioDriveã€‚ Fusion-io ioDriveã¨Fusion-io ioDrive Duoã§ã¯ã©ã¡ã‚‰ã‚‚ã€æœ€å°å®¹é‡ã®ãƒ¢ãƒ‡ãƒ«ã¯SLCåž‹ã€ãã®ã»ã‹ã¯MLCåž‹ã‚’ä½¿ã£ã¦ã„ã‚‹ãŒã€Fusion ioDriveã®èªã¿è¾¼ã¿é€Ÿåº¦ã¯735ã€œ770MB/sã€æ›¸ãè¾¼ã¿é€Ÿåº¦ã¯510ã€œ750MB/sã ã€‚Fusion ioDrive Duoã«è‡³ã£ã¦ã¯ã€èªã¿è¾¼ã¿é€Ÿåº¦ã¯1.0ã€œ1.5GB/sã€æ›¸ãè¾¼ã¿é€Ÿåº¦ã¯ä¸€å¾‹1.5GB/sã¨ã„ã†æ•°å€¤ã‚’ãŸãŸãå‡ºã™ã€‚ ï¼ IT Special PRï¼šFusion-ioã®ã‚¯ãƒ¼ãƒ«ãªæŠ€è¡“ã‚’ä½¿ã„ã“ãªã›ï¼ ä»Šæ—¥ã¯ãƒ‡ãƒ«ã•ã‚“ä¸»å‚¬ã®ä¸‹è¨˜ã‚»ãƒŸãƒŠãƒ¼ã«ã¦ã€ã“ã®Fusion-ioã«é–¢ã™ã‚‹DELLç¤¾ã®æ¤œè¨¼çµæžœç´¹ä»‹ã‚„ã€DeNAæ¾ä¿¡ã•ã‚“ã«ã‚ˆã‚‹MySQLç’°å¢ƒã§ã®Fusion-ioæ¤œè¨¼çµæžœãŠã‚ˆã³DeNAã§ã®åˆ©ç”¨ã«é–¢ã™ã‚‹ãŠè©±ãŒèžã‘ã‚‹ã¨ã®ã“ã¨ã ã£ãŸã®ã§ã€é€”ä¸ã‹ã‚‰ã®å‚åŠ ã§
pitworks 2011/09/24
é«˜é€ŸåŒ–

mysql

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

FusionIO
ãƒªãƒ³ã‚¯
Spider for MySQL project files : Spider for MySQL
pitworks 2011/09/05
MySQL

Spider

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†
ãƒªãƒ³ã‚¯
æ¶ˆã—ã¦ã—ã¾ã£ãŸMySQLã®ãƒ‡ãƒ¼ã‚¿ã‚’å¾©æ—§ã™ã‚‹æ–¹æ³• | ãƒ›ã‚²ãƒ›ã‚²ãƒãƒƒã‚¯
åŒåƒšãŒèª¤ã£ã¦æœ¬ç•ªé‹ç”¨ä¸ã®DBã‚’æ¶ˆã—ã¦ã—ã¾ã£ãŸã€‚ è‡ªåˆ†ã‚‚åŒã˜ãƒŸã‚¹ã‚’çŠ¯ã—ã‹ããªã„ã®ã§ã€å¯¾å‡¦æ³•ã‚’ãƒ¡ãƒ¢ã—ã¦ãŠãã€‚ ã¾ãšã€å¾©æ—§ã«ã¯ãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã¨ãƒã‚¤ãƒŠãƒªãƒã‚°ãŒå¿…è¦ã¨ãªã‚‹ã€‚ç„¡ã„å ´åˆã¯ã“ã®è¨˜äº‹ã§ã¯ã‚«ãƒãƒ¼ã§ããªã„ã€‚ ä¸¡æ–¹ã‚ã‚‹å ´åˆã¯ä»¥ä¸‹ã®æ‰‹é †ã§å¾©æ—§ã™ã‚‹ã€‚ ã¾ãšã€ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã—ã¦ã‚ã£ãŸãƒ€ãƒ³ãƒ—ãƒ•ã‚¡ã‚¤ãƒ«ã§ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ™‚ç‚¹ã¾ã§å¾©æ—§ã™ã‚‹ã€‚ ãƒã‚¤ãƒŠãƒªãƒã‚°ã‹ã‚‰å¿…è¦ãªæœŸé–“ã®SQLã‚’æŠ½å‡ºã™ã‚‹ã€‚ ã©ã®æ™‚ç‚¹ã‹ã‚‰ã®SQLã‚’æŠ½å‡ºã™ã‚‹ã®ã‹ãŒé›£ã—ã„ã¨ã“ã‚ã ãŒã€æ™®é€šã¯ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’å–ã£ãŸæ™‚ç‚¹ã‹ã‚‰ã ã‚ã†ã€‚ mysqldump -d db_name /var/lib/mysql-bin.000001 --start-datetime='2011-06-06 01:11:25' --end-datetime='2011-06-07 11:11:12' > recover.sql ãƒã‚¤ãƒŠãƒªãƒã‚°ãŒè¤‡æ•°ã‚ã‚‹å ´åˆã¯ã€å¿…è¦ã«å¿œã˜ã¦è¿½è¨˜ã—ã¦ã„ãã€‚
pitworks 2011/08/12
# mysqlbinlog -d db_name /var/lib/mysql-bin.000001 --start-datetime='2011-06-06 01:11:25' --end-datetime='2011-06-07 11:11:12' ã§å¿…è¦ãªæ™‚é–“ã®ãƒã‚¤ãƒŠãƒªãƒã‚°ã‚’å–å¾—å¯èƒ½

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

ãƒªã‚¹ãƒˆã‚¢
ãƒªãƒ³ã‚¯
MySQLãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãƒ»ãƒªã‚«ãƒãƒª
Â© 2005 Sony Global Solutions Inc. 2005 3 26 (MATSUNOBU Yoshinori) Â© 2005 Sony Global Solutions Inc. ï¿½ ï¿½ MySQL ï¿½ ï¿½ ï¿½ ï¿½ ï¿½ mysqldump ï¿½ FLUSH TABLES WITH READ LOCK ï¿½ ï¿½ ï¿½ ï¿½ Â© 2005 Sony Global Solutions Inc. (4.1 ) ( ) SSL SSL VPN(SSH ) ( ) (InnoDB ) (InnoDB ) SQL92 SQL99 Core 4.1 5.0 SQL InnoDB MyISAM ( ) B-Tree ( 5.0 ) 4 (InnoDB ) C/C++( ) Linux,Solaris,HP-UX,AIX,Windows Â© 2005 Sony Global Solutions I
pitworks 2011/08/12
ãƒã‚¤ãƒŠãƒªãƒã‚°ã‹ã‚‰ã®ãƒªã‚«ãƒãƒªã«ã¤ã„ã¦ã®è©³ã—ã„èª¬æ˜Ž

MySQL

ãƒªã‚«ãƒãƒª

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†
ãƒªãƒ³ã‚¯
ä¿¡ã˜ã‚‰ã‚Œãªã„DBæ–‡åŒ–ã€ŒJoinç¦æ¢ã€ã«ã€Œå›ºå®šé•·DBã€ã€ã€ã§ã‚‚ã€åˆã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
åƒ•ã‚‰ãŒæœ€è¿‘æ‰‹ãŒã‘ã¦ã„ã‚‹ã®ã¯ã€ã¨ã¦ã‚‚å¤§è¦æ¨¡ãªã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ 100ä¸‡äººã®å¥‘ç´„ãƒ¦ãƒ¼ã‚¶ãŒä½¿ã„ã€1ãƒ†ãƒ¼ãƒ–ãƒ«ã«1å„„ãƒ¬ã‚³ãƒ¼ãƒ‰ä»¥ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’è²¯ã‚ã€24æ™‚é–“æ¢ã‚ã‚‹ã“ã¨ãŒè¨±ã•ã‚Œãšã€ è¦æ±‚ã‹ã‚‰å¿œç”ã¾ã§ã®ã‚¿ãƒ¼ãƒ³ã‚¢ãƒ©ã‚¦ãƒ³ãƒ‰ã‚¿ã‚¤ãƒ ãŒ1ç§’ä»¥å†…ã¨ã„ã†åŽ³ã—ã„SLAã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€‚ ä¸ã§ã‚‚åƒ•ã¯RDBã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚’æ‹…å½“ã—ã¦ã„ã‚‹ã€‚ åƒ•ãŒã“ã®ç¾å ´ã«æ¥ã¦ã€é©šæ„•ã—ãŸæ–‡åŒ–ãŒ2ã¤ã‚ã‚‹ ãã‚Œã¯ã€ŒJoinç¦æ¢ã€ã¨ã€Œå›ºå®šé•·DBã€ã ã€‚ ã‚ã‚Šãˆãªã„ã€‚ ã¨ã¯ã„ãˆã€æ£ç›´ã«è¨€ãˆã°ã€Œã¾ãŸã‹ã€ã€ã€ã€ã¨ã„ã†æ„Ÿæƒ³ã§ã‚‚ã‚ã‚‹ã€‚ RDBã‚’çŸ¥ã‚‰ãªã„ãƒ¬ã‚¬ã‚·ãƒ¼ãªäººãŸã¡ãŒè¨è¨ˆã—ãŸDBã§ã¯ã‚ˆãã‚ã‚ŠãŒã¡ãªè¨è¨ˆã ã‹ã‚‰ã ã€‚ ã¨åƒ•ã¯æ—©ã€…ã«ã“ã®æ–‡åŒ–ã¨æˆ¦ã£ã¦ã€çµ¶å¯¾ã«è¦†ã—ã¦ã‚„ã‚ã†ã¨è€ƒãˆã¦ãŸã€‚ éŽåŽ»ã®çµŒé¨“ä¸Šãã‚Œã¯ãŸã‚„ã™ã„ãƒã‚ºã ã£ãŸã€‚ ã—ã‹ã—ã€ã“ã®æ–‡åŒ–ã¨æˆ¦ã†ã“ã¨3ãƒ¶æœˆé–“ã€‚ å±ˆã—ãŸã€‚åˆã‚ã¦å±ˆã—ãŸã€‚ã„ã‚„ã€å±ˆã—ãŸã¨ã„ã†ã‚ˆã‚Šã¯ç†è§£ã—ãŸã€‚ å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBã¨ã„ã†
pitworks 2011/08/10
Joinç¦æ¢ã®ãƒãƒªã‚·ãƒ¼ã¯ã€ŒRDBã¯ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆï¼ˆã‚µãƒ¼ãƒå¢—è¨ï¼‰ã—ã«ãã„ã‹ã‚‰DBã«ã¯è€ƒãˆã•ã›ãªã„ã€‚ã€ã¨ã„ã†è€ƒãˆæ–¹ã€‚

DB

è¨è¨ˆ

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

MySQL
ãƒªãƒ³ã‚¯
oinume journal
å¤§è¦æ¨¡ãªã‚³ãƒ¼ãƒ‰ãƒ™ãƒ¼ã‚¹ã§ãƒªãƒ•ã‚¡ã‚¯ã‚¿ãƒªãƒ³ã‚°ã‚’çœã‚¨ãƒåŒ–ã™ã‚‹ãŸã‚ã«codemodã‚’æœ€è¿‘èª¿ã¹ã¦ã„ã¦ã€è»½ãè©¦è¡ŒéŒ¯èª¤ã—ãŸã®ã§ãã®ãƒ¡ãƒ¢ã€‚ ã‚„ã‚ŠãŸã„ã“ã¨ ä¾‹ãˆã°ä»¥ä¸‹ã®ã‚ˆã†ãªTable Driven Testãªã‚³ãƒ¼ãƒ‰ã‚’BEFOREã‹ã‚‰AFTERã«æ›¸ãæ›ãˆãŸã„ã€‚ã‚³ãƒ¼ãƒ‰é‡ãŒå¤šã„ãŸã‚äººé–“ãŒã‚„ã‚‹ã®ã¯ç¾å®Ÿçš„ã§ã¯ãªãã€codemodã§æ©Ÿæ¢°çš„ã«æ›¸ãæ›ãˆãŸã„ã€‚ BEFORE package main import ( "slices" "testing" ) func TestContains(t *testing.T) { type args struct { ss []string s string } tests := []struct { name string args args want bool }{ { name: "empty: false", args: args{[]string{}, ""}, wan
pitworks 2011/08/10
CREATE TABLE hoge_20081123 LIKE hoge; / INSERT INTO hoge_20081123 SELECT * FROM hoge;

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†
ãƒªãƒ³ã‚¯
MySQL 5.6ã«æ–°æ©Ÿèƒ½è©¦ç”¨ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’è¿½åŠ - å…¨æ–‡æ¤œç´¢ã‚„ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã© | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
MySQL Oracleã¯8æœˆ1æ—¥(ç±³å›½æ™‚é–“)ã€MySQL 5.6ã‚¢ãƒ¼ãƒªãƒ¼ã‚¢ã‚¯ã‚»ã‚¹ç‰ˆã«ã€InnoDBã®æ–°æ©Ÿèƒ½ã¨ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®æ–°æ©Ÿèƒ½ã‚’è©¦ã™ã“ã¨ãŒã§ãã‚‹ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’è¿½åŠ ã—ãŸã“ã¨ã‚’ç™ºè¡¨ã—ãŸã€‚ã‚¢ãƒ¼ãƒªãƒ¼ã‚¢ã‚¯ã‚»ã‚¹ç‰ˆã¯MySQL Server Snapshotsã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¯èƒ½ã€‚ã€Œmysql-5.6-labs-innodb-ftsã€ãŒæ–°ã—ãè¿½åŠ ã•ã‚ŒãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ãªã‚‹ã€‚Windowsç‰ˆã€Mac OS Xç‰ˆã€Linuxç‰ˆã€Solarisç‰ˆãŒæä¾›ã•ã‚Œã¦ã„ã‚‹ã€‚ ã‚¢ãƒ¼ãƒªãƒ¼ã‚¢ã‚¯ã‚»ã‚¹ç‰ˆã§è©¦ç”¨ã§ãã‚‹InnoDBã®æ–°æ©Ÿèƒ½ã¯æ¬¡ã®ã¨ãŠã‚Šã€‚ å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ã€‚ REDOãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®2TBä¸Šé™ã¸ã®å¼•ãä¸Šã’ã€‚ ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«UNDOãƒã‚°ã‚’é…ç½®ã€‚ å†èµ·å‹•æ™‚ã®äº‹å‰èªã¿è¾¼ã¿ãŠã‚ˆã³ã‚¦ã‚©ãƒ¼ãƒŸãƒ³ã‚°ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«æ©Ÿèƒ½ã€‚ .ibdãƒ•ã‚¡ã‚¤ãƒ«ã®è‡ªå‹•ã‚¨ã‚¯ã‚¹ãƒ†ãƒ³ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã€‚ 4KãŠã‚ˆã³8Kãƒšãƒ¼ã‚¸ã‚µã‚¤ã‚ºã®ã‚µãƒãƒ¼ãƒˆã€‚
pitworks 2011/08/09
å…¨æ–‡æ¤œç´¢æ©Ÿèƒ½ / REDOãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºã®2TBä¸Šé™ã¸ã®å¼•ãä¸Šã’ / ãã‚Œãžã‚Œã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚¹ãƒšãƒ¼ã‚¹ã«UNDOãƒã‚°ã‚’é…ç½® / å†èµ·å‹•æ™‚ã®äº‹å‰èªã¿è¾¼ã¿ãŠã‚ˆã³ã‚¦ã‚©ãƒ¼ãƒŸãƒ³ã‚°ã‚’å®Ÿç¾ã™ã‚‹ãŸã‚ã®ãƒãƒƒãƒ•ã‚¡ãƒ—ãƒ¼ãƒ«æ©Ÿèƒ½...etc

MySQL
ãƒªãƒ³ã‚¯
ã€ãƒ¬ãƒãƒ¼ãƒˆã€‘MySQL 5.5ã€ã‚»ãƒŸåŒæœŸãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ãƒ‡ãƒ¼ã‚¿ä¸€è²«æ€§ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
MySQL ç¾åœ¨MySQLã¯5.1ç³»ã¨5.5ç³»ã®é–‹ç™ºãŒæ´»ç™ºã«é€²ã‚ã‚‰ã‚Œã¦ã„ã‚‹ã€‚ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ãƒªãƒªãƒ¼ã‚¹ãŒå®Ÿæ–½ã•ã‚ŒãŸã®ã¯MySQL 5.1ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆãƒ©ã‚¤ãƒ³ã§ã‚ã‚Šã€æ¬¡ã®ãƒ—ãƒãƒ€ã‚¯ã‚·ãƒ§ãƒ³ãƒªãƒªãƒ¼ã‚¹ã¯MySQL 5.5ç³»ã‹ã‚‰ã«ãªã‚‹ã¨ã¿ã‚‰ã‚Œã‚‹ã€‚ã“ã®MySQL 5.5ã«ãŠã‘ã‚‹ç›®çŽ‰æ©Ÿèƒ½ã®ãªã‚Šãã†ãªã®ãŒãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã®æ‹¡å¼µã ã€‚ã©ã†ã„ã£ãŸæ‹¡å¼µãŒå®Ÿæ–½ã•ã‚Œã‚‹ã®ã‹ãŒMySQL 5.5: What's New in Replication (Oracle's MySQL Blog)ã«ãŠã„ã¦ç°¡å˜ã«ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ã€‚ MySQLã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³æ©Ÿèƒ½ã¯ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ãŒç°¡å˜ãªã‚ã‚Šã«ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ãŒã‚ã£ã¦ã€ã—ã‹ã‚‚æ‰±ã„ã‚„ã™ã„ã€‚ãƒ‡ãƒ¼ã‚¿ã®å†—é•·æ€§ã‚„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ç›®çš„ã§ã®åˆ©ç”¨ãŒç°¡å˜ã«å®Ÿæ–½ã§ãã‚‹ã“ã¨ã‹ã‚‰ã€MySQLã®æ©Ÿèƒ½ã¨ã—ã¦äººæ°—ãŒã‚ã‚‹ã€‚MySQL 5.5ã§ã¯ã“ã®æ©Ÿèƒ½ã‚’æ‹¡å¼µã—ã€å¾“æ¥ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚ˆã‚Šã‚‚ã‚ˆã‚ŠãƒŸãƒƒã‚·ãƒ§ãƒ³ã‚¯ãƒªãƒ†ã‚£ã‚«ãƒ«ãªã‚·ãƒ¼ãƒ³ã§æŽ¡ç”¨
pitworks 2011/08/09
ãƒžã‚¹ã‚¿ãƒ¼ã¨ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ä¸€è²«æ€§ã‚’ä¿è¨¼ã™ã‚‹ã‚»ãƒŸåŒæœŸãƒ¬ãƒ—ãƒªæ©Ÿèƒ½ã®å°Žå…¥ / ã‚¹ãƒ¬ãƒ¼ãƒ–ã‚µãƒ¼ãƒã®å‹•ä½œæ¤œçŸ¥ã®ãƒã‚§ãƒƒã‚¯æœŸé–“ã‚’ã•ã‚‰ã«çŸãæŒ‡å®šã§ãã‚‹ / ã‚¯ãƒ©ãƒƒã‚·ãƒ¥ã—ãŸã‚¹ãƒ¬ãƒ¼ãƒ–ãŒè‡ªå‹•çš„ã«ãƒªã‚«ãƒãƒªã™ã‚‹æ©Ÿèƒ½ã‚’å®Ÿç¾..etc

MySQL

ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
ãƒªãƒ³ã‚¯
DeNAãŒç¤¾å†…åˆ©ç”¨ã—ã¦ã„ã‚‹MySQLã®è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹é–‹å§‹
MySQLãŒãƒ€ã‚¦ãƒ³ã—ãŸã¨ãã«è‡ªå‹•çš„ã«åˆ¥ã®MySQLã¸å‡¦ç†ã‚’å¼•ãç¶™ãã“ã¨ã§ã€é«˜å¯ç”¨æ€§ã‚’å®Ÿç¾ã™ã‚‹ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼ãƒ„ãƒ¼ãƒ«ã€ŒMySQL-MHA: MySQL Master High Availability manager and toolsã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã¨ã—ã¦å…¬é–‹ã•ã‚ŒãŸã“ã¨ã‚’ã€ä½œè€…ã®æ¾ä¿¡å˜‰ç¯„ï¼ˆã¾ã¤ã®ã¶ã‚ˆã—ã®ã‚Šï¼‰æ°ãŒãƒ–ãƒã‚°ã§ä¼ãˆã¦ã„ã¾ã™ã€‚ Yoshinori Matsunobu's blog: Announcing MySQL-MHA: "MySQL Master High Availability manager and tools" æ¾ä¿¡æ°ã¯ãƒ¢ãƒã‚²ãƒ¼ãªã©ã§çŸ¥ã‚‰ã‚Œã‚‹DeNAã«å‹¤å‹™ã—ã¦ãŠã‚Šã€MySQL-MHAã«ã‚ˆã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ¼æ©Ÿèƒ½ã¯DeNAã®ã‚¤ãƒ³ãƒ•ãƒ©é‹ç”¨ã‚’æ”¯ãˆã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚åŒæ°ã®ãƒ–ãƒã‚°ã‹ã‚‰å¼•ç”¨ã—ã¾ã™ã€‚ Difficulties of master failover is one of
pitworks 2011/08/04
MySQL-MHAã«ã‚ˆã‚‹è‡ªå‹•ãƒ•ã‚§ã‚¤ãƒ«ã‚ªãƒ¼ãƒãƒ„ãƒ¼ãƒ«ã«ã¤ã„ã¦ã«ãƒ—ãƒ¬ã‚¼ãƒ³ã€‚ãƒžã‚¹ã‚¿ãƒ¼ã®ãƒ‡ãƒ¼ã‚¿ãŒæ¬ ã‘ãŸã¾ã¾ã ã£ãŸã‚Šã€ã»ã‹ã®ã‚¹ãƒ¬ãƒ¼ãƒ–ã¨ãƒ‡ãƒ¼ã‚¿ãŒãšã‚ŒãŸã¾ã¾ã«ãªã‚‰ãªã„æ§˜ã«é…æ…®ã—ãŸå‹•ä½œã‚’ã—ã¦ãã‚Œã‚‹ã€‚

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

MySQL-MHA
ãƒªãƒ³ã‚¯
å¤§è¦æ¨¡ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ é–‹ç™ºã‹ã‚‰å¦ã‚“ã PHPï¼†MySQLå®Ÿè·µãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
OSC 2011 Hokkaidoã®ç™ºè¡¨ã§ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã§ã™ã€‚ å¼Šç¤¾ãŒã€Œãƒ–ãƒ©ã‚¦ã‚¶ä¸‰å›½å¿—ã€ã‚„ã€Œè‹±é›„ã‚¯ã‚¨ã‚¹ãƒˆã€ã¨ã„ã£ãŸã‚²ãƒ¼ãƒ ã‚’ã€PHPï¼‹MySQLã§æ§‹ç¯‰ã—ã¦ããŸä¸Šã§ã€èº«ã«ã¤ã‘ãŸãƒŽã‚¦ãƒã‚¦ã‚„ã€æ³¨æ„ã™ã¹ãç®‡æ‰€ã€æŒ‡é‡ãªã©ã‚’ã¾ã¨ã‚ãŸè³‡æ–™ã¨ãªã£ã¦ã„ã¾ã™ã€‚Read less
pitworks 2011/06/29
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã«ãŠã‘ã‚‹MySQLã®ä½¿ã„æ–¹ãŒéžå¸¸ã«åˆ†ã‹ã‚Šã‚„ã™ã„ãã¾ã¨ã¾ã£ã¦ã„ã‚‹è³‡æ–™

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚¢ãƒ—ãƒª

php

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

é«˜é€ŸåŒ–

ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
DBã‚µãƒ¼ãƒå‘ã‘Linuxãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è€ƒãˆã‚‹ ã€œ ãƒ¡ãƒ¢ãƒªã‚ªãƒ¼ãƒãƒ¼ã‚³ãƒŸãƒƒãƒˆç·¨ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
Cã§ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã„ã¦ã„ã¦å¤§é‡ã®ãƒ¡ãƒ¢ãƒªã‚’ç¢ºä¿ã—ãŸããªã£ãŸã¨ãã€å¤§æŠµã¯ mallocã‚’ä½¿ã†ã¨æ€ã„ã¾ã™ãŒã€ãã®éš›ã«ã¯æˆ»ã‚Šå€¤ãŒNULLã‹ã©ã†ã‹ã‚’åˆ¤æ–ã—ã¦ã‚¨ãƒ©ãƒ¼å‡¦ç†ã«é£›ã°ã™ã¨æ€ã„ã¾ã™ã€‚ã—ã‹ã—ã€Linux ã®ãƒ¡ãƒ¢ãƒªç®¡ç†ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã«ã¯ã€Œãƒ¡ãƒ¢ãƒªãƒ»ã‚ªãƒ¼ãƒãƒ¼ã‚³ãƒŸãƒƒãƒˆã€ã¨ã„ã†æ©Ÿæ§‹ãŒã‚ã‚Šã€å®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ãƒ¡ãƒ¢ãƒªä»¥ä¸Šã®é ˜åŸŸã‚’ç¢ºä¿ã§ãã¦ã—ã¾ã„ã¾ã™ã€‚ #include <stdio.h> #include <stdlib.h> int main() { int i; char *p; for(i=0;i<65536;i++){ p = (char *)malloc(65536); if(0 == (long)p){ break; } } printf("SIZE=%dMB\n",i*65536/1024/1024); return(0); } swapoff ã—ãŸãƒ¡ãƒ¢ãƒª 1G ã®ãƒžã‚·ãƒ³ã§ã“ã‚Œã‚’å®Ÿè¡Œã™ã‚‹ã¨ã“ã‚“ãªæ„Ÿã˜ã«ãª
pitworks 2011/06/29
# sysctl -w vm.overcommit_ratio=99 # sysctl -w vm.overcommit_memory=2 ã§OOMã€€KILLERã¯åœæ¢å¯èƒ½

OOM Killer

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

mysql
ãƒªãƒ³ã‚¯
MySQL ã® MEMORY(HEAP) ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ä½¿ã†ã¨ãã¯ index_type ã«æ°—ã‚’ã¤ã‘ã‚ - @kyanny's blog
çµè«–: MEMORY ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã® index_type ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ HASH ãªã®ã§ = or <=>æ¼”ç®—åã‚’ä½¿ç”¨ã™ã‚‹ç‰ä¾¡æ¯”è¼ƒã«ã®ã¿ä½¿ç”¨ã•ã‚Œã‚‹ã€‚ >, >=, <, <=, BTWEEN ã‚’ä½¿ã†ã‚¯ã‚¨ãƒªã§ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã„ãŸã„ã¨ãã¯ USING BTREE ã‚’ã¤ã‘ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½œã‚‹ã“ã¨ã€‚ MySQL 5.0.75 (ã‚„ã‚„å¤ã‚ã‹ã—ã„ï¼Ÿï¼‰ã‚’ä½¿ã£ã¦ã„ã¦ã€ MEMORY ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦ã€ SELECT * FROM tbl WHERE col1 = 'val1' AND col2 <= 'val2';ãªã‚“ã¦ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ãŸã‚‰å¦™ã«é…ã‹ã£ãŸã€‚ col1, col2 ã®é †ç•ªã§è¤‡åˆã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ã¯ã£ã¦ã„ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€‚ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«èªã‚“ã ã‚‰ã¡ã‚ƒã‚“ã¨æ›¸ã„ã¦ã‚ã‚Šã¾ã—ãŸã€‚ã‚ã‚“ã¾ã‚Šä½¿ã†æ©Ÿä¼šã‚‚ãªã„ã ã‚ã†ã‘ã©ï¼ˆã ã‹ã‚‰ã“ãï¼Ÿï¼‰ãƒ¡ãƒ¢ã€‚ ãã®åå‰ã‹ã‚‰ã‚‚ã‚ã‹ã‚‹ã‚ˆã†ã«ã€MEMORY ãƒ†ãƒ¼ãƒ–ãƒ«ã¯
pitworks 2011/06/04
ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã¨ãã« index_type ã§ BTREE ã‚’æŒ‡å®šã™ã‚‹ã¨BTREE ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§æ—©ããªã‚‹

MySQL

Heep

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - å±±ç¾Šã®é ã®æ—¥è¨˜
1æ™‚é–“ä»¥ä¸Šã‹ã‹ã£ã¦ã„ãŸã‚ã‚‹selectæ–‡ã®å®Ÿè¡ŒãŒã€MySQLã®è¨å®šã‚’å¤‰æ›´ã—ãŸã‚‰ã€2åˆ†ã«çŸç¸®ã§ããŸã€‚ tmp_table_sizeã‚’32Mã‹ã‚‰300Mã«å¤‰æ›´ã€‚ãŒã€ã“ã‚Œã ã‘ã§ã¯è¨å®šãŒæœ‰åŠ¹ã«ãªã‚‰ãªã„ã€‚ max_heap_table_sizeã‚’16Mã‹ã‚‰300Mã«å¤‰æ›´ã™ã‚‹ã€‚ ãŸã¨ãˆã° select count(*) from ( select distinct ... ) a ã®ã‚ˆã†ãªselectã®ãƒã‚¹ãƒˆã®å ´åˆã€æ‹¬å¼§å†…ã®selectã®å®Ÿè¡ŒçµæžœãŒãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã«ä½œæˆã•ã‚Œã‚‹ã€‚ã“ã®ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã«ä½œæˆã•ã‚Œã‚‹ãŒã€ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–ãƒ«ã®ã‚µã‚¤ã‚ºãŒtmp_table_sizeã‚ˆã‚Šå¤§ãããªã‚‹ã¨ã€/tmpãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªä¸‹ã«ISAMãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ä½œæˆã•ã‚Œã‚‹ãŒã€ISAMãƒ•ã‚¡ã‚¤ãƒ«ã¸ã®å‡¦ç†ãŒé…ãã€æ¥µç«¯ã«å‡¦ç†æ™‚é–“ãŒå¢—å¤§ã—ã¦ã—ã¾ã†ã€‚ ãªã®ã§ã€tmp_table_sizeã‚’å¤§ããã™ã‚Œã°ã„ã„ã®ã ãŒã€ãƒ†ãƒ³ãƒãƒ©ãƒªãƒ†ãƒ¼ãƒ–
pitworks 2011/06/04
select count(*) from ( select distinct .. ) aã€€ã®æ§˜ãªselectã®ãƒã‚¹ãƒˆã§ã¯æ‹¬å¼§å†…ã®selectçµæžœãŒtmp_tableã«ã‚ªãƒ³ãƒ¡ãƒ¢ãƒªã§ä½œæˆã•ã‚Œã‚‹ã€‚tmp_table_sizeã‚ˆã‚Šå¤§ãããªã‚‹ã¨ã€/tmpã«ISAMãƒ•ã‚¡ã‚¤ãƒ«ã§ä½œæˆã•ã‚Œé‡ã„ tmp_table_size/max_heap_table_sizeã‚’å¤‰æ›´ã™ã‚‹ã¨æ—©ã„

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

é«˜é€ŸåŒ–
ãƒªãƒ³ã‚¯
ä¹…ä¹…ç²¾å“å›½äº§é¦™è•‰äºšæ´²AV_ç–¯ç‹‚åšå—XXXâ…©é«˜æ½®é«˜æ½®æŒ‰æ‘©_æ— ç å°‘å¦‡ä¸€åŒºäºŒåŒºæµªæ½®AV_ä¹…ä¹…å¤©å¤©èºç‹ ç‹ èºå¤œå¤œAVAPP
pitworks 2011/06/04
The global system variable "max_heap_table_size" define the maximum size memeory table can reach. The default values is 16384. set global max_heap_table_size=1048576000;

MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

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

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
MySQL :: MySQL Product Archives
pitworks 2011/05/26
MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
HAåŒ–æ©Ÿèƒ½ã‚’æ‰‹ã«å…¥ã‚ŒãŸSPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã«ã¯ã‚‚ã¯ã‚„æ»è§’ã¯ãªã‹ã£ãŸã€‚
æœ¬ãƒ–ãƒã‚°ã§ã‚‚ä½•åº¦ã‹å–ã‚Šä¸Šã’ãŸã“ã¨ã®ã‚ã‚‹ã‚ã®SPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã•ã‚‰ã«ãƒ‘ãƒ¯ãƒ¼ã‚¢ãƒƒãƒ—ã—ã¦ä¾¿åˆ©ã«ãªã£ãŸï¼ï¼˜æœˆã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚ŒãŸãƒãƒ¼ã‚¸ãƒ§ãƒ³2.22ã§ã¯æ¬¡ã®ï¼’ã¤ã®å¼·åŒ–ãŒè¡Œã‚ã‚Œã¦ã„ã‚‹ã€‚ HAæ©Ÿèƒ½ã®è¿½åŠ ï¼ˆãƒ‡ãƒ¼ã‚¿ãƒŽãƒ¼ãƒ‰ã®å†—é•·åŒ–ï¼‰ LinuxãŠã‚ˆã³Windowsç”¨ãƒ“ãƒ«ãƒ‰æ¸ˆã¿MySQLãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®é…å¸ƒ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒç°¡å˜ã«ãªã£ãŸï¼å‰å›žSPIDERã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’ç´¹ä»‹ã—ãŸã¨ãã«ã¯ã€ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã‹ã‚‰ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã€ãªãŠã‹ã¤MySQL æœ¬ä½“ã«ãƒ‘ãƒƒãƒã‚’é©ç”¨ã—ãªã‘ã‚Œã°ãªã‚‰ãšã€åˆ©ç”¨ã™ã‚‹ã¾ã§ã®æ•·å±…ãŒé«˜ã‹ã£ãŸã‚ˆã†ã«æ€ã†ã€‚ã—ã‹ã—ã€ãƒãƒ¼ã‚¸ãƒ§ãƒ³2.22ã‚ˆã‚ŠSPIDERã‚’å«ã‚“ã ãƒ“ãƒ«ãƒ‰æ¸ˆã¿ãƒã‚¤ãƒŠãƒªãŒæä¾›ã•ã‚ŒãŸã“ã¨ã«ã‚ˆã‚Šã€SPIDERã‚’åˆ©ç”¨ã™ã‚‹æ‰‹é–“ã¯ãã£ã¨å°‘ãªããªã£ãŸã€‚ã—ã‹ã‚‚ã“ã®ãƒ“ãƒ«ãƒ‰æ¸ˆã¿ã®ãƒã‚¤ãƒŠãƒªã«ã¯SPIDERã ã‘ã§ãªãå„ç¨®ãƒ‘ãƒƒãƒã¨ã€ã•ã‚‰ã«ã¯VPã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã¾ã§å«ã¾ã‚Œã¦ã„ã‚‹ã¨ã„ã†æ°—ã®åˆ©ãã‚ˆã†ã ã€‚ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«
pitworks 2011/05/26
MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: å›½ç”£MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒSpiderã€ã®ä½œè€…ã€æ–¯æ³¢å¥å¾³æ°ã«èžã
ã“ã‚“ã«ã¡ã¯ã€‚ä¸æ‘ã§ã™ã€‚ MySQLã«ã¯MyISAMã€InnoDBã€CSVãªã©ã®ã„ãã¤ã‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ãŒã‚ã‚Šã¾ã™ãŒã€çš†ã•ã‚“ã¯Spiderã¨ã„ã†ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã‚’èžã„ãŸã“ã¨ã¯ã‚ã‚Šã¾ã™ã§ã—ã‚‡ã†ã‹ã€‚Spider Storage Engineã¯æ–¯æ³¢å¥å¾³ã•ã‚“ã«ã‚ˆã‚Šä½œæˆã•ã‚ŒãŸDatabase Shardingã‚’å¯èƒ½ã«ã™ã‚‹ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã§MySQL 5.1ã§åˆ©ç”¨å¯èƒ½ã§ã™ã€‚ å…ˆæ—¥ã€æŸé›†ã¾ã‚Šã§æ–¯æ³¢ã•ã‚“ã¨ãŠä¼šã„ã—ãŸã¨ãã«Spiderã‚’ä½œã£ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸã®ã§ã€æ—©é€Ÿè©³ã—ã„å†…å®¹ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ â€»Spiderã«ã¤ã„ã¦ã®èª¬æ˜Žè³‡æ–™ã¯MySQLã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2009ã«ã¦æ–¯æ³¢ã•ã‚“ãŒç™ºè¡¨ã•ã‚ŒãŸã¨ãã®ã‚¹ãƒ©ã‚¤ãƒ‰ãŒã‚ã‚Šã¾ã™ã€‚ã‚¹ãƒ©ã‚¤ãƒ‰ã®ç›´ãƒªãƒ³ã‚¯ï¼ˆzipï¼‰ Spider Storage Engine ã«ã¤ã„ã¦ posted by (C)ãƒ•ã‚©ãƒˆè”µ Spider Storage Engineã¨ã¯ï¼Ÿ
pitworks 2011/05/26
MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
Wild Growth æ—¥æœ¬èªž
2/18ã«SkySQLãŒæ—¥æœ¬ã§ç¬¬ï¼’å›žç›®ã¨ãªã‚‹MariaDB/MySQLã®ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¾ã™ã€‚ http://atnd.org/event/E0023540 æµ·å¤–ã‹ã‚‰ã®è¬›æ¼”è€…ã¯ã€å‰å›žæ¥æ—¥ã•ã‚ŒãŸColin Charlesæ°ã€Michael Carneyæ°ã®ã»ã‹ã€ä»Šå›žã¯MySQL ABã®å‰µæ¥è€…ã®Micaelâ€œMontyâ€Wideniusæ°(MySQLã®ç”Ÿã¿ã®è¦ªã¨ã—ã¦ã‚‚æœ‰å)ã¨David Axmarkæ°ã‚‚åŠ ã‚ã‚‹è±ªè¯ãªé¡”ã¶ã‚Œã§ã™ã€‚ ã¾ãŸã€å‰å›žã‚ˆã‚Šæ™‚é–“æž ãŒæ‹¡å¤§ã—ã€æ ªå¼ä¼šç¤¾ãƒ‡ã‚£ãƒ¼ãƒ»ã‚¨ãƒŒãƒ»ã‚¨ãƒ¼æ§˜ã€æ ªå¼ä¼šç¤¾ã‚¢ã‚·ã‚¹ãƒˆæ§˜ã€MySQLãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šå ¤äº•æ°ã®è¬›æ¼”ãŒäºˆå®šã•ã‚Œã¦ãŠã‚Šã€ç§ã‚‚æœ¬ã‚¤ãƒ™ãƒ³ãƒˆã§ç™»å£‡ã•ã›ã¦é ‚ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ DeNA æ¨‹å£æ°ã‹ã‚‰ã¯ã€ŒHandlersocket 2.0ã€ DeNA ä¸è°·æ°ã‹ã‚‰ã¯ã€ŒMySQL ite: SQLiteãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’èªã¿æ›¸ãã™ã‚‹MySQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚¨ãƒ³ã‚¸ãƒ³ã€ ã®è¬›
pitworks 2011/05/26
MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
Spider for MySQL in Launchpad
The spider storage engine enables tables of different MySQL instances to be treated like a table of a same instance. Because xa transaction and partitioning is supported, it can do decentralized arrangement to two or more servers of data of same table. The new storage engine "Spider" does work for its strong scalability to access other storage engine of MySQL, to idea to the most considerations ar
pitworks 2011/05/26
MySQL

ã‚µãƒ¼ãƒæ§‹ç¯‰

ã‚µãƒ¼ãƒç®¡ç†

spider
ãƒªãƒ³ã‚¯
1 2 3 4 5 6 7 8 9 10 æ¬¡ã®ãƒšãƒ¼ã‚¸