LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
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.

Notices

Reply
 
Search this Thread
Old 09-04-2007, 08:50 PM   #1
Swakoo
Member
 
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?

thanks!
 
Old 09-07-2007, 12:52 PM   #2
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 197Reputation: 197
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..
 
  


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 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 03:04 PM.

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