아래와 같이 모아봤습니다.
- 시스템모니터링
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://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://gywn.net/2012/09/mysql-tuning/
http://egloos.zum.com/mcchae/v/11063919
- DB 서버 분리
http://igoto.x-y.net/xe/linux/247
https://www.phpschool.com/gnuboard4/bbs/board.php?bo_table=qna_db&wr_id=225408
https://cafe24.zendesk.com/hc/ko/articles/5746130903961--Apache-%EC%84%B1%EB%8A%A5-%ED%8A%9C%EB%8B%9D%EC%9D%80-%EC%96%B4%EB%96%BB%EA%B2%8C-%ED%95%98%EB%82%98%EC%9A%94-Apache-MPM