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 Member

    Joined:
    Nov 19, 2006
    Messages:
    151
    Likes Received:
    0
    Trophy Points:
    16
    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 Member

    Joined:
    Apr 13, 2006
    Messages:
    66
    Likes Received:
    0
    Trophy Points:
    6
    Seems to be your mysql is not configure correctly. Modify your my.cnf and reconfigure it properly.
     
  3. big_bull

    big_bull Member

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

Share This Page