Please recommend MySQL Profiler (preferably free)

Question

I tried "Jet Profiler for MySQL" but I didn’t like it

Answer 1

One graphical profiler for mysql is Jet Profiler. see review

Answer 2

SHOW PROFILES or EXPLAIN are directly available in MySQL and provide tons of information.

I guess some MySQL gui will be able to represent it graphically ...

: phpMyAdmin , , .

Answer 3

EXPLAIN mysql?

Answer 4

MySQL, /etc/mysql/my.cnf Ubuntu. , " "

# * Logging and Replication
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.

log = /var/log/mysql/mysql.log

mysql, OUT

general_log_file        = /var/log/mysql/mysql.log
general_log             = 1
log_error                = /var/log/mysql/error.log

"log", . MySQL :   sudo/etc/init.d/mysql restart

Now we were ready to begin monitoring requests as they arrived. Open a new terminal and run this command to scroll through the log file, adjusting the path if necessary.

tail -f /var/log/mysql/mysql.log