分类 "Linux" 下的文章

安装依赖:yum groupinstall "Development tools" yum install zlib-devel bzip2-devel openssl-devel ncurses-devel sqlite-devel 安装python2.7:wget https://www.python.org/ftp/python/2.7.13/Python-2.7.1

限制:binlog格式必须为rowbinlog_format = rowbinlog_row_image = full仅支持5.6与5.7只能回滚DML(增、删、改)下载地址:https://github.com/Meituan-Dianping/MyFlash/archive/master.zip安装:yum groupinstall "Development Tools"

删除10天前的MySQL binlog日志PURGE MASTER LOGS BEFORE DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY); show master logs;删除所有MySQL binlog日志reset master;实例://清除MySQL-bin.010日志: PURGE MASTER LOGS TO 'MySQL-bin.010'; //清

修改时区为上海vim /etc/sysconfig/clock ZONE="Asia/Shanghai"建立软链接rm /etc/localtime ln -s /usr/share/zoneinfo/Asia/Shanghai /etc/localtime设置ntp同步yum install ntpdate 添加任务crontab -e 20 02 * * * /usr/sb

1、统计baidu蜘蛛每秒并发,按时间排序grep -i "Baiduspider" access.log | awk '{print $4}' | sort | uniq -c | sort -t":" -k3,42、统计baidu蜘蛛每秒并发,按并发量排序,取前100grep -i "Baiduspider" access.log |

场景:被登录服务器:A本地客户端:B被登录服务器A操作:1、A开启免密登录功能vim /etc/ssh/sshd_config 如下三行注释去掉 RSAAuthentication yes PubkeyAuthentication yes AuthorizedKeysFile .ssh/authorized_keys2、重启ssh服务service sshd restart3、创建必要文