mytop monitor all databases

[Suurbier]

Does anyone know how to monitor all databases and not a specific database in mytop.

 

[SeLLeRoNe]

this is my own .mytop

user=da_admin
pass=da_admin_pass
host=localhost
db=mysql
delay=1
port=3306
socket=
batchmode=0
header=1
color=1
idle=1

And seem to me that check all dbs.

Regards

 

[Suurbier]

It works but it doesnt show queries, i see a lot of mysql processes. Maybe its not from a website in directadmin but something else. Is there a way to check this?

Thnx for you reply anyway!

 

[scsi]

Then what are you seeing?

It should be dumping show full processlist.

http://jeremy.zawodny.com/mysql/mytop/mytop.html
http://serverfault.com/questions/231734/mytop-doesnt-display-executed-queries

Im sure there are more guides around the internet.

 

[SeLLeRoNe]

Maybe is just too speedy on execute queries and u cant see them.

Regards

 

[zEitEr]

@Suurbier,

try this Jet Profiler for MySQL (http://www.jetprofiler.com/), free version is also available.