The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Advanced & Expert Users
Google UNIX.COM


UNIX for Advanced & Expert Users Advanced UNIX and Linux questions go here. Expert-to-Expert.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
configur a remot acssas server in redhat linux sachinbhagat Linux 1 05-14-2008 12:22 AM
how to setup a virtual IP to control 2 server load for linux summerpeh Linux 0 01-17-2008 10:56 PM
down load file from unix server to Windows machine. chandu_kalari Linux 3 12-02-2007 10:39 AM
linux prog for server space, load etc arlan Security 1 07-28-2005 09:44 AM

Closed Thread
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-15-2003
Registered User
 

Join Date: Jun 2003
Posts: 10
Server load (Unix/Linux, Redhat, CPanel)

Hello,

I'm facing a big problem with my hosting server (Dual Xeon 2.4GHz), I'm having a load in the CPU usage and the memory (maybe it's related) ALSO mySQL:

Server Load 5.34 (2 cpus) (to 22 sometime)
Memory Used 68.4 % (to 70% sometime)

When I go to 'CPU/Memory/MySQL Usage' I found:

User Domain %CPU %MEM Mysql Processes

mysql 31.36 125.79 0.0
_____________________
Top Process %CPU 99.9 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.domain.com.pid --skip-locking
Top Process %CPU 92.0 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.domain.com.pid --skip-locking
Top Process %CPU 74.3 /usr/sbin/mysqld --basedir/ --datadir/var/lib/mysql --usermysql --pid-file/var/lib/mysql/hostname.domain.com.pid --skip-locking
______________________

NEED YOUR HELP PLEASE



Khalid
__________________
Regards,
Khalid
Forum Sponsor
  #2 (permalink)  
Old 09-15-2003
davidg's Avatar
Registered User
 

Join Date: Jul 2003
Location: Holland
Posts: 207
Hi,

Sorry to say, but this might be a good example of a bad structured MYSQL statement.
Please see your Admin for this.

Regs David
  #3 (permalink)  
Old 09-15-2003
Registered User
 

Join Date: Jun 2003
Posts: 10
I don't have admin for the server!
Could you please let me know what cause this issue?

Will it be solved if I upgade the RAM?
__________________
Regards,
Khalid
  #4 (permalink)  
Old 09-15-2003
davidg's Avatar
Registered User
 

Join Date: Jul 2003
Location: Holland
Posts: 207
Hi Khalid,

Nope. I think (from what I have seen), that there is an SQL-statement runing on a table which has not been indexed and might therefor be eating more cpu-time. Looking at some scripts that just perform the same action over a thousand times in a script might be the cause of your problem now.

Our DBA and I have often seen users run awfull SQL statements which cause this problem.
It might be nice for you to find out the real bottleneck in her performing : sar 2 20 . You can now see if it's WIO/ USR or SYS. Most off all it will also be WIO. Still upgrading memory should not matter.

Aargh, will deep into it a bit more. Please perform a
"swapinfo -at"

and paste the output here. Also the output of "sar 5 20" would be nice. Please let me know the total amount of physical memory and created swap. Also let me know on what disk you configured swap. please give me a "sar -d 5 20" output of this disk.

Will continue tomorow.

Regs David
Google UNIX.COM
Closed Thread

Thread Tools
Display Modes




All times are GMT -7. The time now is 08:29 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008 The CEP Blog All Rights Reserved -Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0