mimi_csdn的博客

Percona-XtraBackup 下载地址：https://www.percona.com/downloads/XtraBackup/LATEST/文档地址：https://learn.percona.com/hubfs/Manuals/Percona_Xtra_Backup/Percona_XtraBackup_2.4/Percona-XtraBackup-2.4.9.pdf

innobackupex参数说明（innobackupex --help ）：1）备份：innobackupex [--compress] [--compress-threads=NUMBER-OF-THREADS] [--compress-chunk-size=CHUNK-SIZE] [--encrypt=ENCRYPTION-ALGORITHM]

mysql5.7从库多线程报错：2018-02-25T07:11:52.613073Z 11 [Note] Multi-threaded slave statistics for channel '': seconds elapsed = 124; events assigned = 211909633; worker queues filled over overrun level = 16

当一台mysql服务器有多个实例，需要重启其中一个实例时，需要针对单实例进行重启，不能直接重启mysqld软件，会导致全部实例都重启。只有一个实例时：service mysqld restart/usr/local/mysql/support_files/mysql.server restart/usr/bin/mysqld_safe--defaults-file=/e

某些情况下需要忽略主从同步中某些错误，例如此处：主库mysql5.6，从库mysql5.7，mysql.user表结构不同，在主库修改用户密码，会导致从库报错，因为5.7没有password字段1.MySQL5.7中mysql.user表比MySQL5.6少了1个字段(Password) 2.MySQL5.7中mysql.user表比MySQL5.6多了3个字段(passwor

查询mysql未提交事物，导致表卡死先查询线程Mysql > show full processlist;Kill 46063604 select * frominformation_schema.TokuDB_trx\G   ####若查询结果有数据，不要着急，mysql会自己回滚，恢复，耐心等待。

导出某表某些数据mysql -uroot -p -S /tmp/mysql_3308.sock db_settle -e "SELECT settle_no,partner,partner_name,null as 'out_partner',null as 'out_partner_name',contract_no,trade_count,trade_amo

-- 不是以数字开头select * from mot_terms where `name` not REGEXP '^[0-9]' -- 不是以字母开头select * from mot_terms where `name` not REGEXP '^[a-zA-Z]' -- 已数字和特殊字符开头select * from mot_terms where `name` REGEXP '^[@#$...