MySQL Query Analyzer查询分析器

MySQL Query Analyzer查询分析器

 

Query Analyzer Use Cases Developers and QA Profile and tune SQL code while in development Enabled at all times during QA DBAs/Sys Admins Enabled at all times in production (may be limited) Sampling of production query stream during non-peak hours via application port swapping

 

 

 

 

图解Oracle Checkpoint Queue

图解Oracle Checkpoint Queue

 

Checkpoint queues contain the dirty buffers that are ordered by the low RBA. There is one file queue per data file containing: Dirty buffers belonging to that file Delayed logged buffers Linking buffer to checkpoint queue: Whenever the low RBA is set for a buffer, the buffer is added to tail of the CKPTQ and appropriate FQ. Removal of buffer from checkpoint queue: The low RBA is cleared when the buffer is added to write batch. When the buffer is written to disk, it is unlinked from the FQ and CKPTQ. Write of hot buffers from CKPTQ is deferred.

图解Oracle 11g physical standby Rolling Upgrade物理备库滚动升级特性

图解Oracle 11g physical standby Rolling Upgrade物理备库滚动升级特性 11g Rolling Database Upgrades Using Transient Logical Flow:

 

MySQL企业版VS社区版

MySQL企业版VS社区版 MySQL Enterprise vs Community Server

 

 

Oracle、MySQL、SQL Server架构大对比

Oracle、MySQL、SQL Server架构大对比：

 

MySQL Enterprise Monitor架构图

MySQL Enterprise Monitor架构图 Enterprise Monitor Architecture

 

图解MySQL Replication的几种拓扑

图解MySQL Replication的几种拓扑 MySQL Replication Topologies

图解揭秘Oracle Buffer Header数据结构

X$BH V$BH? Oracle里 的Buffer Header到底是这样的数据结构， 保存了哪些buffer属性？

图解揭秘Oracle Buffer Header数据结构， Buffer header记录了lru chain 、 Hash bkt、User List、 Waiter List、flags、TSN、afn、dba、buffer address、CR env、lock element等信息：

 

 

Oracle DBA学习路径图

Oracle DBA学习路径图

 

Oracle Shared pool内存管理图解

Oracle Shared pool内存管理图解， 解释了包括 Heap、Extent、reserved List、Free List、bucket、chunk这几个概念：

 

 

shared pool 原理还可以参考下这个帖子：http://t.askmaclean.com/thread-272-1-1.html

Blogroll

« Older posts
Newer posts »