Hi,
I don't know how many people have perl actually installed in /usr/local/bin/perl but it may be more convenient for the masses if this would point to /usr/bin/perl .

When I just run ./myq_status I got:
$ ./myq_status
Mode must be one of 'myisam', 'commands', 'qcache', 'cttf', 'throughput', 'query', 'temp', 'handler'


When I run e.g.

 $ ./myq_status -unknown
Unknown option: unknown
myq_status [-t <secs>] [-u user [-p [pass]]] [-h host] [-P <port>] [myisam|commands|qcache|cttf|throughput|query|temp|handler]

I also get the help. I think would be nice if the help is also displayed in the first case.


What do you think about making -p accept the password like mysql, only when directly appended? Because if not it makes the following fail:

$ ./myq_status -u root -h db01 -p myisam
Mode must be one of 'myisam', 'commands', 'qcache', 'cttf', 'throughput', 'query', 'temp', 'handler'

It needs to be written like this
$ ./myq_status -u root -h db01 -p -- myisam


Of course I also didn't pay attention once I got past the arguments that I didn't had mysql client binaries installed on this vhost. I think it would be nice to give a nicer error message then this:
$ ./myq_status -u root -h db01 -p -- myisam
Password:
sh: mysql: command not found

Next bump was that my password contained a '$'. This confused the mysql_call which generates a shell command which doesn't protect against such characters. Modifying the source and quoting with '--password=icontaina$' worked.

I tried with five seconds interval and got the message:
$ ./myq_status -t 5 -u root -h db01 -p -- myisam
Repeat time must be at least than 15 seconds

English is not my native language but I think this should read something along "Repeat time must be at least 15 seconds" ?

Btw, I would really appreciate a smaller amount of seconds, on busy server 15 seconds may be too much already.

During my password problem I had to manually set $DEBUG in MySQL_Script_Utils.pm to 1. It would be nice if this could be turned on with kind of verbose switch, e.g. -v .

I really like such small tools, gives a nice comprehensive overview. Thanks!