Ninja forms flooding mysql with select queries

Resolved

(@timeassistant)

Having issues where ninja forms is causing mysql to take 100% CPU and completely slow down websites. it basically does what seems to be thousands of these requests as shown below. This is a recent issue and seems to be mostly happening when the form being loaded has saved submissions. Empty forms don’t seem to trigger it. Quite often the page trying to load will end up with a 504 gateway timeout

some of the queries listed below:

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT Meta.key, Meta.value
                FROM wp_nf3_fields as Object
                JOIN wp_nf3_field_meta as Meta
                ON Object.id = Meta.parent_id
                WHERE Object.id = '2797'
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT Meta.key, Meta.value
                FROM wp_nf3_fields as Object
                JOIN wp_nf3_field_meta as Meta
                ON Object.id = Meta.parent_id
                WHERE Object.id = '3974'
Progress: 0.000

Viewing 1 replies (of 1 total)

Thread Starter

Greg Marshall

(@timeassistant)

2 years, 5 months ago

Here’s more


    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_action_meta</code>
                WHERE  <code>parent_id</code> = 457
Progress: 0.000

 Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 228
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_action_meta</code>
                WHERE  <code>parent_id</code> = 2106
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 663
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 21
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 463
Progress: 0.000

non forms pages in the dashbaord also have loads of these queries which is also adding extra load

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 140
Progress: 0.000

Command: Query
    Time: 0
   State: Sending data
    Info: SELECT <code>key</code>, <code>value</code>
                FROM   <code>wp_nf3_form_meta</code>
                WHERE  <code>parent_id</code> = 448

This reply was modified 2 years, 5 months ago by Greg Marshall.

Viewing 1 replies (of 1 total)

The topic ‘Ninja forms flooding mysql with select queries’ is closed to new replies.