Results 1 to 17 of 17
  1. #1

    * Major Load Issue, Need Urgent Help !

    We are running on Celeron 1.6 Mhz , 1 GB RAM Box, but we are experiencing major load problem on the box, which is making the forums / website loading very slow.

    Here are few details -

    Httpd Conf :

    Code:
    ServerType standalone
    ServerRoot "/etc/httpd"
    LockFile /var/run/httpd.lock
    PidFile /var/run/httpd.pid
    ScoreBoardFile logs/apache_runtime_status
    ResourceConfig /dev/null
    AccessConfig /dev/null
    
    Timeout 300
    KeepAlive On
    MaxKeepAliveRequests 100
    KeepAliveTimeout 5
    MinSpareServers 5
    MaxSpareServers 20
    StartServers 8
    MaxClients 100
    MaxRequestsPerChild 100

    Top Result :

    Code:
    top - 15:56:18 up 12:53,  1 user,  load average: 0.77, 3.09, 6.95
    Tasks: 108 total,   1 running, 107 sleeping,   0 stopped,   0 zombie
    Cpu(s): 13.6% us,  3.4% sy,  0.0% ni, 12.3% id, 70.6% wa,  0.0% hi,  0.0% si
    Mem:   1027320k total,   999196k used,    28124k free,    70000k buffers
    Swap:  2096472k total,      208k used,  2096264k free,   800928k cached
    
      PID USER      PR  NI %CPU    TIME+  %MEM  VIRT  RES  SHR S COMMAND
    31534 apache    15   0  7.9   0:00.14  1.1 43168  10m 3936 S httpd
    31600 apache    16   0  7.9   0:00.09  1.0 42796  10m 3508 S httpd
    31560 apache    15   0  5.9   0:00.09  1.0 42984  10m 3596 S httpd
    31540 apache    15   0  4.0   0:00.11  1.0 43004  10m 3600 S httpd
    31536 apache    15   0  2.0   0:00.31  1.1 43096  11m 4652 S httpd
        1 root      16   0  0.0   0:00.80  0.1  3268  548  468 S init
        2 root      34  19  0.0   0:00.08  0.0     0    0    0 S ksoftirqd/0
        3 root       5 -10  0.0   0:00.00  0.0     0    0    0 S events/0
        4 root       7 -10  0.0   0:00.00  0.0     0    0    0 S khelper
        5 root      15 -10  0.0   0:00.00  0.0     0    0    0 S kacpid
       27 root       5 -10  0.0   0:00.00  0.0     0    0    0 S kblockd/0
       28 root      15   0  0.0   0:00.00  0.0     0    0    0 S khubd
       45 root      20   0  0.0   0:00.00  0.0     0    0    0 S pdflush
       46 root      15   0  0.0   0:05.03  0.0     0    0    0 S pdflush
       47 root      15   0  0.0   0:12.81  0.0     0    0    0 S kswapd0
       48 root      12 -10  0.0   0:00.00  0.0     0    0    0 S aio/0
      194 root      25   0  0.0   0:00.00  0.0     0    0    0 S kseriod
    then suddenly it becomes

    Code:
    load average: 28.77, 23.09, 6.95
    Tasks: 108 total,   1 running, 107 sleeping,   0 stopped,   0
    I am not able to understand , that am i being DDOS'ed attacked or what is wrong with server ? That for some time it works all fine, then gets high load even upto 40 - 50.

    The problem ( high load ) solves itself for few minutes, when we restart mysqld and httpd service , but again starts in few moments.

    Even mysqld service closes / errors out, when the load goes high, hence making everything down


    Please kindly help over,

    if you need output of any command, or view any file config, kindly post.

    Edit :

    Latest TOP output, hence making server down

    Code:
    top - 16:02:15 up 12:59,  1 user,  load average: 22.37, 15.41, 11.01
    Last edited by Passwordz; 04-01-2008 at 04:02 PM.

  2. #2
    Join Date
    Jun 2003
    Location
    Janesville, Wi
    Posts
    1,516
    Check out how much free RAM you have. It looks like you may be eating up all of your RAM. What oes your swap look like when the load goes up?
    Jakiao

  3. #3
    Quote Originally Posted by Jakiao View Post
    Check out how much free RAM you have. It looks like you may be eating up all of your RAM. What oes your swap look like when the load goes up?

    Here is output :

    Code:
    free -m
                 total       used       free     shared    buffers     cached
    Mem:          1003        966         37          0         52        789
    -/+ buffers/cache:        124        878
    Swap:         2047          0       2047
    I wonder why is shows Swap Used 0 ?

    Please kindly ask any more details if you need to help over.


    EDIT :

    ps aux | grep httpd | wc -l
    22
    Last edited by Passwordz; 04-01-2008 at 04:23 PM.

  4. #4
    Join Date
    May 2003
    Location
    California, USA, Earth
    Posts
    1,049
    If the server was booted recently, it would be normal to have no swap usage, but if it stays zero it could indicate a problem. Most servers will utilize some swap even if there's plenty of physical memory. Do you have a top output when the load was 28?

    My guess is you need more physical memory - I'd bump it up to at least 2GB.
    Blesta - Professional Billing Software
    Innovation that benefits the user experience
    Trial - Demo | 866.478.7567 | Twitter @blesta

  5. #5
    Join Date
    Jun 2003
    Location
    Janesville, Wi
    Posts
    1,516
    I'm speaking with him over AIM. When the load hits >25, his RAM usage is only around 144MB. So it isn't a lack of memory issue.
    Jakiao

  6. #6
    Quote Originally Posted by pphillips View Post
    If the server was booted recently, it would be normal to have no swap usage, but if it stays zero it could indicate a problem. Most servers will utilize some swap even if there's plenty of physical memory. Do you have a top output when the load was 28?

    My guess is you need more physical memory - I'd bump it up to at least 2GB.
    When load is 10 - 12

    Code:
    free -m
                 total       used       free     shared    buffers     cached
    Mem:          1003        924         78          0         64        659
    -/+ buffers/cache:        200        802
    Swap:         2047          0       2047
    I guess RAM is enough .. there is some other issue..

    thank's Jakiao for help over

  7. #7
    Join Date
    Jun 2003
    Location
    Janesville, Wi
    Posts
    1,516
    The rundown appears to be this:

    The MySQL server on here is more active than the default MySQL config is designed to handle. Introducing a query cache, increasing the key_buffer to 128MB, increasing the table cache, and using persistent connections instead of normal connections shows that MySQL is hungry for RAM. With the restrictive default configuration, it was slow to process data thus increasing Apache running connections and increasing the load.

    The changes to my.cnf has caused the machine to use up most of its RAM, and yet it still wants more. So it does, in fact, look like a RAM upgrade is in order as it will be necessary to tune MySQL to a configuration suitable for the damands of the websites on this server.

    One other interesting fact to point out: The IOWait time on this server is 84%. Whether or not this is being caused by MySQL lagging or a problem with the hardware is unknown.
    Jakiao

  8. #8
    Join Date
    Jan 2006
    Location
    Sydney, Australia
    Posts
    251
    Quote Originally Posted by Jakiao View Post
    One other interesting fact to point out: The IOWait time on this server is 84%. Whether or not this is being caused by MySQL lagging or a problem with the hardware is unknown.
    If it is on a dedicated server, you might want to run "dmesg" to check whether kernel is reporting any unusual activity -- for example a bad IDE drive is forcing it to switch from DMA mode to PIO mode, which will cause huge IO wait.

    If you have Linux 2.6.20+ and CONFIG_TASK_IO_ACCOUNTING compiled in, you can also run pidstat (part of sysstat package) with -d to show which processes are accessing the I/O.

  9. #9
    top

    Code:
     load average: 16.14, 11.34, 9.93

    free -m

    Code:
    free -m
                 total       used       free     shared    buffers     cached
    Mem:          1003        991         11          0         42        641
    -/+ buffers/cache:        307        695
    Swap:         2047         17       2030

  10. #10
    # dmesg

    Code:
    selinux_register_security:  Registering secondary module capability
    Capability LSM initialized as secondary
    Mount-cache hash table entries: 512 (order: 0, 4096 bytes)
    CPU: After generic identify, caps: afebfbff 20100000 00000000 00000000
    CPU: After vendor identify, caps:  afebfbff 20100000 00000000 00000000
    monitor/mwait feature present.
    using mwait in idle threads.
    CPU: L1 I cache: 32K, L1 D cache: 32K
    CPU: L2 cache: 512K
    CPU: After all inits, caps:        afebf3ff 20100000 00000000 00000040
    Intel machine check architecture supported.
    Intel machine check reporting enabled on CPU#0.
    CPU: Intel(R) Celeron(R) CPU          420  @ 1.60GHz stepping 01
    Enabling fast FPU save and restore... done.
    Enabling unmasked SIMD FPU exception support... done.
    Checking 'hlt' instruction... OK.
    ENABLING IO-APIC IRQs
    ..TIMER: vector=0x31 pin1=2 pin2=-1
    checking if image is initramfs... it is
    Freeing initrd memory: 704k freed
    NET: Registered protocol family 16
    PCI: PCI BIOS revision 3.00 entry at 0xf0031, last bus=3
    PCI: Using MMCONFIG
    mtrr: v2.0 (20020519)
    ACPI: Subsystem revision 20040816
    ACPI: Interpreter enabled
    ACPI: Using IOAPIC for interrupt routing
    Error attaching device data
    Error attaching device data
    Error attaching device data
    Error attaching device data
    ACPI: PCI Root Bridge [PCI0] (00:00)
    PCI: Probing PCI hardware (bus 00)
    PCI: Ignoring BAR0-3 of IDE controller 0000:00:1f.1
    PCI: Transparent bridge - 0000:00:1e.0
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI0._PRT]
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI0.P0P4._PRT]
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI0.P0P5._PRT]
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI0.P0P2._PRT]
    ACPI: PCI Interrupt Link [LNKA] (IRQs 3 4 5 6 7 *10 11 12 14 15)
    ACPI: PCI Interrupt Link [LNKB] (IRQs 3 4 5 6 7 10 *11 12 14 15)
    ACPI: PCI Interrupt Link [LNKC] (IRQs 3 4 5 6 7 *10 11 12 14 15)
    ACPI: PCI Interrupt Link [LNKD] (IRQs *3 4 5 6 7 10 11 12 14 15)
    ACPI: PCI Interrupt Link [LNKE] (IRQs 3 4 5 6 7 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [LNKF] (IRQs 3 4 5 6 7 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [LNKG] (IRQs 3 4 5 6 7 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [LNKH] (IRQs 3 4 *5 6 7 10 11 12 14 15)
    Linux Plug and Play Support v0.97 (c) Adam Belay
    usbcore: registered new driver usbfs
    usbcore: registered new driver hub
    PCI: Using ACPI for IRQ routing
    ACPI: PCI Interrupt 0000:00:02.0[A] -> GSI 16 (level, low) -> IRQ 169
    ACPI: PCI Interrupt 0000:00:1b.0[A] -> GSI 16 (level, low) -> IRQ 169
    ACPI: PCI Interrupt 0000:00:1c.0[A] -> GSI 16 (level, low) -> IRQ 169
    ACPI: PCI Interrupt 0000:00:1c.1[B] -> GSI 17 (level, low) -> IRQ 177
    ACPI: PCI Interrupt 0000:00:1d.0[A] -> GSI 23 (level, low) -> IRQ 185
    ACPI: PCI Interrupt 0000:00:1d.1[B] -> GSI 19 (level, low) -> IRQ 193
    ACPI: PCI Interrupt 0000:00:1d.2[C] -> GSI 18 (level, low) -> IRQ 201
    ACPI: PCI Interrupt 0000:00:1d.3[D] -> GSI 16 (level, low) -> IRQ 169
    ACPI: PCI Interrupt 0000:00:1d.7[A] -> GSI 23 (level, low) -> IRQ 185
    ACPI: PCI Interrupt 0000:00:1f.1[A] -> GSI 18 (level, low) -> IRQ 201
    ACPI: PCI Interrupt 0000:00:1f.2[B] -> GSI 19 (level, low) -> IRQ 193
    ACPI: PCI Interrupt 0000:00:1f.3[B] -> GSI 19 (level, low) -> IRQ 193
    ACPI: PCI Interrupt 0000:02:00.0[A] -> GSI 17 (level, low) -> IRQ 177
    ACPI: PCI Interrupt 0000:03:01.0[A] -> GSI 17 (level, low) -> IRQ 177
    apm: BIOS version 1.2 Flags 0x03 (Driver version 1.16ac)
    apm: overridden by ACPI.
    audit: initializing netlink socket (disabled)
    audit(1207018953.912:1): initialized
    highmem bounce pool size: 64 pages
    Total HugeTLB memory allocated, 0
    VFS: Disk quotas dquot_6.5.1
    Dquot-cache hash table entries: 1024 (order 0, 4096 bytes)
    SELinux:  Registering netfilter hooks
    Initializing Cryptographic API
    ksign: Installing public key data
    Loading keyring
    - Added public key F7990D68EDEBC2D7
    - User ID: CentOS (Kernel Module GPG key)
    pci_hotplug: PCI Hot Plug PCI Core version: 0.5
    ACPI: Processor [P001] (supports C1)
    Real Time Clock Driver v1.12
    Linux agpgart interface v0.100 (c) Dave Jones
    agpgart: Detected an Intel 945G Chipset.
    agpgart: Maximum main memory to use for agp memory: 933M
    agpgart: Detected 7932K stolen memory.
    agpgart: AGP aperture is 256M @ 0xe0000000
    serio: i8042 AUX port at 0x60,0x64 irq 12
    serio: i8042 KBD port at 0x60,0x64 irq 1
    Serial: 8250/16550 driver $Revision: 1.90 $ 68 ports, IRQ sharing enabled
    ttyS0 at I/O 0x3f8 (irq = 4) is a 16550A
    RAMDISK driver initialized: 16 RAM disks of 16384K size 1024 blocksize
    divert: not allocating divert_blk for non-ethernet device lo
    Uniform Multi-Platform E-IDE driver Revision: 7.00alpha2
    ide: Assuming 33MHz system bus speed for PIO modes; override with idebus=xx
    ICH7: IDE controller at PCI slot 0000:00:1f.1
    ACPI: PCI Interrupt 0000:00:1f.1[A] -> GSI 18 (level, low) -> IRQ 201
    ICH7: chipset revision 1
    ICH7: not 100% native mode: will probe irqs later
        ide0: BM-DMA at 0xffa0-0xffa7, BIOS settings: hda:pio, hdb:pio
        ide1: BM-DMA at 0xffa8-0xffaf, BIOS settings: hdc:pio, hdd:pio
    Probing IDE interface ide0...
    Probing IDE interface ide1...
    Probing IDE interface ide0...
    Probing IDE interface ide1...
    Probing IDE interface ide2...
    Probing IDE interface ide3...
    Probing IDE interface ide4...
    Probing IDE interface ide5...
    ide-floppy driver 0.99.newide
    usbcore: registered new driver hiddev
    usbcore: registered new driver usbhid
    drivers/usb/input/hid-core.c: v2.0:USB HID core driver
    mice: PS/2 mouse device common for all mice
    md: md driver 0.90.0 MAX_MD_DEVS=256, MD_SB_DISKS=27
    NET: Registered protocol family 2
    IP route cache hash table entries: 32768 (order: 5, 131072 bytes)
    TCP established hash table entries: 131072 (order: 8, 1048576 bytes)
    TCP bind hash table entries: 131072 (order: 9, 3670016 bytes)
    TCP: Hash tables configured (established 131072 bind 131072)
    Initializing IPsec netlink socket
    NET: Registered protocol family 1
    NET: Registered protocol family 17
    ACPI wakeup devices:
    EUSB MC97 P0P4 P0P5 P0P6 P0P7 P0P8 P0P9 USB0 USB1 USB2 USB3 P0P2 P0P1
    ACPI: (supports S0 S1 S3 S4 S5)
    Freeing unused kernel memory: 172k freed
    SCSI subsystem initialized
    libata version 2.00 loaded.
    ata_piix 0000:00:1f.2: version 2.00ac7
    ata_piix 0000:00:1f.2: MAP [ P0 P2 P1 P3 ]
    ACPI: PCI Interrupt 0000:00:1f.2[B] -> GSI 19 (level, low) -> IRQ 193
    PCI: Setting latency timer of device 0000:00:1f.2 to 64
    ata1: SATA max UDMA/133 cmd 0xE080 ctl 0xE002 bmdma 0xD800 irq 193
    ata2: SATA max UDMA/133 cmd 0xDC00 ctl 0xD882 bmdma 0xD808 irq 193
    scsi0 : ata_piix
    ata1.00: ATA-8, max UDMA/133, 234441648 sectors: LBA48 NCQ (depth 0/32)
    ata1.00: ata1: dev 0 multi count 16
    ata1.00: configured for UDMA/133
    scsi1 : ata_piix
    Using cfq io scheduler
      Vendor: ATA       Model: WDC WD1200AAJS-0  Rev: 01.0
      Type:   Direct-Access                      ANSI SCSI revision: 05
    SCSI device sda: 234441648 512-byte hdwr sectors (120034 MB)
    SCSI device sda: drive cache: write back
    SCSI device sda: 234441648 512-byte hdwr sectors (120034 MB)
    SCSI device sda: drive cache: write back
     sda: sda1 sda2
    Attached scsi disk sda at scsi0, channel 0, id 0, lun 0
    kjournald starting.  Commit interval 5 seconds
    EXT3-fs: mounted filesystem with ordered data mode.
    SELinux:  Disabled at runtime.
    SELinux:  Unregistering netfilter hooks
    inserting floppy driver for 2.6.9-67.0.4.EL
    floppy0: no floppy controllers found
    ACPI: PCI Interrupt 0000:03:01.0[A] -> GSI 17 (level, low) -> IRQ 177
    3c59x: Donald Becker and others. www.scyld.com/network/vortex.html
    0000:03:01.0: 3Com PCI 3c905B Cyclone 100baseTx at 0xcc00. Vers LK1.1.19
    divert: allocating divert_blk for eth0
    ACPI: PCI Interrupt 0000:00:1b.0[A] -> GSI 16 (level, low) -> IRQ 169
    PCI: Setting latency timer of device 0000:00:1b.0 to 64
    hw_random: RNG not detected
    ACPI: PCI Interrupt 0000:00:1d.7[A] -> GSI 23 (level, low) -> IRQ 185
    ehci_hcd 0000:00:1d.7: EHCI Host Controller
    PCI: Setting latency timer of device 0000:00:1d.7 to 64
    ehci_hcd 0000:00:1d.7: irq 185, pci mem f8834c00
    ehci_hcd 0000:00:1d.7: new USB bus registered, assigned bus number 1
    PCI: cache line size of 32 is not supported by device 0000:00:1d.7
    ehci_hcd 0000:00:1d.7: USB 2.0 enabled, EHCI 1.00, driver 2004-May-10
    hub 1-0:1.0: USB hub found
    hub 1-0:1.0: 8 ports detected
    USB Universal Host Controller Interface driver v2.2
    ACPI: PCI Interrupt 0000:00:1d.0[A] -> GSI 23 (level, low) -> IRQ 185
    uhci_hcd 0000:00:1d.0: UHCI Host Controller
    PCI: Setting latency timer of device 0000:00:1d.0 to 64
    uhci_hcd 0000:00:1d.0: irq 185, io base 0000e880
    uhci_hcd 0000:00:1d.0: new USB bus registered, assigned bus number 2
    hub 2-0:1.0: USB hub found
    hub 2-0:1.0: 2 ports detected
    ACPI: PCI Interrupt 0000:00:1d.1[B] -> GSI 19 (level, low) -> IRQ 193
    uhci_hcd 0000:00:1d.1: UHCI Host Controller
    PCI: Setting latency timer of device 0000:00:1d.1 to 64
    uhci_hcd 0000:00:1d.1: irq 193, io base 0000e800
    uhci_hcd 0000:00:1d.1: new USB bus registered, assigned bus number 3
    hub 3-0:1.0: USB hub found
    hub 3-0:1.0: 2 ports detected
    ACPI: PCI Interrupt 0000:00:1d.2[C] -> GSI 18 (level, low) -> IRQ 201
    uhci_hcd 0000:00:1d.2: UHCI Host Controller
    PCI: Setting latency timer of device 0000:00:1d.2 to 64
    uhci_hcd 0000:00:1d.2: irq 201, io base 0000e480
    uhci_hcd 0000:00:1d.2: new USB bus registered, assigned bus number 4
    hub 4-0:1.0: USB hub found
    hub 4-0:1.0: 2 ports detected
    ACPI: PCI Interrupt 0000:00:1d.3[D] -> GSI 16 (level, low) -> IRQ 169
    uhci_hcd 0000:00:1d.3: UHCI Host Controller
    PCI: Setting latency timer of device 0000:00:1d.3 to 64
    uhci_hcd 0000:00:1d.3: irq 169, io base 0000e400
    uhci_hcd 0000:00:1d.3: new USB bus registered, assigned bus number 5
    hub 5-0:1.0: USB hub found
    hub 5-0:1.0: 2 ports detected
    md: Autodetecting RAID arrays.
    md: autorun ...
    md: ... autorun DONE.
    ACPI: Power Button (FF) [PWRF]
    EXT3 FS on sda1, internal journal
    device-mapper: 4.5.5-ioctl (2006-12-01) initialised: [email protected]
    Adding 2096472k swap on /dev/sda2.  Priority:-1 extents:1
    IA-32 Microcode Update Driver: v1.14 <[email protected]>
    microcode: CPU0 already at revision 0x32 (current=0x32)
    microcode: No new microdata for cpu 0
    IA-32 Microcode Update Driver v1.14 unregistered
    parport0: PC-style at 0x378 [PCSPP,TRISTATE]
    ip_tables: (C) 2000-2002 Netfilter core team
    ip_tables: (C) 2000-2002 Netfilter core team
    ACPI: PCI Interrupt 0000:03:01.0[A] -> GSI 17 (level, low) -> IRQ 177
    parport0: PC-style at 0x378 [PCSPP,TRISTATE]
    lp0: using parport0 (polling).
    lp0: console ready
    NET: Registered protocol family 10
    Disabled Privacy Extensions on device c038a3a0(lo)
    IPv6 over IPv4 tunneling driver
    divert: not allocating divert_blk for non-ethernet device sit0
    eth0: no IPv6 routers present

  11. #11
    Join Date
    Oct 2000
    Location
    Israel
    Posts
    1,286
    Quote Originally Posted by Jakiao View Post
    So it does, in fact, look like a RAM upgrade is in order as it will be necessary to tune MySQL to a configuration suitable for the damands of the websites on this server.
    Don't be too quick to bump up your RAM since you might just end up spending money on RAM, and end up with the same problem.

    It could very well be that one of the sites has a script that has very poorly behaving queries. A query on a very large database without using the LIMIT clause can bring your server to it's knees.

  12. #12
    You need to isolate the problem. Is it the script or mysql or Apache... Setup your mysql so that it will log slow query. Once you isolate that mysql is not the problem. then it might be your script. Once you have narrow down the issue, report back so we can help you to fix the problem.
    Sitek XEN Hosting - Reliable VPS Hosting

    CRM OnDemand - Fully Managed / Customized vTiger Hosting

  13. #13
    Quote Originally Posted by Abu Mami View Post
    Don't be too quick to bump up your RAM since you might just end up spending money on RAM, and end up with the same problem.

    It could very well be that one of the sites has a script that has very poorly behaving queries. A query on a very large database without using the LIMIT clause can bring your server to it's knees.
    That what i was thinking, i do not want to spend on RAM,
    as i am still unsure, what is wrong with the server.
    As it was working perfectly till few days ago, and now it is acting weird ( sometimes very high load, sometimes just 0.20 )



    Quote Originally Posted by jamesmoey View Post
    You need to isolate the problem. Is it the script or mysql or Apache... Setup your mysql so that it will log slow query. Once you isolate that mysql is not the problem. then it might be your script. Once you have narrow down the issue, report back so we can help you to fix the problem.
    Please let me know how can i "Setup your mysql so that it will log slow query." , even mention where will that log be located, so i can copy / paste it's content here.

    And even mention what other thing you want me to do.


    CURRENT DATA :

    Code:
     mysqladmin status
    Uptime: 27961  Threads: 88  Questions: 1531740  Slow queries: 25  Opens: 1274  Flush tables: 94  Open tables: 512  Queries per second avg: 54.781
    Code:
    free -m
                 total       used       free     shared    buffers     cached
    Mem:          1003        990         12          0         41        577
    -/+ buffers/cache:        371        631
    Swap:         2047          0       2046

    Code:
    uptime
     09:39:34 up  7:47,  1 user,  load average: 21.87, 17.78, 11.47

    Code:
    ps aux | grep httpd | wc -l
    53

  14. #14
    it was all fine till 3 days ago.
    Load was less then 1
    I wonder what has happened to the box Someone kindly help

  15. #15
    Join Date
    Sep 2002
    Location
    Top Secret
    Posts
    11,687
    We are running on Celeron 1.6 Mhz , 1 GB RAM Box
    There's your problem right there
    Celeron boxes suck

    a 1.6 is so out of date it can BARELY handle anythingg at all without croaking.

    It's time to upgrade the server. More memory will help, but what will help MORE is getting a real server, not a child's play server.
    WHMCS Guru - WHMCS addons, management, support and more.
    WHMCS Notifications Extended - Add slack, hipchat, SMS, pushover to WHMCS !!
    Always looking for Linux, WHMCS, Support Desk work. PM for details

  16. #16
    Join Date
    Mar 2008
    Posts
    72
    It seems you're swapping , I'd suggest you to upgrade the server or get more ram also celeron box are not good too good to be used , so upgrade would be nice option

  17. #17
    Join Date
    Jul 2002
    Location
    Kolding, Denmark
    Posts
    292
    Code:
    top - 15:56:18 up 12:53,  1 user,  load average: 0.77, 3.09, 6.95
    Tasks: 108 total,   1 running, 107 sleeping,   0 stopped,   0 zombie
    Cpu(s): 13.6% us,  3.4% sy,  0.0% ni, 12.3% id, 70.6% wa,  0.0% hi,  0.0% si
    Mem:   1027320k total,   999196k used,    28124k free,    70000k buffers
    Swap:  2096472k total,      208k used,  2096264k free,   800928k cached
    You problem is quite clearly displayed in the data above: 70.6% waitstates is way above acceptable (0-5% is acceptable over extended periods of time)

    Waitstates means that your system is waiting for a subsystem to return data, which usually means the harddrives. If you fetch a lot of data from an external server via NFS or HTTP over WAN it may cause a similar problem, btw.

    I would check two things:

    1)
    Who is the idiot who added a MySQL query without adding the proper indexes to the database?

    2)
    Do you have a dying hard drive or a malfunctioning dontroller/driver?

    My money is on suggestion 1).
    Last edited by goldenplanet; 04-04-2008 at 08:57 AM. Reason: Clarification regarding waitstates
    Best regards,

    Anders C. Madsen
    Golden Planet Support - http://www.goldenplanet.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •