We build a strong log-collection system to analyze total logs of our operation teams (including system ,database, web service ,load balance ,audit, ca[……]
March 10, 2017 Architect, system No comments
We build a strong log-collection system to analyze total logs of our operation teams (including system ,database, web service ,load balance ,audit, ca[……]
February 17, 2017 Architect, Architecture, maintain, MYSQL, system No comments
September 21, 2016 Architecture, MYSQL, redis, system No comments
I found a useful tool named sniffer to help us analyze network packages (this tool can capture packages on specific port)
I use sniffer to analyze[……]
December 28, 2015 system No comments
We could use inotify-tools to monitor file or directory IO state
yum install inotify-tools
#inotifywait -m /storage/sas/mysql3306/data/diab[……]
August 24, 2015 Internals, linux, MYSQL, rdbms No comments
August 19, 2015 MYSQL, replication, system No comments
July 24, 2015 Architect, Architecture, Internals, MYSQL, network, system No comments
MySQL Tcpdump system : use percona-toolkit to analyze network packages
We can identify problem SQLs with high execution frequency.
With DBMON s[……]
April 24, 2015 system No comments
We can use iopp tool to monitor process io performance
download from github : https://github.com/markwkm/iopp
pid: The process id. rchar: The num[......]
March 13, 2015 system No comments
Today I read a nice article , which give a new design for mysql database . In this article , Author (Mr.lou) uses OneSQL (a branch of MySQL) for the[……]
July 17, 2014 migration, oracle, system, unix No comments architecture
You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码[……]