[Resolved] Site extremely slow when traffic increases

[Author]

Posts

[philippeB-3]

I am trying to:
No relevant

Link to a page where the issue can be seen:
hidden link

I expected to see:
Rapid display of the page

Instead, I got:
Server crashes when traffic gets higher

On this log
*pagination_permalink_data() /home/ziofix/web/wp-content/plugins/wp-views/embedded/inc/wpv-pagination-embedded.php:1664* it consumes too much data.

I'm only displaying 9 custom post type on the View page. I don't understand why it is such CPU consuming.

- Have I done something wrong with Ajax ?
- Have I set up the plugin not in a good way ?

Thanks in advance.
Nb this site records 30K monthly and I haven't registered Toolset plugins yet (I've done it on the dev environment)

Thanks a lot for you help

[Beda]

There is a connection issue to the database, I cannot reach the site.

Can you confirm that as soon the View is removed from the very page, the page loads accordingly fast?

There are a few things that might be the cause, however, I rather think it might be due to the meanwhile outdated MySQL version 5.5.5 used on your server.
WordPress itself recommends 5.6, we require 5.6:
https://wordpress.org/about/requirements/
https://toolset.com/toolset-requirements/

It might be that you use some query settings which require a higher MySQL version and that you experience hidden errors slowing down the site.

Of course, it could also be a lot of other factors playing at this issue.
To confirm whether or not you could solve it with a higher MySQL version you could try a duplicate on a MAMP or WAMP server, or, you can send me a copy, so I can try locally.
Then, I could feedback my findings and accordingly you could react.

However, note that the MySQL version update is a must if using Toolset, as the minimum version required is 5.6

I've activated a private reply in case you want me to test it on a higher version and generally check if I can spot other issues.

[Beda]

1. The MySQL on this server is not 5.6 - it is 5.5.5. I see this in the debug information you sent. If the site you seek access to is not on this server, please let me know the proper Site Address, as you can register up to 3 sites but no more, as you own a Toolset Subscription for 3 sites max. If the issue is of another server/site you should submit me the Debug from there.

2. Given the size, yes, it's impossible to send me a copy of this site.

3. Given the size, every WordPress native Query (and Views uses those) will probably start to fail, as all posts are stored in one only database table - also known as a bottleneck.
This is expected if you query a database so large. Of course, it will depend a lot on the data you query and how you show it.

4. PHP version should be fine, it's 7.+, which surely is a faster solution than any other version supported by Toolset

5. When I load hidden link (I assume this is the same as on your live site), then I see no delay, even loading the content freshly from noncached data (cmd+r)
(see screenshot)

6. There are a lot of errors though, which could be the cause of slowdowns.
The JS errors are all not related to Toolset:
- PLEASE NOTE: this is just a notification that the Sticky Menu (or Anything!) plugin is now working in Debug Mode. (sticky-menu-or-anything-on-scroll Plugin)
- Even though this mode will not impact any functionality, do NOT use this mode in production environments! (same sticky plugin)
- above errors repeat.

Other than that I saw no ovious slowdowns

[philippeB-3]

Hello Beda,

Let's make it simpler 🙂
The site URL is this one => hidden link
The URL in cause of crashing is this one => hidden link

1. Hosting provider has now upgraded mySQL to 5.7. I've joined Debug info.
As you can see the page loads correctly, do you think everything should work fine now with traffic increase (we've deleted the access to the page for the moment) ?

{"core":{"Wordpress":{"Multisite":"No","SiteURL":"https:\/\/www.aperodujeudi.com","HomeURL":"https:\/\/www.aperodujeudi.com","Version":"5.2.2","PermalinkStructure":"\/%postname%\/","PostTypes":"post, page, attachment, revision, nav_menu_item, custom_css, customize_changeset, oembed_cache, user_request, wp_block, layout, project, cred-form, cred-user-form, wp-types-group, wp-types-user-group, wp-types-term-group, acf-field-group, acf-field, ai1ec_event, view, view-template, mc4wp-form, bar, cred_rel_form","PostSatus":"publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, acf-disabled, hidden"},"Server":{"jQueryVersion":"1.12.4-wp","PHPVersion":"7.2.20-1+ubuntu16.04.1+deb.sury.org+1","MySQLVersion":"5.7.26","ServerSoftware":"nginx\/1.10.3"},"PHP":{"MemoryLimit":"268435456","UploadMax":"8M","PostMax":"8M","TimeLimit":"300","MaxInputVars":"5000"}},"plugins":{"active_plugins":{"gravityforms\/gravityforms.php":{"Name":"Gravity Forms","PluginURI":"https:\/\/www.gravityforms.com","Version":"2.4.11","Author":"rocketgenius","AuthorURI":"https:\/\/www.rocketgenius.com","TextDomain":"gravityforms","DomainPath":"\/languages","Network":false,"Title":"Gravity Forms","AuthorName":"rocketgenius"},"add-widget-after-content\/add-widget-after-content.php":{"Name":"Add Widget After Content","PluginURI":"https:\/\/pintopsolutions.com\/downloads\/add-widget-after-content\/","Version":"2.4.1","Author":"Arelthia Phillips","AuthorURI":"http:\/\/www.arelthiaphillips.com","TextDomain":"add-widget-after-content","DomainPath":"\/languages","Network":false,"Title":"Add Widget After Content","AuthorName":"Arelthia Phillips"},"advanced-custom-fields-pro\/acf.php":{"Name":"Advanced Custom Fields PRO","PluginURI":"https:\/\/www.advancedcustomfields.com","Version":"5.8.2","Author":"Elliot Condon","AuthorURI":"https:\/\/www.advancedcustomfields.com","TextDomain":"acf","DomainPath":"\/lang","Network":false,"Title":"Advanced Custom Fields PRO","AuthorName":"Elliot Condon"},"all-in-one-event-calendar\/all-in-one-event-calendar.php":{"Name":"All-in-One Event Calendar by Time.ly","PluginURI":"https:\/\/wordpress.org\/plugins\/all-in-one-event-calendar\/","Version":"2.5.41","Author":"Time.ly Network Inc.","AuthorURI":"https:\/\/time.ly\/","TextDomain":"all-in-one-event-calendar","DomainPath":"\/language","Network":false,"Title":"All-in-One Event Calendar by Time.ly","AuthorName":"Time.ly Network Inc."},"all-in-one-seo-pack\/all_in_one_seo_pack.php":{"Name":"All In One SEO Pack","PluginURI":"https:\/\/semperplugins.com\/all-in-one-seo-pack-pro-version\/","Version":"3.1.1","Author":"Michael Torbert","AuthorURI":"https:\/\/semperplugins.com\/all-in-one-seo-pack-pro-version\/","TextDomain":"all-in-one-seo-pack","DomainPath":"\/i18n\/","Network":false,"Title":"All In One SEO Pack","AuthorName":"Michael Torbert"},"cm-table-of-content\/cm-table-of-content.php":{"Name":"CM Table Of Contents","PluginURI":"https:\/\/www.cminds.com\/store\/purchase-cm-table-of-content-plugin-for-wordpress\/","Version":"1.1.1","Author":"CreativeMindsSolutions","AuthorURI":"https:\/\/www.cminds.com\/","TextDomain":"cm-table-of-content","DomainPath":"","Network":false,"Title":"CM Table Of Contents","AuthorName":"CreativeMindsSolutions"},"cred-frontend-editor\/plugin.php":{"Name":"Toolset Forms","PluginURI":"https:\/\/toolset.com\/home\/toolset-components\/#cred","Version":"2.4","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com\/","TextDomain":"cred-frontend-editor","DomainPath":"","Network":false,"Title":"Toolset Forms","AuthorName":"OnTheGoSystems"},"duplicator\/duplicator.php":{"Name":"Duplicator","PluginURI":"https:\/\/snapcreek.com\/duplicator\/duplicator-free\/","Version":"1.3.18","Author":"Snap Creek","AuthorURI":"http:\/\/www.snapcreek.com\/duplicator\/","TextDomain":"duplicator","DomainPath":"","Network":false,"Title":"Duplicator","AuthorName":"Snap Creek"},"geo-mashup\/geo-mashup.php":{"Name":"Geo Mashup","PluginURI":"https:\/\/wordpress.org\/plugins\/geo-mashup\/","Version":"1.11.5","Author":"Dylan Kuhn","AuthorURI":"http:\/\/www.cyberhobo.net\/","TextDomain":"GeoMashup","DomainPath":"\/lang","Network":false,"Title":"Geo Mashup","AuthorName":"Dylan Kuhn"},"gravityformsmailchimp\/mailchimp.php":{"Name":"Gravity Forms MailChimp Add-On","PluginURI":"https:\/\/www.gravityforms.com","Version":"4.6","Author":"rocketgenius","AuthorURI":"https:\/\/www.rocketgenius.com","TextDomain":"gravityformsmailchimp","DomainPath":"\/languages","Network":false,"Title":"Gravity Forms MailChimp Add-On","AuthorName":"rocketgenius"},"gravityformsstripe\/stripe.php":{"Name":"Gravity Forms Stripe Add-On","PluginURI":"https:\/\/www.gravityforms.com","Version":"2.7","Author":"rocketgenius","AuthorURI":"https:\/\/www.rocketgenius.com","TextDomain":"gravityformsstripe","DomainPath":"\/languages","Network":false,"Title":"Gravity Forms Stripe Add-On","AuthorName":"rocketgenius"},"gravityformsuserregistration\/userregistration.php":{"Name":"Gravity Forms User Registration Add-On","PluginURI":"https:\/\/www.gravityforms.com","Version":"4.2","Author":"rocketgenius","AuthorURI":"https:\/\/www.rocketgenius.com","TextDomain":"gravityformsuserregistration","DomainPath":"\/languages","Network":false,"Title":"Gravity Forms User Registration Add-On","AuthorName":"rocketgenius"},"like-box-widget\/like-box-widget.php":{"Name":"Widget Facebook like box","PluginURI":"https:\/\/wordpress.org\/like-box-widget\/","Version":"1.0","Author":"wpladge","AuthorURI":"https:\/\/wordpress.org\/like-box-widget\/","TextDomain":"like-box-widget","DomainPath":"","Network":false,"Title":"Widget Facebook like box","AuthorName":"wpladge"},"mailchimp-for-wp\/mailchimp-for-wp.php":{"Name":"Mailchimp for WordPress","PluginURI":"https:\/\/mc4wp.com\/#utm_source=wp-plugin\u0026utm_medium=mailchimp-for-wp\u0026utm_campaign=plugins-page","Version":"4.5.2","Author":"ibericode","AuthorURI":"https:\/\/ibericode.com\/","TextDomain":"mailchimp-for-wp","DomainPath":"\/languages","Network":false,"Title":"Mailchimp for WordPress","AuthorName":"ibericode"},"mailchimp-top-bar\/mailchimp-top-bar.php":{"Name":"MailChimp for WordPress - Top Bar","PluginURI":"https:\/\/mc4wp.com\/#utm_source=wp-plugin\u0026utm_medium=mailchimp-top-bar\u0026utm_campaign=plugins-page","Version":"1.3.2","Author":"ibericode","AuthorURI":"https:\/\/ibericode.com\/","TextDomain":"mailchimp-top-bar","DomainPath":"\/languages","Network":false,"Title":"MailChimp for WordPress - Top Bar","AuthorName":"ibericode"},"really-simple-ssl\/rlrsssl-really-simple-ssl.php":{"Name":"Really Simple SSL","PluginURI":"https:\/\/www.really-simple-ssl.com","Version":"3.2.3","Author":"Rogier Lankhorst, Mark Wolters","AuthorURI":"https:\/\/really-simple-plugins.com","TextDomain":"really-simple-ssl","DomainPath":"\/languages","Network":false,"Title":"Really Simple SSL","AuthorName":"Rogier Lankhorst, Mark Wolters"},"redirection\/redirection.php":{"Name":"Redirection","PluginURI":"https:\/\/redirection.me\/","Version":"4.3.1","Author":"John Godley","AuthorURI":"https:\/\/johngodley.com","TextDomain":"redirection","DomainPath":"\/locale","Network":false,"Title":"Redirection","AuthorName":"John Godley"},"shortcodes-ultimate\/shortcodes-ultimate.php":{"Name":"Shortcodes Ultimate","PluginURI":"https:\/\/getshortcodes.com\/","Version":"5.3.0","Author":"Vladimir Anokhin","AuthorURI":"https:\/\/vanokhin.com\/","TextDomain":"shortcodes-ultimate","DomainPath":"\/languages","Network":false,"Title":"Shortcodes Ultimate","AuthorName":"Vladimir Anokhin"},"simple-lightbox\/main.php":{"Name":"Simple Lightbox","PluginURI":"http:\/\/archetyped.com\/tools\/simple-lightbox\/","Version":"2.7.1","Author":"Archetyped","AuthorURI":"http:\/\/archetyped.com","TextDomain":"simple-lightbox","DomainPath":"\/l10n","Network":false,"Title":"Simple Lightbox","AuthorName":"Archetyped"},"social-icon-widget\/social-icon.php":{"Name":"Social Icon Widget","PluginURI":"https:\/\/mostafizshamim.com\/social-icon-widget","Version":"1.0.2","Author":"Mostafiz Shamim","AuthorURI":"https:\/\/mostafizshamim.com","TextDomain":"socialiconwidget","DomainPath":"","Network":false,"Title":"Social Icon Widget","AuthorName":"Mostafiz Shamim"},"sticky-menu-or-anything-on-scroll\/sticky-menu-or-anything.php":{"Name":"Sticky Menu (or Anything!) on Scroll","PluginURI":"http:\/\/www.senff.com\/plugins\/sticky-anything-wp","Version":"2.1.1","Author":"Mark Senff","AuthorURI":"http:\/\/www.senff.com","TextDomain":"sticky-menu-or-anything-on-scroll","DomainPath":"","Network":false,"Title":"Sticky Menu (or Anything!) on Scroll","AuthorName":"Mark Senff"},"toolset-maps\/toolset-maps-loader.php":{"Name":"Toolset Maps","PluginURI":"https:\/\/toolset.com\/documentation\/user-guides\/display-on-google-maps\/","Version":"1.8.1","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"toolset-maps","DomainPath":"\/languages","Network":false,"Title":"Toolset Maps","AuthorName":"OnTheGoSystems"},"types\/wpcf.php":{"Name":"Toolset Types","PluginURI":"https:\/\/toolset.com\/?utm_source=typesplugin\u0026utm_campaign=types\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"3.3.2","Author":"OnTheGoSystems","AuthorURI":"http:\/\/www.onthegosystems.com","TextDomain":"types","DomainPath":"","Network":false,"Title":"Toolset Types","AuthorName":"OnTheGoSystems"},"uix-shortcodes\/uix-shortcodes.php":{"Name":"Uix Shortcodes","PluginURI":"https:\/\/uiux.cc\/wp-plugins\/uix-shortcodes\/","Version":"1.8.0","Author":"UIUX Lab","AuthorURI":"https:\/\/uiux.cc","TextDomain":"uix-shortcodes","DomainPath":"\/languages","Network":false,"Title":"Uix Shortcodes","AuthorName":"UIUX Lab"},"wordpress-importer\/wordpress-importer.php":{"Name":"WordPress Importer","PluginURI":"https:\/\/wordpress.org\/plugins\/wordpress-importer\/","Version":"0.6.4","Author":"wordpressdotorg","AuthorURI":"https:\/\/wordpress.org\/","TextDomain":"wordpress-importer","DomainPath":"","Network":false,"Title":"WordPress Importer","AuthorName":"wordpressdotorg"},"wordpress-popup\/popover.php":{"Name":"Hustle","PluginURI":"https:\/\/wordpress.org\/plugins\/wordpress-popup\/","Version":"7.0.0.1","Author":"WPMU DEV","AuthorURI":"https:\/\/premium.wpmudev.org","TextDomain":"wordpress-popup","DomainPath":"","Network":false,"Title":"Hustle","AuthorName":"WPMU DEV"},"wp-rocket\/wp-rocket.php":{"Name":"WP Rocket","PluginURI":"https:\/\/wp-rocket.me","Version":"3.3.5.2","Author":"WP Media","AuthorURI":"https:\/\/wp-media.me","TextDomain":"rocket","DomainPath":"languages","Network":false,"Title":"WP Rocket","AuthorName":"WP Media"},"wp-views\/wp-views.php":{"Name":"Toolset Views","PluginURI":"https:\/\/toolset.com\/?utm_source=viewsplugin\u0026utm_campaign=views\u0026utm_medium=plugins-list-full-version\u0026utm_term=Visit plugin site","Version":"2.8.4","Author":"OnTheGoSystems","AuthorURI":"https:\/\/toolset.com","TextDomain":"wp-views","DomainPath":"","Network":false,"Title":"Toolset Views","AuthorName":"OnTheGoSystems"},"wp_ziofix\/wp_ziofix.php":{"Name":"Ziofix WP Core","PluginURI":"http:\/\/www.ziofix.fr","Version":"1.6.6","Author":"Ziofix","AuthorURI":"http:\/\/www.ziofix.fr","TextDomain":"wp_ziofix","DomainPath":"","Network":false,"Title":"Ziofix WP Core","AuthorName":"Ziofix"}},"mu_plugins":[],"dropins":{"advanced-cache.php":{"Name":"advanced-cache.php","PluginURI":"","Version":"","Description":"","Author":"","AuthorURI":"","TextDomain":"","DomainPath":"","Network":false,"Title":"","AuthorName":""}}},"theme":{"Name":"Extra Child Theme","ThemeURI":null,"Author":"\u003Ca href=\u0022http:\/\/www.elegantthemes.com\u0022\u003EElegant Themes\u003C\/a\u003E","AuthorURI":null,"Template":"Extra","Version":"1.0","TextDomain":null,"DomainPath":null},"extra-debug":{"types":{"add_resized_images_to_library":0,"register_translations_on_import":1,"images_remote":0,"images_remote_cache_time":"36","help_box":"by_types","hide_standard_custom_fields_metabox":"show","postmeta_unfiltered_html":"on","usermeta_unfiltered_html":"on"},"CRED":{"wizard":1,"cache_notice":1,"export_settings":1,"export_custom_fields":1,"autogeneration_email":{"subject":"Welcome new user","body":"[username]Your username is: %cuf_username%[\/username]\\n[nickname]Your nickname is: %cuf_nickname%[\/nickname]\\n[password]Your password is: %cuf_password%[\/password]"},"dont_load_cred_css":1},"views":{"views_template_loop_blog":0,"wpv_bootstrap_version":1,"wpv_custom_conditional_functions":[],"wpv_custom_inner_shortcodes":[],"wpv_debug_mode":"","wpv_debug_mode_type":"compact","wpv_map_plugin":0,"wpv_show_hidden_fields":"","wpv_saved_auto_detected_framework":"","wpv_codemirror_autoresize":"","wpv_enable_pagination_manage_history":0,"wpv_enable_parametric_search_manage_history":0,"support_spaces_in_meta_filters":0,"allow_views_wp_widgets_in_elementor":0,"default_user_editor":"basic","manage_meta_transient_method":"cron","views_template_for_bar":22612},"installer":{"version":"1.9.4","repositories":{"wpml":{"api-url":"https:\/\/api.wpml.org\/","products":"http:\/\/d2salfytceyqoe.cloudfront.net\/wpml33-products.json","subscription":""},"toolset":{"api-url":"https:\/\/api.toolset.com\/","products":"http:\/\/d7j863fr5jhrr.cloudfront.net\/toolset33-products.json","subscription":{"key":"iFt6t08bPg","data":{"subscription_type":7527,"expires":"2020-06-18","status":"1"},"registered_by":3591,"site_url":"https:\/\/www.aperodujeudi.com"}}},"instances":{"\/home\/ziofix\/web\/wp-content\/plugins\/types\/vendor\/otgs\/installer\/installer.php":{"bootfile":"\/home\/ziofix\/web\/wp-content\/plugins\/types\/vendor\/otgs\/installer\/installer.php","version":"1.9.4","args":{"plugins_install_tab":"1","repositories_include":["toolset","wpml"]},"delegated":true}}}}}

3. Well I query CPT just like Toolset documentation told me to. I got AJAX on with only 9 CPT or so displayed by page. I show it using <table> format.

6. Thank you just turn off debug mode of the incriminated plugin

Thanks for you help

[Beda]

I loaded the page hidden link in less than 2 seconds from here, no crashes.

I made a short video, here: hidden link

I see no issues there, do you still experience any flaws?

If it happens again when increasing visits to the page, it'd be good to get the Server logs and let us know the precise errors registered, as it is difficult to guess what might be the cause. With the settings and view you describe, the Toolset should not fail.
That why it would be great to have the logs in case such things happen again.

Thank you!