装BSD两个星期了,网站经常莫明其秒的挂掉,哪个高手帮帮我

walkerxk

Apache/2.0.54
Compiled in modules:
  core.c
  mod_access.c
  mod_auth.c
  mod_log_config.c
  mod_logio.c
  mod_env.c
  mod_setenvif.c
  prefork.c
  http_core.c
  mod_mime.c
  mod_status.c
  mod_autoindex.c
  mod_negotiation.c
  mod_dir.c
  mod_alias.c
  mod_so.c
启用以下模块：
bw.load（必需）
cgi.load
dav_fs.load
dav.load
dav_svn.load（必需）
fcgid.load
limitipconn.load（必需）
mod_python.load（必需）
perl.load（必需）
php4.load（必需）
proxy.load（必需）
rewrite.load（必需）
userdir.load

HonestQiao

ｌｚ前面说了，报错。

那么，mysql报什么错呢？

kingstone32

没有调整最大连接数会报too many connects的错误，加到2048后就会经常出现下面的错误或者APACHE被阻死了，网页完全打不开

Discuz! info: Can not connect to MySQL server

Time: 2007-3-30 10:39pm
Script: /index.php

Error: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)
Errno.: 2002

Similar error report has beed dispatched to administrator before.

大大狗

原帖由 kingstone32 于 2007-4-2 11:35 发表
没有调整最大连接数会报too many connects的错误，加到2048后就会经常出现下面的错误或者APACHE被阻死了，网页完全打不开

Discuz! info: Can not connect to MySQL server

Time: 2007-3-30 10:39pm
Script ...

这个MYSQL报错 最好看一下日志 里面会写的很清楚 可能是权限问题

isjfk

原帖由 大大狗 于 2007-4-2 11:51 发表

这个MYSQL报错 最好看一下日志 里面会写的很清楚 可能是权限问题

不是权限问题，是他的mysql不堪重负仆街了...

xuezongqing

每个httpd进程竟然占内存20M。太恐怖了吧。。
我使用的版本一般都是apache1.3.XX版本的。。每个httpd时程也才几M。
不过我觉得要稳定一些的话。还是用apache1.3X php4X mysql3.23.59好一些

cdcchen

我的也是这样啊，郁闷死了，查资料说把apache的KeepAlive关了就行了，我试了，确实要好多了，但隔几天还是会出现load非常大，大到三四百之多，系统就跟死了没区别，只是现在隔的时间比较长，大约四五天就出现一次这种情况，只能重启，难道大家没有遇到这种情况的吗？？那我也太倒霉了吧

kingstone32

下午加了条1G内存,竟然还是挂掉了,直接打不开论坛,难道是APACHE和MYSQL的版本太新不稳定??

HTTPD占用那么多内存是怎么回事??

从新贴一下现在的dmesg和top的结果:

www# top
last pid: 12011;  load averages: 66.50, 78.40, 77.48    up 0+05:50:42  23:26:09
935 processes: 22 running, 906 sleeping, 7 lock
CPU states: 25.6% user,  0.0% nice, 73.6% system,  0.8% interrupt,  0.0% idle
Mem: 1169M Active, 161M Inact, 484M Wired, 66M Cache, 213M Buf, 29M Free
Swap: 2002M Total, 423M Used, 1580M Free, 21% Inuse, 264K In

  PID USERNAME  THR PRI NICE   SIZE    RES STATE  C   TIME   WCPU COMMAND
  605 mysql     440  20    0  1135M   273M kserel 0 346:48  4.39% mysqld
  608 root        1   8    0   117M   920K nanslp 0   0:24  0.00% httpd
8832 www         1   4    0   119M 10748K sbwait 1   0:02  0.00% httpd
9242 www         1   4    0   120M 10128K sbwait 0   0:02  0.00% httpd
10225 www         1   4    0   119M 11248K sbwait 1   0:01  0.00% httpd
9057 www         1   4    0   120M 10028K sbwait 1   0:01  0.00% httpd
10510 www         1   4    0   119M 11436K sbwait 0   0:01  0.00% httpd
9658 www         1   4    0   119M 11000K sbwait 0   0:01  0.00% httpd
9956 www         1   4    0   119M 11464K sbwait 1   0:01  0.00% httpd
10435 www         1   4    0   119M 11032K sbwait 0   0:01  0.00% httpd
9261 www         1   4    0   121M 10620K sbwait 1   0:01  0.00% httpd
10008 www         1   4    0   119M 11848K sbwait 0   0:01  0.00% httpd
9169 www         1   4    0   119M 11136K sbwait 0   0:01  0.00% httpd
9809 www         1   4    0   121M 12524K sbwait 1   0:01  0.00% httpd
10182 www         1   4    0   120M 11152K sbwait 1   0:01  0.00% httpd
10395 www         1   4    0   119M 11376K sbwait 1   0:01  0.00% httpd


www# dmesg
Copyright (c) 1992-2007 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
        The Regents of the University of California. All rights reserved.
FreeBSD is a registered trademark of The FreeBSD Foundation.
FreeBSD 6.2-STABLE #0: Fri Mar 23 03:44:52 CST 2007
    root@www.local.com:/usr/obj/usr/src/sys/SuperKernel-SMP-ULE-64bit
Timecounter "i8254" frequency 1193182 Hz quality 0
CPU: Intel(R) Pentium(R) D  CPU 2.66GHz (2660.21-MHz K8-class CPU)
  Origin = "GenuineIntel"  Id = 0xf47  Stepping = 7
  Features=0xbfebfbff<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,HTT,TM,PBE>
  Features2=0x651d<SSE3,RSVD2,MON,DS_CPL,TM2,CNTX-ID,CX16,XTPR>
  AMD Features=0x20100800<SYSCALL,NX,LM>
  AMD Features2=0x1<LAHF>
  Cores per package: 2
real memory  = 2139029504 (2039 MB)
avail memory = 2057859072 (1962 MB)
ACPI APIC Table: <GBT    AWRDACPI>
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
cpu0 (BSP): APIC ID:  0
cpu1 (AP): APIC ID:  1
ioapic0: Changing APIC ID to 2
ioapic0 <Version 2.0> irqs 0-23 on motherboard
kbd1 at kbdmux0
acpi0: <GBT AWRDACPI> on motherboard
acpi0: Power Button (fixed)
cpu0: <ACPI CPU> on acpi0
acpi_throttle0: <ACPI CPU Throttling> on cpu0
cpu1: <ACPI CPU> on acpi0
acpi_throttle1: <ACPI CPU Throttling> on cpu1
acpi_throttle1: failed to attach P_CNT
device_attach: acpi_throttle1 attach returned 6
acpi_button0: <Power Button> on acpi0
pcib0: <ACPI Host-PCI bridge> port 0xcf8-0xcff on acpi0
pci0: <ACPI PCI bus> on pcib0
pci0: <display, VGA> at device 2.0 (no driver attached)
pci0: <serial bus, USB> at device 29.0 (no driver attached)
pci0: <serial bus, USB> at device 29.1 (no driver attached)
pci0: <serial bus, USB> at device 29.2 (no driver attached)
pci0: <serial bus, USB> at device 29.3 (no driver attached)
pci0: <serial bus, USB> at device 29.7 (no driver attached)
pcib1: <ACPI PCI-PCI bridge> at device 30.0 on pci0
pci1: <ACPI PCI bus> on pcib1
fxp0: <Intel 82559 Pro/100 Ethernet> port 0xa000-0xa03f mem 0xe0100000-0xe0100fff,0xe0000000-0xe00fffff irq 19 at device 1.0 on pci1
miibus0: <MII bus> on fxp0
inphy0: <i82555 10/100 media interface> on miibus0
inphy0:  10baseT, 10baseT-FDX, 100baseTX, 100baseTX-FDX, auto
fxp0: Ethernet address: 00:03:47:98:f5:ee
pci1: <network, ethernet> at device 5.0 (no driver attached)
pci0: <multimedia, audio> at device 30.2 (no driver attached)
isab0: <PCI-ISA bridge> at device 31.0 on pci0
isa0: <ISA bus> on isab0
atapci0: <Intel ICH7 SATA300 controller> port 0x1f0-0x1f7,0x3f6,0x170-0x177,0x376,0xf000-0xf00f at device 31.2 on pci0
ata0: <ATA channel 0> on atapci0
ata1: <ATA channel 1> on atapci0
pci0: <serial bus, SMBus> at device 31.3 (no driver attached)
ppc0: <Standard parallel printer port> port 0x378-0x37f irq 7 on acpi0
ppc0: Generic chipset (NIBBLE-only) in COMPATIBLE mode
ppbus0: <Parallel port bus> on ppc0
plip0: <PLIP network interface> on ppbus0
lpt0: <Printer> on ppbus0
lpt0: Interrupt-driven port
ppi0: <Parallel I/O> on ppbus0
atkbdc0: <Keyboard controller (i8042)> port 0x60,0x64 irq 1 on acpi0
atkbd0: <AT Keyboard> irq 1 on atkbdc0
kbd0 at atkbd0
atkbd0: [GIANT-LOCKED]
psm0: <PS/2 Mouse> irq 12 on atkbdc0
psm0: [GIANT-LOCKED]
psm0: model Generic PS/2 mouse, device ID 0
orm0: <ISA Option ROM> at iomem 0xc0000-0xca7ff on isa0
sc0: <System console> at flags 0x100 on isa0
sc0: VGA <16 virtual consoles, flags=0x300>
vga0: <Generic ISA VGA> at port 0x3c0-0x3df iomem 0xa0000-0xbffff on isa0
Timecounters tick every 1.000 msec
ipfw2 (+ipv6) initialized, divert loadable, rule-based forwarding disabled, default to accept, logging limited to 20 packets/entry by default
ad2: 156333MB <Maxtor 6L160M0 BACE1G20> at ata1-master SATA150
SMP: AP CPU #1 Launched!
Trying to mount root from ufs:/dev/ad2s1a
WARNING: / was not properly dismounted
WARNING: /tmp was not properly dismounted
WARNING: /usr was not properly dismounted
/usr: mount pending error: blocks 4 files 0
WARNING: /var was not properly dismounted
/var: mount pending error: blocks 24 files 14
fxp0: device timeout
fxp0: device timeout
fxp0: link state changed to UP
fxp0: SCB timeout: 0x70 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: SCB timeout: 0xf0 0x0 0x50 0x400
fxp0: device timeout
collecting pv entries -- suggest increasing PMAP_SHPGPERPROC

[ 本帖最后由 kingstone32 于 2007-4-2 23:27 编辑 ]

aha111

关注

cdcchen

把httpd.conf里的KeepAlive设成off试一下，应该会好一点点