09 2021 档案

mysql直接备份到远程服务器
摘要：mysqldump --single-transaction --master-data=1 --triggers -R -B dbtest |gzip -c |ssh root@192.168.100.100 'cat > /tmp/dbtest.sql.gz' xtrabackup 2.4 ./ 阅读全文
posted @ 2021-09-29 14:36 learnnote 阅读(390) 评论(0) 推荐(0)
Centos7.4 安装docker
摘要：DNS1=8.8.8.8DNS2=114.114.114.114uname -a yum updateyum install -y yum-utils device-mapper-persistent-data lvm2yum-config-manager --add-repo https://do 阅读全文
posted @ 2021-09-28 10:29 learnnote 阅读(40) 评论(0) 推荐(0)
mysql压测命令
摘要：sysbench io压测sysbench --test=fileio --file-num=4 --file-block-size=16384 --file-total-size=20G --file-test-mode=rndrd --file-extra-flags=direct prepar 阅读全文
posted @ 2021-09-28 10:28 learnnote 阅读(80) 评论(0) 推荐(0)
安装数据库前调整系统参数，提高性能
摘要：操作系统关闭swap磁盘调度算法设置为：deadline或者noopecho deadline > /sys/block/sda/queue/schedulermount -o noatime,nobarrier /dev/sdb1 /data 阅读全文
posted @ 2021-09-28 10:25 learnnote 阅读(59) 评论(0) 推荐(0)
rman备份脚本
摘要：#!/bin/sh rman target / nocatalog msglog=/AAfile/AA_rman/AAdata/full_`date +%Y%m%d-%H%M%S`.log << EOF run {allocate channel c1 type disk;allocate chan 阅读全文
posted @ 2021-09-15 11:46 learnnote 阅读(83) 评论(0) 推荐(0)
oracle导出mysqldump脚本
摘要：#!/bin/sh FILE_DATE=`date '+%Y%m%d-%H%M%S'`DUMP_DIR=/u01/backupSAVED_DAY=7SAVED_DAY2=2DUMP_FILE=$DUMP_DIR/AAA_$FILE_DATE.dmpDUMP_FILElog=$DUMP_DIR/AAA 阅读全文
posted @ 2021-09-15 11:43 learnnote 阅读(96) 评论(0) 推荐(0)
oracle慢sql
摘要：select * from (select sa.SQL_TEXT, sa.SQL_FULLTEXT, sa.EXECUTIONS "执行次数", round(sa.ELAPSED_TIME / 1000000, 2) "总执行时间", round(sa.ELAPSED_TIME / 1000000 阅读全文
posted @ 2021-09-15 10:23 learnnote 阅读(150) 评论(0) 推荐(0)
prepare SQL 格式
摘要：set @s = 'SELECT * FROM employees WHERE emp_no = ?'set @a = 100000;PREPARE stmt FROM @s;EXECUTE stmt USING @a;DEALLOCATE PREPARE stmt; 阅读全文
posted @ 2021-09-14 14:05 learnnote 阅读(69) 评论(0) 推荐(0)
mysql建表规范
摘要：1.建议主键创建 bigint 2. signed选择有负号的（不推荐使用unsigned，可能出现溢出现象）3. auto_increment （重启实例，auto_increment可能回溯） 小数1.建议使用decimal（float，double精度不够） rand函数(插入测试数据）rep 阅读全文
posted @ 2021-09-09 10:59 learnnote 阅读(101) 评论(0) 推荐(0)
dataguard从库断电
摘要：准备工作 iptables -L setenforce 0 lsnrctl start 备库启动遇到问题 SQL> startup ORA-10458: standby database requires recovery ORA-01196: file 1 is inconsistent due 阅读全文
posted @ 2021-09-08 13:08 learnnote 阅读(61) 评论(0) 推荐(0)
mysql多实例，mysqld_multi
摘要：mysql单机多实例 [mysqld_multi]mysqld=/usr/local/mysql/bin/mysqld_safemysqladmin=/usr/local/mysql/bin/mysqldadminlog=/usr/local/mysql/mysqld_multi.log [mysq 阅读全文
posted @ 2021-09-07 10:25 learnnote 阅读(45) 评论(0) 推荐(0)
mysql的参数文件 my.cnf
摘要：# author: jiangchengyao[client]user = rootpassword = 1111aaA_ [mysql]prompt = [\\u@\\p][\\d]>\\_no-auto-rehash [mysqld_safe]malloc-lib=tcmalloc [mysql 阅读全文
posted @ 2021-09-03 16:21 learnnote 阅读(83) 评论(0) 推荐(0)
linux同步修正时间
摘要：server： 1. yum -y remove ntpdate && yum install ntp -y 2. vim /etc/ntp.conf 3. systemctl restart ntpd 4. ntpstat && ntpq -pn client 操作 rm -f /etc/loca 阅读全文
posted @ 2021-09-03 11:29 learnnote 阅读(47) 评论(0) 推荐(0)
mysql升级步骤
摘要：1./etc/init.d/mysqld stop (关闭mysql进程） 2.备份 data（数据datadir）目录 3.用高版本的mysql安装目录（basedir）替换 低版本mysql安装目录 4.调整/etc/my.cnf 中的个别参数 5.启动mysqld_safe --user=my 阅读全文
posted @ 2021-09-02 16:11 learnnote 阅读(916) 评论(0) 推荐(0)
python编辑ftp客户端
摘要：# -*- coding: utf-8 -*- from ftplib import FTPimport osimport refrom datetime import datetime S_date = datetime.now().strftime("%Y%m%d")fnameRegex = r 阅读全文
posted @ 2021-09-02 15:26 learnnote 阅读(48) 评论(0) 推荐(0)