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

uokada id:uokada

tuningã«é–¢ã™ã‚‹uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

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

ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ ï½žã€Œæ›¸ãã€ã«ã¤ã„ã¦ï½žï½œPostgreSQLã‚¤ãƒ³ã‚µã‚¤ãƒ‰
ä»Šå›žã®è¨˜äº‹ã¯ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è¦³ç‚¹ã¨ä»•çµ„ã¿ã‚’ç†è§£ã™ã‚‹ã“ã¨ã«ä¸»çœ¼ã‚’ç½®ã„ã¦ã„ã¾ã™ã€‚å…·ä½“çš„ãªå¯¾å‡¦æ–¹æ³•ã«ã¤ã„ã¦ã¯ã‚·ã‚¹ãƒ†ãƒ ã«ã‚ˆã£ã¦ç•°ãªã‚‹ãŸã‚ã€ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã®ç¢ºèªã‚„ã€å„ç¨®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã®ã”åˆ©ç”¨ã‚’ã”æ¤œè¨Žãã ã•ã„ã€‚ãªãŠã€ã“ã®è¨˜äº‹ã§å¯¾è±¡ã«ã—ã¦ã„ã‚‹PostgreSQLã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯9.5ä»¥é™ã§ã™ã€‚ æœ¬è¨˜äº‹ã®æ§‹æˆ æœ¬è¨˜äº‹ã€Œãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ã€ã¯ä»¥ä¸‹4ã¤ã®è¨˜äº‹ã‹ã‚‰æ§‹æˆã•ã‚Œã¦ã„ã¾ã™ã€‚ä»–ã®è¨˜äº‹ã‚‚ä½µã›ã¦ã”è¦§ãã ã•ã„ã€‚ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ ï½žã¯ã˜ã‚ã«ï½ž ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ ï½žã€Œæ›¸ãã€ã«ã¤ã„ã¦ï½žï¼ˆæœ¬è¨˜äº‹ï¼‰ ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ ï½žã€ŒæŽ¢ã—ã€ã«ã¤ã„ã¦ï½ž ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°9ã¤ã®æŠ€ ï½žã€ŒåŸºç›¤ã€ã«ã¤ã„ã¦ï½ž 1. ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ã€Œæ›¸ãã€ã¨ã¯ ä¸€èˆ¬çš„ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å¤§é‡ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã„ã€å¤§é‡ã®å•ã„åˆã‚ã›ã‚„æ›´æ–°ã‚’é«˜é€Ÿã«å‡¦ç†ã—ã€ã•ã‚‰ã«éšœå®³ç™ºç”Ÿ
uokada 2023/07/09
postgresql

performance

tuning
ãƒªãƒ³ã‚¯
Fate/Grand Orderã«ãŠã‘ã‚‹ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã¨è² è·è©¦é¨“.pdf
Copyright 2019 DELiGHTWORKS Inc. All Rights Reserved. Fate/Grand Orderã«ãŠã‘ã‚‹ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç§»è¡Œã¨è² è·è©¦é¨“ 2019å¹´6æœˆ14æ—¥ ä»Šäº• å®ˆç”Ÿ Copyright 2019 DELiGHTWORKS Inc. All Rights Reserved. è³‡æ–™ã¯å…¬é–‹äºˆå®šã§ã™ æœ¬ã‚»ãƒƒã‚·ãƒ§ãƒ³ã§ã¯ä»¥ä¸‹ã®å†…å®¹ã‚’ãŠè©±ã—ã¾ã™ AWS Database Migration Serviceã‚’ä½¿ã£ãŸå¤§è¦æ¨¡ãªDBç§»è¡Œäº‹ä¾‹ï¼ˆåž‚ç›´åˆ†å‰²â†’æ°´å¹³åˆ†å‰²ï¼‰ ç§»è¡Œå¾Œã«æƒ³å®šãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒã‘ã‚‹ã“ã¨ã‚’æ¤œè¨¼ã™ã‚‹ãŸã‚ã®è² è·è©¦é¨“æ‰‹æ³• å¼Šç¤¾ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãŒéŽåŽ»ã«2å›žã€DBç§»è¡Œã‚’ä¸»ãªãƒˆãƒ”ãƒƒã‚¯ã¨ã—ãŸè¬›æ¼”ã‚’è¡Œã£ã¦ã„ã¾ã™ ã®ã§ã“ã¡ã‚‰ã‚‚ã”å‚ç…§ãã ã•ã„ ã“ã‚Œã§æ€–ããªã„ï¼ï¼Ÿå¤§è¦æ¨¡ç’°å¢ƒã§ä½“é¨“ã™ã‚‹DBè² è·å¯¾ç–ï½žåž‚ç›´ã‹ã‚‰æ°´å¹³ã®å½¼æ–¹ã¸ï½ž /ç”² https://www.slideshare.n
uokada 2023/07/08
db

tuning
ãƒªãƒ³ã‚¯
JVMã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ITã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç”Ÿãã‚‹
å‰å›žã€JVMã¨GCã®ã—ãã¿ - IT ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦ç”Ÿãã‚‹ã§JVMã¨GCã®ã—ãã¿ã«ã¤ã„ã¦æ›¸ã„ãŸã€‚ ä»Šå›žã¯ãã®ç¶šãã¨ã„ã†ã“ã¨ã§JVMã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«ã¤ã„ã¦æ›¸ããŸã„ã¨æ€ã†ã€‚ JVMãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã£ã¦ -Xms ãƒ»ãƒ»ãƒ» ãƒ’ãƒ¼ãƒ—å…¨ä½“ï¼ˆNewé ˜åŸŸï¼‹Oldé ˜åŸŸï¼‰ã®åˆæœŸå€¤ -Xmx ãƒ»ãƒ»ãƒ» ãƒ’ãƒ¼ãƒ—å…¨ä½“ï¼ˆNewé ˜åŸŸï¼‹Oldé ˜åŸŸï¼‰ã®æœ€å¤§å€¤ ãã‚‰ã„ã—ã‹è©±é¡Œã«ä¸ŠãŒã‚‰ãªã„ã—æ„è˜ã—ãªã„ã“ã¨ãŒå¤šã„ï¼ˆæ°—ãŒã™ã‚‹ï¼‰ã€‚ ã§ã‚‚ãƒ›ãƒ³ãƒˆã¯ã“ã‚Œã ã‘ã§ã¯ãƒ€ãƒ¡ã§ã€å‰å›žã®ã‚ˆã†ã«Permanenté ˜åŸŸã€Newé ˜åŸŸã€Oldé ˜åŸŸã‚’æ„è˜ã—ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãŒå¿…è¦ã«ãªã‚‹ã€‚ VMãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è€ƒãˆã‚‹ãã®å‰ã«ãƒ»ãƒ»ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®è©±ã‚’ã™ã‚‹å‰ã«ã¾ãšVMã®èµ·å‹•ãƒ¢ãƒ¼ãƒ‰ã«ã¤ã„ã¦è©±ã—ãŸã„ã¨æ€ã†ã€‚ VMã«ã¯å¤§ããä»¥ä¸‹ï¼’ã¤ã®èµ·å‹•ãƒ¢ãƒ¼ãƒ‰ãŒã‚ã‚Šã€ãã‚Œãžã‚Œä»¥ä¸‹ã®ã‚ˆã†ãªç‰¹å¾´ã‚’æŒã¤ã€‚ â—†ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆVMãƒ¢ãƒ¼ãƒ‰ èµ·å‹•æ™‚é–“ã‚’çŸç¸®ã—ã€ãƒ¡ãƒ¢ãƒªã‚µã‚¤ã‚ºã‚’ç¸®å°ã™ã‚‹ã‚ˆã†ã«èª¿æ•´ã•ã‚Œã¦ã„ã‚‹ã€‚ VMèµ·å‹•æ™‚
uokada 2018/02/07
â€œã€ŒåˆæœŸå€¤ â‰ æœ€å¤§å€¤ã€ã¨ã—ãŸå ´åˆã€åˆæœŸåŒ–æ™‚ã«ã¯æœ€å¤§ã‚¢ãƒ‰ãƒ¬ã‚¹ç©ºé–“ãŒã€Œä»®æƒ³çš„ã€ã«ç¢ºä¿ã•ã‚Œã€å¿…è¦ã«ãªã‚‹ã¾ã§ç‰©ç†ãƒ¡ãƒ¢ãƒªã¯å‰²ã‚Šå½“ã¦ã‚‰ã‚Œãªã„ã€‚â€

JVM

performance

tuning
ãƒªãƒ³ã‚¯
ã‚ãªãŸã®å¤§é‡é…ä¿¡ã‚µãƒ¼ãƒip_conntrack æº¢ã‚Œã¦ã„ã¾ã›ã‚“ã‹ï¼Ÿ | ãƒ–ãƒã‚° | æ ªå¼ä¼šç¤¾ã‚¤ãƒ¼ãƒ»ã‚¨ãƒ¼ã‚¸ã‚§ãƒ³ã‚·ãƒ¼
ip_conntrackã‚’è¨å®šã™ã‚‹ç†ç”± ãƒ‘ã‚±ãƒƒãƒˆãƒ•ã‚£ãƒ«ã‚¿ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã§ã‚ã‚‹iptablesã¯ã€ãƒ‘ã‚±ãƒƒãƒˆã‚’è§£æžã™ã‚‹ã¨ãã«ip_conntrackã¨ã„ã†ãƒ•ã‚¡ã‚¤ãƒ«ã«ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°æƒ…å ±ã‚’è¨˜éŒ²ã—ã¾ã™ã€‚ ip_conntrackã«ã¯ã€æœ€å¤§ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°æ•°ãŒã‚ã‚Šã€ãã‚Œã‚’ã‚ªãƒ¼ãƒãƒ¼ã™ã‚‹ã¨æ–°è¦ã‚»ãƒƒã‚·ãƒ§ãƒ³ã‚’å¼¾ã„ã¦ã—ã¾ã£ã¦ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®åŠ£åŒ–ã‚’æ‹›ãã¾ã™ã€‚ /var/log/messageã«ã“ã®ã‚ˆã†ãªãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºã¦ã„ãŸã‚‰ã€ip_conntrackãŒæº¢ã‚Œã¦ã„ã‚‹çŠ¶æ…‹ã§ã™ã€‚ å¤§é‡ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’æŒããƒãƒ¼ãƒ‰ãƒãƒ©ãƒ³ã‚µãƒ¼ã‚„ã‚ãƒ£ãƒƒã‚·ãƒ¥ãªã©ã®ç›®çš„ã‚’æŒã£ãŸLinuxãƒžã‚·ãƒ³ã§ã€iptablesã‚’ä½¿ã£ã¦ã„ã‚‹ã¨ãã«ã¯ã€ip_conntrackã®æœ€å¤§ãƒˆãƒ©ãƒƒã‚ãƒ³ã‚°æ•°ã‚’å¿˜ã‚Œãšã«è¨å®šã—ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ ã“ã“ã§ã¯ã€æ‰‹å…ƒã®ãƒžã‚·ãƒ³CentOS 5ã¨6ã§è¨å®šã‚’ã—ã¦ã„ãã¾ã™ã€‚ æ¤œè¨¼ç’°å¢ƒ CentOS 6.3(64bit) CentOS 5.8(
uokada 2013/09/26
ãªã‚“ã‹ã“ã‚Œæº¢ã‚Œã¦ã„ã‚‹å¯èƒ½æ€§ã€‚ /proc/sys/net/ipv4/ip_conntrack_max /proc/sys/net/ipv4/netfilter/ip_conntrack_count

Linux

performance

network

tuning

iptables
ãƒªãƒ³ã‚¯
åŒæ™‚æŽ¥ç¶šæ•°ï¼ˆMaxClientsï¼‰ã‚’ã„ãã¤ã«è¨å®šã™ã¹ãã‹ï¼Ÿ
ã¸ã‚“ã˜ãŒãªã„ã€‚ãŸã ã®ãƒãƒ³ã‚³ãƒ„ã®ã‚ˆã†ã ã€‚ ãƒãƒ³ã‚³ãƒ„ãŒä»Šæ—¥ã‚‚æŒã¡å ´ã§ã‚¬ãƒ³ãƒãƒªã¤ã¤ã€ æ¥½ã—ãç”Ÿãã¦ã„ããŸã‚ã®å‚™å¿˜éŒ²ãƒ–ãƒã‚°ã€‚ã¬ã‚ãƒ¼ãƒ¼ã£ã£ï¼ï¼2005å¹´7æœˆã‹ã‚‰çµ¶è³›ã€Œæ›´æ–°ã€ä¸ï¼ ã€ã“ã®è¨˜äº‹ã®æ‰€è¦æ™‚é–“ ï¼š ç´„ 9 åˆ†ã€‘ Apacheã®åŒæ™‚æŽ¥ç¶šæ•°ï¼ˆMaxClientsï¼‰ã‚’ã©ã®ã‚ˆã†ã«è¨å®šã™ã‚‹ã®ãŒã„ã„ã®ã‹èª¿ã¹ãŸã€‚ Apacheã®ãƒ—ãƒã‚»ã‚¹æ•°ã‚’åˆ¶é™ã™ã‚‹ãŸã‚ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒ†ã‚£ãƒ–ãŒã€ŒMaxClientsã€ã§ã€ã“ã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒ†ã‚£ãƒ–ã«ã¯ã€åŒæ™‚ã«æŽ¥ç¶šã§ãã‚‹ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆï¼ˆåŽ³å¯†ã«ã¯ã‚»ãƒƒã‚·ãƒ§ãƒ³ï¼‰ã®æ•°ã‚’æŒ‡å®šã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã€‚ â—ã¾ãšã¯Apacheãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ç¢ºèªã—ã‚ˆã† Apacheã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«å®šç¾©ã•ã‚Œã¦ã„ãŸã€‚ MaxClients ãƒ‡ã‚£ãƒ¬ã‚¯ãƒ†ã‚£ãƒ– èª¬æ˜Ž: ãƒªã‚¯ã‚¨ã‚¹ãƒˆã«å¿œç”ã™ã‚‹ãŸã‚ã«ä½œæˆã•ã‚Œã‚‹åãƒ—ãƒã‚»ã‚¹ã®æœ€å¤§å€‹æ•° æ§‹æ–‡: MaxClients number ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ: è©³ç´°ã¯ä½¿ç”¨æ³•ã‚’ã”è¦§ä¸‹ã•ã„ã€‚ ã‚³ãƒ³ãƒ†ã‚ã‚¹ãƒˆ:
uokada 2012/11/16
apache

Linux

performance

tuning
ãƒªãƒ³ã‚¯
openSUSE 12.3: ç¬¬15ç« ãƒ¡ãƒ¢ãƒªç®¡ç†ã‚µãƒ–ã‚·ã‚¹ãƒ†ãƒ ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
JavaScript is disabled on your browser. Please enable JavaScript to use correctly mesosadmin frontend Please login Login Password Forgot your personal password ? We can remind you
uokada 2012/11/06
http://goo.gl/CWsJ2 vm.min_free_kbytesã®è¨å®šå‘¨ã‚Š

tuning

memory

linux
ãƒªãƒ³ã‚¯
RDBã®ãƒãƒƒãƒ•ã‚¡ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒå›ºå®šé•·ã®DBã§ã‚‚90%ä»¥ä¸Šãƒ’ãƒƒãƒˆã™ã‚‹ç†ç”± - ãƒ¬ãƒ™ãƒ«ã‚¨ãƒ³ã‚¿ãƒ¼å±±æœ¬å¤§ã®ãƒ–ãƒã‚°
æ‹™è‘—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ä¿¡ã˜ã‚‰ã‚Œãªã„DB æ–‡åŒ–ã€Œå›ºå®šé•·DBã€ã§ã‚‚ã‚ã†ã‚“ã§ã™ã€‚å¤§è¦æ¨¡ã‚³ãƒ³ã‚·ãƒ¥ãƒ¼ãƒžå‘ã‘ã‚µãƒ¼ãƒ“ã‚¹ã®RDBè¨è¨ˆ - å±±æœ¬å¤§ã®æ—¥è¨˜ã«ã¤ã„ãŸã‚³ãƒ¡ãƒ³ãƒˆã§ã€ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ãŒã‚ã£ãŸã€‚ å€‹äººçš„ã«ã¯ã€Œå›ºå®šé•·ã«ã™ã‚‹ã“ã¨ã§ã®CPUã‚³ã‚¹ãƒˆã€ã‚ˆã‚Šã‚‚ã€Œå›ºå®šé•·ã«ã™ã‚‹ã“ã¨ã§ã®I/Oã‚³ã‚¹ãƒˆã€ã€ã¤ã¾ã‚Šè¨˜äº‹ã«ã‚‚ã‚ã‚Šã¾ã™ã€Œãƒãƒƒãƒ•ã‚¡ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒä½Žããªã‚‹ã€‚ã€ã“ã¨ã«ã‚ˆã‚‹æ€§èƒ½åŠ£åŒ–ãŒã¨ã¦ã‚‚æ°—ã«ãªã‚‹ã®ã§ã™ãŒã€‚ã€‚ã€‚ ãã®è¾ºã¯ã€ä¸€æ‹¬ã§ãƒ‰ã‚«ãƒ³ã¨æ”¯æ‰•ã‚ã‚ŒãŸåˆæœŸæŠ•è³‡è²»ç”¨ã§ååˆ†ãªã‚µã‚¤ã‚ºã®ãƒ¡ãƒ¢ãƒªã‚’ç©ã‚“ã§å›žé¿ã•ã‚ŒãŸã®ã§ã—ã‚‡ã†ã‹ã€‚ ã“ã‚Œã«å¯¾ã—ã¦ã¯ã€åƒ•ã¯æŠ€è¡“ã®è«–ç†çš„ãªè§£ç”ã§ã¯ãªãã€é‹ç”¨å®Ÿç¸¾ã‹ã‚‰å¿œãˆã•ã‚Œã¦ã„ãŸã ã“ã†ã¨æ€ã†ã€‚ ã¯ã˜ã‚ã«ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒãƒƒãƒ•ã‚¡ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã¯ Oralceã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å†…ã€SGAã¨å‘¼ã°ã‚Œã‚‹ãƒ¡ãƒ¢ãƒªé ˜åŸŸã®ä¸ã®ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒ»ãƒãƒƒãƒ•ã‚¡ãƒ»ã‚ãƒ£ãƒƒã‚·ãƒ¥ã€ã¨ã„ã†é ˜åŸŸã‚’ç„¡è¦–ã—ã¦ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã™ã‚‹ã“ã¨ã¯ã‚ã‚Šãˆãªã„ã¨è¨€ã£ã¦ã„ã„ã„ã€‚
uokada 2012/08/29
DB

database

tuning
ãƒªãƒ³ã‚¯
[MySQL][InnoDB] innodb_log_file_size å¤‰æ›´æ‰‹é † - koziyã®æ—¥è¨˜
æ¯Žåº¦æ¯Žåº¦æ¯Žåº¦ã¯ã’ã—ãã©å¿˜ã‚Œã™ã‚‹ã®ã§ãƒ¡ãƒ¢ã€‚ æ‰‹é †ã¯ InnoDBã‚’ä½¿ã†ã¨ãã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° - ãƒ•ãƒ„ãƒ¼ãªæ—¥å¸¸ ã§æ›¸ã‹ã‚Œã¦ã¾ã™ãã€‚ innodb_log_file_sizeã‚’å¢—ã‚„ã™ innodb_log_file_size=512Mã« ã¡ã‚‡ã£ã¨ã‚³ãƒ„ãŒã„ã‚‹æ“ä½œãŒå¿…è¦ã€‚ * ä¸€åº¦mysqlã‚’shutdownã™ã‚‹ * innodbã®ãƒã‚°ã‚’åˆ¥ã®å ´æ‰€ã«é€€é¿ã•ã›ã‚‹ * innodb_log_file_sizeã®å€¤ã‚’å¤‰ãˆã‚‹ * å†åº¦mysqldã‚’ä¸Šã’ç›´ã™ã€‚ãƒã‚°ã¯ç„¡ã‘ã‚Œã°å‹æ‰‹ã«ä½œã‚‰ã‚Œã‚‹ã€‚ InnoDB ã®ãƒã‚°ã¯ ib_logfile\d+ (ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã ã¨ ib_logfile(0|1) ã® 2 ãƒ•ã‚¡ã‚¤ãƒ«) ãªã®ã§ã“ã‚Œã‚’ /tmp ã«ã§ã‚‚ mv ã—ã¡ã‚ƒã†ã¨ã€‚ ã§ã€ãªã‚“ã§ã“ã‚“ãªã‚ã‚“ã©ãƒ¼ãªã“ã¨ãŒå¿…è¦ãªã®ã‹ã¨ã„ã†ã¨ no title ã§æ›¸ã‹ã‚Œã¦ã„ã‚‹ æ—¢ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãƒã‚°ãŒå˜åœ¨ã—ã¦ã„ã¦ï¼Œinnodb_
uokada 2012/05/30
tips

innodb

performance

mysql

tuning
ãƒªãƒ³ã‚¯
ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã¯åˆ‡ã£ãŸã»ã†ãŒã„ã„ã‚“ã˜ã‚ƒãªã‚¤ã‚«ï¼Ÿ : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
KLab Advent Calendar 2011 ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ã®2æ—¥ç›®ã¯ã€æ˜¨æ—¥ã«å¼•ãç¶šãã€MySQLã‚’éª¨ã¾ã§ã—ã‚ƒã¶ã‚‹ãŸã‚ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã§ã™ã€‚ ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ ã¯ä¸€èˆ¬ã‚µã‚¤ãƒˆã‚ˆã‚Šã‚‚DBã¸ã®æ›´æ–°ã‚¯ã‚¨ãƒªã®å‰²åˆãŒå¤šããªã‚ŠãŒã¡ã§ã™ã€‚æ›´æ–°ã‚¯ã‚¨ãƒªãŒå¤šã„MySQLã§ã¯ã€é€šå¸¸ã¯æœ‰ç›Šãªã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒç„¡ç›Šã©ã“ã‚ã‹æœ‰å®³ã«ãªã‚Šã¾ã™ã€‚ ãã‚‚ãã‚‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ãƒ’ãƒƒãƒˆçŽ‡ãŒä½Žã„ã€‚20%ä»¥ä¸‹ãªã‚“ã¦ã“ã¨ã‚‚ã‚¶ãƒ©ã«ã‚ã‚‹ ã—ã‹ã‚‚ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã®æ›´æ–°ã¯ã‚°ãƒãƒ¼ãƒãƒ«ãªãƒãƒƒã‚¯ã‚’å–å¾—ã™ã‚‹ ã‹ã‚‰ã§ã™ã€‚ç‰¹ã«å¾Œè€…ã¯å•é¡Œã§ã™ã€‚ãŸã ã®å‚ç…§ã‚¯ã‚¨ãƒªã‚‚ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’æ›´æ–°ã™ã‚‹ä¸Šã«ã€æ›´æ–°ã‚¯ã‚¨ãƒªã¯ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ã®å…¨ã‚¨ãƒ³ãƒˆãƒªã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦ã€æ›´æ–°ã—ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã«å½±éŸ¿ãŒã‚ã‚Šãã†ãªå…¨ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’discardã—ã¦ã„ããŸã‚ã§ã™ã€‚ãŸã¨ãˆã°ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®è¡Œå‹•åŠ›ã®ã‚ˆã†ãªãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ãŸå‚ç…§ã‚‚æ›´æ–°ã‚‚å¤šã„ãƒ†ãƒ¼ãƒ–ãƒ«ã§ã‚¯ã‚¨ãƒªã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒæœ‰åŠ¹ã«ãªã£ã¦
uokada 2012/03/12
MySQL

advent calendar

tuning

performance
ãƒªãƒ³ã‚¯
MySQLã«ãŠã‘ã‚‹JOINã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å®šçŸ³
EnterpriseZineï¼ˆã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºã‚¸ãƒ³ï¼‰ç·¨é›†éƒ¨ã§ã¯ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“ã€ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ‹…å½“ã®æ–¹ã€…å‘ã‘ã«ã€EnterpriseZine Dayã€Security Online Dayã€DataTechã¨ã„ã†ã€3ã¤ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã—ã¦ãŠã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œç·¨é›†éƒ¨ç‹¬è‡ªã®åˆ‡ã‚Šå£ã§ã€æ¥ç•Œãƒˆãƒ¬ãƒ³ãƒ‰ã‚„æœ€æ–°äº‹ä¾‹ã‚’ç¶²ç¾…ã€‚æœ€æ–°ã®å‹•å‘ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã‚‹å ´ã¨ã—ã¦ã€å¥½è©•ã‚’å¾—ã¦ã„ã¾ã™ã€‚
uokada 2011/10/18
performance

mysql

tuning

join

database

algorithm
ãƒªãƒ³ã‚¯
1