WordPress.org

Ready to get started?Download WordPress

Forums

Delayed Insert in mysqladmin (1 post)

  1. lush4
    Member
    Posted 3 years ago #

    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.

Topic Closed

This topic has been closed to new replies.

About this Topic