Category: system

JKDB PLATFORM – our company’s data management platform

In this post, we introduce backup-restore module,focus on automatic backup and restore in a[……]

Read more

We test Facebook WDT tool:https://github.com/facebook/wdt

Read this PDD: WDT-TEST[……]

Read more

We build a strong log-collection system to analyze total logs of our operation teams (including system ,database, web service ,load balance ,audit, ca[……]

Read more

We build this system based on Inception (Qunar)。

All of MySQL DDL/DML operations are based on Donkey system, with strict approval process to keep o[……]

Read more

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

Read more

We could use inotify-tools to monitor file or directory IO state

yum install inotify-tools

#inotifywait -m /storage/sas/mysql3306/data/diab[……]

Read more

Reprint a PDF for MySQL Injection Test

MySQL Error Based SQL Injection Using EXP[……]

Read more

how to use percona-tookit to verify mysql data

Read this PDF : mysql_checksum[……]

Read more

MySQL Tcpdump system : use percona-toolkit to analyze network packages

We can identify problem SQLs with high execution frequency.

With DBMON s[……]

Read more

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