Server Optimisation

محروم.كوم · #1 04-26-2009, 06:10 PM

Hello,
Please help me to fix mysql server, I got a lot of Mysql error :

Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Too many connections
/public_html/forum/includes/class_core.php on line 311

1- Dedicated server
2- 8 x Quad-Core AMD Opteron(tm) Processor 2346 HE
Processor Speed (MHz) 1800.072
Total Memory 8388608 kB
hard drive : 500 Gb
Debian 4.1.1-21
Apache 2.2.11
MySQL 5.0.67
Php 5.2.9
3- vBulletin 3.8.1 Patch Level 1
4- No innodb databases/tables on my server
5- I don't know
6-
Quote:
top - 15:06:39 up 6 days, 5:52, 1 user, load average: 1.49, 1.34, 1.18
Tasks: 109 total, 4 running, 105 sleeping, 0 stopped, 0 zombie
top - 15:06:44 up 6 days, 5:52, 1 user, load average: 1.45, 1.33, 1.18
top - 15:08:02 up 6 days, 5:53, 1 user, load average: 1.80, 1.54, 1.27
Tasks: 106 total, 2 running, 103 sleeping, 0 stopped, 1 zombie
Cpu0 : 85.7%us, 14.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu1 : 66.7%us, 33.3%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 75.0%us, 25.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 :100.0%us, 0.0%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 87.5%us, 12.5%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 93.1%us, 6.9%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 12.0%us, 1.2%sy, 0.0%ni, 86.8%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8388608k total, 475256k used, 7913352k free, 0k buffers
Swap: 0k total, 0k used, 0k free, 0k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29586 apache 20 0 29920 15m 3524 S 21.9 0.2 0:03.30 httpd
29505 apache 20 0 24064 11m 3044 S 4.7 0.1 0:00.60 httpd
29555 apache 20 0 28220 13m 3156 S 2.7 0.2 0:00.38 httpd
28614 apache 20 0 31728 17m 3532 S 2.0 0.2 0:02.40 httpd
29371 apache 20 0 32008 17m 3536 S 2.0 0.2 0:02.64 httpd
29493 apache 20 0 27620 12m 3152 S 2.0 0.2 0:00.76 httpd
29512 apache 20 0 28376 13m 3172 S 2.0 0.2 0:01.36 httpd
27942 apache 20 0 31568 16m 3164 S 1.3 0.2 0:03.46 httpd
29257 apache 20 0 30080 15m 3540 S 1.3 0.2 0:01.46 httpd
29518 apache 20 0 30280 15m 3160 R 1.3 0.2 0:01.24 httpd
29581 apache 20 0 23808 10m 2892 S 1.3 0.1 0:00.38 httpd
29700 root 20 0 8780 2608 2116 S 1.3 0.0 0:00.04 sshd
28706 root 20 0 2196 1084 820 R 0.7 0.0 0:00.22 top
29510 apache 20 0 27676 13m 3532 S 0.7 0.2 0:00.36 httpd
29521 apache 20 0 29872 15m 3536 S 0.7 0.2 0:00.84 httpd
1 root 20 0 2068 664 572 S 0.0 0.0 0:05.22 init
45 root 20 0 100 12 4 S 0.0 0.0 0:02.58 init-logger
590 root 20 0 1724 624 524 S 0.0 0.0 0:01.06 syslogd
593 root 20 0 1676 400 332 S 0.0 0.0 0:00.00 klogd
644 dovecot 20 0 4892 1828 1512 S 0.0 0.0 0:00.00 pop3-login
654 dovecot 20 0 4892 1824 1508 S 0.0 0.0 0:00.00 pop3-login
668 dovecot 20 0 4892 1828 1508 S 0.0 0.0 0:00.00 pop3-login
670 dovecot 20 0 4892 1828 1508 S 0.0 0.0 0:00.00 pop3-login
675 dovecot 20 0 4892 1832 1512 S 0.0 0.0 0:00.00 pop3-login
700 dovecot 20 0 4892 1828 1508 S 0.0 0.0 0:00.00 pop3-login
726 dovecot 20 0 4892 1828 1512 S 0.0 0.0 0:00.00 pop3-login
739 root 20 0 7128 1052 656 S 0.0 0.0 0:00.96 sshd
774 root 20 0 3240 1108 576 S 0.0 0.0 0:02.38 crond
1347 root 20 0 5348 1212 1064 S 0.0 0.0 0:00.00 mysqld_safe
1369 mysql 20 0 67616 31m 3872 S 0.0 0.4 1:31.16 mysqld
7-
Quote:
[mysqld]
local-infile=0
8-
Quote:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
9- I have other script on the serveur witch utilise php and mysql

10- max users on my vB forum : 1300, cookie timeout = 3600

11- phpinfo

12-
Timeout 300
KeepAlive On
MaxKeepAliveRequests 500
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 20
StartServers 8
MaxClients 450
MaxRequestsPerChild 1000

13-
find: /proc/13705/task/13705/fd/4: No such file or directory
find: /proc/13705/task/13705/fdinfo/4: No such file or directory
find: /proc/13705/fd/4: No such file or directory
find: /proc/13705/fdinfo/4: No such file or directory

14-
uname -a
Linux bibou.edelweisshosting.com 2.6.24-2-pve #1 SMP PREEMPT Wed Jan 14 11:32:49 CET 2009 i686 athlon i386 GNU/Linux

ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
scheduling priority (-e) 0
file size (blocks, -f) unlimited
pending signals (-i) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) unlimited
real-time priority (-r) 0
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) unlimited
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

cat /proc/cpuinfo
Quote:
processor : 0
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 0
siblings : 4
core id : 0
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3603.03
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 1
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 0
siblings : 4
core id : 1
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3604.56
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 2
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 0
siblings : 4
core id : 2
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3604.43
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 3
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 0
siblings : 4
core id : 3
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs

bogomips : 3604.43
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 4
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 1
siblings : 4
core id : 0
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3600.27
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 5
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE

stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 1
siblings : 4
core id : 1
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3600.26
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 6
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 1
siblings : 4
core id : 2
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3600.26
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate

processor : 7
vendor_id : AuthenticAMD
cpu family : 16
model : 2
model name : Quad-Core AMD Opteron(tm) Processor 2346 HE
stepping : 3
cpu MHz : 1800.072
cache size : 512 KB
physical id : 1
siblings : 4
core id : 3
cpu cores : 4
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 mmx fxsr sse sse2 ht syscall nx mmxext fxsr_opt pdpe1gb rdtscp lm 3dnowext 3dnow constant_tsc rep_good pni cx16 popcnt lahf_lm cmp_legacy svm extapic cr8_legacy abm sse4a misalignsse 3dnowprefetch osvw ibs
bogomips : 3600.26
TLB size : 1024 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 48 bits physical, 48 bits virtual
power management: ts ttp tm stc 100mhzsteps hwpstate __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
I'm after a server format, Server optimisation request.	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-10-2009 06:10 PM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-21-2009 10:30 PM
Server optimisation help	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-31-2009 10:50 AM
Server Optimisation Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-23-2009 12:22 PM
Server Optimisation Req. for VMWARE	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	04-29-2009 06:40 PM