Solved

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

Posted on 2008-10-19
1
417 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 26

Accepted Solution

by:
Umesh 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

How Blockchain Is Impacting Every Industry

Blockchain expert Alex Tapscott talks to Acronis VP Frank Jablonski about this revolutionary technology and how it's making inroads into other industries and facets of everyday life.

Question has a verified solution.

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

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 This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

627 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