[B! æœ€é©åŒ–] tiadeen2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

tiadeen2 id:tiadeen2

æœ€é©åŒ–ã«é–¢ã™ã‚‹tiadeen2ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

(å¸°ã£ã¦ããŸ)InnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Ž | Yakst
MySQL Performance Blogã®ç¿»è¨³ã€‚Perconaã®ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã‚ã‚‹ç†è€…ãŒã€InnoDBã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®åŸºç¤Žã«ã¤ã„ã¦ã€ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã‚„OSã®é¸å®šã‹ã‚‰ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®æŽ¨å¥¨å€¤ã¾ã§è§£èª¬ã™ã‚‹ã€‚ æœ€è¿‘ã€2007å¹´ã«Peter ZaitevãŒæ›¸ã„ãŸã€ŒInnoDBãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹æœ€é©åŒ–ã®åŸºç¤Žã€ã¨ã„ã†è¨˜äº‹ã‚’è¦‹ã¤ã‘ãŸã€‚ã“ã‚Œã¯ç´ æ™´ã‚‰ã—ã„è¨˜äº‹ã§ã€èªã‚“ã§ã„ã‚‹ã¨ã€MySQLã¨Percona Serversãã—ã¦ä»Šæ—¥åˆ©ç”¨å¯èƒ½ãªå…¨ã¦ã®åŸºç›¤æŠ€è¡“ã«é–¢ã—ã¦ã€6å¹´è¿‘ãã®é–“ã«ä½•ãŒå¤‰ã‚ã£ã¦ããŸã®ã‹ã‚’è¦‹ç›´ã—ã¦ã¿ãŸã„ã¨æ€ã‚ã›ã‚‹ã‚‚ã®ã ã€‚ æœ¬å½“ã«ãŸãã•ã‚“ã®ã“ã¨ãŒå¤‰ã‚ã£ãŸã‚‚ã®ã ï¼ã“ã®è¨˜äº‹ã§ã¯ã€InnoDBã®ä½¿ç”¨ã«åŠ¹æžœçš„ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®å¤šãã«ã€ç‰¹ã«ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®è¦³ç‚¹ã‹ã‚‰ç„¦ç‚¹ã‚’å½“ã¦ã‚‹ã€‚ç§ã¯ã‚µãƒãƒ¼ãƒˆã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã§ã€Percona Supportã§ã¯InnoDBãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®é©åˆ‡ãªã‚µã‚¤ã‚ºã«é–¢ã™ã‚‹è³ªå•ãŒãŸãã•ã‚“å¯„ã›ã‚‰ã‚Œã¦ã„ã‚‹
tiadeen2 2013/10/03
mysql

innodb

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³å‘ã‘Webã‚µã‚¤ãƒˆã®è¡¨ç¤ºé€Ÿåº¦ é«˜é€ŸåŒ–æ‰‹æ³•
å¯¾è±¡èªè€… ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³Webã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºè€… ç‰¹ã«ã€ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰å‘¨ã‚Šã®é–‹ç™ºã«å¾“äº‹ã™ã‚‹æ–¹ ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³å‘ã‘Webã‚µã‚¤ãƒˆé«˜é€ŸåŒ–ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã¯OSï¼ãƒ‡ãƒã‚¤ã‚¹ã®é€²åŒ–ãŒæ¿€ã—ãã€è¦æ±‚ã•ã‚Œã‚‹æœ€é©åŒ–ã®å†…å®¹ã‚‚åŠå¹´ã§åˆ¥ç‰©ã«ãªã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãã®ãŸã‚æœ€é©åŒ–ã«éš›ã—ã¦ã¯ã€æ¡ˆä»¶ã”ã¨ã®çŠ¶æ³ã‚„ç›®çš„ã€ãƒ‡ãƒã‚¤ã‚¹ï¼OSã®ã‚·ã‚§ã‚¢ã«å¿œã˜ã¦ã€ã¾ãšã‚¿ãƒ¼ã‚²ãƒƒãƒˆç«¯æœ«ã‚’é¸å®šã—ã€å•é¡Œã®æ¤œå‡ºã‚’è¡Œã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã§ã¯ã€ŒiPhone 4ï¼‹iOS 5ã€ã‚’æƒ³å®šã—ã¦è©±ã‚’é€²ã‚ã¾ã™ã€‚å®Ÿéš›ã«ã€ŒiPhone 4ï¼‹iOS 5ã€ã¯ã‚ˆãç¾å ´ã§ã‚‚æœ€ã‚‚å‹•ä½œãŒé‡ã„çµ„ã¿åˆã‚ã›ã¨ã—ã¦ã‚¿ãƒ¼ã‚²ãƒƒãƒˆç«¯æœ«ã«æŒ™ãŒã‚Šã¾ã™ã€‚ã“ã‚Œã¯iPhone 4ãŒRetinaãƒ‡ã‚£ã‚¹ãƒ—ãƒ¬ã‚¤ã‚’æŽ¡ç”¨ã—ãŸã“ã¨ã§960Ã—460ãƒ”ã‚¯ã‚»ãƒ«ã®é«˜è§£åƒåº¦ã‚’å‚™ãˆãªãŒã‚‰ã€CPUãªã©ã®ãƒ‡ãƒã‚¤ã‚¹æ€§èƒ½ãŒæ½¤æ²¢ã¨ã¯ã„ãˆãšã€ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ãŒç”Ÿã¾ã‚Œã‚„ã™ã„ãŸã‚ã§ã™ã€‚iOS 4ã§ã¯ãªãiOS 5ã‚’ã‚¿ãƒ¼ã‚²ãƒƒãƒˆç«¯æœ«ã¨ã—ã¦æ‰±ã†ã®ã¯ã€
tiadeen2 2012/11/10
javascript

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

æœ€é©åŒ–

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
Movable Typeã‚’ã‚ã£ã¡ã‚ƒé«˜é€ŸåŒ–ã™ã‚‹20ã®æ–¹æ³•ã€‚ | Junnama Online
Movable Typeã‚’ã‚ã£ã¡ã‚ƒé«˜é€ŸåŒ–ã™ã‚‹20ã®æ–¹æ³•ã€‚ å…¬é–‹æ—¥ : 2007-07-06 12:41:08 ã„ã¤ã‹ã¡ã‚ƒã‚“ã¨æ›¸ã“ã†ã¨æ€ã£ã¦ã„ãŸã€‚ ã“ã†ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã®Entryã‚’Må›žä»¥ä¸Šã‹ãã¨ãƒ–ãƒã‚°ãŒã¤ã¾ã‚‰ãªããªã‚‹ã‚‰ã—ã„ã®ã ãŒã€ã¾ãã„ã„ã‚„ã€‚å•é¡Œã¯ä¸èº«ã ã‚ˆã€‚ ã“ã“ã§è¨€ã†ã€Œé«˜é€ŸåŒ–ã€ã¨ã¯ã€CMSã‚’æ“ä½œã—ã¦ã„ã‚‹ç™ºä¿¡è€…å´ã€ãƒ–ãƒã‚°ã‚’è¨ªã‚Œã‚‹è¨ªå•è€…å´åŒæ–¹ã‚’å¯¾è±¡ã«ã—ã¦ã„ã‚‹ã€‚å…¨ã¦ãŒå…¨ã¦ã©ã‚“ãªç’°å¢ƒã§ã‚‚å‡ºæ¥ã‚‹ã¨ã¯é™ã‚‰ãªã„ãŒ(ç‰¹ã«ã‚µãƒ¼ãƒãƒ¼ã«å¯¾ã™ã‚‹æ¨©é™ã®å•é¡Œã§å‡ºæ¥ãªã„éƒ¨åˆ†ã‚‚äººã«ã‚ˆã£ã¦ã¯ã‚ã‚‹ã‹ã‚‚ã—ã‚Œãªã„ãŒ)ä½•ã—ã‚20ã‚‚ã‚ã‚‹ã‹ã‚‰1ã¤ã‚„2ã¤ã¯èª°ã«ã ã£ã¦å‡ºæ¥ã‚‹ã ã‚ã†ã€‚ ç’°å¢ƒã¾ã‚ã‚Šã€‚ 1.ãƒãƒ¼ãƒ‰ã‚¦ã‚§ã‚¢ã®ã‚¹ãƒšãƒƒã‚¯ã‚’ä¸Šã’ã‚‹ã€‚ å½“ãŸã‚Šå‰ã®ã“ã¨ã ã‘ã©ã€ãƒ¡ãƒ¢ãƒªã‚’å¢—ã‚„ã™ã€é«˜é€ŸãªHDDã«å…¥ã‚Œæ›¿ãˆã‚‹ã€ã‚ã‚‹ã„ã¯ã‚µãƒ¼ãƒãƒ¼è‡ªä½“ã‚’å¤‰ãˆã‚‹ã€‚ ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãƒ¼ã¨ã‹ã ã£ãŸã‚‰ãƒ—ãƒ©ãƒ³ã‚’å¤‰æ›´ã™ã‚‹ã€‚ é‡‘ã‹ã‘ãŸããªã„? ã¨ã¯ã„ãˆãƒ¡ãƒ¢ãƒªãƒ¼ã‚‚HDDã‚‚æ˜”ã¨æ¯”ã¹ãŸã‚‰å®‰ã„ã‚‚ã®ã
tiadeen2 2009/01/08
ã¾ã¨ã‚

æœ€é©åŒ–

movabletype
ãƒªãƒ³ã‚¯
PHPã‚³ãƒ¼ãƒ‰æœ€é©åŒ–Tipsã®ã‚¦ã‚½ã¨æœ¬å½“(è§£èª¬) - ã‚«ã‚¿ã‚³ãƒˆæ—¥è¨˜
PHP ã‚³ãƒ¼ãƒ‰æœ€é©åŒ– Best Practices 63+ - ã‚«ã‚¿ã‚³ãƒˆæ—¥è¨˜ å‰å›žã¯ã€å…ƒè¨˜äº‹ã«ä¸€å®šã®æ•¬æ„ã‚’è¡¨ã—ã¦ã€é …ç›®ã¨ã‹ã¯ã‚ãˆã¦ãã®ã¾ã¾ã«ã—ã¦ãŸã‚“ã§ã™ãŒã€ è‡ªåˆ†ã¨ã—ã¦ã‚‚æ°—ã«ãªã‚‹éƒ¨åˆ†ãŒå¤šã€…ã‚ã£ãŸã®ã§ã€å°‘ã—ã ã‘èª¿ã¹ç›´ã—ã¦å„ªå…ˆåº¦ï¼†è§£èª¬ã¤ã‘ã¾ã—ãŸã€‚ ç‹¬æ–ã¨åè¦‹ã§ã™ãŒã€‚ãƒ½(Â´ãƒ¼ï½€)ãƒŽ æ¤œè¨¼ã¯ã—ã¦ã¾ã›ã‚“ã€‚ã”ã‚ã‚“ãªã•ã„ã”ã‚ã‚“ãªã•ã„ã€‚ å„ªå…ˆåº¦Aã€Bã€Cã€ä¸æ˜Žã€éžæŽ¨å¥¨ã«åˆ†ã‘ã¦ã¿ã¾ã—ãŸã€‚ã©ã†ãžã¤ã£ã“ã‚“ã§ãã ã•ã„ã€‚ é•·ã„ã‚ˆã€ä»Šå›žã¯ã€‚ å„ªå…ˆåº¦A. é »åº¦ã‚‚é«˜ã„ã—ä½¿ãˆãã† - 6ã¤ 01. static ã«ã§ãã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã¯ static ã¨ã—ã¦å®£è¨€ã—ã‚ˆã†ã€‚ï¼ˆ4å€é€Ÿã„ï¼‰ æ£ã—ãã¯ã€static ãªãƒ¡ã‚½ãƒƒãƒ‰ã«ã¯ã€OOP ã®ãƒ«ãƒ¼ãƒ«ã«å¾“ã£ã¦ã¡ã‚ƒã‚“ã¨ static å®£è¨€ã‚’ã¤ã‘ã‚ˆã†ï¼ ã£ã¦ã¨ã“ã§ã—ã‚‡ã†ã‹ã€‚æœ¬æ¥ãã†ã§ãªã„ã‚‚ã®ã‚’ç„¡ç†ã« static ã«ã—ã¡ã‚ƒãˆã£ã¦è©±ã§ã¯ãªã„ã¯ãšã€‚*1 Ã— <?php public function
tiadeen2 2008/05/27
æœ€é©åŒ–

PHP

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
PostgreSQL ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¾ã¨ã‚ - å¾’ç„¶ãªã‚‹ã¾ã¾ã«Blog
PostgreSQLã‚’ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ ãã®æ™‚ã«èª¿ã¹ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°é …ç›®ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®é•ã„ã‚„ã‚µãƒ¼ãƒã®è¦æ¨¡ãªã©ã«ã‚ˆã£ã¦ã‚‚ åŠ¹æžœã¯å¤‰ã‚ã£ã¦ãã‚‹ã¨æ€ã†ã®ã§ã‚ãã¾ã§å‚è€ƒç¨‹åº¦ã®ã‚‚ã®ã§ã™ãŒã€‚ ãƒ»shared_buffers 7ç³»ã§ã¯8000ã€œ10000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ 8ç³»ã§ã¯150000ç¨‹åº¦ã¾ã§å¼•ãä¸Šã’ã‚‹ã“ã¨ãŒå¯èƒ½ã€100000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ã“ã‚Œã«å¤šãå‰²ã‚Šå½“ã¦ã‚‹ã‚ˆã‚ŠOSã®ãƒãƒƒãƒ•ã‚¡é ˜åŸŸã¨ã—ã¦ä½¿ã†æ–¹ãŒæ€§èƒ½ãŒå‘ä¸Šã™ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã‚µã‚¤ã‚ºã‚’å‰²ã‚Šå‡ºã—ã¦è¨å®šã™ã‚‹ã®ãŒãƒ™ã‚¹ãƒˆ ç°¡å˜ã«è¨å®šã™ã‚‹ãªã‚‰æè¼‰ãƒ¡ãƒ¢ãƒªé‡ã®1/4ã€æè¼‰ãƒ¡ãƒ¢ãƒªãŒå¤šã‘ã‚Œã°1/2ãã‚‰ã„ã§ã‚‚å¯ ãƒ»max_connections 7ç³»ã§ã¯256ç¨‹åº¦ã€8ç³»ã§ã¯1000ç¨‹åº¦ãŒæ€§èƒ½ã®ãƒ”ãƒ¼ã‚¯ ãƒ»work_mem(sort_mem) é©åˆ‡ãªã‚µã‚¤ã‚ºã«èª¿æ•´ã™ã‚‹ã€2048ã€œ4096ç¨‹åº¦ ãƒ—ãƒã‚»ã‚¹æ¯Ž
tiadeen2 2007/08/02
database

postgres

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

æœ€é©åŒ–
ãƒªãƒ³ã‚¯
1