Solved

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

Posted on 2008-10-19
1
414 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:
ushastry earned 50 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysql ide 10 45
paypal ipn to mysql 3 57
unable to insert record into a table 2 40
possible to record changes (trigger I think) msql 11 39
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

820 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