Server sql loop or? - (Slow write performance)

Discussion in 'MySQL' started by ASTRAPI, Nov 17, 2010.

  1. #1
    Hello

    On my server (forum) the performance of read and open topics and everything on the forum is super high and less than half second even on pick times.

    My problem is sql when i have only 10 users per minute the database shows load of cpu: 114% and ram 5%.

    At pick time it goes to about cpu 170% and ram if i am not wrong is the same about 5%.

    The problem is at pick time when i try to edit pin unpin move a topic as it takes more than 20 seconds and sometimes i get 500 intrnal server error.

    (researching about that error i set all folders on correct permissions and i use 775 permissions on the places that need it...)

    I think something is always hit the sql and don't let it to calm down :(

    From cpanel and statistics i was trace the process and got this:

    Process 27265 attached - interrupt to quit
    select(4, [3], NULL, NULL, NULL)        = 1 (in [3])
    fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
    accept(3, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 444
    fcntl(3, F_SETFL, O_RDWR)               = 0
    getsockname(444, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
    fcntl(444, F_SETFL, O_RDONLY)           = 0
    fcntl(444, F_GETFL)                     = 0x2 (flags O_RDWR)
    fcntl(444, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
    setsockopt(444, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
    futex(0xda3544, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xda3540, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
    futex(0xda2960, FUTEX_WAKE_PRIVATE, 1)  = 1
    select(4, [3], NULL, NULL, NULL)        = 1 (in [3])
    fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
    accept(3, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 70
    fcntl(3, F_SETFL, O_RDWR)               = 0
    getsockname(70, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
    fcntl(70, F_SETFL, O_RDONLY)            = 0
    fcntl(70, F_GETFL)                      = 0x2 (flags O_RDWR)
    fcntl(70, F_SETFL, O_RDWR|O_NONBLOCK)   = 0
    setsockopt(70, SOL_IP, IP_TOS, [8], 4)  = -1 EOPNOTSUPP (Operation not supported)
    futex(0xda3544, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xda3540, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
    futex(0xda2960, FUTEX_WAKE_PRIVATE, 1)  = 1
    select(4, [3], NULL, NULL, NULL)        = 1 (in [3])
    fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
    accept(3, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 444
    fcntl(3, F_SETFL, O_RDWR)               = 0
    getsockname(444, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
    fcntl(444, F_SETFL, O_RDONLY)           = 0
    fcntl(444, F_GETFL)                     = 0x2 (flags O_RDWR)
    fcntl(444, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
    setsockopt(444, SOL_IP, IP_TOS, [8], 4) = -1 EOPNOTSUPP (Operation not supported)
    futex(0xda3544, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0xda3540, {FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
    futex(0xda2960, FUTEX_WAKE_PRIVATE, 1)  = 0
    select(4, [3], NULL, NULL, NULL)        = 1 (in [3])
    fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
    accept(3, {sa_family=AF_FILE, path=@""}, [8516025424675864578]) = 444
    fcntl(3, F_SETFL, O_RDWR)               = 0
    getsockname(444, {sa_family=AF_FILE, path="/var/lib/mysql\1"...}, [8516025424675864604]) = 0
    fcntl(444, F_SETFL, O_RDONLY)           = 0
    fcntl(444, F_GETFL)                     = 0x2 (flags O_RDWR)
    fcntl(444, F_SETFL, O_RDWR|O_NONBLOCK)  = 0
    Code (markup):

    If any expert have an idea please let me know :)

    My server:

    2x Intel Xeon Quad 5405
    16GB ram
    4x SAS disks raid 10


    Thank you
     
    ASTRAPI, Nov 17, 2010 IP
  2. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #2
    Is there anything else (other than forum) running on this server?
     
    mwasif, Nov 26, 2010 IP