[B! ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°] at_homeã®ãƒ

at_home id:at_home

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«é–¢ã™ã‚‹at_homeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (12)

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

ã•ã„ãã‚“ã® Rails ã‚µãƒ¼ãƒ“ã‚¹ã‚’é«˜é€ŸåŒ–ã‚’ã—ã¦ã¿ãŸ - 2nd life (ç§»è»¢ã—ã¾ã—ãŸ)
å…ˆæ—¥ã®ã‚‚ã‚‚ã‚¯ãƒãƒãƒƒã‚«ã‚½ãƒ³ã§å‡ºä¼šã£ãŸ wantedly ã‚’ä½œã£ã¦ã‚‹ä»²ã•ã‚“ãŒ ã¨è¨€ã£ã¦ãŸã®ã§ã€é¢ç™½ãã†ãªã®ã§ wantedly ã‚’é€Ÿãã—ã¦ã¿ã¾ã—ãŸã€‚ wantedly ã¡ãªã¿ã«ãƒ‡ãƒ¼ã‚¿ãŒæ•°ç™¾ä¸‡ã‚ªãƒ¼ãƒ€ãƒ¼ã‚‚ãªã•ãã†ãªã®ã«ã€ã©ã®ãƒšãƒ¼ã‚¸ã‚‚ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ã¨2-5ç§’ãã‚‰ã„ã‹ã‹ã£ã¦ã„ãŸã®ã§ã€ç¢ºå®Ÿã«é€Ÿãã§ããã†ã ãªãã¨ã„ã†æ„Ÿè¦šã¯ã‚„ã‚‹å‰ã‹ã‚‰ã‚ã‚Šã¾ã—ãŸã€‚ ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚µã‚¤ãƒ‰ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° åˆå¿ƒè€…*1ã«ã‚ã‚ŠãŒã¡ãªå•é¡Œã¨ã—ã¦ SQL ã«é©åˆ‡ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹å¼µã£ã¦ãªã„ ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã¹ãå ´æ‰€ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã„ãªã„ ç„¡é§„ãªãƒ‡ãƒ¼ã‚¿ã‚’å¼•ãã™ãŽã¦ã‚‹ ã“ã¨ãŒã‚ˆãã‚ã‚Šã¾ã™ã€‚ã®ã§é †ã«å®Ÿè£…ã‚’è¦‹ã¦ã„ãã¾ã—ãŸã€‚ SQLã«é©åˆ‡ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¼µã£ã¦ãªã„ å¼µã£ã¦ã‚ã‚Šã¾ã—ãŸï¼ã³ã£ãã‚Šï¼ï¼¼(^o^)ï¼ ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã¹ãå ´æ‰€ã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã—ã¦ã„ãªã„ Facebook API ã‚’åˆ©ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãªã‚“ã§ã™ãŒã€ãƒ¦ãƒ¼ã‚¶ã®ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã‚’æ¯Žå›žé¦¬é¹¿æ£ç›´ã« HT
at_home 2013/11/15
ã‚ãƒ£ãƒƒã‚·ãƒ¥

rails

heroku

ruby

performance

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

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
sarã«ã‚ˆã‚‹ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ç™ºè¦‹ã®æ‰‹é †(ã¨ã„ã†ã‹sysstatã®ä½¿ç”¨æ³•)ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ - end0tknr's kipple - webå†™çµŒé–‹ç™º
sar ã§åŽé›†ã—ãŸãƒªã‚½ãƒ¼ã‚¹ä½¿ç”¨æƒ…å ±ãŒ sadf ã‚³ãƒžãƒ³ãƒ‰ã§ TSV ã¨ã—ã¦å‡ºåŠ› (2014/8/6è¿½è¨˜) sar ã§åŽé›†ã—ãŸãƒªã‚½ãƒ¼ã‚¹ä½¿ç”¨æƒ…å ±ãŒ sadf ã‚³ãƒžãƒ³ãƒ‰ã§ TSV ã¨ã—ã¦å‡ºåŠ›ã§ãã‚‹ - å®®å·æ‹“ã®æ—¥è¨˜ â†‘å…¨ãçŸ¥ã‚Šã¾ã›ã‚“ã§ã—ãŸ ç§ãŒã‚ˆãåˆ©ç”¨ã™ã‚‹option (2013/8/6è¿½è¨˜. ã‚ˆãå¿˜ã‚Œã‚‹ã®ã§) $ sar -r -s 00:00:00 -e 01:00:00 -f /var/log/sa/sa03 ï½µï¾Œï¾Ÿï½¼ï½®ï¾ å†…å®¹ ä¾‹ -q load average $ sar -q -u cpuä½¿ç”¨çŽ‡ $ sar -u -b I/Oå›žæ•°ã¨ï¾ƒï¾žï½°ï¾€é‡ $ sar -b -r ï¾’ï¾“ï¾˜ã¨ï½½ï¾œï½¯ï¾Œï¾Ÿä½¿ç”¨çŽ‡ $ sar -r -s é–‹å§‹æ™‚é–“ $ sar -s 00:00:00 -e çµ‚äº†æ™‚é–“ $ sar -e 03:00:00 -f æ—¥ä»˜ â€» $ sar -f /var/log/sa/sa03 â€»ã€Œ
at_home 2013/06/03
ã‚³ãƒžãƒ³ãƒ‰

Linux

ã‚µãƒ¼ãƒ

server

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

sar

ãƒœãƒˆãƒ«ãƒãƒƒã‚¯

è² è·åŽŸå›
ãƒªãƒ³ã‚¯
DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼
MySQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ãŠã„ã¦éžå¸¸ã«é‡è¦ã¨ãªã‚‹ãƒ¡ãƒ¢ãƒª(ãƒãƒƒãƒ•ã‚¡)é–¢é€£ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã«ã¤ã„ã¦ã€ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆ DSASã®ã¨ã‚ã‚‹DBã‚µãƒ¼ãƒ(å®Ÿãƒ¡ãƒ¢ãƒª4GB)ã®å®Ÿéš›ã®è¨å®šå€¤ ã‚’ã¾ã¨ã‚ã¦ã¿ã¾ã™ã€‚ ã¾ãŸã€å¿…è¦ãƒ¡ãƒ¢ãƒªã®ç·é‡ã®è¨ˆç®—ã‚„é™ç•Œå€¤ã‚’è¶Šãˆã¦ãªã„ã‹ãƒã‚§ãƒƒã‚¯ã—ã¦ãã‚Œã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚‚ç´¹ä»‹ã—ã¾ã™ã€‚ æ˜¯éžã€å‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ï¼ ã¾ãšæœ€åˆã«æ³¨æ„ç‚¹ã‚’ã€‚ ãƒãƒƒãƒ•ã‚¡ã«ã¯2ã¤ã®ã‚¿ã‚¤ãƒ—ãŒã‚ã‚Šã¾ã™ã€‚ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ ã‚°ãƒãƒ¼ãƒãƒ«ãƒãƒƒãƒ•ã‚¡ã¯mysqldå…¨ä½“ã§ãã®ãƒãƒƒãƒ•ã‚¡ãŒ1ã¤ã ã‘ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã€ ã“ã‚Œã«å¯¾ã—ã€ ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã¯ã‚¹ãƒ¬ãƒƒãƒ‰(ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³)ã”ã¨ã«ç¢ºä¿ã•ã‚Œã‚‹ã‚‚ã®ã§ã™ã€‚ ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®éš›ã«ã¯ã‚°ãƒãƒ¼ãƒãƒ«/ã‚¹ãƒ¬ãƒƒãƒ‰ã®é•ã„ã‚’æ„è˜ã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ã‚‡ã†ã€‚ ãªãœãªã‚‰ã€ã‚¹ãƒ¬ãƒƒãƒ‰ãƒãƒƒãƒ•ã‚¡ã«å¤šãã®ãƒ¡ãƒ¢ãƒªã‚’å‰²ã‚Šå½“ã¦ã‚‹ã¨ã€ã‚³ãƒã‚¯ã‚·ãƒ§ãƒ³ãŒå¢—ãˆãŸã¨ãŸã‚“ã«ã‚¢ãƒƒã¨ã„ã†é–“ã«ãƒ¡ãƒ¢ãƒªä¸è¶³ã«ãªã£ã¦ã—ã¾ã†ã‹ã‚‰ã§ã™ã€‚ in
at_home 2012/12/26
ã“ã‚Œã¯è‰¯ãã¾ã¨ã¾ã£ã¦ã‚‹

InnoDB

ãƒ¡ãƒ¢ãƒª

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

tips

mysql

db

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

performance

database

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹
ãƒªãƒ³ã‚¯
IBM Developer
IBM Developer is your one-stop location for getting hands-on training and learning in-demand skills on relevant techno logies such as generative AI, data science, AI, and open source.
at_home 2012/11/21
PHPã§ãƒ¡ãƒ¢ãƒªç®¡ç†

php

windows

performance

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

ãƒ¡ãƒ¢ãƒª

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

OS

ãƒ¡ãƒ¢ãƒªç®¡ç†

tips
ãƒªãƒ³ã‚¯
BirdLab | phpç ”ç©¶æ‰€
åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:02) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:01) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:01) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:41:00) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:59) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:58) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:57) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:56) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:56) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:55) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:54) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-05-04 22:40:53) åå‰ : ã‚³ãƒ¡ãƒ³ãƒˆ (2023-
at_home 2012/02/06
MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è©±ã€‚

ãƒ¡ãƒ¢ãƒª

system

ä»®æƒ³

mysql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL :: MySQL 8.0 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 13.8.2 EXPLAIN ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
SAVEPOINTã€ROLLBACK TO SAVEPOINT ãŠã‚ˆã³ RELEASE SAVEPOINT ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆ
at_home 2010/12/07
mysql

SQL

ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«

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

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

å…¬å¼

SQLåˆ†æž

index

db
ãƒªãƒ³ã‚¯
Oracleã®æ©Ÿèƒ½ã‚’ä½¿ã£ã¦è¡¨ã®çµåˆã‚’é«˜é€ŸåŒ–ã™ã‚‹ï¼ˆ1/4ï¼‰ ï¼ ï¼ IT
æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã€Œè¡¨ã®çµåˆã‚’æ¥µã‚ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€ã§ã¯ã€çµžã‚Šè¾¼ã¿æ¡ä»¶ãŒãªã„çµåˆã‚’å«ã‚€SQLã€çµžã‚Šè¾¼ã¿æ¡ä»¶ã®ã‚ã‚‹çµåˆã‚’å«ã‚€SQLã«ã¤ã„ã¦å®Ÿä¾‹ã‚’åŸºã«æœ€é©ãªçµåˆæ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€Oracleã®æ©Ÿèƒ½ã§ã‚ã‚‹ã€Œãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã€ã€ŒBIT MAP JOIN INDEXã€ã€Œã‚¯ãƒ©ã‚¹ã‚¿ã€ã‚’åˆ©ç”¨ã—ãŸçµåˆå‡¦ç†ã«é–¢ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ç†è§£ã™ã‚‹ çµåˆå‡¦ç†ãª
at_home 2010/06/08
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

Oracle

SQL

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
MySQL :: MySQL 5.6 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 8.9.3.3 ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ§‹æˆ
have_query_cache ã‚µãƒ¼ãƒãƒ¼ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¯ã€ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒä½¿ç”¨ã§ãã‚‹ã‹ã©ã†ã‹ã‚’ç¤ºã—ã¾ã™ã€‚ mysql> SHOW VARIABLES LIKE 'have_query_cache'; +------------------+-------+ | Variable_name | Value | +------------------+-------+ | have_query_cache | YES | +------------------+-------+ æ¨™æº– MySQL ãƒã‚¤ãƒŠãƒªã‚’ä½¿ç”¨ã—ã¦ã„ã‚‹å ´åˆã€ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒç„¡åŠ¹ã«ã•ã‚Œã¦ã„ã‚‹å ´åˆã§ã‚‚ã€ã“ã®å€¤ã¯å¸¸ã« YES ã§ã™ã€‚ ã»ã‹ã®ã„ãã¤ã‹ã®ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¯ã€ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥æ“ä½œã‚’åˆ¶å¾¡ã—ã¾ã™ã€‚ã“ã‚Œã‚‰ã¯ã€mysqld ã®èµ·å‹•æ™‚ã«ã€ã‚ªãƒ—ã‚·ãƒ§ãƒ³ãƒ•ã‚¡ã‚¤ãƒ«ã‚„ã‚³ãƒžãƒ³ãƒ‰è¡Œã§è¨å®šã§ãã¾ã™ã€‚ã‚¯ã‚¨ãƒªãƒ¼ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚·ã‚¹ãƒ†ãƒ å¤‰æ•°ã¯ã™ã¹ã¦ã€qu
at_home 2010/06/07
mysql

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

db

è¨å®š
ãƒªãƒ³ã‚¯
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã®ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«ã¤ã„ã¦
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚·ã‚¹ãƒ†ãƒ (OSS iPedia) ã¯ã€2013å¹´5æœˆ17æ—¥(é‡‘) ã‚’ã‚‚ã¡ã¾ã—ã¦é‹ç”¨ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ é•·ã„é–“ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ OSS iPediaã§æä¾›ã—ã¦ãŠã‚Šã¾ã—ãŸã€IPA ãƒ•ã‚©ãƒ³ãƒˆã€æ–‡å—æƒ…å ±åŸºç›¤ã€ãã®ä»–å ±å‘Šæ›¸ç‰ã«ã¤ã„ã¦ã¯ã€ä¸‹è¨˜ãƒªãƒ³ã‚¯ã‚’ã”å‚ç…§ãã ã•ã„ã€‚ çš†æ§˜ã«ã¯å¤§å¤‰ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ãŒã€ä½•å’ã”ç†è§£ã®ç¨‹ã‚’ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚
at_home 2010/06/03
mysql

tips

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

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

SQL
ãƒªãƒ³ã‚¯
Kazuho@Cybozu Labs: MySQL ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’çµ±è¨ˆçš„ã«ç›£è¦–ãƒ»è§£æžã™ã‚‹æ–¹æ³•
MySQL ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨è¨€ã£ãŸå ´åˆã«ã¯ã€ã‚µãƒ¼ãƒãƒ¼ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®èª¿æ•´ã‚„ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’åˆ©ç”¨ã—ãŸã‚¯ã‚¨ãƒªå®Ÿè¡Œè¨ˆç”»ã®æœ€é©åŒ–ãŒè©±é¡Œã«ä¸Šã‚‹ã“ã¨ãŒå¤šã„ã§ã™ã€‚ã—ã‹ã—ã€ç™ºè¡Œã™ã‚‹å…¨ã¦ã® SQL ã«ã¤ã„ã¦ã€ã„ã¡ã„ã¡ EXPLAIN ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ç¢ºèªã—ã¦ã„ã¦ã¯ã€ã„ãã‚‰æ™‚é–“ãŒã‚ã£ã¦ã‚‚ãŸã‚Šã¾ã›ã‚“ã€‚ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’åŠ¹çŽ‡çš„ã«é€²ã‚ã‚‹ã«ã¯ã€ã¾ãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã£ã¦ã„ã‚‹ SQL ã‚¯ã‚¨ãƒªã‚’ç‰¹å®šã—ã€æ¬¡ã«ãã®æœ€é©åŒ–ã‚’è¡Œã†ã¹ãã§ã™ã€‚ ã§ã¯ã©ã®ã‚ˆã†ã«ã—ã¦ã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’ç‰¹å®šã™ã‚‹ã®ã‹ã€‚MySQL Conference & Expo 2009 ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ Mark Callaghan æ°ã¯ã€Google ã§ã¯ SHOW PROCESSLIST ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ãŸçµ±è¨ˆçš„ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’ä½¿ã£ã¦ã„ã‚‹ã¨è¿°ã¹ã¦ã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ (å‚ç…§: MySQLConf 09: Mark Callaghan, "This is Not a
at_home 2010/04/23
mysql

ã‚³ãƒžãƒ³ãƒ‰

SQL

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

db

performance
ãƒªãƒ³ã‚¯
ï¼¯ï¼²ï¼¡ï¼£ï¼¬ï¼¥ï¼ã‚ªãƒ©ã‚¯ãƒ«ï¼³ï¼±ï¼¬ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼ˆãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼‰
ã‚¹ãƒãƒ³ã‚µãƒ¼ãƒ‰ã€€ãƒªãƒ³ã‚¯ â—ã€€åˆ—ç•ªå·ã¯ä½¿ç”¨ã—ãªã„ ORDER BYå¥ã«åˆ—ç•ªå·ã§æŒ‡å®šã—ãŸå ´åˆã€ï¼³ï¼±ï¼¬è§£æžæ™‚ã«èªã¿æ›¿ãˆå‡¦ç†ãŒç™ºç”Ÿã™ã‚‹ã®ã§ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ä½Žä¸‹ã«ç¹‹ãŒã‚‹ â—‹ select a.emp_id, a.emp_name from emp a order by salary; Ã— select a.emp_id, a.emp_name from emp a order by 5; â—ã€€DISTINCTå¥ã‚ˆã‚ŠEXISTSå¥ã®ä½¿ç”¨ã‚’æ¤œè¨Žã™ã‚‹ DISTINCTã¯ã€æ¡ä»¶ã«ä¸€è‡´ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–ã‚Šå‡ºã—æš—é»™ã®ã‚½ãƒ¼ãƒˆå‡¦ç†å¾Œã«é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æŽ’é™¤ã™ã‚‹ã“ã¨ã«å¯¾ã—ã€EXISTSå¥ã¯æ¡ä»¶ã«ä¸€è‡´ã™ã‚‹ãƒ¬ã‚³ãƒ¼ãƒ‰ï¼‘ä»¶ã§ã‚‚ã‚ã‚Œã°ãã“ã§å‡¦ç†ã¯çµ‚äº†ã™ã‚‹ç‚ºã€æš—é»™ã®ã‚½ãƒ¼ãƒˆå‡¦ç†ã‚’ã—ãªã„åˆ†ã€DISTINCTã«æ¯”ã¹ã‚‹ã¨è² è·ãŒå°ã•ããªã‚‹ Ã— select distinct a.emp_id, a.dept_id from emp a,dept b
at_home 2009/12/08
ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

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

oracle

sql
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬1å›žï¼špostgresql.confã«ã‚ˆã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
PostgreSQLã«é™ã‚‰ãšã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚½ãƒ•ãƒˆã¯å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã®ã§ã€å ´åˆã«ã‚ˆã£ã¦ã¯å‡¦ç†ã«ã‹ãªã‚Šæ™‚é–“ãŒã‹ã‹ã‚‹ã“ã¨ã‚‚ã‚ã‚Šã¾ã™ã€‚ãã®ãŸã‚ã€ã§ãã‚‹ã ã‘å‡¦ç†æ™‚é–“ã‚’çŸç¸®ã—ã€å‡¦ç†åŠ¹çŽ‡ã‚’å‘ä¸Šã™ã‚‹ã€Œãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã€ã¨ã„ã†æŠ€è¡“ãŒé‡è¦–ã•ã‚Œã¦ã„ã¾ã™ã€‚ Webã‚·ã‚¹ãƒ†ãƒ ã®ã‚ˆã†ã«æ•°å¤šãã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’åŒæ™‚ã“ãªã•ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€å€‹ã€…ã®å•ã„åˆã‚ã›ã®å‡¦ç†æ™‚é–“ã¯æ•°ç™¾ãƒŸãƒªç§’ã¨çŸãã¦ã‚‚ã€å…¨ä½“ã®å‡¦ç†æ™‚é–“ãŒè†¨å¤§ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚ˆã†ãªã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã€1ã¤1ã¤ã®å‡¦ç†æ™‚é–“ã‚’ã§ãã‚‹ã ã‘çŸãã™ã‚‹ã“ã¨ãŒé‡è¦ã§ã™ã€‚ ã¾ãŸã€ã€Œãƒãƒƒãƒå‡¦ç†ã€ã«ãŠã„ã¦ã‚‚å‡¦ç†æ™‚é–“ã®çŸç¸®ã¯é‡è¦ã§ã™ã€‚ãƒãƒƒãƒå‡¦ç†ã¨ã¯ã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¨å¯¾è©±çš„ã«è¡Œã‚ã‚Œã‚‹å‡¦ç†ã§ã¯ãªãã€è‡ªå‹•çš„ã«å®Ÿè¡Œã•ã‚Œã‚‹å‡¦ç†ã§ã™ï¼ˆå¤šãã®å ´åˆã€äººæ‰‹ã‚’ä»‹ã™ã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ï¼‰ã€‚ãŸã¨ãˆã°1æ—¥ã®ãƒ‡ãƒ¼ã‚¿ã‚’å¤œé–“ã«ã¾ã¨ã‚ã‚‹ã€Œæ—¥æ¬¡å‡¦ç†ã€ãªã©ãŒã“ã‚Œã«è©²å½“ã—ã¾ã™ã€‚æ—¥æ™‚å‡¦ç†ãŒæ±ºã‚ã‚‰ã‚ŒãŸæ™‚é–“å†…ã«çµ‚ã‚ã‚‰ãªã‘ã‚Œã°ã€å‡¦ç†è‡ªä½“ãŒç„¡æ„
at_home 2009/03/19
DB

postgresql

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
1