To install RPMforge repo in yum,
http://wiki.centos.org/AdditionalResources/Repositories/RPMForge
#wget http://packages.sw.be/rpmforge-release/rpmforge-release-0.5.2-2.el5.rf.i386.rpm
#rpm –import http://apt.sw.be/RPM-GPG-KEY.dag.txt
#rpm -K rpmforge-release-0.5.2-2.el5.rf.*.rpm
#rpm -i rpmforge-release-0.5.2-2.el5.rf.i386.rpm
Check processlist in MySQL
mysql -p -e “show processlist”
Get each mysql db table’s engine type
select table_schema, table_name from information_schema.tables;
Network tool to test network bandwidth and performance
install netperf by souce code on both server and client.
server side:
start netperf
#netserver
client side:
netperf -H remote.lalife.net
To open a new screen
#screen
To detach it
#screen -d
To get list of screens
#screen -list
13827.pts-4.servername
To resume it
#screen -r 13827
To sudo to a different user aaa then use screen
sudo -u aaa -s
script /dev/null
screen
Ref. http://dbadump.blogspot.com/2009/04/start-screen-after-sudo-su-to-another.html
start screen
#screen
detach
#screen -d
resume
#screen -r (single)
or
#screen -x (multi)
There’re 2 ways to enable mysql query logs
in /etc/my.cnf
log=/var/log/mysqld-query.log
or add ” –log” in start script
/usr/bin/mysqld_safe –datadir=”$datadir” …. –log >/dev/null 2>&1 &
How to stop binary log
remove the following from my.cnf
log-bin=mysql-bin
binlog_format=mixed
HELO smtp.lalife.net
MAIL FROM: test@localhost
RCPT TO: test@lalife.net
DATA
FROM:test@localhost
Subject: test smtp
test smtp.
.
QUIT
Another way to send mail by command line
echo “testmail” | mail -s “test” yan@yan.lalife.net
iptraf is a tool used to monitor the network traffic
To add more ports (beyond 104)
iptraf > Enter > Configure > Additional Ports
To change log interval
iptraf > Enter > Timers > Logging interval
Add/Delete/Active/Unactive Filter
iptraf > Enter > IP
Monitor traffic statistics by port
iptraf > Enter > Statistical breakdowns…
To run iptraf background for 10 min and send data to log files
/usr/bin/iptraf -B -s eth0 -t 10
Log file is under /var/log/iptraf/ by default
Install vnstat
tar -zxvf vnstat-1.xx.tar.gz
Compile and install
make all
make install
Use vnstat
create new database
vnstat -u -i eth0
database is created under /var/lib/vnstat/eth0
Setup cron to collect data
copy from examples/vnstat.cron
#vnstat
#vnstat -i eth0
#vnstat -d
#vnstat -m
rx = recieved
tx = transmitted
wget -q –http-user=webmaster –http-passwd=PASSWORD “http://www.abcd.com” -O /var/tmp/logfile