I am looking for a way to log queries that are taking a while on a MySQL server v5.1.69. I am unsure whether or not to do this in the my.cnf file or the console of MySQL?
Is there a way to specify the time value that it would log these queries? Could the value be set under a second? I have been looking through MySQL documentation but no luck yet.
Thanks for viewing, I'll provide as much details as needed.