VMCD.ORG

[oracle@db-42 ~]$ unzip p13262857_112030_Generic.zip 
[oracle@db-42 ~]$ cd 13262857/
[oracle@db-42 13262857]$ ora si 

SQL*Plus: Release[......]Read more

linux tools part 8– Monitoring Reads and Writes to a File and device

May 13, 2013 linux, system No comments linux tools

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

MySQL AWR – Myawr

May 6, 2013 Architecture, MYSQL, performance No comments mysqlawr

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

linux tools part 7– Monitor socket activity

April 23, 2013 linux, system No comments linux tools

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