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

machataka id:machataka

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

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

Re: çµå±€ã€Goè¨€èªžã‚’ã‚„ã‚ã‚‹ç†ç”±ã¯ãªã‹ã£ãŸä»¶ - Hateburo: kazeburo hatenablog
ã™ã¿ã¾ã›ã‚“ã€ISUCONã®ã‚¢ãƒ¬ã«ç«ãŒã¤ã„ã¦ã—ã¾ã£ãŸã®ã§..ã€‚ Advent Calendarã¨ã¯ã¨ãã«é–¢ä¿‚ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ qiita.com qiita.com ã“ã¡ã‚‰ã®è¨˜äº‹ã‚’ã¿ã¦ã€æ°—ã«ãªã£ã¦ã—ã¾ã£ãŸã®ã§ interpolateParams ã®è¿½åŠ ã¨MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’ã—ã¦ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’å›žã—ã¦ã¿ã¾ã—ãŸã€‚ ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã®ç’°å¢ƒãŒå…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã®ã¯ç´ æ™´ã‚‰ã—ã„ã§ã™ãã€‚ github.com 8vCPU/16GB Memã®c5a.2xlargeãªEC2ã®ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’èµ·å‹•ã—ã¦ã€ä»¥ä¸‹ã®æ‰‹é †ã«ã—ãŸãŒã£ã¦dockerã¨docker-composeã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã—ãŸã€‚OSã¯Ubuntu 20.04ã‚’ä½¿ã„ã¾ã—ãŸã€‚ docs.docker.com docs.docker.com ä¸Šè¨˜ã®benchmarkã®repositoryã‚’git cloneã—ã€compose build && compose upã—
machataka 2020/12/18
ç§˜ä¼ã®ã‚¿ãƒ¬ã™ã”

mysql

tuning
ãƒªãƒ³ã‚¯
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
machataka 2009/07/22
show processlist

mysql

tuning
ãƒªãƒ³ã‚¯
[ThinkIT] ã¯ã˜ã‚ã¦ã®MySQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚° ç¬¬3å›žï¼šmax_connectionsã¨thread_cacheã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã† (1/3)
å‰å›žã€Œç¬¬2å›žï¼šè² è·ã«ã‚ˆã‚‹ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã‚’è©¦ã™ã€ã®æ¸¬å®šçµæžœã§ã¯ã€æ¸¬å®šé€”ä¸ã§max_connectionsã«é”ã—ã¦ã—ã¾ã„ã€è¨ˆç”»ã—ã¦ã„ãŸæ¸¬å®šã‚’å®Œäº†ã™ã‚‹ã“ã¨ãŒã§ãã¾ã›ã‚“ã§ã—ãŸã€‚ãã“ã§max_connectionsã‚’å¢—ã‚„ã—ã¦ã€å†åº¦æ¸¬å®šã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ max_connectionsã‚’å¢—ã‚„ã™ã«ã¯2é€šã‚Šã®æ‰‹æ®µãŒã‚ã‚Šã¾ã™ã€‚ã¾ãšã€Œ/etc/my.cnfã€ã«è¨å®šã‚’è¿½è¨˜ã™ã‚‹æ–¹æ³•ã§ã™ã€‚è¨å®šå€¤ã¯450ã«å¤‰æ›´ã—ã¾ã™ã€‚
machataka 2007/07/20
*mysql

tuning
ãƒªãƒ³ã‚¯
https://ilia.ws/files/phptek2007_performance.pdf
machataka 2007/07/13
php

tuning
ãƒªãƒ³ã‚¯
PHPã‚’ã‚ˆã‚Šé«˜é€ŸåŒ–ã™ã‚‹ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°ãƒ„ãƒ¼ãƒ«ã‚ã‚Œã“ã‚Œ
PHPã‚’é«˜é€ŸåŒ–ã™ã‚‹ãŸã‚ã«ä¸é–“ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’ä½¿ã†å„ç¨®PHPã‚¢ã‚¯ã‚»ãƒ©ãƒ¬ãƒ¼ã‚¿ã«ã¤ã„ã¦ã¯ä»¥å‰ã«ã€ŒPHPã‚¢ã‚¯ã‚»ãƒ©ãƒ¬ãƒ¼ã‚¿ã§ä¸€ç•ªé«˜é€Ÿãªã®ã¯ã©ã‚Œã‹ï¼Ÿã€ã§æ›¸ãã¾ã—ãŸãŒã€ãã†ã„ã†æ–¹æ³•ä»¥å¤–ã«ã©ã“ã§æ™‚é–“ãŒã‹ã‹ã£ã¦ã„ã‚‹ã®ã‹ï¼ˆãƒœãƒˆãƒ«ãƒãƒƒã‚¯ï¼‰ã‚’è¦‹ã¤ã‘å‡ºã™ã“ã¨ã«ã‚ˆã£ã¦ã€æ ¹æœ¬çš„ã«é«˜é€ŸåŒ–ã™ã‚‹ã¨ã„ã†æ‰‹æ³•ã‚‚ã¡ã‚ã‚“ã‚ã‚‹ã‚ã‘ã§ã€‚ ãã†ã„ã†ä½œæ¥ã«å½¹ç«‹ã¡ãã†ãªãƒ„ãƒ¼ãƒ«ãŒã„ã‚ã„ã‚ã¨ã‚ã‚‹ã‚ˆã†ãªã®ã§å®Ÿéš›ã®ä½¿ã„æ–¹ã¨ä¸€ç·’ã«è¦‹ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ SitePoint Blogs >> Faster PHP Apps-Profile Your Code with Xdebug ã€ŒXdebugã€ã¨ã„ã†ã®ãŒã©ã†ã‚‚ä¸€èˆ¬çš„ã®ã‚ˆã†ã§ã™ã€‚Windowsç”¨ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚‚ã‚ã‚Šã€PHP4ã ã‘ã§ãªã5ã«ã‚‚å¯¾å¿œã€‚ Xdebug - Debugger and Profiler Tool for PHP http://www.xdebug.org/ Xdebugã ã‘ã ã¨ãƒ—ãƒãƒ•ã‚¡ã‚¤ãƒªãƒ³ã‚°
machataka 2007/07/09
*php

degub

profiler

tuning
ãƒªãƒ³ã‚¯
http://forums.theplanet.com/index.php?showtopic=64695&pid=573659&st=0&
machataka 2007/06/26
*mysql

tuning
ãƒªãƒ³ã‚¯
MySQLã‚¯ã‚¨ãƒªæœ€é©åŒ– & ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ & è² è·åˆ†æ•£äººæ°—è¨˜äº‹ã¾ã¨ã‚ - Lazy Technology
ã¯ã¦ãƒ–ã®mysqlã‚¿ã‚°ã®ãƒˆãƒƒãƒ—200ä»¶ã‚’è¦‹ã¦å‚è€ƒã«ãªã‚Šãã†ãªã‚µã‚¤ãƒˆã‚’åˆ—æŒ™ã€‚ å¾Œã§èªã‚€ã€‚ http://tech.media-index.jp/2006/11/mysql_1.html DSASé–‹ç™ºè€…ã®éƒ¨å±‹:5åˆ†ã§ã§ãã‚‹ã€MySQLã®ãƒ¡ãƒ¢ãƒªé–¢ä¿‚ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ï¼ MySQLã‚¯ã‚¤ãƒƒã‚¯ãƒ»ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ç¾å ´æŒ‡å‘ã®ãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è©³èª¬ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› http://www.res-system.com/it em/550 http://labs.unoh.net/2006/07/post_26.html http://tomo.ac/goodstream/database/mysql/linux/tips.htm http://codezine.jp/a/article/aid/1229.aspx ã‚·ãƒ³ãƒ—ãƒ«ãªPHPã¨MySQLã®æœ€é©åŒ–æ–¹æ³•ã€Œå½“ãŸã‚Šå‰ã‚’ç©ã¿é‡ãã‚‹ã¨ç‰¹åˆ¥ã«ãªã‚‹ã€ - GIGAZINE
machataka 2007/05/26
ã€€ã¯ã¦ãƒ–ã‹ã‚‰ã®ã¾ã¨ã‚ã€‚

*mysql

tuning

*tips
ãƒªãƒ³ã‚¯
mt-search.cgiã‚’mod_cacheã§è¶…é«˜é€ŸåŒ–ã™ã‚‹!! - Ogawa::Memoranda
Posted by: Hirotaka Ogawa @ February 12, 2007 03:45 AM | ã‹ãªã‚Šå‰ã‹ã‚‰Apache 2.2.xã‚’ä½¿ã£ã¦ã„ã‚‹ã®ã§ã™ãŒã€mod_cache/mod_disk_cacheãªã‚“ã¦ã„ã†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒå˜åœ¨ã™ã‚‹ã“ã¨ã«å…¨ç„¶æ°—ãŒã¤ã„ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ã“ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã§ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã‚’å®Ÿç¾ã™ã‚‹ã‚‚ã®ã§ã€CGIãªã©ã‚’ä½¿ã£ã¦ç”Ÿæˆã•ã‚Œã‚‹å‹•çš„ãªã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã®ãƒ¬ãƒ³ãƒ€ãƒªãƒ³ã‚°çµæžœã®å†åˆ©ç”¨ã‚’å¯èƒ½ã«ã—ã¾ã™(é™çš„ãªã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã‚‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã§ãã¾ã™ãŒã€å¿œç”æ™‚é–“ãŒå•é¡Œã«ãªã‚‹ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã—ã€ä¸€èˆ¬çš„ã«ã¯ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã§ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã•ã‚Œã¾ã™)ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã¯æ™‚é–“åˆ¶ç´„ã®å¼·ããªã„ã‚‚ã®ã§ã‚ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ä¾‹ãˆã°ã€ã‚³ãƒ¡ãƒ³ãƒ†ã‚£ãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ ãªã©ã§ã¯ãƒ¦ãƒ¼ã‚¶ãŒè¡Œã£ãŸæ“ä½œã‚’ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«å³åº§ã«åæ˜ ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ãŸã‚ã«é©ã—ã¦ã„ã¾ã›ã‚“ãŒã€æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã‚„CMSã®ã‚ˆã†ã«å¯¾è±¡ã¨ãª
machataka 2007/02/12
*apache

mod_cache

è² è·åˆ†æ•£

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

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

tuning

*tips
ãƒªãƒ³ã‚¯
mysql ã‚’é«˜é€ŸåŒ–ã—ãŸã„ã¨ãã«èªã‚€ãƒ¡ãƒ¢ (TechKnowledge)
çµ¦æ–™ã®æŒ¯è¾¼å£åº§ã¨ã—ã¦ä¸‰äº•ä½å‹éŠ€è¡Œã«å£åº§ã‚’æŒã£ã¦ã„ã¾ã™ã€‚è‡ªå‹•æ”¯æ‰•ã„ã‚µãƒ¼ãƒ“ã‚¹ã‚’ä½¿ç”¨ã—ã¦å…‰ç†±è²»ç‰ã®å…¬å…±æ–™é‡‘ã®æ”¯æ‰•ã„ã‚’ã—ã¦ã„ã¾ã™ãŒã€å…ˆæ—¥ãã‚Œã‚‰ã®å†…ã®ä¸€ã¤ã‚’å¤±å¿µã—ã¦ãŸã“ã¨ã«æ°—ã¥ãã¾ã—ãŸã€‚å£åº§ã‚’ç¢ºèªã—ãŸæ™‚ã«ã¯ã™ã§ã«å¼•ãè½ã¨ã—ãŒå®Œäº†ã—ã¦ã„ãŸãŸã‚ã€æ‰‹å…ƒã®è³‡é‡‘ãŒå¿ƒç´°ããªã£ãŸçŠ¶æ…‹ã§æ•°æ—¥ã‚’éŽã”ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸‰äº•ä½å‹éŠ€è¡Œã§å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒå¯èƒ½ã§ã‚ã‚Œã°ã€æ˜¯éžåˆ©ç”¨ã—ãŸã„ã®ã§ã™ãŒã€‚ é‹ãŒè‰¯ã‘ã‚Œã°ã€ä¸‰äº•ä½å‹éŠ€è¡Œã®å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã¯å¯èƒ½ ä¸‰äº•ä½å‹éŠ€è¡Œã®ç‰¹å¾´ã¯ã¾ãšã‚¯ãƒ¬ã‚¸ãƒƒãƒˆã‚«ãƒ¼ãƒ‰ä¼šç¤¾ã¨ã®é€£æºã—ãŸã‚µãƒ¼ãƒ“ã‚¹ãŒé…åŠ›çš„ãªã“ã¨ãŒã‚ã’ã‚‰ã‚Œã¾ã™ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ã§ã¯éŠ€è¡Œã‚«ãƒ¼ãƒ‰ãƒãƒ¼ãƒ³ã§ã™ã‹ã‚‰ã€ä½•ã‚ˆã‚Šå®‰ã„é‡‘åˆ©ãŒå¤§ãã„åˆ©ç‚¹ã«ãªã‚Šã¾ã™ã€‚æ¦‚ãéŠ€è¡Œç³»ã®å¯©æŸ»ã«å¿…è¦ãªæ™‚é–“ã¯é•·ããªã‚‹ã‚ˆã†ã§ã™ãŒã€ä¸‰äº•ä½å‹éŠ€è¡Œã§ã¯ã‚«ãƒ¼ãƒ‰ç™ºè¡ŒãŒå½“æ—¥ã«è¡Œãªã£ã¦ãã‚Œã¾ã™ã€‚ ä¸‰äº•ä½å‹éŠ€è¡Œã¯å³æ—¥ã‚ãƒ£ãƒƒã‚·ãƒ³ã‚°ãŒã§ãã‚‹ã‹ã¨è¨€ã†ã¨å¾®å¦™ãªã“ã¨ã«ãªã‚Šã¾ã™ã€‚ç”³è¾¼ã‹ã‚‰å¯©æŸ»çµæžœã®é€£çµ¡ã¾ã§ã¯ã€åœŸæ—¥
machataka 2006/12/06
*mysql

performance

*tips

tuning
ãƒªãƒ³ã‚¯
Top 84 MySQL Performance Tips | Debian Admin
MySQL is a widely used and fast SQL database server. It is a client/server implementation that consists of a server daemon (mysqld) and many different client programs/libraries. You can check the same tips from here.Here is very useful tips for all mysql DBAâ€™s,Developers these tips are noted from MySQL Camp 2006 suggested by mysql community experts. Kaj (Most Excellent Obvious Facilitator) Index s
machataka 2006/11/29
*mysql

performance

*tips

tuning

ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°
ãƒªãƒ³ã‚¯
12ã®PHPæœ€é©åŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯:phpspoté–‹ç™ºæ—¥èªŒ
12 PHP optimization tips Ilia Alshanetskyâ€™s PHP performance talk given last week at the Zend conference is pretty useful as far as getting small tips for tweaking PHP code. PHPæœ€é©åŒ–ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ãŒç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã—ãŸã®ã§ä»¥ä¸‹ã«ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ staticãƒ¡ã‚½ãƒƒãƒ‰ãŒä½¿ãˆã‚‹ãªã‚‰ä½¿ãŠã†ã€‚é€Ÿåº¦ã¯4å€ã«ãªã‚‹ __get, __set, __autoload ã¯ä½¿ã‚ãªã„ require_once ã¯é‡ã„ include, requireã§èªã¿è¾¼ã‚€ãƒ•ã‚¡ã‚¤ãƒ«ã¯ãƒ•ãƒ«ãƒ‘ã‚¹ã«ã—ã‚ˆã† ã‚¹ã‚¯ãƒªãƒ—ãƒˆé–‹å§‹æ™‚ã®UNIXã‚¿ã‚¤ãƒ ã‚’ ï¼„_SERVER['REQUEST_TIME'] ã§å–ã‚Œã‚‹ strncasecmpé–¢æ•°ã‚„strpbrké–¢æ•°ã‚’ä½¿ãˆã‚‹ã‚±ãƒ¼ã‚¹ã¯
machataka 2006/11/21
*php

*tips

tuning
ãƒªãƒ³ã‚¯
MySQL Performance Blog ï¿½ What to tune in MySQL Server after installation
Tuning For Your HardwareDepending on the hardware you have installed MySQL on, some variables need to be set based on the machine (or VM) specifications. The following variables are largely dependent on your hardware: innodb_buffer_pool_size Generally, set to 50% â€“ 70% of your total RAM as a starting point. It does not need to be set any larger than the total database size.innodb_log_file_size Thi
machataka 2006/10/01
*mysql

performance

tuning
ãƒªãƒ³ã‚¯
Getting Rich with PHP 5
Getting Rich with PHP 5 2024-03-19 0 Getting Rich with PHP 5 OSCON 2006 July 26, 2006. Portland Rasmus Lerdorf <rasmus@php.net> http://talks.php.net/show/oscon06
machataka 2006/08/26
*php

apc

tuning

è³‡æ–™
ãƒªãƒ³ã‚¯
MySQL :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 5.2.13 ãã®ä»–ã®æœ€é©åŒ–ã®ãƒ’ãƒ³ãƒˆ
This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.
machataka 2006/08/04
*mysql

tuning
ãƒªãƒ³ã‚¯
Cell Phone Tracker App - Track Mobile Phone Location Free
Free Cell Phone Tracker by Snoopza Itâ€™s your chance to track your kids and workers Android Phone Tracker Phone tracker app by Snoopza is a free monitoring program for recording Calls, tracking phone Locations, to view text Messages, Cameras, Internet activity, Screenshots, Instagram, WhatsApp, Viber, Facebook, Skype and Telegram.
machataka 2006/07/09
*php

tuning
ãƒªãƒ³ã‚¯
http://japan.internet.com/developer/20060523/26.html
machataka 2006/06/28
database

tuning
ãƒªãƒ³ã‚¯
GIGAZINE - GIGAZINEã®LoadAvarageã‚’ã€Œ27ã€ã‹ã‚‰ã€Œ2ã€ã¸ä¸‹ã’ãŸæ–¹æ³•
ã“ã“3æ—¥é–“ãã‚‰ã„è¶…çµ¶ãªé‡ã•ã ã£ãŸã®ã¯ã‚µãƒ¼ãƒã«ç‰©ç†çš„ãƒˆãƒ©ãƒ–ãƒ«ãŒç™ºç”Ÿã—ãŸã‹ã‚‰ã§ã¯ãªãã€å˜ç´”ã«é–²è¦§è€…æ•°ãŒæº€å“¡å¾¡ç¤¼ã¨ãªã‚Šã€å„æ™‚é–“ã§å€å¢—ã—ãŸãŸã‚ã§ã™ã€‚LoadAverageã¯ã²ã©ã„ã¨ãã§15åˆ†é–“ã®å¹³å‡å€¤ã€Œ27.1ã€ç¨‹åº¦ã€‚çž¬é–“æœ€å¤§é¢¨é€Ÿã ã¨ã‚‚ã£ã¨é«˜ã„ã§ã™â€¦â€¦æ˜Žã‚‰ã‹ã«ã¾ãšã„ã€‚ ã¨ã„ã†ã‚ã‘ã§ã€Apacheã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆè¨å®šã§ä»Šã¾ã§ã¯å¤§ä¸ˆå¤«ã ã£ãŸã®ã§ã™ãŒã€ã¤ã„ã«é«˜è² è·ã‚µã‚¤ãƒˆç”¨ã®è¨å®šã«å¤‰æ›´ã›ã–ã‚‹ã‚’å¾—ãªããªã‚Šã¾ã—ãŸã€‚ ãã®ãŸã‚ã€å®Ÿéš›ã«è¡Œã£ãŸå¯¾å‡¦æ–¹æ³•ã¯ä»¥ä¸‹ã®é€šã‚Šã€‚1æ—¥30ä¸‡PVè¿‘ã„å‹•çš„ã‚µã‚¤ãƒˆã®é«˜è² è·ã‚’ç·©å’Œã•ã›ã‚‹æ–¹æ³•ã¨ã—ã¦å‚è€ƒã«ãªã‚Œã°å¹¸ã„ã§ã™ã€‚ ã¾ãšå¤§å‰æã¨ã—ã¦ã€æ—¢ã«DNSé€†å¼•ãã‚„.htaccessã®ä½™è¨ˆãªèªã¿è¾¼ã¿ãªã©ã¯åœæ¢ã•ã›ã¦ã„ã¾ã—ãŸã€‚ä¸‹è¨˜ãƒšãƒ¼ã‚¸ã«æ›¸ã„ã¦ã‚ã‚‹ã“ã¨ã¯å®Ÿè¡Œæ¸ˆã¿ã€‚ ï¼ ITï¼šApacheãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®å®Ÿè·µï¼ˆ1/2ï¼‰ ã“ã®çŠ¶æ…‹ã§è² è·ãŒ15åˆ†å¹³å‡ã§ã€Œ27ã€ã«ãªã£ã¦ã„ãŸã‚ã‘ã§ã™ã€‚ ã¾ãŸã€LoadA
machataka 2006/06/01
tuning

è² è·åˆ†æ•£

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

*mysql

performance
ãƒªãƒ³ã‚¯
performancewiki.comÂ -Â performancewiki ãƒªã‚½ãƒ¼ã‚¹ãŠã‚ˆã³æƒ…å ±
This webpage was generated by the domain owner using Sedo Domain Parking. Disclaimer: Sedo maintains no relationship with third party advertisers. Reference to any specific service or trade mark is not controlled by Sedo nor does it constitute or imply its association, endorsement or recommendation.
machataka 2006/05/24
wiki

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

tuning
ãƒªãƒ³ã‚¯
Vitamin Features Â» Serving JavaScript Fast
Learning to code can be fun! Get started today with a free trial and discover why thousands of students are choosing Treehouse to learn about web development, design, and business. Learn more With a starting salary of up to $75,000 perÂ year, working in tech isnâ€™t a job â€” itâ€™s a career. Did you know? There are more than 500,000 positions in the tech industry waiting to be filled. Our Techdegree pro
machataka 2006/05/23
*javascript

flickr

*php

tuning
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸