服务器常用测试shell命令记录

2015/09/20 linux

一句话测试mysql链接

/usr/local/php-5.4.42/bin/php -r '$h="10.199.100.25";$u="qtuser";$p="*****";$db="hiapkdede";$sql="show tables;";$con = mysql_connect($h,$u,$p);var_dump($con);mysql_select_db($db, $con);$result = mysql_query($sql);while($row = mysql_fetch_array($result)){print_r($row);}'

一句话测试memcache链接

/usr/local/php-5.4.42/bin/php -r '$mc=memcache_connect("10.199.19.43", 11211);var_dump($mc);var_dump($mc->set("TEST", time()));var_dump($mc->get("TEST"));'

文件最后修改

find ./ mtime -3 type -f -name "*.php"

查看端口占用

lsof -i:3306

查看服务安装位置

whereis proftpd

查看系统运行时间(用来验证这台机器是否重装过)

uptime 

kill

kill 对应的是 PID
pkill 对应的是COMMAND
ps aux | grep -w mysql

搜索汇总

zgrep "xxxx" logname | awk -F \" '($2 ~ 200){print $1}'|awk '{print $7}'|sort|uniq -c |sort -nr

请求总数

grep 'zb/bd2015/' news.hiapk.com-aceess.log | wc -l

每小时请求次数

grep 'dededynamicapi_v2.php' manager.hiapk.com-aceess.log | grep '08/Sep/2015:[0-9][0-9]:.*' | awk '{print $4}' | awk -F":" '{print $2"H"}' | uniq -c 

查找每分钟最大请求数据

grep 'd/zb/mi5s/?from=xmpctime' manager.hiapk.com-aceess.log | grep '08/Sep/2015:[0-9][0-9]:.*' | awk '{print $4}' | awk -F":" '{print $2":"$3}' | uniq -c | sort -nr | head -n 10

curl发送post请求

curl --data-ascii '{"touser": "@all","toparty": "","totag": " ","msgtype": "text","agentid": "1","text": {"content": "这是内容~"},"safe":"0"}' https://qyapi.weixin.qq.com/cgi-bin/message/send?access_token=ACCESS_TOKEN

杀死僵尸进程

ps -A -o stat,ppid,pid,cmd | grep php | grep 'Sl' | awk '{print $3}' | xargs kill -9

scp 从远程复制到本地

scp root@10.199.130.23:/root/php-5.4.45.tgz /home/lost+found/php-5.4.45.tgz
scp -r root@10.199.99.56:/data/mysql_backup/2016-06-12_12-59-15 /data/mysqlbak_pullmaster/2016-06-12_12-59-15

scp 从本地复制到远程

scp /home/lost+found/php-5.4.45.tgz root@10.199.130.23:/root/php-5.4.45.tgz

kill 掉当前mysql的process

注意不要把主从process也kill掉

/usr/local/mysql/bin/mysql -uroot -pbdweb..pw..1999yy -S /tmp/mysql.sock -e "show processlist" | grep Query | awk '{print "kill "$1";"}' > /tmp/kill.sql

find文件并打包结果

查找.php后缀文件

find ./data/ -name "*.php" | xargs tar czvf /tmp/code_findhiapk_dataphp2.tar.gz

5天内被修改的文件

find ./data/ -mtime -5 -type f  -name "*.php" | xargs tar czvf /tmp/code_findhiapk_dataphp2.tar.gz

查看当前服务器http请求数

ss -o state established '( dport = :http or sport = :http )' | wc -l

Search

    Table of Contents