Difference between revisions of "Centos Oneliners"
From Brian Nelson Ramblings
(→Apache Oneliners) |
(→Mysql Oneliners) |
||
| Line 15: | Line 15: | ||
===Mysql Oneliners=== | ===Mysql Oneliners=== | ||
| + | |||
| + | Show locked tables | ||
| + | show open tables WHERE In_use > 0; | ||
===Qmail Oneliners=== | ===Qmail Oneliners=== | ||
Revision as of 15:29, 10 December 2013
Contents
Centos Oneliners
This will be a place to save my oneliners
Centos Oneliners
kill all pts
for x in $(ps aux | grep pts| awk '{print $2}'); do kill $x; done
Apache Oneliners
Check the Number of IP's Connecting over Port 80
netstat -tn | grep :80 | awk '{print $5}'| cut -d: -f1 | uniq -c | sort -rn | head
Check what IP's are getting the most traffic
netstat -tn | grep EST | grep :80 | awk '{print $4}' |cut -d: -f1 | uniq -c | sort -rn
Mysql Oneliners
Show locked tables
show open tables WHERE In_use > 0;
