‘Tablepress’ causing immense load on the server
-
Hello Tablepress team,
From the logs, I can see that one of the plugins ‘Tablepress’ was causing immense load on the server in the form of heavy SQL queries.
For now, I have disabled the mentioned plugin and server load starting to normalize.
Kindly tell me how to use tablepress plugin properly!
The page I need help with: [log in to see the link]
-
Hi,
thanks for your post, and sorry for the trouble.
What are the “heavy SQL queries” that you are seeing?
Regards,
TobiasHi,
regarding your tweet at https://twitter.com/rajinderverma01/status/1133343733812908033:
I don’t know where these queries are coming from, as TablePress does not directly run such queries. This seems to be a standard WordPress query.Regards,
TobiasHello Sir,
Thanks for your valuable reply, Cloudways server hosting support team had found that Tablepress plugin is producing heavy Mysql load,
Here is the string i am receiving an error:
fxzqyrsgug 116 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 394 fxzqyrsgu localhost fxzqyrsgug 85 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 437 fxzqyrsgu localhost fxzqyrsgug 55 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 467 fxzqyrsgu localhost fxzqyrsgug 24 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 480 fxzqyrsgu localhost fxzqyrsgug 12 Query Creating SELECT SQL_CALC_FOUND_ROWS wpl4_posts.ID FROM wpl4_posts WHERE 1=1 AND (((wpl4_p 491 root localhost 0 Query init show full processlist
After disabling Tablepress plugin, the server runs smoothly! without any load… I have 3800+ posts on my website in which I had used tablepress,
See screenshot:
-
This reply was modified 5 years, 9 months ago by
rajinderverma.
Hi,
I could imagine that this is maybe related to the TablePress search integration. Please try adding
add_filter( 'tablepress_wp_search_integration', '__return_false' );
to see if turning that off helps.
Regards,
TobiasHello Sir,
In which WordPress file I need to add this code and on which line number?
Kindly, tell me with a reference example of WordPress website!
Hi,
ah, sorry for missing that ?? Please add this to the end of your theme’s “functions.php” file (but before the
?>
if that exists).Regards,
TobiasI am using Newspaper V 8.5.1 theme with WordPress 5.2.1…
Hello sir, I am not a techy guy. Therefore, I understand these things with some difficulty…
Here is the function.php code: kindly tell me where to insert code with proper manner!
<?php
/*
Our portfolio: https://themeforest.net/user/tagDiv/portfolio
Thanks for using our theme!
tagDiv – 2017
*//**
* Load the speed booster framework + theme specific files
*/// load the deploy mode
require_once(‘td_deploy_mode.php’);// load the config
require_once(‘includes/td_config.php’);
add_action(‘td_global_after’, array(‘td_config’, ‘on_td_global_after_config’), 9); //we run on 9 priority to allow plugins to updage_key our apis while using the default priority of 10// load the wp booster
require_once(‘includes/wp_booster/td_wp_booster_functions.php’);require_once(‘includes/td_css_generator.php’);
require_once(‘includes/shortcodes/td_misc_shortcodes.php’);
require_once(‘includes/widgets/td_page_builder_widgets.php’); // widgets/*
* mobile theme css generator
* in wp-admin the main theme is loaded and the mobile theme functions are not included
* required in td_panel_data_source
* @todo – look for a more elegant solution(ex. generate the css on request)
*/
require_once(‘mobile/includes/td_css_generator_mob.php’);/* —————————————————————————-
* Woo Commerce
*/// breadcrumb
add_filter(‘woocommerce_breadcrumb_defaults’, ‘td_woocommerce_breadcrumbs’);
function td_woocommerce_breadcrumbs() {
return array(
‘delimiter’ => ‘ <i class=”td-icon-right td-bread-sep”></i> ‘,
‘wrap_before’ => ‘<div class=”entry-crumbs” itemprop=”breadcrumb”>’,
‘wrap_after’ => ‘</div>’,
‘before’ => ”,
‘after’ => ”,
‘home’ => _x(‘Home’, ‘breadcrumb’, ‘woocommerce’),
);
}// use own pagination
if (!function_exists(‘woocommerce_pagination’)) {
// pagination
function woocommerce_pagination() {
echo td_page_generator::get_pagination();
}
}// Override theme default specification for product 3 per row
// Number of product per page 8
add_filter(‘loop_shop_per_page’, create_function(‘$cols’, ‘return 4;’));if (!function_exists(‘woocommerce_output_related_products’)) {
// Number of related products
function woocommerce_output_related_products() {
woocommerce_related_products(array(
‘posts_per_page’ => 4,
‘columns’ => 4,
‘orderby’ => ‘rand’,
)); // Display 4 products in rows of 1
}
}/* —————————————————————————-
* bbPress
*/
// change avatar size to 40px
function td_bbp_change_avatar_size($author_avatar, $topic_id, $size) {
$author_avatar = ”;
if ($size == 14) {
$size = 40;
}
$topic_id = bbp_get_topic_id( $topic_id );
if ( !empty( $topic_id ) ) {
if ( !bbp_is_topic_anonymous( $topic_id ) ) {
$author_avatar = get_avatar( bbp_get_topic_author_id( $topic_id ), $size );
} else {
$author_avatar = get_avatar( get_post_meta( $topic_id, ‘_bbp_anonymous_email’, true ), $size );
}
}
return $author_avatar;
}
add_filter(‘bbp_get_topic_author_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);
add_filter(‘bbp_get_reply_author_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);
add_filter(‘bbp_get_current_user_avatar’, ‘td_bbp_change_avatar_size’, 20, 3);//add_action(‘shutdown’, ‘test_td’);
function test_td () {
if (!is_admin()){
td_api_base::_debug_get_used_on_page_components();
}}
/**
* tdStyleCustomizer.js is required
*/
if (TD_DEBUG_LIVE_THEME_STYLE) {
add_action(‘wp_footer’, ‘td_theme_style_footer’);
// new live theme demos
function td_theme_style_footer() {
?>
<div id=”td-theme-settings” class=”td-live-theme-demos td-theme-settings-small”>
<div class=”td-skin-body”>
<div class=”td-skin-wrap”>
<div class=”td-skin-container td-skin-buy”>BUY NEWSPAPER NOW!</div>
<div class=”td-skin-container td-skin-header”>GET AN AWESOME START!</div>
<div class=”td-skin-container td-skin-desc”>With easy <span>ONE CLICK INSTALL</span> and fully customizable options, our demos are the best start you’ll ever get!!</div>
<div class=”td-skin-container td-skin-content”>
<div class=”td-demos-list”>
<?php
$td_demo_names = array();foreach (td_global::$demo_list as $demo_id => $stack_params) {
$td_demo_names[$stack_params[‘text’]] = $demo_id;
?>
<div class=”td-set-theme-style”>” class=”td-set-theme-style-link td-popup td-popup-<?php echo $td_demo_names[$stack_params[‘text’]] ?>” data-img-url=”<?php echo td_global::$get_template_directory_uri ?>/demos_popup/large/<?php echo $demo_id; ?>.jpg”><span></span></div>
<?php } ?>
<div class=”td-set-theme-style-empty”></div>
<div class=”td-set-theme-style-empty”></div>
<div class=”clearfix”></div>
</div>
</div>
<div class=”td-skin-scroll”><i class=”td-icon-read-down”></i></div>
</div>
</div>
<div class=”clearfix”></div>
<div class=”td-set-hide-show”></div>
<div class=”td-screen-demo” data-width-preview=”380″></div>
</div>
<?php
}}
//td_demo_state::update_state(“ink”, ‘full’);
//print_r(td_global::$all_theme_panels_list);
/**
* Show info message for logged users when API classes are not defined (maybe some TAGDIV plugins are not installed)
*/
add_action( ‘get_footer’, ‘td_on_get_footer’ );
function td_on_get_footer() {
if ( is_user_logged_in() && ! td_util::tdc_is_live_editor_iframe() && td_util::get_check_installed_plugins() ) {ob_start();
?>
<script>setTimeout(function () {
confirm( “Did you disable any TagDiv plugins? \nWe’ve got some errors at loading API files. It could happen because of a disabled TagDiv plugin!”);
}, 3000);
</script>
<?phpecho ob_get_clean();
}
}Hi,
as I said, to the very end of the file.
Regards,
TobiasOk Sir, doing it..will tell you the response of this change, very soon!
Hi,
thanks!
Best wishes,
Tobias -
This reply was modified 5 years, 9 months ago by
- The topic ‘‘Tablepress’ causing immense load on the server’ is closed to new replies.