The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQl5 exhaust CPU!

Discussion in 'General Discussion' started by Cr3m4t0rY, Jun 29, 2007.

  1. Cr3m4t0rY

    Cr3m4t0rY Registered

    Joined:
    Dec 12, 2005
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Appreciate any help.

    Using my-small.cnf as my.cnf

    MySQL running:

    top - 13:59:17 up 3 days, 20 min, 1 user, load average: 17.51, 15.86, 18.36
    Tasks: 173 total, 5 running, 168 sleeping, 0 stopped, 0 zombie
    Cpu(s): 48.2%us, 51.8%sy, 0.0%ni, 0.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
    Mem: 515784k total, 466012k used, 49772k free, 28828k buffers
    Swap: 2096472k total, 314472k used, 1782000k free, 143788k cached

    ...
    PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
    14471 mysql 18 0 140m 28m 5168 S 98.0 5.6 8:18.30 mysqld

    MySQL stopped:

    top - 14:00:53 up 3 days, 22 min, 1 user, load average: 14.06, 15.50, 18.00
    Tasks: 164 total, 1 running, 162 sleeping, 0 stopped, 1 zombie
    Cpu(s): 3.0%us, 1.3%sy, 0.0%ni, 92.3%id, 3.3%wa, 0.0%hi, 0.0%si, 0.0%st
    Mem: 515784k total, 416228k used, 99556k free, 29896k buffers
    Swap: 2096472k total, 298948k used, 1797524k free, 147496k cached


    [root@mlwc765 mysql]# dmesg
    Linux version 2.6.20-1.2320.fc5 (brewbuilder@hs20-bc2-2.build.redhat.com) (gcc version 4.1.1 20070105 (Red Hat 4.1.1-51)) #1 Tue Jun 12 18:50:38 EDT 2007
    BIOS-provided physical RAM map:
    sanitize start
    sanitize end
    copy_e820_map() start: 0000000000000000 size: 00000000000a0000 end: 00000000000a0000 type: 1
    copy_e820_map() type is E820_RAM
    copy_e820_map() start: 00000000000f0000 size: 0000000000010000 end: 0000000000100000 type: 2
    copy_e820_map() start: 0000000000100000 size: 000000001fed0000 end: 000000001ffd0000 type: 1
    copy_e820_map() type is E820_RAM
    copy_e820_map() start: 000000001ffd0000 size: 0000000000010000 end: 000000001ffe0000 type: 2
    copy_e820_map() start: 000000001ffe0000 size: 0000000000008000 end: 000000001ffe8000 type: 3
    copy_e820_map() start: 000000001ffe8000 size: 0000000000008000 end: 000000001fff0000 type: 4
    copy_e820_map() start: 000000001fff0000 size: 0000000000010000 end: 0000000020000000 type: 2
    copy_e820_map() start: 00000000fec00000 size: 0000000001400000 end: 0000000100000000 type: 2
    BIOS-e820: 0000000000000000 - 00000000000a0000 (usable)
    BIOS-e820: 00000000000f0000 - 0000000000100000 (reserved)
    BIOS-e820: 0000000000100000 - 000000001ffd0000 (usable)
    BIOS-e820: 000000001ffd0000 - 000000001ffe0000 (reserved)
    BIOS-e820: 000000001ffe0000 - 000000001ffe8000 (ACPI data)
    BIOS-e820: 000000001ffe8000 - 000000001fff0000 (ACPI NVS)
    BIOS-e820: 000000001fff0000 - 0000000020000000 (reserved)
    BIOS-e820: 00000000fec00000 - 0000000100000000 (reserved)
    0MB HIGHMEM available.
    511MB LOWMEM available.
    found SMP MP-table at 000fb280
    Using x86 segment limits to approximate NX protection
    Entering add_active_range(0, 0, 131024) 0 entries of 256 used
    Zone PFN ranges:
    DMA 0 -> 4096
    Normal 4096 -> 131024
    HighMem 131024 -> 131024
    early_node_map[1] active PFN ranges
    0: 0 -> 131024
    On node 0 totalpages: 131024
    DMA zone: 32 pages used for memmap
    DMA zone: 0 pages reserved
    DMA zone: 4064 pages, LIFO batch:0
    Normal zone: 991 pages used for memmap
    Normal zone: 125937 pages, LIFO batch:31
    HighMem zone: 0 pages used for memmap
    DMI 2.3 present.
    Using APIC driver default
    ACPI: RSDP (v000 IBM ) @ 0x000fe030
    ACPI: RSDT (v001 IBM M51SL 0x00000001 IBM 0x00000000) @ 0x1ffe0000
    ACPI: FADT (v001 IBM M51SL 0x00000001 IBM 0x00000000) @ 0x1ffe014b
    ACPI: ASF! (v016 IBM 0x01000000 0x00000000) @ 0x1ffe0030
    ACPI: MADT (v001 IBM M51SL 0x00000001 IBM 0x00000000) @ 0x1ffe00e3
    ACPI: DSDT (v001 IBM M51SL 0x00001000 MSFT 0x0100000d) @ 0x00000000
    ACPI: PM-Timer IO Port: 0x40c
    ACPI: Local APIC address 0xfee00000
    ACPI: LAPIC (acpi_id[0x01] lapic_id[0x00] enabled)
    Processor #0 15:2 APIC version 20
    ACPI: LAPIC_NMI (acpi_id[0xff] high edge lint[0x1])
    ACPI: Skipping IOAPIC probe due to 'noapic' option.
    Using ACPI for processor (LAPIC) configuration information
    Intel MultiProcessor Specification v1.4
    Virtual Wire compatibility mode.
    OEM ID: IBM Product ID: M51G APIC at: 0xFEE00000
    I/O APIC #1 Version 17 at 0xFEC00000.
    I/O APIC #2 Version 17 at 0xFEC01000.
    I/O APIC #3 Version 17 at 0xFEC02000.
    Enabling APIC mode: Flat. Using 3 I/O APICs
    Processors: 1
    Allocating PCI resources starting at 30000000 (gap: 20000000:dec00000)
    Detected 2799.273 MHz processor.
    Built 1 zonelists. Total pages: 130001
    Kernel command line: ro root=LABEL=/ rhgb quiet noapic
    mapped APIC to ffffd000 (fee00000)
    mapped IOAPIC to ffffc000 (fec00000)
    mapped IOAPIC to ffffb000 (fec01000)
    mapped IOAPIC to ffffa000 (fec02000)
    Enabling fast FPU save and restore... done.
    Enabling unmasked SIMD FPU exception support... done.
    Initializing CPU#0
    CPU 0 irqstacks, hard=c0720000 soft=c071f000
    PID hash table entries: 2048 (order: 11, 8192 bytes)
    Console: colour VGA+ 80x25
    Dentry cache hash table entries: 65536 (order: 6, 262144 bytes)
    Inode-cache hash table entries: 32768 (order: 5, 131072 bytes)
    Memory: 514436k/524096k available (2091k kernel code, 9076k reserved, 845k data, 232k init, 0k highmem)
    virtual kernel memory layout:
    fixmap : 0xfff9b000 - 0xfffff000 ( 400 kB)
    pkmap : 0xff800000 - 0xffc00000 (4096 kB)
    vmalloc : 0xe0800000 - 0xff7fe000 ( 495 MB)
    lowmem : 0xc0000000 - 0xdffd0000 ( 511 MB)
    .init : 0xc06e0000 - 0xc071a000 ( 232 kB)
    .data : 0xc060aefd - 0xc06de614 ( 845 kB)
    .text : 0xc0400000 - 0xc060aefd (2091 kB)
    Checking if this processor honours the WP bit even in supervisor mode... Ok.
    Calibrating delay using timer specific routine.. 5600.40 BogoMIPS (lpj=2800203)
    Security Framework v1.0.0 initialized
    SELinux: Initializing.
    SELinux: Starting in permissive mode
    selinux_register_security: Registering secondary module capability
    Capability LSM initialized as secondary
    Mount-cache hash table entries: 512
    CPU: After generic identify, caps: bfebfbff 00000000 00000000 00000000 00004400 00000000 00000000
    CPU: Trace cache: 12K uops, L1 D cache: 8K
    CPU: L2 cache: 512K
    CPU: After all inits, caps: bfebf3ff 00000000 00000000 00003080 00004400 00000000 00000000
    Intel machine check architecture supported.
    Intel machine check reporting enabled on CPU#0.
    CPU0: Intel P4/Xeon Extended MCE MSRs (12) available
    CPU: Intel(R) Pentium(R) 4 CPU 2.80GHz stepping 09
    Checking 'hlt' instruction... OK.
    ACPI: Core revision 20060707
    ACPI: setting ELCR to 0200 (from 06a0)
    NET: Registered protocol family 16
    ACPI: bus type pci registered
    PCI: PCI BIOS revision 2.10 entry at 0xf0220, last bus=2
    PCI: Using configuration type 1
    Setting up standard PCI resources
    ACPI: Interpreter enabled
    ACPI: Using PIC for interrupt routing
    ACPI: PCI Interrupt Link [PII0] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII1] (IRQs 3 4 5 6 7 *9 10 11 12 14 15)
    ACPI: PCI Interrupt Link [PII2] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII3] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII4] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII5] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII6] (IRQs 3 4 5 6 *7 9 10 11 12 14 15)
    ACPI: PCI Interrupt Link [PII7] (IRQs 3 4 *5 6 7 9 10 11 12 14 15)
    ACPI: PCI Interrupt Link [PII8] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PII9] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIA] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIB] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIC] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIID] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIE] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIF] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI10] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI11] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI12] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI13] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI14] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PI15] (IRQs 3 4 5 6 7 9 10 11 12 14 15) *0, disabled.
    ACPI: PCI Interrupt Link [PIIU] (IRQs 3 4 5 6 7 9 *10 11 12 14 15)
    ACPI: PCI Root Bridge [PCI0] (0000:00)
    PCI: Probing PCI hardware (bus 00)
    Boot video device is 0000:00:03.0
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI0._PRT]
    ACPI: PCI Root Bridge [PCI1] (0000:01)
    PCI: Probing PCI hardware (bus 01)
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI1._PRT]
    ACPI: PCI Root Bridge [PCI2] (0000:02)
    PCI: Probing PCI hardware (bus 02)
    ACPI: PCI Interrupt Routing Table [\_SB_.PCI2._PRT]
    Linux Plug and Play Support v0.97 (c) Adam Belay
    pnp: PnP ACPI init
    pnp: PnP ACPI: found 14 devices
    usbcore: registered new interface driver usbfs
    usbcore: registered new interface driver hub
    usbcore: registered new device driver usb
    PCI: Using ACPI for IRQ routing
    PCI: If a device doesn't work, try "pci=routeirq". If it helps, post a report
     
Loading...
Similar Threads - MySQl5 exhaust CPU
  1. InteractM
    Replies:
    3
    Views:
    255

Share This Page