摘要：
mysql shell 执行脚本 #!/bin/bash export PATH=/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/mysql-5.6/bin:/usr/local/mysql/bin mysql -H -uroot -p'mysqlpass' -S /ssd/mysql/3306/tmp/mysql.sock <<EOF use... 阅读全文
摘要：
使用工具pt-table-checksum: 数据不同步的处理: 阅读全文
摘要：
使用工具pt-online-schema-change 阅读全文
摘要：
#!/bin/bash #by sk 备份解码脚本 echo "-------------------------------------------------" function getdir(){ #echo $1 for file in $1/* do if test -f $file then echo $file ... 阅读全文
摘要：
#!/usr/bin/env python # encoding: utf-8 #@author: 东哥加油 #@file: sthread.py #@time: 2018/9/17 17:07 import threading import time import pymysql exitFlag = 0 def get_conn48(): conn = None tr... 阅读全文
摘要：
#!/usr/bin/env python # encoding: utf-8 #@author: 东哥加油! #@file: clear_pool.py #@time: 2018/8/28 17:06 from rediscluster import StrictRedisCluster import datetime import sys def redis_cluster(): ... 阅读全文
摘要：
#!/usr/bin/env python # encoding: utf-8 #@author: 东哥加油! #@file: sksendmail.py #@time: 2018/8/20 13:37 import smtplib from email.mime.image import MIMEImage from email.mime.multipart import MIMEMult... 阅读全文
摘要：
#!/usr/bin/env python # encoding: utf-8 #@author: 东哥加油! #@file: log_analyze.py #@time: 2018/8/23 17:15 import pandas as pd import re import time import datetime def tj_log_to_excel(from_file_nam... 阅读全文
摘要：
#!/usr/bin/env python # encoding: utf-8 #@author: 东哥加油! #@file: del_tb_bigtable_statistic.py #@time: 2018/11/21 15:39 import pymysql import datetime import math import time #获取连接 def get_conn():... 阅读全文
摘要：
mysql 3306 主库配置文件 [client] port = 3306 default-character-set=utf8mb4 socket = /ssd/mysql/3306/tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] secure_fil... 阅读全文