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)