Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-19
1
Medium Priority
?
421 Views
Last Modified: 2012-05-05
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:
set-variable=long_query_time=1
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
0
Comment
Question by:nabil_zakkak
1 Comment
 
LVL 26

Accepted Solution

by:
Umesh earned 150 total points
ID: 22755776
It's log-slow-queries

http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

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"
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL several years ago, it seemed like now was a good time to update it for object-oriented PHP.  This article does that, replacing as much as possible the pr…
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question