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

araishi id:araishi

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

ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚«ãƒ•ã‚§Ã— ãƒ‰ãƒªã‚³ãƒ æŠ€è¡“å‹‰å¼·ä¼š ï½žæœˆé–“50å„„ï¼°ï¼¶ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’æ”¯ãˆã‚‹æŠ€è¡“ - yamasaki0's diary
ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚«ãƒ•ã‚§Ã— ãƒ‰ãƒªã‚³ãƒ æŠ€è¡“å‹‰å¼·ä¼š ï½žæœˆé–“50å„„ï¼°ï¼¶ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã‚’æ”¯ãˆã‚‹æŠ€è¡“ å‹‰å¼·ä¼šã«å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚ â—†gussanæ° ã€Œã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã®ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æ´å²ã€ http://www.slideshare.net/drecom/ss-11667563 ãƒ‰ãƒªã‚³ãƒ ãŒ2å¹´åŠã§å¢—ãˆãŸç‰© ç´¯è¨ˆãƒ¦ãƒ¼ã‚¶ãƒ¼1000ä¸‡ æœˆé–“PV 50å„„+ ã‚µãƒ¼ãƒãƒ¼å°æ•°400å°ï¼‹ ã‚µãƒ¼ãƒ“ã‚¹å®‰å®šç¨¼åƒé‡è¦ 2009å¹´å¤ mixiã‚¢ãƒ—ãƒªã‚ªãƒ¼ãƒ—ãƒ³ã—ãŸã®ã§ã€ã‚¢ãƒ—ãƒªãƒªãƒªãƒ¼ã‚¹ Railsã‚’åˆ©ç”¨ mongrelã€€rails2.3 ãƒªãƒªãƒ¼ã‚¹æ—¥ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ãŒ10ä¸‡ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« 1é€±é–“çœ ã‚Œãªã„æ—¥ã€…ç¶šã æ’ƒæ²ˆç†ç”± åŒã˜ã‚ˆã†ãªã‚·ãƒ¥ãƒ«ã®ã‚¯ã‚¨ãƒªãŒè²¯ã¾ã‚‹ MYISAMã®ãƒ†ãƒ¼ãƒ–ãƒ«ãƒãƒƒã‚¯ãŒã‹ã‹ã£ã¦ã„ãŸã€€-> innoDBã«å¤‰æ›´ã§å›žé¿ ã‚«ãƒ©ãƒ ã®æ›´æ–°ãŒå¤šã„ã€€->memcached TokyoTyrantã«é€ƒãŒã—ãŸ ååˆ†ã«å¤§ããªãƒ‡ãƒ¼ã‚¿ã§è² è·è©¦é¨“ã—ã¦
araishi 2016/09/17
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ

DB

æŠ€è¡“
ãƒªãƒ³ã‚¯
ãƒ¤ãƒ•ãƒ¼ç¤¾å†…ã§ã‚„ã£ã¦ã‚‹MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚»ãƒŸãƒŠãƒ¼å¤§å…¬é–‹
3. Yahoo! JAPANã®RDBç’°å¢ƒ â€¢ 11g RAC Enterprise Edition â€¢ ç´„200DB â€¢ ã‚µãƒ¼ãƒ 200å°, Exadata ã‚‚ã‚ã‚‹ã‚ˆ â€¢ MySQL 5.1 (RR,Mixed) Percona 5.5 (RR,Mixed) Percona 5.6 (RC,RBR,GTID) â€¢ ç´„500DB â€¢ ã‚µãƒ¼ãƒ 300å° Oracle Database MySQL Percona
araishi 2016/02/23
ã‚ˆãã¾ã¨ã¾ã£ã¦ã‚‹

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

mysql

DB
ãƒªãƒ³ã‚¯
Mac/Windows/Linuxã§åˆ©ç”¨å¯èƒ½ãªDBå°‚ç”¨GUIãƒ„ãƒ¼ãƒ«ã€Ž0xDBEã€ã«ã¤ã„ã¦ | DevelopersIO
ã“ã‚Œã¾ã§ã«ã€(ä¸»ã«)Amazon Redshiftã§æ´»ç”¨å‡ºæ¥ã‚‹GUIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€ŽIntellij IDEA Ultimate Editionã€ã‚„ã€ŽAginityã€ç‰ã‚’ç´¹ä»‹ã—ã¦æ¥ã¾ã—ãŸãŒã€Intellij IDEAã‚’é–‹ç™ºã—ã¦ã„ã‚‹JetBrainç¤¾ã‹ã‚‰åˆ¥ç¨®ã®DBé–¢é€£ãƒ„ãƒ¼ãƒ«ãŒé–‹ç™ºã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†æƒ…å ±ã‚’å…ˆæ—¥çŸ¥ã‚Šã¾ã—ãŸã€‚ Amazon Redshiftã®Mac OS Xå‘ã‘GUIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã€ŽIntellij IDEA Ultimate Editionã€ã®Database Toolsã‚’ä½¿ã† ï½œ Developers.IO Redshiftå°‚ç”¨ Windows GUIãƒ„ãƒ¼ãƒ«ã€ŽAginity Workbench for Amazon Redshiftã€ãŒä¾¿åˆ©ã‹ã‚‚ã—ã‚Œãªã„ä»¶ ï½œ Developers.IO ãã‚ŒãŒã“ã®ã€Ž0xDBEã€ã¨å‘¼ã°ã‚Œã‚‹ã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ã‚¢ãƒŠã‚¦ãƒ³ã‚¹è‡ªä½“ã¯1å¹´ä»¥ä¸Šå‰ã‹ã‚‰ãªã•ã‚Œã¦ã„ãŸæ§˜ã§ã€
araishi 2015/07/29
DB

ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
MySQL ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ - kozy.heteml.jp
å®Ÿè¡Œ â€ CALL ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£å() ã§å®Ÿè¡Œã€‚ mysql> CALL test_proc01(); +------------+ | CURDATE() | +------------+ | 2007-12-31 | +------------+ ã¡ãŒã†DBã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚‚å®Ÿè¡Œã§ãã‚‹ã€‚ãã®å ´åˆã¯ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£åã®å‰ã«DBåã‚’ã¤ã‘ã‚‹ã€‚ DBå.ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£å â†‘ å®šç¾© â€ delimiteræŒ‡å®šã§ä¸€æ™‚çš„ã«åŒºåˆ‡ã‚Šæ–‡å—ã‚’å¤‰æ›´ã—ã¦ã„ã‚‹ç‚¹ã«æ³¨æ„ï¼ mysql> delimiter // mysql> CREATE PROCEDURE test_proc02() -> BEGIN -> SELECT * FROM group_test_tbl WHERE type="A"; -> SELECT * FROM group_test_tbl WHERE type="B";
araishi 2012/08/17
mysql

DB
ãƒªãƒ³ã‚¯
ã“ã‚Œã ã‘ã¯è¦šãˆã¦ãŠããŸã„!!MySQL ã®ï¼–ã¤ã®è‡ªå‹•å¤‰æ› - sakaikã®æ—¥ã€…é›‘æ„Ÿï½ž(T)ç·¨
MySQLã¯ã¨ã¦ã‚‚æ°—ãƒã¤ã‹ã„å±‹ã•ã‚“ã§ã‚ã‚‹ã€‚æˆ‘ã€…ãŒæŠ•ã’ã‚‹å¤šå°‘ã‚ã„ã¾ã„ãªæŒ‡ç¤ºã‚‚é ‘å¼µã£ã¦è§£é‡ˆã—ã€ãªã‚“ã¨ã‹æ–‡å¥ã‚’è¨€ã‚ãšã«å®Ÿè¡Œã—ã¦ã¿ã‚ˆã†ã¨æŒ‘æˆ¦ã—ã¦ã¿ã¦ãã‚Œã‚‹ã€‚ ä»Šæ—¥ã¯ãã‚“ãªMySQLãŒã‚±ãƒŠã‚²ã«è§£é‡ˆã—ã¦ãã‚Œã‚‹è‡ªå‹•å¤‰æ›ã«ã¤ã„ã¦ç´¹ä»‹ã—ã‚ˆã†ã¨æ€ã†ã€‚ã“ã®è‡ªå‹•å¤‰æ›ã€ã‚±ãƒŠã‚²ãªMySQLã®å¥¥ã‚†ã‹ã—ã•æ•…ã€å‡ºã—ãŸæŒ‡ç¤ºã¨ç•°ãªã‚‹å‹•ä½œã‚’ã•ã‚ŒãŸã“ã¨ã«æ°—ãŒã¤ã‹ãªã„ã“ã¨ãŒã‚ã‚‹ã€‚ã“ã“ã§ç´¹ä»‹ã™ã‚‹ï¼–ã¤ã®è‡ªå‹•å¤‰æ›ã‚’ã—ã£ã‹ã‚Šè„³ãƒŸã‚½ã«ãŸãŸãè¾¼ã‚“ã§ãŠã‘ã°ã€ç„¡ç”¨ãªãƒˆãƒ©ãƒ–ãƒ«ã«ãƒãƒžã‚‹æ™‚é–“ã‚‚æ¸›ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ã€‚ ï¼‘ï¼Ž[æ•°å€¤] ç¯„å›²å¤–ã®æ•°å€¤ã¯é ã‚’æŠ¼ã•ãˆã¤ã‘ã‚‰ã‚Œã‚‹ intã‚„smallintã€bigintãªã©ã®æ•°å€¤åž‹ã«ã¯ã€æ‰±ãˆã‚‹ç¯„å›²ãŒæ±ºã¾ã£ã¦ã„ã‚‹ã€‚ä¾‹ãˆã°intåž‹ãªã‚‰æœ€å¤§21å„„ã¡ã‚‡ã£ã¨ã ï¼ˆunsignedã®å ´åˆã¯43å„„å¼±ï¼‰ã€‚ã“ã‚Œã‚ˆã‚Šå¤§ãã„æ•°å—ã‚’ç™»éŒ²ã™ã‚‹ã‚ˆã†æŒ‡ç¤ºã‚’å‡ºã™ã¨MySQLã¯ã©ã†ã™ã‚‹ã‹ã€‚ãã†ã€é ‘å¼µã£ã¦å…¥ã‚Œã‚‰ã‚Œã‚‹ã¨ã“ã‚ã¾ã§å…¥ã‚Œã¦ãã‚Œã‚‹ã®ã§ã‚ã‚‹ã€‚ã€Œå…¥ã‚Œã‚‰ã‚Œã‚‹ã¨ã“
araishi 2010/02/27
mysql

DB
ãƒªãƒ³ã‚¯
1