| # This is an example of the Stack Exchange Tier 1 HAProxy config | |
| # The only things that have been changed from what we are running are: | |
| # 1. User names have been removed | |
| # 2. All Passwords have been remove | |
| # 3. IPs have been changed to use the example/documentation ranges | |
| # 4. Rate limit numbers have been changed to randome numbers, don't read into them | |
| userlist stats-auth | |
| group admin users $admin_user | |
| user $admin_user insecure-password $some_password |
| Use tcpdump to monitor mysql | |
| # Capture the packets | |
| sudo tcpdump -i eth0 port 3306 -s 65535 -x -n -q -tttt > tcpdump.out | |
| # analyze all the requests from a given host | |
| pt-query-digest --type=tcpdump --filter '($event->{host} || $event->{ip} || "") =~ m/192.168.248.64/' tcpdump.out |
| # Licensed under CC BY 3.0 http://creativecommons.org/licenses/by/3.0/ | |
| # Derived works must attribute https://gist.github.com/4492300 at the beginning, and the date. | |
| ################################################################## | |
| Installing and Configuring SmartOS on a budget server (with a /29) | |
| ################################################################## | |
| # if you find this gist useful, please star it | |
| # please be aware that budget hosting companies usually cut corners somewhere, |
rsync (Everyone seems to like -z, but it is much slower for me)
| superpages on: | |
| -------------- | |
| # sysctl -a | grep vm | |
| kern.ipc.semvmx: 32767 | |
| kern.vm_guest: none | |
| vm.vmtotal: | |
| vm.loadavg: { 0.00 0.02 0.02 } | |
| vm.v_free_min: 12793 | |
| vm.v_free_target: 53855 | |
| vm.v_free_reserved: 2683 |
