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
Solved

how to check Apache, MySQL and general logs on CentOS

Posted on 2011-09-08
12
685 Views
Last Modified: 2012-05-12
Hi,
On a CentOS 5.x Server

1. How do I check Apache logs for a particular date? e.g. what was the peak of concurrent web requests on this date?

2. MySQL logs for a particular date? i.e.  a list of queries that were running at the time that the load spiked.

3. On a particular date, The traffic was very high and server became non responsive, so to identify what was the bottle neck, how do I check what was the system condition before it became non responsive, using logs?

Thanks
0
Comment
Question by:rajoo_sharma
  • 4
  • 3
  • 2
  • +1
12 Comments
 
LVL 21

Expert Comment

by:Papertrip
ID: 36507930
0
 
LVL 38

Accepted Solution

by:
wesly_chen earned 500 total points
ID: 36508123
1. /var/log/httpd/access_log*
But double check your httpd.conf
grep  CustomLog   /etc/httpd/conf/httpd.conf

2. check the start script for mysqld
egrep  '--log|general_log'   /etc/init.d/mysqld
Usually, by default, the query is not enabled for MySQL.

3. use sar (System Activity Reporter)
It is included in sysstat package
yum  install  sysstat
After a couple minutes or hours(to collect data), then
sar -n DEV   #gives network device stats
0
 
LVL 7

Expert Comment

by:boon86
ID: 36509156
cd /var/log

use: cat <filename>
0
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.

 
LVL 7

Expert Comment

by:boon86
ID: 36509163
here is you search some keyword inside the log:

use: cat abc.log | grep <my keyword>
0
 

Author Comment

by:rajoo_sharma
ID: 36509194
Thanks guys, I'll check and get back.
0
 
LVL 38

Expert Comment

by:wesly_chen
ID: 36511026
2. for log setting, also check /etc/my.cnf
grep  ^log  /etc/my.cnf


3. for more usage details, do
man sar
   sar can report certain period of time.
0
 
LVL 21

Expert Comment

by:Papertrip
ID: 36900837
Hi Rajoo,

Were we able to help resolve this question?
0
 
LVL 7

Expert Comment

by:boon86
ID: 36901401
0
 
LVL 7

Expert Comment

by:boon86
ID: 36901406
ops wrong post
0
 

Author Comment

by:rajoo_sharma
ID: 37205369
Hey guys, apologies for such a delayed response, actually I couldn't check anything since we were terribly stuck in something else. I'll check in a day or two and get back to you again.

Thanks and Regards
0
 

Author Closing Comment

by:rajoo_sharma
ID: 37404955
sysstat gives me what I want, though there were issues and it could not generate the graphs.
So we finally installed Munin and its generating graphs.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
lunix and unix command 21 86
MySQL - need to join three tables 2 46
Syslog-ng works. Now what? How to filter and manage? 8 62
Generate PDF from MySQL using PHP 3 16
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Fine Tune your automatic Updates for Ubuntu / Debian
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

839 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