CODEWITHSUNDEEP
mysqlprofiling
Vinicius Rocha
Vinicius Rocha

Reputation: 4243

Does mysql profiling tool can work to monitor a different connection?

MySQL 5 comes with a profiling tool that I can enable using "set profiling = 1", the problem is that one connection cannot monitor "queries" from another connection. Is there a way to enable that?

mysql> set profiling=1;
mysql> show profiles;

Upvotes: 1

Views: 538

Answers (1)

Daniel Luca CleanUnicorn
Daniel Luca CleanUnicorn

Reputation: 1097

You can profile your queries by modifying your wrapper functions and logging the queries.

With MySQL 5 you can turn on slow query logging if you wish. http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Upvotes: 1

Related Questions