컴퓨터 / Computer

서버 튜닝하기

공유지기 0 5,279 2017.03.09 17:47

0_fivEmSUN_cafc0046fceae53820e6e11ed19a3a0d3034ec3c.jpg 



아래와 같이 모아봤습니다.

 

 

 

 

- 시스템모니터링

   http://darkwind.tistory.com/40

 

- DB 기본 상식 :

   http://www.slideshare.net/devparan/h3-2011-b2-mysql-tuning-strategy-for-large-site

   - MyISAM vs InnoDB 비교  - http://chiccoder.tistory.com/24

 

 - DB 서버 캐싱 및 가속 : memcached + active MQ

    https://www.digitalocean.com/community/tutorials/how-to-install-and-use-memcache-on-ubuntu-14-04

    http://www.solanara.net/solanara/memcached

    http://www.memcached.org/about

    - http://jdm.kr/blog/137 을 참고하여 http://wordpressxe.tistory.com/8 이 방식대로 설치 

  

 

 - 속도개선 방법

    http://novicecoder.tistory.com/entry/%EB%8C%80%EA%B7%9C%EB%AA%A8-%EC%9B%B9%EC%82%AC%EC%9D%B4%ED%8A%B8-%EA%B5%AC%EC%84%B1%ED%95%98%EA%B8%B0

    http://stevesouders.com/examples/rules.php

    https://developers.google.com/speed/docs/insights/rules

    https://developer.yahoo.com/performance/rules.html

    https://blog.lael.be/post/1866

    인덱스 다시 하기 : http://stackoverflow.com/questions/30613533/how-to-index-rebuild-in-mysql-for-all-tables-in-a-database

    쿼리코드 수정 https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=78629

 

 - pagespeed 모듈 설치 https://www.cmsfactory.net/node/11436

 

 - mysql 튜닝

    http://cyberseo.tistory.com/entry/%EC%B4%88%EB%B3%B4%EB%8F%84-%EC%95%8C%EC%95%84%EC%95%BC-%ED%95%A0-MySQL-%ED%8A%9C%EB%8B%9D-18-%EA%B0%80%EC%A7%80

    http://gywn.net/2012/09/mysql-tuning/

    http://egloos.zum.com/mcchae/v/11063919

    https://blog.lael.be/post/370

 

 - DB 서버 분리

    http://igoto.x-y.net/xe/linux/247

    https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=225408


 

 

 

Comments