[B! tuning] amayanã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

amayan id:amayan

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

ã‚¢ãƒ¡ãƒ–ãƒã®ä¸ã®äººãŒæ›¸ã„ãŸMySQLã®æœ¬ - blog.nomadscafe.jp
100å„„PVã¨ã„ã†ã“ã¨ã§è©±é¡Œã«ãªã£ãŸã‚¢ãƒ¡ãƒ–ãƒã®MySQLã®æœ¬ãŒå‡ºãŸã®ã§è²·ã„ã¾ã—ãŸã€‚ PVã¨ã„ã†è¨€è‘‰ã¯å®šç¾©ã«ã‚ˆã£ã¦ã„ã‚ã„ã‚å¤‰ã‚‹ã®ã§ã‚ã‚Œã§ã™ãŒã€ã‚µãƒ¼ãƒã§100å„„ãƒªã‚¯ã‚¨ã‚¹ãƒˆã‚’å‡¦ç†ã—ã¦ã„ã‚‹ã¨è€ƒãˆã‚‹ã¨ã‚„ã¯ã‚Šå¤§è¦æ¨¡ãªã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã¨æ„Ÿã˜ã¾ã™ã€‚ æœˆé–“100å„„ã‚’ç§’ã«ç›´ã™ã¨ã€ 10,000,000,000 / ( 3600 * 24 * 30 ) = 3,858.02469 å¤§ä½“4,000å¼±ã€‚ãƒ”ãƒ¼ã‚¯ã‚¿ã‚¤ãƒ ã§ã¯ã“ã®å€ãã‚‰ã„ã«ãªã‚‹ã§ã—ã‚‡ã†ã€‚ æœ¬ã®å†…å®¹ã¯ã€MySQLã®åŸºæœ¬çš„ãªä½¿ã„æ–¹ã«åŠ ãˆã¦ã€ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã«é©ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®è¨è¨ˆã€é‹ç”¨ã«å¿…è¦ãªç›£è¦–ã‚„ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦ã‚‚ä¸å¯§ã«è§£èª¬ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç‰¹ã«ç›£è¦–ã‚„è² è·ãƒ»éšœå®³å¯¾ç–ã¯å®Ÿéš›ç¾å ´ã§çµŒé¨“ã‚’ã•ã‚ŒãŸäººã®çŸ¥è˜ãŒè©°ã¾ã£ã¦ã„ã¦è‰¯ã„æ„Ÿã˜ã§ã™ã€‚ ä¸€ã¤æ°—ã«ãªã£ãŸã®ã¯ã€MySQL 4.1ã€MyISAMã‚’å¤šãåˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã¨ã“ã‚ã§ã™ã€‚ P4ã®ã‚³ãƒ©ãƒ ã§è§¦
amayan 2009/10/12
ameba

mysql

tuning
ãƒªãƒ³ã‚¯
IMJãƒ¢ãƒã‚¤ãƒ«ï¼ˆã‚¢ã‚¤ã‚¨ãƒ ã‚¸ã‚§ã‚¤ãƒ¢ãƒã‚¤ãƒ«ï¼‰CTO blog:MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãã®ï¼‘ï¼
amayan 2009/08/17
mysql

tuning

performance
ãƒªãƒ³ã‚¯
InnoDB Plugin ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åœ§ç¸®æ©Ÿèƒ½ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒ 1/10 ã«ãªã£ã¦ã‚¢ã‚¯ã‚»ã‚¹é€Ÿåº¦ã‚‚å¤§å¹…æ”¹å–„ã‹ã€‚å®Ÿãƒ‡ãƒ¼ã‚¿ã§ã“ã‚Œã¯ã™ã”ã„ãª *1ã€‚ Iâ€™ve tried to convert this table using COMPRESSED row format. This time conversion took 1,5 hours and results were really surprising: Only 5Gb data file (from 60Gb) ~5% I/O load according to iostat (from 99%) ~5% CPU load according to top (from 80-100% mostly waiting for I/O) 0.01 sec average lookup time by primary key (from 1-20 sec before the conve
amayan 2009/08/17
innodb

mysql

tuning

performance
ãƒªãƒ³ã‚¯
firefox 3ãŒé…ããªã£ãŸâ†’ SQLite reindexã§è§£æ±ºï¼†é«˜é€ŸåŒ– - ã—ãŠãã‚‹ã¨
Firefox 3ã‚’ä½¿ã£ã¦ã„ã¦ã€èµ·å‹•ãŒç•°æ§˜ã«é…ããªã£ã¦ã„ã¦å›°ã£ã¦ã„ã¾ã—ãŸã€‚ ä»Šå›žã€ã©ã†ã‚„ã‚‰è§£æ±ºã—ãŸæ¨¡æ§˜ãªã®ã§å‚™å¿˜éŒ²ã¾ã§ã«è¨˜è¼‰ã—ã¾ã™ã€‚ Firefox 3ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ã—ã¦ã‹ã‚‰ã€ãƒ¡ã‚¤ãƒ³ã§åˆ©ç”¨ã—ã¦ã„ã‚‹PCã§ Firefox ã®èµ·å‹•ãŒé…ãã¦ä»•æ–¹ãŒãªã„ã€ipv6æ¤œç´¢ã‚’ç„¡åŠ¹ã«ã™ã‚‹ã¨ã‹è©¦ã—ã¦ã¿ãŸã‘ã©ã‚‚ã‹ã‚ãšã€ã¨ã„ã†çŠ¶æ…‹ã§ã—ãŸã€‚ ã ã„ãŸã„åŒã˜Add-onã‚’ ä»–ã®PCã«ã‚‚å…¥ã‚Œã¦åˆ©ç”¨ã—ã¦ã„ã¾ã™ãŒã€ãã¡ã‚‰ã¯ã¯ãã†é…ãã¯ãªã„ã®ã§ã€ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«ç³»ã‹ã‚ã€ã¾ã§ã¯åˆ‡ã‚Šåˆ†ã‘ã—ã¦ãã®ã¾ã¾åˆ©ç”¨ã—ã¦ãŠã‚Šã¾ã—ãŸã€‚ ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒ«å†ä½œæˆã€é¢å€’ã§ã™ã—ãã€‚ ã§ã€ãµã¨æ€ã„ç«‹ã£ã¦ Firefox 3 ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ã€SQLite ãƒ‡ãƒ¼ã‚¿ç¾¤ã‚’ã‹ãŸã£ã±ã—ã‹ã‚‰ Reindex ã—ãŸã‚‰ã€ æ˜”ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒå†ç¾ã—ã¾ã—ãŸã€‚ã¯ã‚„ã„ï¼ æ”¹å–„ï¼šï¼’ã¤ ï¼‘ï¼‰èµ·å‹•ãŒé€Ÿããªã£ãŸï¼ˆèµ·å‹•ã«1-2åˆ†ã‹ã‹ã‚‹â†’ã™ãèµ·å‹•ã€‚åŠ‡çš„ã«æ”¹å–„ã€‚ï¼‰ ï¼’ï¼‰ã‚µã‚¤ãƒˆè¡¨ç¤ºã‚‚ã¯ã‚„ã„ã€‚ cookie
amayan 2009/05/12
firefox

tuning

sqlite reindex

sqlite
ãƒªãƒ³ã‚¯
[Perl] Encode Jcode UnicodeJapanese ã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯æ¯”è¼ƒ isoya9ã®æ—¥è¨˜-ã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°
ã€Œã‚¦ã‚§ãƒ–ãƒªãƒ–ãƒã‚°ã€ã¯ 2023å¹´1æœˆ31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹æä¾›ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3æœˆã®ã‚µãƒ¼ãƒ“ã‚¹é–‹å§‹ã‚ˆã‚Š19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”æ„›ç”¨ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’å¿ƒã‚ˆã‚ŠãŠç¤¼ç”³ã—ä¸Šã’ã¾ã™ã€‚ä»Šå¾Œã¨ã‚‚ã€BIGLOBEã‚’ã”æ„›é¡§è³œã‚Šã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ç”³ã—ä¸Šã’ã¾ã™ã€‚ â€»å¼•ã£è¶Šã—å…ˆãƒ–ãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“ã‚¹ã¯2024å¹´1æœˆ31æ—¥ã§çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ã‚¹ä¸€è¦§
amayan 2008/02/23
perl

tuning

bookmark
ãƒªãƒ³ã‚¯
OutOfMemoryã‚¨ãƒ©ãƒ¼ç™ºç”Ÿ!? GCãŒã‚ã‚‹ã®ã«ã€ãªãœï¼Ÿ
ä»Šå›žã®æ¦‚è¦ æœ¬ç¨¿ã§ã¯Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§å®Ÿéš›ã«ç›´é¢ã—ãŸãƒ¡ãƒ¢ãƒªã«é–¢ã™ã‚‹ãƒˆãƒ©ãƒ–ãƒ«äº‹ä¾‹ã®ä¸ã‹ã‚‰java.lang.OutOfMemoryErrorã‚’é¡Œæã¨ã—ãŸTipsã‚’ç´¹ä»‹ã™ã‚‹ã€‚ å¸°å®…ç›´å‰ã«ã€çªç„¶é›»è©±ãŒé³´ã‚ŠéŸ¿ã æ¥å‹™ã‚’çµ‚ãˆã¦å¸°å®…ã—ã‚ˆã†ã¨ã—ãŸã¨ã‚ã‚‹å¤œã€çªç„¶é›»è©±ãŒé³´ã‚‹ã€‚ç›¸æ‰‹ã¯ç¤¾å†…ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®ãƒžãƒãƒ¼ã‚¸ãƒ£ã§ã‚ã‚‹ã€‚ ã€Œç¾åœ¨ã€ãƒ†ã‚¹ãƒˆã‚’å®Ÿæ–½ã—ã¦ã„ã‚‹ãŒã€æ•°åˆ†çµŒã¤ã¨OutOfMemoryErrorãŒç™ºç”Ÿã—ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒè½ã¡ã¦ã—ã¾ã†ã€‚å†èµ·å‹•ã‚’æŽ›ã‘ã‚‹ã¨ã€ã¾ãŸé †èª¿ã«å‹•ããŒã€ã—ã°ã‚‰ãåˆ©ç”¨ã—ã¦ã„ã‚‹ã¨ã€åŒã˜ã‚ˆã†ã«OutOfMemoryErrorãŒç™ºç”Ÿã™ã‚‹ã€‚ãƒ¡ãƒ¢ãƒªä¸è¶³ã®ã‚¨ãƒ©ãƒ¼ãªã®ã§ã€ç‰©ç†ãƒ¡ãƒ¢ãƒªã‚’å¢—ã‚„ãã†ã‹ã¨æ€ã£ã¦ã„ã‚‹ãŒã€ç‰©ç†ãƒ¡ãƒ¢ãƒªå¢—è¨ã®å‰ã«ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¨ã„ã†è¦³ç‚¹ã‹ã‚‰ãƒ¡ãƒ¢ãƒªä¸è¶³ã‚’å¼•ãèµ·ã“ã™å•é¡ŒãŒãªã„ã‹èª¿æŸ»ã—ã¦ã»ã—ã„ã€ å–ã‚Šã‚ãˆãšã€åŽŸå› ã‚’æŽ¢ã‚‹ãŸã‚ã«ç¾å ´ã«æ€¥è¡Œã—ãŸã€‚ ç¾å ´ã«ã¦ãƒˆãƒ©ãƒ–ãƒ«ã®è©³ç´°ã‚’ãƒ’ã‚¢
amayan 2007/07/27
ã‚ã¨ã§èªã‚€

development

gc

performance

programming

tuning

java
ãƒªãƒ³ã‚¯
naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼ - è² è·ã¨ã¯ä½•ã‹
èª¿ã¹ã”ã¨ã‚’ã—ãŸã®ã§ blog ã«æ›¸ã„ã¦ç†è§£ã‚’æ·±ã‚ã‚ˆã†ã®ã‚³ãƒ¼ãƒŠãƒ¼ã§ã™ã€‚é•·æ–‡ã§ã™ã€‚ Linux ã§ã‚·ã‚¹ãƒ†ãƒ è² è·ã‚’è¦‹ã‚‹å ´åˆã«ãŠä¸–è©±ã«ãªã‚‹ã®ãŒ top ã‚„ sar (sysstat ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«åŒæ¢±ã•ã‚Œã¦ã‚‹ã‚³ãƒžãƒ³ãƒ‰) ãªã©ã®ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ top ã§ã¯ã‚·ã‚¹ãƒ†ãƒ çµ±è¨ˆã®ã‚¹ãƒŠãƒƒãƒ—ã‚·ãƒ§ãƒƒãƒˆã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ä»Šã‚·ã‚¹ãƒ†ãƒ ãŒã©ã†ã„ã†çŠ¶æ…‹ã‹ãªãƒ¼ã¨ã„ã†ã¨ãã¯ top ãŒä¾¿åˆ©ã€‚ top - 08:16:54 up 3 days, 14:43, 6 users, load average: 0.18, 0.07, 0.03 Tasks: 43 total, 2 running, 41 sleeping, 0 stopped, 0 zombie Cpu(s): 18.2% us, 0.0% sy, 0.0% ni, 81.8% id, 0.0% wa, 0.0% hi, 0.0% siä¸€æ–¹ã® sar ã§ã¯10åˆ†ã”ã¨ã®ã‚·
amayan 2007/02/23
naoya

linux

kernel

server

performance

è² è·å¯¾ç–

è² è·åˆ†æ•£

tips

tuning
ãƒªãƒ³ã‚¯
1