mysql taking too much load

mywish1

• October 23, 2014 07:24

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

• 

  cPanelMichael

  • October 23, 2014 15:11

  Hello :) Could you verify that sufficient disk space and inodes are available? You can check this with commands such as:
  df -h df -i
  Thank you.

  0
• 

  mywish1

  • October 25, 2014 14:38

  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 [COLOR="silver">- - - 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

  0
• 

  smoge

  • October 26, 2014 07:40

  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.

  0
• 

  mywish1

  • October 26, 2014 09:02

  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

  0
• 

  mywish1

  • October 26, 2014 16:56

  rootfs 20G 19G 228M 99% / how to increased this ? plz help me

  0
• 

  smoge

  • October 26, 2014 22:23

  Ask your hosting company to give you more disc space

  0
• 

  mywish1

  • October 27, 2014 05:19

  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

  0
• 

  smoge

  • October 27, 2014 08:38

  20gb I'm sure are on a VPS. Ask your host! LOL! Very simple why are you making it so complicated??

  0
• 

  mywish1

  • October 27, 2014 12:55

  ohh my man i at server why you are not understand i have whm full server access

  0
• 

  cPanelMichael

  • October 28, 2014 17:47

  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.

  0

Please sign in to leave a comment.