Visit the LQ Articles and Editorials section
Go Back > Forums > Linux Forums > Linux - General
User Name
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.


  Search this Thread
Old 09-04-2007, 08:50 PM   #1
Registered: Apr 2005
Distribution: Red Hat / Fedora / CentOS
Posts: 508

Rep: Reputation: 30
Spike in load for dB server

Hi guys,

I have a database server running on RHEL4, MySQL4. Its main application is for vbb.
Recently there are sparodic spikes in load (goes all the way to 100+!) but I can't seem to trace the problem...

the application-front is run on 4 webservers in a load-balanced farm.
Could it be a bottleneck in between?

what other ways can i try to trace the problem?

Old 09-07-2007, 12:52 PM   #2
LQ Guru
Registered: Jan 2001
Posts: 24,147

Rep: Reputation: 229Reputation: 229Reputation: 229
Well first of all, when it occurs, you need to find out what application is causing the load. Is it only MySQL basically running on this machine? Any other applications? Have you done any performance tuning on the database? How much memory, CPU? How many users hit the front end servers that hit the database at any given time? Is it at the same time these spikes occur? Is it any type of cron jobs running that could be causing the problems?

More details get better responses, without specific details, we're just as lost as you are working in the dark..


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 On
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Traffic Spike Related To Port Scan? bbonifield Linux - Security 9 06-20-2007 04:15 PM
Weird Spike On Mrtg Graphs debloxie Linux - Networking 3 06-06-2006 04:38 AM
KDE had CPU 'spike' every 15seconds! HELP! dezireduser Linux - General 13 11-26-2005 04:22 AM
Spike in outbound traffic- where to look? htmlcoder Linux - Security 3 03-19-2005 03:13 PM
Moving mouse makes xorg CPU spike to 40% or more tripmix Linux - Newbie 2 12-19-2004 06:06 AM

All times are GMT -5. The time now is 05:44 AM.

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