aaooo54 wrote :

> how to monitor dynamic performance of mysql server w/o enterprise monitor? I
> mostly works in command line client and there is no chance to install third
> party monitors. Based on SHOW GLOBAL STATUS I have information about general
> status of server but I have lack of information about current processes. Is
> any magic query to meet my needs?

To get current state of running queries use "SHOW FULL PROCESSLIST;",
but I'm sure you already heard about it, isn't it ?

If you use InnoDB engine, you also could try "SHOW INNODB STATUS;" that
gives precious realtime informations about engine state.

Don't forget OS specific monitoring tools about CPU, I/O and memory
usage, that could be ful at time.

--
Hugo