Server Optimisation Request/mysql High Memory
Jul 2, 2007
cpu speed/type single or dual cpus): Intel Xeon 2x3.6
how much memory installed: 2048MB
hard drive type/configuration: 2x160GB SATA
linux distributor or windows version: CentOS 4.5 x86_64
apache/IIS version: apache 1.3.37
PHP version: php 4.4.7
MySQL version: 4.1.22-standard
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
19017 teknoloj 16 0 0 0 0 Z 27 0.0 0:00.93 php <defunct>
17751 mysql 15 0 241m 55m 3148 S 25 2.8 0:53.73 mysqld
19025 root 18 0 16204 6104 1392 D 6 0.3 0:00.17 cpcpan_check_in
18968 sohbetgo 16 0 44596 7540 3556 S 5 0.4 0:00.44 php
18552 nobody 15 0 32636 4208 1204 S 2 0.2 0:00.28 httpd
18808 resimsit 17 0 46944 9960 3616 R 1 0.5 0:00.23 php
18896 resimsit 16 0 46944 9984 3616 D 1 0.5 0:00.08 php
18921 resimsit 17 0 46404 9444 3572 R 1 0.5 0:00.09 php
18819 nobody 17 0 32644 4176 1192 S 1 0.2 0:00.06 httpd
18868 haylazt 16 0 0 0 0 Z 1 0.0 0:00.48 php <defunct>
18871 nobody 15 0 32504 4056 1148 S 1 0.2 0:00.06 httpd
18892 root 16 0 6416 1180 756 R 1 0.1 0:00.24 top
18978 nobody 16 0 32504 4028 1132 S 1 0.2 0:00.02 httpd
11 root 5 -10 0 0 0 S 0 0.0 0:24.56 events/1
2638 root 0 -20 0 0 0 S 0 0.0 0:16.96 loop0
2981 named 18 0 88016 2328 1152 S 0 0.1 8:44.12 named
3592 mailman 16 0 50316 2320 1828 S 0 0.1 0:00.78 python2.4
my.cnf
[mysqld]
safe-show-database
skip-innodb
max_connections = 500
key_buffer = 80M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 25
connect_timeout = 10
tmp_table_size = 128M
max_heap_table_size = 128M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 32768
ft_min_word_len=3
ft_max_word_len=25
[mysqld_safe]
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
ft_min_word_len=3
ft_max_word_len=25
[mysqlhotcopy]
interactive-timeout
MySQL 4.1.22-standard uptime 0 0:39:9 Sat Jun 30 21:33:29 2007
__ Key __________________________________________________ _______________
Buffer used 19.34M of 80.00M %Used: 24.17
Current 33.70M %Usage: 42.12
Write hit 32.57%
Read hit 98.45%
__ Questions __________________________________________________ _________
Total 63.26k 26.9/s
Slow 2 0.0/s %Total: 0.00 %DMS: 0.01
DMS 32.14k 13.7/s 50.80
__ Table Locks __________________________________________________ _______
Waited 40 0.0/s %Total: 0.08
Immediate 50.58k 21.5/s
__ Tables __________________________________________________ ____________
Open 486 of 1800 %Cache: 27.00
Opened 702 0.3/s
__ Connections __________________________________________________ _______
Max used 12 of 500 %Max: 2.40
Total 4.33k 1.8/s
__ Created Temp __________________________________________________ ______
Disk table 26 0.0/s
Table 2.23k 1.0/s
File 428 0.2/s
6-7 vbulletin sites-vbseo and other scripts online avarage;
120 registered user ve 500+ unregistered user
cookie timeout : 7200
unique hit : 15000-20000
KeepAlive ON
MaxKeepAliveRequests 100
KeepAliveTimeout 2
MinSpareServers 10
MaxSpareServers 15
StartServers 10
MaxClients 180
Maxrequestsperchild value 1000
[root@server ~]# uname -a
Linux server.xxxxx 2.6.9-55.ELsmp #1 SMP Wed May 2 14:04:42 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux
[root@server ~]# ulimit -aH
core file size (blocks, -c) 1000000
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 4096
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 8192
cpu time (seconds, -t) unlimited
max user processes (-u) 14335
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
[root@server ~]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7207.08
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 1
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.29
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 2
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 0
siblings : 2
core id : 0
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7509.03
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
processor : 3
vendor_id : GenuineIntel
cpu family : 15
model : 4
model name : Intel(R) Xeon(TM) CPU 3.60GHz
stepping : 10
cpu MHz : 3600.322
cache size : 2048 KB
physical id : 3
siblings : 2
core id : 3
cpu cores : 1
fpu : yes
fpu_exception : yes
cpuid level : 5
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall nx lm pni monitor ds_cpl est tm2 cid cx16 xtpr
bogomips : 7199.26
clflush size : 64
cache_alignment : 128
address sizes : 36 bits physical, 48 bits virtual
power management:
View 4 Replies
ADVERTISEMENT
Feb 20, 2007
My Dedicated server is being slow - hopefully someone can give a helping hand
Processor: AMD Single CPU Dual Core Athlon 4200
Memory: 2048MB RAM
Primary Hard Drive: 160GB
Operating System : CentOS 4.x X86_64 Bit
Control Panel: CPanel
uplink port: 100
Apache version 1.3.37
php 4.4.4
View 9 Replies
View Related
Mar 3, 2007
We just upgraded to VBulletin 3.6.5, and are experiencing strange behavior. My forums are on a dedicated server, 27,000 users.
We'll be running along fine with loads of .5-2.00, etc. Then suddenly, the loads start climbing to 50, 70, 85+. We've been trying to figure out why. We even went on a different (much more robust) server, still the same result. This only started happening after the upgrade. Restarting the server corrects the problem, but only until it happens again. It can happen at anytime - during peak or off peak. The server may run for an hour or two until this happens, or it can happen 10 minutes after a restart.
Late last night when loads were normal we benched the server hard, and it ran just fine. We just can't figure out where this load spike is coming from.
Server info below:
Servers:
Mysql: server version: 5.0.27-log
PHP: PHP 5.1.6 (cli) Zend Engine v2.1.0,
Apache Server version: Apache/2.2.3
Kernel: 2.6.19-1.2911.fc6 #1 SMP
Server:
Pentium III with 1 gig of ram
15k RPM SCSI Raid 5
1 Gig RAM
-----------------------------------------------------------------------
[root@forums forums]# cat /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 8
model name : Pentium III (Coppermine)
stepping : 6
cpu MHz : 861.001
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca
cmov pat pse36 mmx fxsr sse
bogomips : 1722.41
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 8
model name : Pentium III (Coppermine)
stepping : 6
cpu MHz : 861.001
cache size : 256 KB
fdiv_bug : no
hlt_bug : no
f00f_bug : no
coma_bug : no
fpu : yes
fpu_exception : yes
cpuid level : 2
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic mtrr pge mca
cmov pat pse36 mmx fxsr sse
bogomips : 1721.51
--------------------------------------------------------------------------
my.cnf:
[root@forums forums]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log_error = /var/log/mysql_error.log
log-slow-queries = /var/log/mysql_slow_queries.log
safe-show-database
old_passwords
back_log = 20
skip-innodb
key_buffer_size = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 600
thread_cache_size = 384
wait_timeout = 35
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 4M
query_cache_size = 48M
query_cache_type = 1
query_prealloc_size = 163840
query_alloc_block_size = 32768
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
-------------------------------------------------------
Relevant Apache:
StartServers 10
MinSpareServers 10
MaxSpareServers 15
ServerLimit 256
MaxClients 90
MaxRequestsPerChild 1000
---------------------------------------------------------
View 3 Replies
View Related
Jul 2, 2009
I have a site that is eating up my server resources and need to know what the best solution for this is. I'm thinking of getting another server just for mysql but do not know what specs the server should be to handle the current traffic/database load and have the site run smoothly without slowing down to a snail's pace.
An alternative is to get another server just for the videos being served and leave the database and html on the current server. This is where I'm stuck and don't know what route to take with this.
My current server stats:
Dual Xeon 5130
4GB RAM
250GB
50 Mbit/sec
CentOS 3.9
Website traffic stats:
15,000 visitors/day
150,000 pageviews/day
Serving videos
I've attached screenshots of top and bandwidth usage per day. Hopefully with this information you could tell me if I need another server or if there are any things I can do to the current server to help things move faster.
View 13 Replies
View Related
Jan 6, 2007
for the last few days, i am facing high memory usage up to 90%.
Memory usage get's high, even if i don't have many visitors online. I have to restart httpd to get the memory to normal. some times, server loads, get's high aswell.
In error logs (only unusual things i see):
Code:
[Sat Jan 6 10:37:04 2007] [error] mod_gzip: TRANSMIT_ERROR:ISMEM:104
[Sat Jan 6 10:37:25 2007] [error] mod_gzip: TRANSMIT_ERROR:ISMEM:104
# top:
Code:
top - 10:42:19 up 10:35, 1 user, load average: 22.95, 10.67, 9.79
Tasks: 318 total, 1 running, 317 sleeping, 0 stopped, 0 zombie
Cpu(s): 0.7% us, 1.3% sy, 0.0% ni, 0.0% id, 61.9% wa, 36.1% hi, 0.0% si
Mem: 2009652k total, 1220736k used, 788916k free, 28756k buffers
Swap: 6224564k total, 135212k used, 6089352k free, 389768k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
6365 root 0 -20 0 0 0 D 40 0.0 3:01.33 loop0
4553 root 16 0 3112 1108 760 R 1 0.1 0:00.30 top
327 root 15 0 0 0 0 S 0 0.0 6:33.15 kjournald
3743 nobody 15 0 18592 7260 2320 S 0 0.4 0:00.21 httpd
3833 nobody 15 0 21664 10m 2780 D 0 0.5 0:00.94 httpd
3838 nobody 15 0 20472 9400 2664 S 0 0.5 0:00.18 httpd
3858 nobody 15 0 18876 7616 2388 S 0 0.4 0:00.82 httpd
3919 nobody 16 0 21492 10m 2432 D 0 0.5 0:00.82 httpd
3931 nobody 15 0 18976 8016 2716 D 0 0.4 0:00.45 httpd
4439 nobody 15 0 18892 7612 2368 S 0 0.4 0:00.16 httpd
4913 root 18 0 2512 292 244 D 0 0.0 0:00.24 sync
1 root 16 0 2484 488 456 S 0 0.0 0:06.16 init
2 root RT 0 0 0 0 S 0 0.0 0:00.11 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:06.66 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.16 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.71 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:14.59 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:42.07 events/1
this looks suspisous to me:
6365 root 0 -20 0 0 0 D 40 0.0 3:01.33 loop0
as it's taking alot of memory. i don't see this before.
View 6 Replies
View Related
Nov 14, 2014
This is my free -m
total used free shared buffers cached
Mem: 1998 1903 95 0 45 542
-/+ buffers/cache: 1315 683
Swap: 2662 36 2625
Not good ....
I got 5 wordpress and 5 statics website on this server and 100 visitors by 24H00 each day.
Question 1 : Why the memory is so low and the swap so high ?
Question 2 : Why i don't find high usage process in top command ?
Question 3 How can i resolve this problem ?
View 2 Replies
View Related
Nov 19, 2007
I have a linux server that is only hosting one site , and although the httpd and mysql are working well , then the server load is high and when I restart the server the server load is high till the swap accelerates to 100% and then it uses the memory alot.
View 5 Replies
View Related
Nov 22, 2008
diagnosing my server which currently experiencing high iowait for weeks, I'm still figuring the root cause.
total used free shared buffers cached
Mem: 4051 3653 398 0 341 2847
-/+ buffers/cache: 464 3587
Swap: 8191 0 8191
The server spec as follow :
HP DL 380 G5
4G RAM
2.6.18-53.el5PAE
the load is around 1 or 2 , but iowait have been on the high side even the server currently is under utilized
I'm running LVM and hardware RAID 1 on the server.
View 5 Replies
View Related
Mar 25, 2009
We are considering a new dedicated server host for a set of 25 domains, about 5 of which are very high traffic (80 million clicks a day each).
I am told that the biggest speed boost and performance comes from memory and fast hard disk. So I'm looking for at least a 16GB RAM and SCSI 10k 300GB hard disks.
I am also told that PHP etc is okay, but MySQL is the one that hogs resources after a while. So for the database server I need a high end server.
I like WHM/Cpanel so that should be alright.
A lot of email alerts may be sent through our system (about 500,000 a day on a good day as there's user subscription to updates functionality) so we may need a separate mail server?
My question: is the following config of 4 x quadcore Dunnington Intels be good enough for the above site? Can I run a database on this config for my kind of traffic or do I need a separate server too?
Code:
Quad Processor Hex Core Intel 7450 - 2.40GHz (Dunnington) - 6 x 9MB (L2) 12MB (L3) cache
Second Processor
Hex Core Intel 7450 - 2.40GHz (Dunnington) - 6 x 9MB (L2) 12MB (L3)
Third Processor
Hex Core Intel 7450 - 2.40GHz (Dunnington) - 6 x 9MB (L2) 12MB (L3) cache
Fourth Processor
Hex Core Intel 7450 - 2.40GHz (Dunnington) - 6 x 9MB (L2) 12MB (L3) cache
16 GB FB-DIMM Registered 533/667
1000 Mbps public uplink
1000 Mbps private uplink
Disk Controller RAID 10
HD1: 300GB SA-SCSI 10K RPM
HD2: 300GB SA-SCSI 10K RPM
HD3: 300GB SA-SCSI 10K RPM
HD4: 300GB SA-SCSI 10K RPM
CentOS 5 (32 bit)
View 7 Replies
View Related
Jun 29, 2009
Whenever I run the "top" command, I see that some of the user "mysql" records always have very high CPU usage, anywhere from 20-80% on average (I've seen 100%). There are multiple records that show this, which means that the CPU is always above 100%. My cacti monitoring account also shows messed up CPU statistics.
I am not too knowledgeable with servers, but I believe that this is a problem. How much CPU usage is a mysqld command supposed to use on average? Here is a copy of the top part of a sample top command:
=========
top - 06:54:50 up 92 days, 5:32, 1 user, load average: 3.82, 3.89, 4.24
Tasks: 181 total, 4 running, 176 sleeping, 0 stopped, 1 zombie
Cpu(s): 0.2%us, 18.6%sy, 80.9%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Mem: 2075600k total, 1905400k used, 170200k free, 331912k buffers
Swap: 4096564k total, 104k used, 4096460k free, 1187304k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
21663 mysql 24 6 63032 30m 3004 R 66 1.5 38:24.06 mysqld
28483 mysql 24 6 63032 30m 3004 R 66 1.5 35:52.86 mysqld
20538 mysql 22 6 63032 30m 3004 S 15 1.5 40:29.74 mysqld
20837 mysql 24 6 63032 30m 3004 R 15 1.5 13:44.15 mysqld
1209 mysql 22 6 63032 30m 3004 S 11 1.5 32:46.26 mysqld
20591 mysql 22 6 63032 30m 3004 S 11 1.5 40:02.76 mysqld
20592 mysql 23 6 63032 30m 3004 S 6 1.5 40:48.29 mysqld
15301 apache 19 4 29928 15m 3608 S 3 0.8 0:00.60 httpd
15317 apache 19 4 28380 14m 3640 S 3 0.7 0:00.58 httpd
15249 apache 19 4 28612 14m 3732 S 1 0.7 0:01.49 httpd
15349 apache 19 4 28876 14m 3324 S 1 0.7 0:00.10 httpd
15319 apache 19 4 28368 14m 3528 S 1 0.7 0:00.34 httpd
15334 apache 19 4 28612 14m 3404 S 1 0.7 0:00.35 httpd
12343 root 15 0 2324 1088 804 R 1 0.1 0:03.31 top
15336 apache 19 4 28876 14m 3500 S 0 0.7 0:00.63 httpd
1 root 15 0 2064 588 508 S 0 0.0 1:01.28 init
2 root RT -5 0 0 0 S 0 0.0 0:09.39 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:01.25 ksoftirqd/0
4 root RT -5 0 0 0 S 0 0.0 0:00.00 watchdog/0
=================================
I told my system manager about the cpu problem, and he said that he installed the cpulimit function on my server. I'm not sure if this is a good solution.
View 2 Replies
View Related
Dec 18, 2008
MySQL the last few days seems to be constantly the most demanding process in top, which it never was before. As far as I can tell, nothing has substantially changed with regards to traffic to MySQL driven sites on the server. Is there anything that might be wrong with the databases, etc., that might throw MySQL into a tizzy?
View 8 Replies
View Related
Apr 21, 2008
So the site got featured on [url]and now the server is drowning...
The Coppermine Gallery usually hovers around 30~50 users daily and now, 1800, and im at a lost as how I should configure mysql to take on such a load. right now it takes about 10 secs or more to load a page and sometimes it would time out. Because it si coppermine, all pages are dynamic and can't be cached -_-"
Here's the my.cnf right now after i played around with the numbers
server spec
Opteron 170 (2ghz)
2gb ram
250 7200rpm
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#skip-networking
back_log = 75
key_buffer = 256M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 7200
max_connections = 600
connect_timeout = 100
wait_timeout = 12000
tmp_table_size = 100M
max_heap_table_size = 64M
max_allowed_packet = 15M
max_connect_errors = 9999999
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
query_cache_limit = 40M
query_cache_size = 150M
query_cache_type = 1
query_prealloc_size = 65536
tmp_table_size = 64M
query_alloc_block_size = 131072
default-storage-engine = MyISAM
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[mysqldump]
quick
max_allowed_packet = 16M
[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
httpd.conf
Timeout 20
#
# KeepAlive: Whether or not to allow persistent connections (more than
# one request per connection). Set to "Off" to deactivate.
#
KeepAlive Off
#
# MaxKeepAliveRequests: The maximum number of requests to allow
# during a persistent connection. Set to 0 to allow an unlimited amount.
# We recommend you leave this number high, for maximum performance.
#
MaxKeepAliveRequests 100
#
# KeepAliveTimeout: Number of seconds to wait for the next request from the
# same client on the same connection.
#
KeepAliveTimeout 15
##
## Server-Pool Size Regulation (MPM specific)
##
# prefork MPM
# StartServers: number of server processes to start
# MinSpareServers: minimum number of server processes which are kept spare
# MaxSpareServers: maximum number of server processes which are kept spare
# ServerLimit: maximum value for MaxClients for the lifetime of the server
# MaxClients: maximum number of server processes allowed to start
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule prefork.c>
StartServers 8
MinSpareServers 5
MaxSpareServers 20
ServerLimit 200
MaxClients 200
MaxRequestsPerChild 1500
</IfModule>
# worker MPM
# StartServers: initial number of server processes to start
# MaxClients: maximum number of simultaneous client connections
# MinSpareThreads: minimum number of worker threads which are kept spare
# MaxSpareThreads: maximum number of worker threads which are kept spare
# ThreadsPerChild: constant number of worker threads in each server process
# MaxRequestsPerChild: maximum number of requests a server process serves
<IfModule worker.c>
StartServers 2
MaxClients 150
MinSpareThreads 25
MaxSpareThreads 75
ThreadsPerChild 25
MaxRequestsPerChild 0
</IfModule>
View 11 Replies
View Related
Jun 15, 2008
if I could get some input on this. Currently I'm running an Opteron 246, 2GB RAM with 2TB bandwidth/mo. I run a single site which is currently 99% HTML, along with an invision forum which is fairly popular. I get about 300-400k pageviews per day.
Right now the server is able to handle this stuff without much of a problem, and the average CPU load is between .5 and 3 (after a TON of tweaking!) - the only exception is when the forum db is being backed up/optimized, which isn't a huge problem since it happens during the off hours.
The problem is that I'm running out of bandwidth quickly, and need to come up with some kind of solution soon. My current provider offers bandwidth at $1/GB, which to me seems crazy compared to other providers, so that's not really an option.
I was thinking about switching to a more affordable provider and upgrading hardware, but I'm not sure what the best approach would be. I'm in the process of moving my HTML content over to a PHP-powered CMS, so I need to make sure whatever I do can handle that... What might be a decent setup for a site like mine which consumes a lot of bandwidth and will probably need more CPU power in the near future for PHP/MySQL stuff?
View 8 Replies
View Related
Jun 24, 2008
I have a fairly high end server in which I have installed SIM. SIM is restarting Apache up to 10 times a day, presumably due to high load causing un-availability.
On restart, Apache / MYSQL is stable until the load / mem usage begins to climb then it is restarted again. Here are my 'load' stats for today:
Load for today
High (2:18am): 4.63
Low (3:30am): 1.20
Mean: 1.84
Latest: 1.61
Mem usage for today
High (1:36am): 9,192.9 MB
Low (1:48am): 7,995.7 MB
Mean: 8,683.1 MB
Latest: 8,781.7 MB
I have seen it using 20GB RAM before.
I have tried to follow various optimisation guides but these seem tailored to less powerful servers.
The web application I run on this server is almost entirely MYSQL based, with thousands of DB calls a day. Across the entire system I probably get 200,000 bot hits per day or even more. At peak times search engine bots are literally hammering the server.
My server specs are:
# Processor: Quad-Core Xeon Processor * 8
# CPU Speed: 3Ghz
# RAM: 32 GB DDR2
# HDD: 36 GB 15k Raptor X2 + 1TB Sata
# OS: 32Bit CentOS
Changes / optimisation of the actual application is not possible.
My configuration files are:
My.cnf ....
View 11 Replies
View Related
Jan 29, 2009
Anyone know a good script that I can run with cron or something? Mysql seems to be the #1 problem with a lot of my web sites, a restart usually fixes it right away for me, but I can't keep restarting my servers everyday manually.
View 1 Replies
View Related
Feb 28, 2008
My video sharing site has high traffic, alexa rate:3,000
My site has 2 servers to split the load. 2 servers share a mysql server. Using rrdns to load the balance.
Server A running mysql 5.0,lighttpd
Server B running lighttpd.
Server B connect to A's mysql database.
During peak time. B can not connect to A's mysql server. It says server not responding. But A still running fine.
When I check mysql log file.
/usr/libexec/mysqld: Forcing close of thread .....
And when run top, the load average is 20.
The spec of Server A
Intel(R) Xeon(TM) CPU 3.06GHz dual core.
2G Ram.
Here is the my.cnf
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
max_connections = 1000
wait_timeout=60
connect_timeout=10
interactive_timeout=120
join_buffer_size=1M
query_cache_size=128M
query_cache_limit=2M
max_allowed_packet=16M
table_cache=1024
sort_buffer_size=2M
read_buffer_size=2M
My question, do I need another maching C to run lighttpd, and just keep mysql on A.
Or I can do some mysql optimization on A.
Also, if my site keeps going, can I have 1 mysql server and 5 http servers?
View 11 Replies
View Related
Apr 27, 2007
we have mysql 5 setup and this morning at around 10:07 tables started disappearing as they were being accessed by different clients.
Databases that had 40 tables now had 30, etc. Only the tables that were attempted to be accessed were gone. This is the first time something like this has happened.
The following output was given:
This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose the
problem, but since we have already crashed, something is definitely wrong and this may fail.
key_buffer_size=8388600
read_buffer_size=131072
max_used_connections=208
max_connections=500
threads_connected=156
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1096188 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0xaf82930
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
Cannot determine thread, fp=0xb143932c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x816b1a0
0xaf1898
0x20
0x81ac49d
0x8182914
0x8189010
0x8189df1
0x818a738
0x818ae5c
0xaeb371
0x9c4ffe
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read [url]and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0xaf36620 = SELECT * FROM `sessions` WHERE `PHPSESSID` = '5e6775cd3c6f187d8c575127ba73be19'
thd->thread_id=113407
The manual page at [url]contains
information that should help you find out what is causing the crash.
mysqld: my_new.cc:51: int __cxa_pure_virtual(): Assertion `"Pure virtual method called." == "Aborted"' failed.
Number of processes running now: 0
070427 10:07:49 mysqld restarted
070427 10:07:50 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
070427 10:07:53 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 227822203.
InnoDB: Doing recovery: scanned up to log sequence number 0 227822203
070427 10:07:53 InnoDB: Started; log sequence number 0 227822203
070427 10:07:54 [Note] /usr/sbin/mysqld: ready for connections.
View 0 Replies
View Related
Nov 4, 2007
my VPS is using between 105mb of memory and it peeked at 127 mb of memory. But I'm only allowed 128mb of memory. It seems to be high and I want to know how to lower it
here's a picture of the list of processes
[url]
I have basically no sites on it just a few testing and it's only used 4.74mb of bandwith, I can't understand what is causing so much resource usage.
View 2 Replies
View Related
Mar 28, 2009
Am using Hypervm,my all vms are not using more than 512 MB memory but when i click on server as localhost the there is show maximum memory usage I have total 8 GB it always show 5-6 GB usage and never drop down, How can I fix this matters?
View 7 Replies
View Related
Oct 11, 2009
I have a Drupal site with around 1000 visitors/day on a basic VPS. (HyperVM with lxadmin) Burstable RAM is 384MB and my site reachs it.
is this normal for a site like this?
anything that I can do to decrease the memory usage?
View 14 Replies
View Related
Aug 30, 2007
I purchased a VPS at wiredtree to upload a site that is in the works so that it would be "ready" once it was launched (had it sitting on a shared server before). So I have this domain on there, as well as a small wordpress blog. In total I'm get a very miniscule trickle of visitors to these websites (as they are not officially launched), around 100 visits per day, many of which are only 1 pageview visits.
My problem is, my server is already idling over its memory limit of 256mb. This is causing major slowdowns, and processes like cpanel are constantly be killed and I can't login.
Does anyone have any idea what is causing my high memory usage? I just can't image that the visitors I am getting are doing much, as for the majority of the day I have absolutely no one viewing my domains, yet my memory usage is still over the limit.
Wiredtree support says its up to me to optimize my msql/php scripts etc for low mem usage, but I don't see how this will help when there is no one using them in the first place.
View 5 Replies
View Related
Oct 6, 2007
what 'committed memory' could mean? Every time it gets to high I experience some problems with my site. There is also a lot of memory put in cache. I saw this in a graph using the application munin. How can I prevent this? Are there some configuration options in mysql or apache such that I can control this? How can I find out which process is using all the memory? And most important what does 'committed memory' actually mean...
The graph can be found at
users.pandora.be/enyo/memory-day.png
(apache+mysql+php where the peak indicates 10 000 visitors approximately)
View 0 Replies
View Related
Oct 24, 2009
I installed kloxo on a fresh CentOS installation, not the hostinabox template
I have high memory usage though as seen here
[url]
Apache appears to be running 2 or 3 times? How do I remedy this?
[url]
View 13 Replies
View Related
Mar 25, 2009
Two of my VPS's with a company are now showing very high memory loads, even after a reboot, both server are located on different nodes and they both shot up to high ram loads at the same time today(9amGMT) ....
View 4 Replies
View Related
Nov 29, 2008
I'm running hypervm on xen a centos 5 64 bit box.
The problem I'm having is that after a couple of hours of uptime Dom0 seems to have used up all of it's available memory i.e:
[root@------ ~]# free -m
total used free shared buffers cached
Mem: 1536 1516 19 0 993 247
-/+ buffers/cache: 275 1260
Swap: 16002 0 16002
I have disabled the memory balloon driver in the xen config and set dom0_mem=1536M in grub.conf, i.e:
default=1
timeout=1
splashimage=(hd0,0)/grub/splash.xpm.gz
hiddenmenu
title CentOS (2.6.18-92.1.18.el5)
root (hd0,0)
kernel /vmlinuz-2.6.18-92.1.18.el5 ro root=LABEL=/
initrd /initrd-2.6.18-92.1.18.el5.img
title CentOS (2.6.18-92.1.18.el5xen)
root (hd0,0)
kernel /xen.gz-2.6.18-92.1.18.el5 dom0_mem=1536M
module /vmlinuz-2.6.18-92.1.18.el5xen ro root=LABEL=/
module /initrd-2.6.18-92.1.18.el5xen.img
View 0 Replies
View Related
May 29, 2007
In the last day or two I've been having issues with memory on one of by boxes.
Something eats it all up, so the OS starts swapping, the I/O wait shoots up, and soon the load is up in the hundreds and the thing is totally useless.
During the day today I've tracked the something to occational apache processes. It seems that occationally a thread is started which uses upwards of 150M of memory. These threads are obvioudly doing something heavyweight and take a while to complete. When I get a few of them running together it soons finishes off all my available memory. Below is an extract from top when a couple of these threads are running.
Code:
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
10230 nobody 25 0 197m 27m 9392 R 45.5 2.9 0:03.27 /usr/local/apache/bin/httpd -DSSL
10231 nobody 25 0 197m 25m 8376 R 52.8 2.7 0:01.60 /usr/local/apache/bin/httpd -DSSL
I was wondering if anyone could help out by suggesting some ways of tracking down what page/script it which uses so much memory. It's a cPanel server so it's not really practical to tail -f the apache logs (not knowing which account it is means I don't know which file to watch).
View 4 Replies
View Related
Oct 4, 2009
I'm currently running vBulletin & two wordpress powered blogs on my box. Number of simultaneous users is about 200~250 and about 15~20 logged in users.
The memory usage is constantly in the range of 1.8 GB - 2.00 GB. Considering that total physical RAM my box has is 2 GB, the memory usage, I believe is exceptionally high.
The same site was running very well on shared hosting environment and also on VPS [with just 512 MB RAM] very fine.
What should I do to bring the memory consumption to minimum (required to run the site well?)
View 5 Replies
View Related
Jul 20, 2014
We are currently running plesk 11.5 and over the last few months, the apache memory usage has been very high. On investigation we have gone through the logs and we can't find a cause.
I can issue a service httpd restart and the memory drops for about 30 minutes and then we see the apache memory grow to almost 1.5 - 2GB. Why this keeps happening?
View 6 Replies
View Related
