LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices

Reply
 
Search this Thread
Old 01-06-2005, 04:29 AM   #1
myheart
LQ Newbie
 
Registered: Oct 2004
Posts: 17

Rep: Reputation: 0
where can i find mysql log file


where can i find mysql log file ?
i using mandrake 10.0 and mysql 4.0.18
 
Old 01-06-2005, 05:28 AM   #2
PBSchmidt
Member
 
Registered: Aug 2004
Location: Aachen, Germany
Distribution: Debian Sarge
Posts: 129

Rep: Reputation: 15
should be in
Code:
/var/log (files mysql.log and mysql.err)
and
Code:
/var/log/mysql/ (rotated logs)
but not sure about Mandrake, though...

HTH, Peter
 
Old 01-06-2005, 06:19 AM   #3
myheart
LQ Newbie
 
Registered: Oct 2004
Posts: 17

Original Poster
Rep: Reputation: 0
thanks.. but i already look in there
anyway thank u for ur reply
 
Old 01-06-2005, 06:28 AM   #4
PBSchmidt
Member
 
Registered: Aug 2004
Location: Aachen, Germany
Distribution: Debian Sarge
Posts: 129

Rep: Reputation: 15
Did you check the comand-line options of mysqld? You can see them in
Code:
ps -ax|grep mysqld
If there is an option "-log=(somefilenamehere)" this tells you where the log goes ... otherwise, check the my.cnf (located in /etc/mysql/my.cnf), this is another place where the log output can be redirected.

HTH,

Peter
 
Old 01-06-2005, 07:49 AM   #5
myheart
LQ Newbie
 
Registered: Oct 2004
Posts: 17

Original Poster
Rep: Reputation: 0
i already found mysql log file... it in /var/lib/mysql, but it changed to hostname.err ...that why i cannot found it at first......
i need to see the log because my apache always hang, in the error it say "server reached MaxClients setting" and i suspect it had something to do with mysql service .... do u have any idea ?...
and thanks for ur post......

HHH
 
Old 01-06-2005, 08:37 AM   #6
PBSchmidt
Member
 
Registered: Aug 2004
Location: Aachen, Germany
Distribution: Debian Sarge
Posts: 129

Rep: Reputation: 15
not a clue. How do you access MySQL, by php? PEAR? Anyway, I found the point-and-click MySQLAdministrator very useful to monitor SNAFUs like that... Mybe that may help you a bit..

Cheers & Heads up,

Peter
 
Old 01-07-2005, 04:36 AM   #7
myheart
LQ Newbie
 
Registered: Oct 2004
Posts: 17

Original Poster
Rep: Reputation: 0
i use phpmyadmin..... but still not very good at it
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL: Log and Conf file Swakoo Linux - General 5 11-11-2005 06:28 PM
Where to find the proper log file? mykrob Suse/Novell 1 10-27-2004 10:12 AM
what log file generator that support squid log? heero82 Linux - Software 2 07-11-2003 08:52 PM
Does Linux write what happens at boot to a file ? I can't find anything in var/log . lostboy Linux - General 8 05-07-2003 02:58 PM
iptables, changing log file from /var/log/messages acid2000 Linux - Networking 3 03-11-2003 08:38 PM


All times are GMT -5. The time now is 02:53 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration