LinuxQuestions.org
LinuxAnswers - the LQ Linux tutorial section.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices



Reply
 
Search this Thread
Old 01-30-2011, 01:24 AM   #1
listener_it
LQ Newbie
 
Registered: Jan 2011
Posts: 11
Blog Entries: 1

Rep: Reputation: 0
Need Suggestions to improve performance of the linux server


Hi All,

We are using centos in our machines but two of the linux boxes are performing very slow, while restoring the mysql database it tooks huge time to complete.

Can someone pls advice what we can do to find out the problem with the slow performance?
 
Old 01-30-2011, 03:49 AM   #2
goodhombre
Member
 
Registered: Mar 2010
Location: Ungheni, Rep. Moldova
Distribution: Ubuntu
Posts: 74

Rep: Reputation: 18
Hi,

Try to check if there are any errors in the mysql log file, for standard mysql-server centos package log file can be found in : /var/log/mysqld.log . Check /etc/my.cnf for more information.

Do you have performance issues only when a database restoration is performed?
 
Old 01-30-2011, 05:19 PM   #3
markhahn
LQ Newbie
 
Registered: Jan 2011
Posts: 12

Rep: Reputation: 3
checking for mysql-specific errors makes sense, but it seems like you'd notice if there were real problems. my first step is to run "vmstat 1" during the slow time. it lets you see, for instance, whether the problem is CPU (100% busy, no idle time), or memory (swapins means thrashing - swapouts are not inherently bad.) it also gives some idea of whether disk(s) are not keeping up ("wait" - processes that are blocked on IO.)

it would also be useful to know what you mean by "performing very slow" - do you mean interactive feel? or do you have some application which reports response times (such as a webserver)? it could also be that your configuration is simply inappropriate - any real analysis would need to know what you're running, and running on...
 
Old 02-02-2011, 02:49 AM   #4
listener_it
LQ Newbie
 
Registered: Jan 2011
Posts: 11
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Hi

The server itself is performing slow (While doing file compression, taking database dump) and during mysql database restoration it takes more time to complete than other systems. We use the server mainly as database server.
 
Old 02-02-2011, 06:06 PM   #5
markhahn
LQ Newbie
 
Registered: Jan 2011
Posts: 12

Rep: Reputation: 3
still to non-specific...

well, database activity and file compression could still reflect many things. for instance, some hardware will throttle the CPU when it overheats, which could happen if a fan dies or a heatsink becomes dislodged. OTOH both symptoms you mention are IO-based, so perhaps a disk is sick (disks can get very slow as they're failing, for instance.) you've verified it's not something simpler, like an out-of-control daemon using all the CPU or memory?
 
Old 02-07-2011, 11:44 AM   #6
listener_it
LQ Newbie
 
Registered: Jan 2011
Posts: 11
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Hi Mark

Thanks for the reply, I will go ahead and check the disk status, but noticeable point is that the same problem is in 4 servers.
 
Old 02-07-2011, 02:52 PM   #7
Gecko
Member
 
Registered: Oct 2003
Location: Ohio
Distribution: Gentoo
Posts: 47

Rep: Reputation: 16
Quote:
Originally Posted by listener_it View Post
Hi Mark

Thanks for the reply, I will go ahead and check the disk status, but noticeable point is that the same problem is in 4 servers.
You aren't saying how large your databases are. Also, how much MEM/CPU/IO do you have available?

Databases eat resources, and generally when query tuning and scheduler aren't options, then you need to throw more RAM, CPU, and faster disk.
 
Old 02-19-2011, 04:07 PM   #8
listener_it
LQ Newbie
 
Registered: Jan 2011
Posts: 11
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Hi

Sorry for the late. Database size will be above 2 GB. but a fresh Linux box with no database also performing slow.

Seems kernel problem, the same kernel having pcs are performing slow but updating kernel also not worked.
 
Old 02-19-2011, 05:18 PM   #9
unSpawn
Moderator
 
Registered: May 2001
Posts: 27,795
Blog Entries: 54

Rep: Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981Reputation: 2981
I suggest you select one fast or faster performing server and a slow one. Collect hardware and configuration data. Install SAR or atsar, dstat or collectl and capture full stats for at least 48 hours. After comparing your next post then should then show the difference in systems hardware, configuration and performance-wise (or attach plain text files) because just saying "it's slow" without posting relevant data does not really help (most of us) help you in an efficient way.
 
Old 02-22-2011, 02:01 PM   #10
markseger
Member
 
Registered: Jul 2003
Posts: 241

Rep: Reputation: 25
It sounds like you have a bunch of servers, some of which perform well and others which don't. Perfect! Using the collectl-utility colmux, which I just released a couple of hours ago, you can monitor all the boxes as a set in real-time, sorting by memory usage, disk/network load, cpu or even process and/or nfs is that is part of the mix. Perhaps that will help identify what's different!

see - http://collectl-utils.sourceforge.net/colmux.html

-mark
 
Old 07-23-2011, 09:16 AM   #11
listener_it
LQ Newbie
 
Registered: Jan 2011
Posts: 11
Blog Entries: 1

Original Poster
Rep: Reputation: 0
Hi All,

My regret for not posting for a long time.

The problem is that the Hard disk drive which is installed in server is SATA but the disk detected in Linux OS was /dev/hda instead of /dev/sda. I change the settings of HDD to enchanced in BIOS. Now the HDD detects as /dev/sda and now it is performing faster as the other.
 
  


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
[SOLVED] Does scheduled reboot of server improve performance snjksh Linux - General 3 07-27-2013 04:27 PM
Suggestions to improve linux titanium_geek Linux - News 7 03-15-2005 09:40 PM
How to REALLY improve linux performance? tradingbr Linux - General 7 05-01-2004 12:38 PM


All times are GMT -5. The time now is 07:33 AM.

Main Menu
Advertisement
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