Hello,
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?
regards,
R

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

> To get current state of running queries use "SHOW FULL PROCESSLIST;",
> but I'm sure you already heard about it, isn't it ?
to be honest, I did not know that. it contains few informations, its a
better than nothing.
thank you Hugo.
R