README
¶
pstop
pstop - a top-like program for MySQL
pstop is a program which collects information from MySQL 5.6+'s performance_schema database and uses this information to display server load in real-time. This should also work for MariaDB 10.0 though I have not tested this at all. Data is shown by table or filename and the metrics also show how this is split between select, insert, update or delete activity.
This program was started as a simple project to allow me to learn go, which I'd been following for a while, but hadn't used in earnest. This probably shows in the code so suggestions on improvement are most welcome.
Access to MySQL is currently via a defaults-file which is assumed to be ~/.my.cnf. I should probably make this more configurable.
See also BUGS and NEW_FEATURES which describe things that probably need looking at, keys.txt which describes the keys used inside pstop, and screen_samples.txt which provides some sample output from my own system.
Feedback and patches welcome.
Simon J Mudd sjmudd@pobox.com
Documentation
¶
Overview ¶
Top like progream which collects information from MySQL's performance_schema database.
Source Files
Directories
¶
| Path | Synopsis |
|---|---|
|
package lib - common routines for pstop logger - minimal logger shared by everyone
|
package lib - common routines for pstop logger - minimal logger shared by everyone |
|
performance_schema - library routines for pstop.
|
performance_schema - library routines for pstop. |
|
file_summary_by_instance
performance_schema - library routines for pstop.
|
performance_schema - library routines for pstop. |
|
ps_table
This file contains the library routines for managing the table_lock_waits_summary_by_table table.
|
This file contains the library routines for managing the table_lock_waits_summary_by_table table. |
|
table_io_waits_summary_by_table
performance_schema - library routines for pstop.
|
performance_schema - library routines for pstop. |
|
table_lock_waits_summary_by_table
This file contains the library routines for managing the table_lock_waits_summary_by_table table.
|
This file contains the library routines for managing the table_lock_waits_summary_by_table table. |
|
This file configures the screen, basically remembering the size and foreground and background colours.
|
This file configures the screen, basically remembering the size and foreground and background colours. |
|
lib - library routines for pstop.
|
lib - library routines for pstop. |