func usage() {
fmt.Println(lib.MyName() + " - " + lib.Copyright())
fmt.Println("")
fmt.Println("Top-like program to show MySQL activity by using information collected")
fmt.Println("from performance_schema.")
fmt.Println("")
fmt.Println("Usage: " + lib.MyName() + " <options>")
fmt.Println("")
fmt.Println("Options:")
fmt.Println("--anonymise=<true|false> Anonymise hostname, user, db and table names")
fmt.Println("--count=<count> Set the number of times to watch")
fmt.Println("--defaults-file=/path/to/defaults.file Connect to MySQL using given defaults-file")
fmt.Println("--help Show this help message")
fmt.Println("--host=<hostname> MySQL host to connect to")
fmt.Println("--interval=<seconds> Set the default poll interval (in seconds)")
fmt.Println("--limit=<rows> Limit the number of lines of output (excluding headers)")
fmt.Println("--password=<password> Password to use when connecting")
fmt.Println("--port=<port> MySQL port to connect to")
fmt.Println("--socket=<path> MySQL path of the socket to connect to")
fmt.Println("--user=<user> User to connect with")
fmt.Println("--use-environment Connect to MySQL using a go dsn collected from MYSQL_DSN e.g. MYSQL_DSN='test_user:test_pass@tcp(127.0.0.1:3306)/performance_schema'")
fmt.Println("--version Show the version")
fmt.Println("--view=<view> Determine the view you want to see when " + lib.MyName() + " starts (default: table_io_latency")
fmt.Println(" Possible values: table_io_latency table_io_ops file_io_latency table_lock_latency user_latency mutex_latency stages_latency")
}
// DisplayHelp displays a help page on the screen
func (s *ScreenDisplay) DisplayHelp() {
s.screen.PrintAt(0, 0, lib.MyName()+" version "+version.Version()+" "+lib.Copyright())
s.screen.PrintAt(0, 2, "Program to show the top I/O information by accessing information from the")
s.screen.PrintAt(0, 3, "performance_schema schema. Ideas based on mysql-sys.")
s.screen.PrintAt(0, 5, "Keys:")
s.screen.PrintAt(0, 6, "- - reduce the poll interval by 1 second (minimum 1 second)")
s.screen.PrintAt(0, 7, "+ - increase the poll interval by 1 second")
s.screen.PrintAt(0, 8, "h/? - this help screen")
s.screen.PrintAt(0, 9, "q - quit")
s.screen.PrintAt(0, 10, "s - sort differently (where enabled) - sorts on a different column")
s.screen.PrintAt(0, 11, "t - toggle between showing time since resetting statistics or since P_S data was collected")
s.screen.PrintAt(0, 12, "z - reset statistics")
s.screen.PrintAt(0, 13, "<tab> or <right arrow> - change display modes between: latency, ops, file I/O, lock and user modes")
s.screen.PrintAt(0, 14, "<left arrow> - change display modes to the previous screen (see above)")
s.screen.PrintAt(0, 16, "Press h to return to main screen")
}
func usage() {
fmt.Println(lib.MyName() + " - " + lib.Copyright())
fmt.Println("")
fmt.Println("vmstat-like program to show MySQL activity by using information collected")
fmt.Println("from performance_schema without sent to stdout.")
fmt.Println("")
fmt.Println("Usage: " + lib.MyName() + " <options> [delay [count]]")
fmt.Println("")
fmt.Println("Options:")
fmt.Println("--defaults-file=/path/to/defaults.file Connect to MySQL using given defaults-file")
fmt.Println("--help Show this help message")
fmt.Println("--host=<hostname> MySQL host to connect to")
fmt.Println("--limit=<rows> Limit the number of lines of output (excluding headers)")
fmt.Println("--password=<password> Password to use when connecting")
fmt.Println("--port=<port> MySQL port to connect to")
fmt.Println("--socket=<path> MySQL path of the socket to connect to")
fmt.Println("--totals Only send the totals to stdout (in stdout mode)")
fmt.Println("--user=<user> User to connect with")
fmt.Println("--version Show the version")
fmt.Println("--view=<view> Determine the view you want to see when " + lib.MyName() + " starts (default: table_io_latency")
fmt.Println(" Possible values: table_io_latency table_io_ops file_io_latency table_lock_latency user_latency mutex_latency stages_latency")
}
