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.

mysql taking too much load

Discussion in 'General Discussion' started by mywish1, Oct 23, 2014.

  1. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    hi guys
    i have good server but my website getting too much load and now open properlly and now i m getting this error

    Unknown table engine 'InnoDB'

    before i m getting this error Can't create/write to file '/tmp/MYsydQEY' (Errcode: 28) so please guys help me what i do to resolve this issue my website offline so any body setup my server for me please any body help me via skype thanks

    any body help me i m still getting this issue and plz also any body optimized my mysql configuration and other setting plz
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Could you verify that sufficient disk space and inodes are available? You can check this with commands such as:

    Code:
    df -h
    df -i
    Thank you.
     
  3. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    what i do my mysql taking too much load and my server load is very high like this Load Averages: 26.64 21.89 18.27
    so please help me what i do any body can optimized my mysql load or manage something thanks

    - - - Updated - - -

    df -h
    Filesystem Size Used Avail Use% Mounted on
    rootfs 20G 18G 1.4G 93% /
    /dev/root 20G 18G 1.4G 93% /
    devtmpfs 32G 236K 32G 1% /dev
    /dev/sda2 1.8T 16G 1.7T 1% /home
    tmpfs 32G 0 32G 0% /dev/shm
    /dev/loop0 485M 14M 446M 3% /tmp
    /dev/loop0 485M 14M 446M 3% /var/tmp

    and

    df -i
    Filesystem Inodes IUsed IFree IUse% Mounted on
    rootfs 1281120 207748 1073372 17% /
    /dev/root 1281120 207748 1073372 17% /
    devtmpfs 8242282 2329 8239953 1% /dev
    /dev/sda2 120176640 563163 119613477 1% /home
    tmpfs 8250640 1 8250639 1% /dev/shm
    /dev/loop0 128016 2423 125593 2% /tmp
    /dev/loop0 128016 2423 125593 2% /var/tmp

    please tel me what i do i have very high load thanks
     
  4. smoge

    smoge Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    You perhaps have some queries that are using more than the half GB allocated to /tmp. Increase the size of temp or point MySQL to use a different file system. But overall your disc space is low - seems you are on a VPS so ask to have that increased first then deal with the tmp space issue.
     
  5. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    my server root space is end

    hi
    showing space is end
    here is disk space what i need to do to increased my space

    Current Disk Usage

    Filesystem Size Used Avail Use% Mounted on
    rootfs 20G 19G 228M 99% /
    /dev/root 20G 19G 228M 99% /
    devtmpfs 32G 236K 32G 1% /dev
    /dev/sda2 1.8T 14G 1.7T 1% /home
    tmpfs 32G 0 32G 0% /dev/shm
    /dev/loop0 485M 13M 447M 3% /tmp
    /dev/loop0 485M 13M 447M 3% /var/tmp

    please help me 228m left only
     
  6. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    rootfs 20G 19G 228M 99% / how to increased this ? plz help me
     
  7. smoge

    smoge Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    Ask your hosting company to give you more disc space
     
  8. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    but its almost over of rootfs 20G 19G 228M 99% / how i can increased this
    i need to increaed it its almost full and my other space is 4tb
     
  9. smoge

    smoge Well-Known Member

    Joined:
    Jul 2, 2004
    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    6
    20gb I'm sure are on a VPS. Ask your host! LOL! Very simple why are you making it so complicated??
     
  10. mywish1

    mywish1 Member

    Joined:
    Sep 13, 2014
    Messages:
    16
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    ohh my man i at server why you are not understand i have whm full server access
     
  11. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,811
    Likes Received:
    671
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can use the following document to help determine what's using the most disk space:

    Manage HD Space

    However, if it's all general usage, then you may need to consult with your VPS hosting provider to see if they can increase the space available to your VPS.

    Thank you.
     
Loading...

Share This Page