Results 1 to 8 of 8
Thread: Server Load very High
-
05-30-2005, 02:52 PM #1Web Hosting Evangelist
- Join Date
- Apr 2004
- Posts
- 500
Server Load very High
top
=================
Code:12:53:16 up 42 days, 13:45, 2 users, load average: 6.92, 10.77, 12.41 86 processes: 75 sleeping, 8 running, 1 zombie, 2 stopped CPU states: cpu user nice system irq softirq iowait idle total 30.1% 0.0% 2.9% 0.5% 0.3% 0.0% 65.8% Mem: 1019396k av, 585896k used, 433500k free, 0k shrd, 88592k buff 324908k actv, 152416k in_d, 21444k in_c Swap: 2040244k av, 19588k used, 2020656k free 335124k cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME CPU COMMAND 22571 nobody 16 0 13896 13M 3588 S 10.7 1.3 0:02 0 httpd 21952 nobody 15 0 13276 12M 3588 S 1.1 1.3 0:05 0 httpd 21974 nobody 15 0 13264 12M 3580 S 0.9 1.3 0:02 0 httpd 22010 nobody 15 0 13988 13M 3596 S 0.9 1.3 0:03 0 httpd 22718 nobody 15 0 12900 12M 3584 S 0.7 1.2 0:01 0 httpd 22729 nobody 15 0 13192 12M 3564 S 0.7 1.2 0:01 0 httpd 22960 mysql 23 0 18332 16M 2168 R 0.5 1.7 0:00 0 mysqld 22961 mysql 23 0 18332 16M 2168 R 0.5 1.7 0:00 0 mysqld 22955 mysql 23 0 18332 16M 2168 R 0.3 1.7 0:00 0 mysqld 22962 mysql 23 0 18332 16M 2168 R 0.3 1.7 0:00 0 mysqld 16295 named 15 0 1996 1676 1072 S 0.1 0.1 3:06 0 named 22800 nobody 15 0 13136 12M 3584 S 0.1 1.2 0:01 0 httpd 22809 root 15 0 1240 1240 896 R 0.1 0.1 0:00 0 top 22956 mysql 23 0 18332 16M 2168 R 0.1 1.7 0:00 0 mysqld 22957 mysql 23 0 18332 16M 2168 R 0.1 1.7 0:00 0 mysqld 1 root 15 0 116 84 56 S 0.0 0.0 0:06 0 init
[code]
root 1 0.0 0.0 1520 80 ? S Mar30 0:46 init [3]
root 2 0.0 0.0 0 0 ? SW Mar30 0:00 [migration/0]
root 3 0.0 0.0 0 0 ? SW Mar30 0:00 [migration/1]
root 4 0.0 0.0 0 0 ? SW Mar30 0:00 [keventd]
root 5 0.0 0.0 0 0 ? SWN Mar30 0:00 [ksoftirqd/0]
root 6 0.0 0.0 0 0 ? SWN Mar30 0:00 [ksoftirqd/1]
root 9 0.0 0.0 0 0 ? SW Mar30 0:00 [bdflush]
root 7 0.0 0.0 0 0 ? SW Mar30 80:51 [kswapd]
root 8 0.2 0.0 0 0 ? SW Mar30 185:40 [kscand]
root 10 0.0 0.0 0 0 ? SW Mar30 2:16 [kupdated]
root 11 0.0 0.0 0 0 ? SW Mar30 0:00 [mdrecoveryd]
root 18 0.0 0.0 0 0 ? SW Mar30 0:00 [scsi_eh_0]
root 19 0.0 0.0 0 0 ? SW Mar30 0:00 [scsi_eh_1]
root 22 0.0 0.0 0 0 ? SW Mar30 0:50 [kjournald]
root 77 0.0 0.0 0 0 ? SW Mar30 0:00 [khubd]
root 3377 0.0 0.0 0 0 ? SW Mar30 0:00 [kjournald]
root 3378 0.0 0.0 0 0 ? SW Mar30 3:43 [kjournald]
root 3379 0.0 0.0 0 0 ? SW Mar30 0:03 [kjournald]
root 3380 0.0 0.0 0 0 ? SW Mar30 0:54 [kjournald]
root 3381 0.0 0.0 0 0 ? SW Mar30 2:00 [kjournald]
root 3382 0.0 0.0 0 0 ? SW Mar30 1:41 [kjournald]
root 3383 0.0 0.0 0 0 ? SW Mar30 4:16 [kjournald]
root 3860 0.0 0.0 1516 240 ? S Mar30 2:09 irqbalance
root 5372 0.0 0.0 2152 276 ? S Mar30 0:00 xinetd -stayalive -pidfile
bin 5593 0.0 0.0 2004 48 ? S Mar30 0:04 /usr/sbin/cannaserver -sysl
daemon 5640 0.0 0.0 1584 176 ? S Mar30 0:04 /usr/sbin/atd
root 5886 0.0 0.0 4628 72 ? S Mar30 0:01 rhnsd --interval 240
root 5915 0.0 0.0 1676 300 ? S Mar30 0:00 /usr/sbin/portsentry -tcp
root 5940 0.0 0.0 6036 544 ? S Mar30 2:26 perl /usr/sbin/cleanlink.pl
root 5952 0.0 0.0 1580 148 ? S Mar30 0:12 mdadm --monitor --scan -f
root 5965 0.0 1.1 12164 12160 ? SL Mar30 0:16 mdmpd
root 5973 0.0 0.0 1504 4 tty1 S Mar30 0:00 /sbin/mingetty tty1
root 5974 0.0 0.0 1504 4 tty2 S Mar30 0:00 /sbin/mingetty tty2
root 5975 0.0 0.0 1504 4 tty3 S Mar30 0:00 /sbin/mingetty tty3
root 5976 0.0 0.0 1504 4 tty4 S Mar30 0:00 /sbin/mingetty tty4
root 5977 0.0 0.0 1504 4 tty5 S Mar30 0:00 /sbin/mingetty tty5
root 5978 0.0 0.0 1504 4 tty6 S Mar30 0:00 /sbin/mingetty tty6
root 5979 0.0 0.0 1504 4 ttyS0 S Mar30 0:00 /sbin/mingetty ttyS0 CON960
root 6748 0.0 0.0 9516 200 ? S Apr03 0:00 cpsrvd - waiting for connec
root 21765 0.0 0.0 11284 220 ? S Apr17 0:00 cppop - accepting on port 1
nobody 31913 0.0 0.0 4284 692 ? S May14 0:07 proftpd: (accepting connect
root 15548 0.0 0.2 31500 2640 ? S May22 2:14 /usr/local/apache/bin/httpd
named 12597 0.0 0.2 48736 2640 ? S May26 0:12 /usr/sbin/named -u named
root 27303 0.0 0.0 3664 644 ? S May26 0:04 /usr/sbin/sshd
root 14598 0.0 0.0 1584 224 ? S May26 0:02 syslogd -m 0
root 14602 0.0 0.0 1524 12 ? S May26 0:00 klogd -x
root 31520 0.0 0.0 1600 584 ? S May29 0:00 crond
nobody 12379 0.0 0.2 31512 2832 ? S 10:01 0:00 /usr/local/apache/bin/httpd
root 12829 0.0 0.1 6876 1492 ? S 10:16 0:00 sshd: root@pts/0
root 12834 0.0 0.1 5320 1284 pts/0 S 10:17 0:00 -bash
nobody 14157 0.0 0.2 31512 2776 ? S 10:51 0:00 /usr/local/apache/bin/httpd
nobody 16276 0.0 0.2 31512 2856 ? S 11:58 0:00 /usr/local/apache/bin/httpd
nobody 16631 0.0 0.2 31512 2912 ? S 12:06 0:00
***************************
about 100 of these
The server doesnt host any videos just database webpages
-
05-30-2005, 02:54 PM #2Problem Solver
- Join Date
- Mar 2003
- Location
- California USA
- Posts
- 13,681
have you optimized apache/mysql?
Steven Ciaburri | Industry's Best Server Management - Rack911.com
Software Auditing - 400+ Vulnerabilities Found - Quote @ https://www.RACK911Labs.com
Fully Managed Dedicated Servers (Las Vegas, New York City, & Amsterdam) (AS62710)
FreeBSD & Linux Server Management, Security Auditing, Server Optimization, PCI Compliance
-
05-30-2005, 04:45 PM #3Web Hosting Master
- Join Date
- Mar 2005
- Posts
- 1,073
Is this an "out of the box" server? As linuxguy mentioned you should take steps to optimise your apache and MySQL config, and furthermore your entire server configuration to cease reoccuring issues.
If you feel incapable, I reccomend hiring someone to configure your server nicelyBeeServe
* Rock solid shared & reseller UK webhosting. No downtime™ *
Now offering fully managed VPS servers
-
05-30-2005, 05:33 PM #4Web Hosting Evangelist
- Join Date
- Apr 2004
- Posts
- 500
the problem im having is that I cannot tune any mysql settings
because for any syntax I put
e.g
max_connections = 500
max_user_connections = 500
It wont let me restart mysqld and it fails until I change it back to the default
If I tail -f /var/log/mysqld.log
It just read the default settings and tells me
050530 15:35:53 mysqld started
/usr/libexec/mysqld: unrecognized option `--max_connections=500'
/usr/libexec/mysqld Ver 3.23.58 for redhat-linux-gnu on i386
Code:[mysqld] skip-innodb datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid
-
05-30-2005, 06:48 PM #5Web Hosting Master
- Join Date
- Jan 2003
- Posts
- 1,715
Either upgrade your mysql install (recommended) or use the 3.x config format:
set-variable = max_join_size=6MGame Servers are the next hot market!
Slim margins, heavy support, fickle customers, and moronic suppliers!
Start your own today!
-
05-30-2005, 07:30 PM #6Web Hosting Evangelist
- Join Date
- Apr 2004
- Posts
- 500
yes thats it thanks, I need to use another config format.
although ive run out of money and the last time i tried to update mysql I crashed the server and lost a few days and had to pay someone to fix it.
So I want to make sure I have someone helping me, if I try it again, plus I heard that it can break many scripts.
-
06-05-2005, 01:47 AM #7Web Hosting Evangelist
- Join Date
- Apr 2004
- Posts
- 500
Well I've managed to get the average down from 12-15 down to less than 1. thelinuxguy was correct, it was totally untouched, im surprised at how much difference it has made, learnt quite alot along the way.
Now webpages load fast, I just have to wait until tonight to see what happens during peak time and optimise more during this time.
I started off by tuning the sysctl.conf, removing unneccesary processes, optimising apache settings and then optimising mysql.
But now with the older version 3.23 is it possible to change these values or did they only come out after 4?
query_cache_limit = 1M
query_cache_size = 32M
query_cache_type = 1Last edited by Blueheaven; 06-05-2005 at 01:53 AM.
-
06-05-2005, 03:53 PM #8Web Hosting Master
- Join Date
- Jan 2003
- Posts
- 1,715
Query cache is a 4.x feature.
Game Servers are the next hot market!
Slim margins, heavy support, fickle customers, and moronic suppliers!
Start your own today!