upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]
FlashCard Test Detail
[SHOUG] 1号店Exadata应用
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]
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[......]
基于MHA 的MySQL高可用方案
PCIE performance test — LSI vs FusionIO vs VIRI
Testing three PCIE cards’s performance for all of scenes using fio
Reference:fio parameter setting[……]
Optimizer in Oracle 11g by wwf.
By wwf from ebay COC about Optimizer in Oracle 11g.
[……]
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)[......]
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 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[......]