Results 1 to 3 of 3

Thread: Delayed insert

  1. #1
    Registered Member big_bull's Avatar
    Join Date
    Nov 2006
    Posts
    151
    cPanel/WHM Access Level

    Root Administrator

    Default Delayed insert

    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 [~]#
    “I am easily satisfied with the very best.”

  2. #2
    Registered Member nilesh_kolte's Avatar
    Join Date
    Apr 2006
    Posts
    66

    Default

    Seems to be your mysql is not configure correctly. Modify your my.cnf and reconfigure it properly.
    ~~~ Cool Buddy ~~~

  3. #3
    Registered Member big_bull's Avatar
    Join Date
    Nov 2006
    Posts
    151
    cPanel/WHM Access Level

    Root Administrator

    Default

    what should be the changes as per your idea?
    “I am easily satisfied with the very best.”

Similar Threads

  1. eximstats SQL delayed insert
    By PPNSteve in forum E-mail Discussions
    Replies: 84
    Last Post: 04-23-2013, 01:55 PM
  2. Bulk DNS insert
    By e0xbr in forum cPanel & WHM Discussions
    Replies: 4
    Last Post: 03-12-2012, 02:28 AM
  3. Delayed insert
    By big_bull in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 08-09-2010, 12:06 PM
  4. insert text to all messages
    By caeos in forum E-mail Discussions
    Replies: 0
    Last Post: 10-20-2008, 10:39 AM
  5. How to insert some php code ?
    By Radio_Head in forum User Experience
    Replies: 5
    Last Post: 10-18-2002, 08:59 PM
bargain