Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Delayed insert

Discussion in 'Database Discussion' started by big_bull, Aug 7, 2010.

  1. big_bull

    big_bull Well-Known Member

    Joined:
    Nov 19, 2006
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    Hello All,

    Whenever I am checking for mysql processes some of the databases shows Delayed Insert, whenever I kills the PID for it the server load decreases, why such queries shows as Delayed Insert and what can I do to prevent it.
    root@server [~]# mysqladmin pr |grep host1
    | 20682 | DELAYED | localhost | host1_wrdp3 | Delayed insert | 143 | Waiting for INSERT | |
    root@server [~]# mysqladmin pr |grep host1
    | 20682 | DELAYED | localhost | host1_wrdp3 | Delayed insert | 149 | Waiting for INSERT | |
    root@server [~]# mysqladmin pr |grep host1
    | 20682 | DELAYED | localhost | host1_wrdp3 | Delayed insert | 150 | Waiting for INSERT | |
    root@server [~]#
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    65
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    Pune ,India
    cPanel Access Level:
    Root Administrator
    Seems to be your mysql is not configure correctly. Modify your my.cnf and reconfigure it properly.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. big_bull

    big_bull Well-Known Member

    Joined:
    Nov 19, 2006
    Messages:
    150
    Likes Received:
    0
    Trophy Points:
    166
    cPanel Access Level:
    Root Administrator
    what should be the changes as per your idea?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice