Delayed Insert in mysqladmin

  • Hello,

    I have a server with multiple WordPress sites running on it. The server configuration is quite standard: CentOS, Apache, MySQL, cPanel.
    I have mentioned that often I see the following lines in the mysqladmin process list for different WP databases:

    | Id | User | Host | db | Command | Time | State | Info
    +———+——————+———–+——————+—————-+——+———————-+———
    | 4688637 | DELAYED | localhost | salr4e1_wrdp2 | Delayed insert | 208 | Waiting for INSERT |

    I cannot understand why the insert is shown as delayed? If there are several such databases in the process list, then the load is growing up. It does not make my server feel well)

    I’m trying to use mysqlcheck -aro to repair such databases. Sometimes it helps but often not and I have to kill such processes to decrease the server load.

    Thank you for any advice.

  • The topic ‘Delayed Insert in mysqladmin’ is closed to new replies.