Latest update causing high load

  • Resolved danbeach

    (@danbeach)


    4 years, 4 months ago

    After updating to the latest version, 2 of my servers have been experiencing high load. I’m not even trying to use the plugin at the moment so guessing something was kicked off by a cron process. Looking at mysql, there’s usually a dozen or so processes like:
    [trimmed output of “show full processlist;”]

    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN wp_data wp_data TEXT DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN wp_data wp_data TEXT DEFAULT NULL
    rename result table | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN users_count users_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN users_count users_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN users_count users_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN files_count files_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN files_count files_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN files_count files_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN files_count files_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN files_count files_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN rows_count rows_count INT(20) DEFAULT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN clone_mode clone_mode VARCHAR(100) NOT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN clone_mode clone_mode VARCHAR(100) NOT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN version version VARCHAR(50) NOT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN version version VARCHAR(50) NOT NULL
    Waiting for table metadata lock | ALTER TABLE pag_ns_cloner_logs CHANGE COLUMN version version VARCHAR(50) NOT NULL

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Latest update causing high load’ is closed to new replies.