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.

Delayed insert

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

  1. big_bull

    big_bull Well-Known Member

    Joined:
    Nov 19, 2006
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    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 [~]#
     
  2. nilesh_kolte

    nilesh_kolte Well-Known Member

    Joined:
    Apr 13, 2006
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  3. big_bull

    big_bull Well-Known Member

    Joined:
    Nov 19, 2006
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    what should be the changes as per your idea?
     

Share This Page