0

How can I get all the queries executed for a given time frame in a MySQL server?

I need this to monitor failures on a web service, which I suspect are caused by multiple operations blocking each other.

Pedro Montoto García
  • 1,672
  • 2
  • 18
  • 38

1 Answers1

0

You should enable General Log on a MySQL server to get all queries executed on a MySQL server. Slow log can be helpful in finding out problematic queries executed on MySQL server.

Refer existing answer mentioned here: MySQL : Monitor Queries

Community
  • 1
  • 1
Mahesh Patil
  • 1,529
  • 1
  • 11
  • 22