03 2013 档案

Percona-Server-5.5.30安装
摘要：1、安装系统环境yum install -y gcc gcc-c++ autoconf automake zlib* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel* cmake bison2、下载源码包1 http://www.percona.com/downloads/2 3 wget -c http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.30-30.1/source/Percona-Server-5.5.30-rel30.1.. 阅读全文
posted @ 2013-03-11 22:32 zwkuang 阅读(476) 评论(0) 推荐(0)
mysql手动删除BINLOG
摘要：用于删除列于在指定的日志或日期之前的日志索引中的所有二进制日志。这些日志也会从记录在日志索引文件在MySQL中执行以下命令：1 PURGE {MASTER | BINARY} LOGS TO ‘log_name’2 3 PURGE {MASTER | BINARY} LOGS BEFORE ‘date’4 5 PURGE {MASTER|BINARY} LOGS BEFORE DATE_SUB(NOW(),INTERVAL 7 DAY);例如：1 mysql>PURGE MASTER LOGS TO ‘mysql-bin.010′;2 3 mysql>PURGE MASTER LO 阅读全文
posted @ 2013-03-08 10:54 zwkuang 阅读(211) 评论(0) 推荐(0)
mysql刷新binlog日志
摘要：1 flush logs; 阅读全文
posted @ 2013-03-08 10:17 zwkuang 阅读(1374) 评论(0) 推荐(0)