willvvv

最近有这么一个需求，对mysql一张很大的表的一个text类型的字段用若干个规则进行匹配，规则由复杂的与或表达式组成，例如：（A and B）or（C and D and E），这里有两个实现版本。第一：取出此text类型字段作为content，拿content和规则中的关键字进行正则匹配，得到一个新的表达式，类似于(0 and 1) or ( 1 and 0 and 1)的临时表达式，然后使...

1.insert ignore into terms_in_homepage(term_name) values(?) on DUPLICATE KEY UPDATE  term_id=LAST_INSERT_ID(term_id); 说明：ignore     只关注主键对应记录是不存在，无则添加，有则忽略。ON DUPLICATE KEY UPDATE 在添加时操作，关注非...

1.新建MySQL用户和用户组groupadd mysqluseradd -g mysql mysql2.新建MySQL数据目录mkdir -p /data/mysql/data/mkdir -p /data/mysql/tablespacemkdir -p /data/mysql/binlog/mkdir -p /data/mysql/relaylog/cho...

 1.在http://www.percona.com/downloads/XtraBackup/LATEST/  下载对应平台的XtraBackup，这里使用的是 http://www.percona.com/redir/downloads/XtraBackup/XtraBackup-2.0.0/binary/Linux/x86_64/percona-xtrabackup-2.0.0.tar....

mysql-full-backup.sh #!/bin/bashexport MYSQL_HOME=/usr/local/Percona-Server-5.5.21-rel25.0-227.Linux.x86_64/export PATH=$MYSQL_HOME/bin:$PATHmysql_backup_dir=/data/backup/mysql/mysql_use...

在 使用Percona XtraBackup热备和恢复MySQL（一）  这里恢复innodb数据库时写的很简单，但是在实践的时候发现有报错，类似如下： IMPORTANT: Please check that the copy-back run completes successfully. At the end of a successful copy-...

1.两者的区别： The ib_logfile's hold statements affecting innodb tables only. If a crash occurs they are automatically used to complete any innodb transactions that didn't complete before the crash....

备份脚本：mysql-dump.sh #!/bin/bashexport MYSQL_HOME=/usr/local/Percona-Server-5.5.21-rel25.0-227.Linux.x86_64/export PATH=$MYSQL_HOME/bin:$PATHmysql_dump_dir=/data/backup/mysqldumpmysql_user...

---------------------------------------------------------登陆-------------------------------------------------------------------- 1.mysql -h192.168.0.181 -utest -ptest; 登陆mysql命令行 ----------...