search

EasyEngine / feature-requests

A repo to track all feature requests on EasyEngine project using issue tracker.
5 stars 2 forks source link

Mysql Monitoring tools #29

Open harshadyeola opened 10 years ago

harshadyeola commented 10 years ago

Nice tool for monitoring mysql server activities Mytop

apt-get install mytop
harshadyeola commented 10 years ago

http://jeremy.zawodny.com/mysql/mytop/ https://github.com/jzawodn/mytop

enricodeleo commented 9 years ago

It's a useful and well known tool, but it's 6 years old script based on standard MySQL of that time... I wouldn't rely on it, I'd rather look for slow queries via built-in slow_query_log and mysqldumpslow (built-in as well).

rahul286 commented 9 years ago

Is there any modern alternative? Something which is based on mysql 5.6

enricodeleo commented 9 years ago

Well, I usually check slow_query_log (with a basic tail -f a for realtime-ish experience), but there are other solutions like Innotop that is even suggested by people at Percona.

ps I found a link that talks about the former approach I suggested: https://www.digitalocean.com/community/tutorials/how-to-use-mysql-query-profiling

rahul286 commented 6 years ago

Note to myself: need to check how it will work with docker