High cpu usage?
-
Hi there. Last days was pretty intense for me, trying to figure out what slows my site and spikes the CPU Usage to max. Everything happens pretty much random so its hard to catch it. But i’ve asked my providers for check and they told me that :
The case is mostly caused by the “SQL_CALC_FOUND_ROWS” query. I see it used in the following plugins:
mycred, ultimate-member, w3-total-cache and wordfence. From these we can exclude (for now) w3-total-cache and wordfence, because many other customers use them and we have not observed a similar case with them.
It is quite possible that the case occurs either during higher traffic or during the execution of a certain function. From cPanel -> Resource usage you can monitor the resources, currently almost none are being used (I guess from the plug-ins being turned off).
What I can recommend you is when there is more traffic to turn off the plugins 1 by 1 (by waiting a few minutes) and monitor the resource statistics.
From all those plugins, i’m using only the Ultimate member last version with last version of WordPress. Is there actual problem with that query , which cause my cpu usage to spike?
-
https://imgur.com/a/CxHd56v – i’ve disable cache for users after i posted. Should i unstick tables?
And i’m using those custom codes in my function.php, could any of them doing problems?
//////////////////////////////////////////////////////////////////////// // Ultimate Member Profile Display Name Integration //////////////////// //////////////////////////////////////////////////////////////////////// add_filter('wpdiscuz_comment_author', 'wpdiscuz_um_author', 10, 2); function wpdiscuz_um_author($author_name, $comment) { if ($comment->user_id) { $column = 'display_name'; // Other options: 'user_login', 'user_nicename', 'nickname', 'first_name', 'last_name' if (class_exists('UM_API') || class_exists('UM')) { um_fetch_user($comment->user_id); $author_name = um_user($column); um_reset_user(); } else { $author_name = get_the_author_meta($column, $comment->user_id); } } return $author_name; } //////////////////////////////////////////////////////////////////////// // Ultimate Member Profile URL Integration ///////////////////////////// //////////////////////////////////////////////////////////////////////// add_filter('wpdiscuz_profile_url', 'wpdiscuz_um_profile_url', 10, 2); function wpdiscuz_um_profile_url($profile_url, $user) { if ($user && (class_exists('UM_API') || class_exists('UM'))) { um_fetch_user($user->ID); $profile_url = um_user_profile_url(); } return $profile_url; } function um_custom_validate_bot_spam( $key, $array, $args ) { if ( isset( $args[$key] ) && $args[$key] != 'ОТАКУ ФЕН' ) { UM()->form()->add_error( $key, __( 'Напишете думите правилно и с главни букви.', 'ultimate-member' ) ); } } add_action( 'um_custom_field_validation_bot_spam', 'um_custom_validate_bot_spam', 30, 3 ); add_filter( 'auto_update_plugin', '__return_false' ); /* Disable oEmbeds author name & author url ~ Stops Showing in embeds */ add_filter( 'oembed_response_data', 'disable_embeds_filter_oembed_response_data_' ); function disable_embeds_filter_oembed_response_data_( $data ) { unset($data['author_url']); unset($data['author_name']); return $data; } add_filter( "um_user_profile_tabs", "um_072522_add_comment_count", 1000 ); function um_072522_add_comment_count( $tabs ) { if( isset( $tabs['comments'] ) && ! isset( $tabs['comments']['notifier'] ) ){ $args = array( 'user_id' => um_profile_id(), // Use user_id. 'count' => true // Return only the count. ); $comments_count = get_comments( $args ); $tabs['comments']['notifier'] = $comments_count; } return $tabs;It’s only when the code for “Enable custom table for usermeta”
at UM Settings -> Misc is enabled theSQL_CALC_FOUND_ROWSis used.Did you switch to the UM usermeta table because of bad performance
with the WP usermeta table?How many registered Users do you have?
Unclick the “Disable Cache User Profile” to enable UM User caching.
You can clear the Cache at UM Dashboard if there are many Users cached.
The topic ‘High cpu usage?’ is closed to new replies.
