Real‑Time Linux & MySQL Monitoring with OrzDBA

OrzDBA is a monitoring script released by Taobao's DBA team, written in Perl, capable of real‑time monitoring of Linux system and MySQL‑related metrics.

Linux System Monitoring

Run the command: ./orzdba -sys The output shows current load, CPU usage, and swap status. Additional options let you view specific information:

System load – -l / --load CPU – -c / --cpu Swap space – -s / --swap Disk read/write – -d / --disk (requires a target disk, discoverable with the df command)

Network traffic – -n / --net (requires a target network interface, discoverable with ifconfig)

All information is sourced from the /proc filesystem, e.g., /proc/loadavg for load, /proc/stat for CPU, and /proc/diskstat for disk.

MySQL Information Monitoring

Run the command: ./orzdba -mysql The output displays common MySQL variables, statistics for INSERT/UPDATE/DELETE/SELECT, InnoDB hit rate, thread status, and MySQL traffic bytes.

The InnoDB hit rate is calculated as:

(Innodb_buffer_pool_read_requests - Innodb_buffer_pool_reads) / Innodb_buffer_pool_read_requests * 100%

Other parameters can be listed with the help option: ./orzdba -h MySQL metrics are obtained similarly to tools like mysqlreport, using SHOW VARIABLES for core variables and SHOW GLOBAL STATUS for status information.

OrzDBA combines system and database monitoring, though installation is a bit involved. The source can be checked out via SVN: svn co http://code.taobao.org/svn/orzdba/trunk The tool requires tcprstat , which is not bundled. It can be downloaded from:

http://github.com/downloads/Lowercases/tcprstat/tcprstat-static.v0.3.1.x86_64

Detailed installation steps are provided in the documentation.