http://tech.noredink.com/post/133347435578/optimizing-mysql-for-high-concurrency-on-amazon
Looking for concurrency bottlenecks
performance schema
List the total maximum wait by event inside of InnoDB
SELECT EVENT_NAME, SUM_TIMER_WAIT/1000000000 WAIT_MS, COUNT_STAR FROM performance_schema.events_waits_summary_global_by_event_name ORDER BY SUM_TIMER_WAIT DESC, COUNT_STAR DESC LIMIT 30;
List current and last wait events on InnoDB. -- “what the current, or last completed, wait for each session was, and for exactly how long they waited” SELECT NAME, IF(PPS.
https://medium.com/devoops-and-universe/database-performance-aws-vs-bare-metal-452f64481b07
https://mariadb.com/kb/en/mariadb/performance-schema-overview/
準系統 2017/04/15
http://www.coolpc.com.tw/tmp/1492164432391274.htm
https://www.mobile01.com/topicdetail.php?f=396&t=5120761
===========
1萬nb
http://pcdvd.com.tw/showthread.php?t=1123368
會去美國eBay撿便宜
像是Dell Latitude E6430 【Manufacturer refurbished】不用美金250元
第三代IvyBrideg I5-3320M 絕對夠用，又是rPGA針腳(不是焊死的BGA)
內行的就知道了
純正商務筆電血統穩定品質大勝台灣萬元筆電
加上Latitude零件流通性不比ThinkPad差，淘寶一堆
http://www.digitalfaq.com/forum/guides-ispconfig/3261-how-optimize-ispconfig.html
vi /etc/postfix/main.cf
# content_filter = amavis:[127.0.0.1]:10024
# receive_override_options = no_address_mappings
/etc/init.d/postfix restart
/etc/init.d/clamav-daemon stop /etc/init.d/clamav-freshclam stop /etc/init.d/spamassassin stop
/etc/init.d/amavis stop
update-rc.d -f clamav-daemon remove update-rc.d -f clamav-freshclam remove update-rc.d -f spamassassin remove update-rc.d -f amavis remove
https://github.com/servisys/ispconfig_setup
好用
