Louis Liu – Page 11 – Louis workspace

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

Updated on December 22, 2014 by Louis Liu

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 GN[......]Read more

MySQL AWR – Myawr

Updated on December 22, 2014 by Louis Liu

noodba同学写的基于mysql的 WORKLOAD REPOSITORY工具,目前还没有开源非常的给力！！

主要思想为一台管理机器,集中了所有client端的数据,client 为mysql database 使用host_id来区分如 host_id=1代表mysql databas[……]

linux tools part 7– Monitor socket activity

Updated on December 22, 2014 by Louis Liu

systemtap发行版本提供了socktop,用于监控socket套接字之间的通信,具体如下：

[root@db-42 ~]# socktop -h
USAGE: socktop [-d] [-i interval] [-N num] [-P protocol]... [-f family].[......]Read more

Optimizer in Oracle 11g by wwf.

Updated on December 22, 2014 by Louis Liu

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

Optimizer in oracle 11g by wwf from ebay COC from Louis liu

[……]

PCIE performance test — LSI vs FusionIO vs VIRI

Updated on December 22, 2014 by Louis Liu

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

Reference:fio parameter setting[……]

基于MHA 的MySQL高可用方案

Updated on December 22, 2014 by Louis Liu

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

基于Mha的my sql高可用方案 from Louis liu

[……]

gdb 调试TPCC 一例

Updated on December 22, 2014 by Louis Liu

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

linux tools part 6– network Monitoring (2)

Updated on December 22, 2014 by Louis Liu

基于上次的nicstat linux还提供了nethogs,可以监控指定pid的具体流量,在这里可以下到源码.

获取过程：

open("/proc/$pid/fd")
open("/proc/net/tcp")
open("/proc[......]Read more

Update exadata flash disk firmware due to poor performance on X2-2

Updated on December 22, 2014 by Louis Liu

ASR XD报警抛出如下错误

" dm01cel02: Hardware Error has been detected in the Flash Logs on the Cell Node dm01cel02: Please open up a Service Request[......]

linux tools part 5– Trace network information

Updated on December 22, 2014 by Louis Liu

Nmap (“Network Mapper”) is an open source tool for network exploration and security auditing. It was designed to rapidly scan large networks, although[……]

Read more