一句话测试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