站内搜索
Loading
Recent Comments
Tag cloud
11g 11g new feature 2011-10-16 architecture asm bug database migrate dataguard datapump dead lock Exadata flashback High performance hint internal life linux tools LOB memory mysql mysqlawr NBU NBU测试 new life ORA-600 Oracle authentication oracle data oracle Install Oracle job rebuild index oracle lock oracle TNS oracle数据管理 oradebug pga RAC scripts sqlldr Stream structure test trouble shooting upgrade 备份恢复 恢复 物化视图Blogroll
How to control CF calculation
根据Richard Foote的文章,做了如下验证：
Ref：Clustering Factor Calculation Improvement and provide some control over DBMS_STATS index clustering factor computation
[oracle@db-42 ~]$ unzip p13262857_112030_Generic.zip [oracle@db-42 ~]$ cd 13262857/ [oracle@db-42 13262857]$ ora si SQL*Plus: Release[......]
linux tools part 8– Monitoring Reads and Writes to a File and device
1.配合使用systemtap 监控系统对于文件的读写：
[root@db-42 systemtap]# uname -a Linux db-42 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux
[root@db-42 systemtap]# more inodewatch.stp
#! /usr/bin/env stap
probe vfs.write, vfs.read
{
# dev and ino are defined by vfs.write[......]
MySQL AWR – Myawr
noodba同学写的基于mysql的 WORKLOAD REPOSITORY工具,目前还没有开源 非常的给力！！
主要思想为一台管理机器,集中了所有client端的数据,client 为mysql database 使用host_id来区分 如 host_id=1代表mysql database 1,host_id=2 代表mysql database 2.
具体采集AWR过程如下：
[mysql@hadooptest2 myawr]$ perl myawrrpt.pl ===============================================[......]
linux tools part 7– Monitor socket activity
systemtap发行版本提供了socktop,用于监控socket套接字之间的通信,具体如下：
[root@db-42 ~]# socktop -h
USAGE: socktop [-d] [-i interval] [-N num] [-P protocol]... [-f family]...
[-t stype]... [-n pname]... [-p pid]... [-u username]... [-h]
-d # print network device traffic (default: off)[......]
Optimizer in Oracle 11g by wwf.
By wwf from ebay COC about Optimizer in Oracle 11g.
PCIE performance test — LSI vs FusionIO vs VIRI
Testing three PCIE cards’s performance for all of scenes using fio
Reference:fio parameter setting
gdb 调试TPCC 一例
TPCC对mysql 5.5.27做一次性能测试时遭遇 Segmentation fault,gdb调试记录之:
[root@db-81 ~]# uname -a Linux db-81 2.6.18-194.el5 #1 SMP Mon Mar 29 22:10:29 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux [root@db-81 ~]# more /proc/meminfo |grep Total MemTotal: 49455412 kB HighTotal: 0 kB LowTotal: 49[......]
linux tools part 6– network Monitoring (2)
基于上次的nicstat linux还提供了nethogs,可以监控指定pid的具体流量,在这里可以下到源码.
获取过程：
open("/proc/$pid/fd")
open("/proc/net/tcp")
open("/proc/net/tcp6")
open("/etc/passwd")
eg:
[root@db-81 27274]# nethogs -d 5 NetHogs version 0.7.snapshot PID USER PRO[......]
