ravsiyan

everything was fine, after a new post is made, then all of a sudden, hundreds of mysql processes were running :

[18:31:06] root@ski-jet [~]# mysqladmin proc
+——+——————+——————————+——————-+———+——+———————-+——————————————————————————————————+
| Id | User | Host | db | Command | Time | State | Info |
+——+——————+——————————+——————-+———+——+———————-+——————————————————————————————————+
| 1 | wp_press | webpage22.fadns.com:46062 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 3 | wp_press | webpage22.fadns.com:46075 | wpski_wp | Query | 38 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AN |
| 14 | wp_press | webpage22.fadns.com:46084 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 16 | wp_press | webpage22.fadns.com:46087 | wpski_wp | Query | 36 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 20 | wp_press | webpage22.fadns.com:46091 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 22 | wp_press | webpage22.fadns.com:46098 | wpski_wp | Query | 5 | Sending data | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (480560) ORDER BY meta_id ASC |
| 24 | wp_press | webpage22.fadns.com:46100 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |

thanks

but

everything was fine, after a new post is made, then all of a sudden, hundreds of mysql processes were running :

[18:31:06] root@ski-jet [~]# mysqladmin proc
+——+——————+——————————+——————-+———+——+———————-+——————————————————————————————————+
| Id | User | Host | db | Command | Time | State | Info |
+——+——————+——————————+——————-+———+——+———————-+——————————————————————————————————+
| 1 | wp_press | webpage22.fadns.com:46062 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 3 | wp_press | webpage22.fadns.com:46075 | wpski_wp | Query | 38 | Sending data | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = ‘post’ AN |
| 14 | wp_press | webpage22.fadns.com:46084 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 16 | wp_press | webpage22.fadns.com:46087 | wpski_wp | Query | 36 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 20 | wp_press | webpage22.fadns.com:46091 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |
| 22 | wp_press | webpage22.fadns.com:46098 | wpski_wp | Query | 5 | Sending data | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (480560) ORDER BY meta_id ASC |
| 24 | wp_press | webpage22.fadns.com:46100 | wpski_wp | Query | 37 | Copying to tmp table | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts |

i think after a new post is made, cache is cleaned.

`
Notice: add_option was called with an argument that is deprecated since version 2.3 with no alternative available. in /home/jetski2/public_html/wp-includes/functions.php on line 3739

Strict Standards: Declaration of Walker_Category2::start_lvl() should be compatible with Walker::start_lvl(&$output, $depth = 0, $args = Array) in /home/jetski2/public_html/wp-content/themes/wptheme/includes/fn-general.php on line 254

Strict Standards: Declaration of Walker_Category2::end_lvl() should be compatible with Walker::end_lvl(&$output, $depth = 0, $args = Array) in /home/jetski2/public_html/wp-content/themes/wptheme/includes/fn-general.php on line 254

Strict Standards: Declaration of Walker_Category2::start_el() should be compatible with Walker::start_el(&$output, $object, $depth = 0, $args = Array, $current_object_id = 0) in /home/jetski2/public_html/wp-content/themes/wptheme/includes/fn-general.php on line 254

Strict Standards: Declaration of Walker_Category2::end_el() should be compatible with Walker::end_el(&$output, $object, $depth = 0, $args = Array) in /home/jetski2/public_html/wp-content/themes/wptheme/includes/fn-general.php on line 254

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “Sidebar” sidebar. Defaulting to “sidebar-1”. Manually set the id to “sidebar-1” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “Post Widget” sidebar. Defaulting to “sidebar-2”. Manually set the id to “sidebar-2” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “single sidebar” sidebar. Defaulting to “sidebar-3”. Manually set the id to “sidebar-3” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “single sidebar160” sidebar. Defaulting to “sidebar-4”. Manually set the id to “sidebar-4” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “menu” sidebar. Defaulting to “sidebar-5”. Manually set the id to “sidebar-5” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: register_sidebar was called incorrectly. No id was set in the arguments array for the “Footer Widget” sidebar. Defaulting to “sidebar-6”. Manually set the id to “sidebar-6” to silence this notice and keep existing sidebar content. Please see Debugging in WordPress for more information. (This message was added in version 4.2.0.) in /home/jetski2/public_html/wp-includes/functions.php on line 3792

Notice: The called constructor method for WP_Widget is deprecated since version 4.3.0! Use

__construct()

instead. in /home/jetski2/public_html/wp-includes/functions.php on line 3624

Notice: The called constructor method for WP_Widget is deprecated since version 4.3.0! Use

__construct()

instead. in /home/jetski2/public_html/wp-includes/functions.php on line 3624

Notice: The called constructor method for WP_Widget is deprecated since version 4.3.0! Use

__construct()

instead. in /home/jetski2/public_html/wp-includes/functions.php on line 3624

Notice: The called constructor method for WP_Widget is deprecated since version 4.3.0! Use

__construct()

instead. in /home/jetski2/public_html/wp-includes/functions.php on line 3624
Notice: Undefined variable: output in /home/jetski2/public_html/wp-content/plugins/facebook-and-digg-thumbnail-generator/facebook-and-digg-thumbnail-generator.php on line 268
xmlns:og=”https://ogp.me/ns#” xmlns:fb=”https://ogp.me/ns/fb#”>
Notice: Undefined offset: 0 in /home/jetski2/public_html/wp-content/plugins/only-tweet-like-share-and-google-1/tweet-like-plusone.php on line 229