随笔分类 -  mysql

mysql log and lock
摘要：mysql bin log==> /etc/my.cnf==> log_bin=/var/log/mysql/mysql-bin.log==> binlog_do_db=your_db ==> 记录所有mysql存储引擎相关的日志==> 类型无论是STATEMENT，ROW，MIXED其记录的都是关 阅读全文
posted @ 2019-03-11 17:59 多彩泰坦 阅读(235) 评论(0) 推荐(0)
mysql57 centos7 使用
摘要：####### yum repository install #######mysql yum repo http://repo.mysql.com/wget http://repo.mysql.com/mysql57-community-release-el7-11.noarch.rpmyum l 阅读全文
posted @ 2018-09-04 17:25 多彩泰坦 阅读(720) 评论(0) 推荐(0)
mysql utf8mb4 设置
摘要：[mysqld]collation-server=utf8mb4_general_ciinit-connect='SET NAMES utf8mb4'character-set-server=utf8mb4skip-character-set-client-handshakesql_mode="ST 阅读全文
posted @ 2018-09-04 14:29 多彩泰坦 阅读(1224) 评论(0) 推荐(0)
mysql Percona-XtraBackup backup
摘要：全量备份FULL BACKUP https://www.percona.com/doc/percona-xtrabackup/2.4/backup_scenarios/full_backup.html#preparing-a-backup 全量备份CHEETSHEET 下载（示例：centos7下2 阅读全文
posted @ 2018-09-04 11:13 多彩泰坦 阅读(198) 评论(0) 推荐(0)