VMCD.ORG

根据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[......]

Read more

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[......]

Read more

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 

===============================================[......]

Read more

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)[......]

Read more

By wwf from ebay COC about Optimizer in Oracle 11g.

Testing three PCIE cards’s performance for all of scenes using fio

Reference:fio parameter setting

aaqwsh与select同学测试的MHA文档,另外基于这个HA方案公司应该会部署一些核心应用。另外提供之前的MHA测试

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[......]

Read more

基于上次的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[......]

Read more

ASR XD报警抛出如下错误

"
dm01cel02: Hardware Error has been detected in the Flash Logs on the Cell Node
dm01cel02: Please open up a Service Request with Oracle to resolve the Error
dm01cel02: View File /tmp/ASR-Flash-Fault-Check-Log for further Information of the Error
dm01cel02: This log File c[......]

Read more