Web Hosting Forum | Lunarpages
News: October 6, 2008 - Submit Your Site for the October 2008 Site of the Month!
 
*
Welcome, Guest. Please login or register.
Did you miss your activation email?
October 12, 2008, 09:22:19 PM


Login with username, password and session length


Pages: [1]   Go Down
  Print  
Author Topic: Mysql Slow Query Log  (Read 336 times)
Jordo1
Trekkie
**
Offline Offline

Posts: 11


« on: August 31, 2006, 09:24:37 PM »

How do you view the slow query log?  I've been searching forever, but can't find it.  Can't find my.cf either.  In fact, everywhere the mysql documentation says things are, it isn't on my dedicated server, and find isn't finding it.
Logged
perestrelka
Administrator
Master Jedi
*****
Offline Offline

Posts: 1058



« Reply #1 on: August 31, 2006, 09:50:04 PM »

Hi,

my.cnf might not be installed by default. MySQL just uses default configuration values unless you create or copy one of predefined configs to /etc/my.cnf.

Slow query log is disabled by default and if you need to enable it add the following in the /etc/my.cnf and then restart MySQL:

Code:
--log-slow-queries[=file_name]

If no file_name value is given, the default is the name of the host machine with a suffix of -slow.log. If a filename is given, but not as an absolute pathname, the server writes the file in the data directory.

I hope this helps.
Logged

Kind Regards,
Vlad Artamonov
Jordo1
Trekkie
**
Offline Offline

Posts: 11


« Reply #2 on: September 01, 2006, 11:44:11 AM »

Thanks, for the response.  It did help.
Logged
perestrelka
Administrator
Master Jedi
*****
Offline Offline

Posts: 1058



« Reply #3 on: September 01, 2006, 09:38:49 PM »

I'm glad to hear I was able to help you. Please don't hesitate to ask should you require any further assistance.

Have a good day!
Logged

Kind Regards,
Vlad Artamonov
Pages: [1]   Go Up
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.6 | SMF © 2006-2008, Simple Machines LLC

Valid XHTML 1.0! Valid CSS! Dilber MC Theme by HarzeM