Constantly requesting ALTER TABLE wp_simply_static_pages

Hi

Since I’ve updated my sites to version 2.1.5.1 there are huge spikes in the CPU usage during the generate process.
I’ve noticed that at some point of the process the plugin start generating a lot of queries for a DB schema update, over and over again the same update. I believe that for each new page added in wp_simply_static_pages such update request is being sent.

I have another site that is still using version 2.1.4.2 and there is no such problem.

I’m adding a small portion of the process list as a reference.

+-------+-------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ID    | USER  | TIME | STATE                           | INFO                                                                                                                                                                |
+-------+-------+------+---------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 23148 | eeb86 | 3001 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 22965 | eeb86 | 3001 | Waiting for table level lock    | UPDATE <code>wp_simply_static_pages</code> SET <code>content_hash</code> = 'e6d716de8f35ba6daf55d57e7fe0ed8d8e50f1f7', <code>last_modified_at</code> = '2021-11-04 12:04:21' WHERE <code>id</code> = '12989'    |
| 23201 | eeb86 | 2994 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23197 | eeb86 | 2994 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23219 | eeb86 | 2992 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23226 | eeb86 | 2991 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23243 | eeb86 | 2989 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23257 | eeb86 | 2987 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23254 | eeb86 | 2987 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23271 | eeb86 | 2985 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |
| 23300 | eeb86 | 2983 | Waiting for table metadata lock | ALTER TABLE wp_simply_static_pages CHANGE COLUMN <code>id</code> id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT                                                                |

• This topic was modified 3 years, 4 months ago by Dimitar Marinov.