• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

I have a problem the slow query log is not working with mysql 5.0.45

Dear Sir/Madam
I cannot active the slow log query in mysql.  I am using windows XP professional and mysql 5.0.45. I add to my.ini the following setting:
log_slow_queries=c:/Program Files/MySQL/MySQL Server 5.0/data/slow_query.log

But I was confuesed while I am searching on the internet some examples using log_slow_queries and others log-slow-queries.  So which I have to user dash ( - ) or underscore ( _ ) .
Thank you
1 Solution
UmeshMySQL Principle Technical Support EngineerCommented:
It's log-slow-queries


It seems your path for slow query log includes space... pls include the path in double quote and restart the server...

log-slow-queries="c:/Program Files/MySQL/MySQL Server 5.0/data/slow_query.log"
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now