Forums



Results 1 to 3 of 3

Thread: Delayed insert

  1. 08-07-2010, 03:28 PM #1
    big_bull
    big_bull is offline
    Member big_bull's Avatar
    Join Date
    Nov 2006
    Posts
    149
    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.”
    Reply With Quote Reply With Quote
  2. 08-08-2010, 01:42 PM #2
    nilesh_kolte
    nilesh_kolte is offline
    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 ~~~
    Reply With Quote Reply With Quote
  3. 08-09-2010, 12:06 PM #3
    big_bull
    big_bull is offline
    Member big_bull's Avatar
    Join Date
    Nov 2006
    Posts
    149
    cPanel/WHM Access Level

    Root Administrator

    Default

    what should be the changes as per your idea?
    “I am easily satisfied with the very best.”
    Reply With Quote Reply With Quote
« Error while connecting to MySQL. Failover enacted. | PhpMyAdmin and Remote MySQL server »

Similar Threads

  1. Bulk DNS insert
    By e0xbr in forum cPanel & WHM Discussions
    Replies: 4
    Last Post: 03-12-2012, 02:28 AM
  2. Delayed insert
    By big_bull in forum cPanel & WHM Discussions
    Replies: 2
    Last Post: 08-09-2010, 12:06 PM
  3. insert text to all messages
    By caeos in forum E-mail Discussions
    Replies: 0
    Last Post: 10-20-2008, 10:39 AM
  4. WHM - Common Tools Insert
    By Solokron in forum cPanel & WHM Discussions
    Replies: 6
    Last Post: 02-21-2008, 08:32 AM
  5. How to insert some php code ?
    By Radio_Head in forum Themes and Branding
    Replies: 5
    Last Post: 10-18-2002, 08:59 PM