Sunday, April 5, 2009

Generating a syslog message

#logger -i -t yourname "This is a test"

=> Message should appear at /var/log/messages.

Thursday, April 2, 2009

MySQL: show disk space occupied by database

#mysql -uroot -p -D -e "show table status\G"| egrep "(Index|Data)_length" | awk 'BEGIN { rsum = 0 } { rsum += $2 } END { print rsum/1024/1024 "M"}'