Posts
Knowing the total size of all your indexes is helpful when setting your key_cache size. This one-liner gives you that number in bytes.
find /var/lib/mysql/ -name "*.MYI" -printf "%s\n" | awk '{ s += $1}; END { print s }'
Showing posts with label one-liner. Show all posts
Showing posts with label one-liner. Show all posts
2.05.2010
6.25.2009
Perl One-Liner Multithreaded Ping Scanner
Just another one-liner today. This launches a thread for each address you want to scan in the range you provide.
perl -e 'use threads; ($n,@r) = @ARGV; map { $t{$_} = new threads sub { $i = shift; print "$_ up\n" if `ping -c 1 $n$i` =~ /1 received/; }, $_;} $r[0]..$r[1]; map $t{$_}->join, keys %t;' 192.168.50. 1 254
perl -e 'use threads; ($n,@r) = @ARGV; map { $t{$_} = new threads sub { $i = shift; print "$_ up\n" if `ping -c 1 $n$i` =~ /1 received/; }, $_;} $r[0]..$r[1]; map $t{$_}->join, keys %t;' 192.168.50. 1 254
6.18.2009
Get a List of IPs that have Been Refused
Just a one-liner today.
grep refused /var/log/secure | perl -ne '@l = $_; map { /from ::ffff:((?:\d{1,3}\.){3}\d{1,3}\b)/; $h{$1}++; } @l; END {map { print "$_ = $h{$_}\n" if $h{$_} > 10;} keys %h; }'
This will print a list of all IPs that have received a 'refused connection' message more than 10 times and print how many times each has been refused.
grep refused /var/log/secure | perl -ne '@l = $_; map { /from ::ffff:((?:\d{1,3}\.){3}\d{1,3}\b)/; $h{$1}++; } @l; END {map { print "$_ = $h{$_}\n" if $h{$_} > 10;} keys %h; }'
This will print a list of all IPs that have received a 'refused connection' message more than 10 times and print how many times each has been refused.
6.15.2009
Inventory Your Machines with a One-liner
The command dmidecode dumps the DMI table from your machines BIOS in human readable text. Depending on your machine, this should contain some really useful info. Basically a total hardware profile on most machines, including info like service tags and model numbers. I recently needed to quickly inventory a bunch of Dell servers and came up with this one-liner that will production a CSV line of text for the machine it's run on. Combine these lines of text into one file and import into Excel, inventory done.
Format is:
'Hostname','Distro-Release Version','UUID','Service Tag','Model','Processor Version','Memory'
echo `hostname` , `cat /etc/*-release` , `dmidecode |egrep UUID |sed "s/\s\+UUID: //"` , `dmidecode -s system-serial-number` , `dmidecode -s system-product-name` , `dmidecode -s processor-version` , `dmesg |egrep Mem |awk '{ print $2; }'`
Now of course you'll need to modify this command for your own hardware, this won't even work for every Dell. But, the output of dmidecode is readable enough to just scan through it and figure out what you need. Also look in /proc/ for other info you might want to add to your inventory.
Format is:
'Hostname','Distro-Release Version','UUID','Service Tag','Model','Processor Version','Memory'
echo `hostname` , `cat /etc/*-release` , `dmidecode |egrep UUID |sed "s/\s\+UUID: //"` , `dmidecode -s system-serial-number` , `dmidecode -s system-product-name` , `dmidecode -s processor-version` , `dmesg |egrep Mem |awk '{ print $2; }'`
Now of course you'll need to modify this command for your own hardware, this won't even work for every Dell. But, the output of dmidecode is readable enough to just scan through it and figure out what you need. Also look in /proc/ for other info you might want to add to your inventory.
Subscribe to:
Posts (Atom)
