加载中
oracle table 一键迁移到mysql 与TiDB

oracle table 一键迁移到mysql 与TiDB python 脚本 ''' @author : hezhiyong @software: python 3.6 @filename: o2tm.py @time : 2021-3-25 15:18 @desc : Convert Oracle table to mysql o...

PG健康检查

一、 单个database中对象数 1. 查询pg_class对象数,pathman分区表数 select current_database(),(select count(1) from pg_class having count(1)>1000000) total_objects,(select count(1)...

mysql 异常信息收集

(一)数据库信息收集 1 .数据库连接信息 select * from information_schema.processlist; 2.数据库当前参数值 show global status; 3.锁信息 3.1 看事务等待状况: SELECT r.trx_id waiting_...

08/08 21:56
11
linux 传送文件方法

常见方法,使用 scp 或 rsync 此外还可以使用nc 与pv 命令: 在目标机器上启动 nc -l 3487|tar xvf - #3487 为监听端口 nc 192.168.1.4 5555 | pv | tar -zxf - 在源机器上执行: tar cvf - ...

07/14 00:07
11
Show engine innodb status 解读

1、启用 InnoDB Monitor 定期输出 2、innodb status分段详解 2.1. status头部 2.2. BACKGROUND THREAD 2.3. SEMAPHORES 2.4. LATEST FOREIGN KEY ERROR 2.5. LATEST DETECTED DEADLOCK 2.6. ...

06/25 22:42
0
MySQL常用配置变量和状态变量详解

MySQL常用配置变量和状态变量详解 本文档主要基于mysql 5.6.35和5.7.17版本编写,但在编写后期也加入了一些新版本特性相关的额参数:例如,MySQL 5.7.22以及8.0.x版本中的并行复制优化参数 ...

06/25 22:39
0
基于InnoDB的不同SQL语句锁

基于 https://dev.mysql.com/doc/refman/8.0/en/innodb-locks-set.html 学习笔记 读锁(locking read),即更新或删除SQL通常除会在执行过程中对扫描的每个索引记录加读锁。是否有WHERE条件过...

04/25 13:43
0
MySQL Connection Handling and Scaling

In this post we describe MySQL connections, user threads, and scaling. We hope that an increased understanding of how MySQL works will help application developers and system adm...

mysql 8.0.18基准性能测试

测试架构:mysql 单实例(如右图) 测试工具: sysbench 1.0.12 Mysql 版本:8.0.18 初始化表数量:32个表 初始化数据量:5kw 初始化整库大小:352G Os 版本: Red Hat Enterpris......

02/19 22:52
82
mysql 8.0.18 升级8.0.20

结论 通过测试验证得出结论: 1.mysql 8.0.18 升级8.0.20 较 8.0.16之前的版本更为简洁,直接安装好二进制软件后,使用8.0.20 二进制起库即可 2.从8.0.18升级到8.0.20 之后,不能回退 升级步...

01/23 23:05
575
Redis cluster跨机房双活架构测试

测试工具:redis-benchmark 测试版本:redis cluster 5.0.7 主机测试架构:三中心部署 1. 同一机房部署只部署了三个主节点(本次测试只是部署在同一主机上) 2.三中心部署:redis cluster 上...

postgresql 备份之-pg_basebackup

(一)创建基础备份 1 、配置可以基于时间点的备份与恢复(point-in-time recovery (PITR)): 1.1 postgresql.conf 中配置 wal_level = replica # used to be "hot_standby" in older vers...

01/05 13:48
1.4K
mysql binlog 分析工具

用于回滚工具: binlog2sql 分析问题工具: analysis_binlog(https://gitee.com/mo-shan/analysis_binlog) 介绍 分析binlog工具,现有功能: 1、基于业务表分析统计各个表的dml的次数。 2、各...

2020/12/27 22:36
139
oracle and mysql Data Type Mapping

Data Type Mapping MySQL / Percona Server have a number of data-types that is almost the same as Oracle but not as rich as compared to Oracle. But since the arrival of the 5.7.8 ...

2020/09/29 13:49
28
Migrating from Oracle to MySQL

With the loss of the Oracle Standard Edition One license, and the free Oracle Express Edition database stuck at the old 11g Release 2 from 2014, many smaller projects are consid...

2020/09/29 13:46
32
JedisPool资源池优化

参考 https://www.alibabacloud.com/help/zh/doc-detail/98726.htm#section-m2c-5kr-zfb https://gist.github.com/warrenzhu25/1beb02a09b6afd41dff2c27c53918ce7......

2020/09/17 14:58
67
Inside the 11g SQL Performance Analyzer (SPA)

SQL Performance Analyzer in Oracle Database 11g Release 1 The concept of SQL tuning sets, along with the DBMS_SQLTUNE package to manipulate them, was introduced in Oracle 10g as...

2020/09/12 20:58
18
Statistics (Cardinality) Feedback

What is Statistics Feedback? Statistics Feedback is the ability of the optimizer to automatically improves plans for repeated queries that have cardinality misestimates. The opt...

pg 优化器不走索引问题

现象 表上列有索引,但是单表基于有索引的列过滤查询不走索引 原因分析 1.有长事务在跑 2.设置old_snapshot_threshold 参数(默认为3h) 临时解决方案 kill 长事务 最终解决方案 把old_snaps...

2020/08/21 21:12
1.1K
mysql 8 innodb_buffer_pool_instances 参数选择

相关测试如下: How Many innodb_buffer_pool_instances Do You Need in MySQL 8? How Many innodb_buffer_pool_instances Do You Need in MySQL 8 With a CPU-Bound Workload?......

2020/08/17 09:09
390

没有更多内容

加载失败,请刷新页面

返回顶部
顶部