Very slow and very high CPU use

Discussion regarding Joomla! 3.x Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10.
Locked
lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Very slow and very high CPU use

Post by lawrich16 » Sun Jul 18, 2021 5:43 pm

Hi all.
I recently moved an old website to up to date versions of PHP, joomla on a new host (siteground)

All was working well but now the site is virtually unusable as its so slow.

CPU usage is through the roof and if it doesn't eventually return a 504 response takes ages.

I have checked that Session Path Writable is yes, which I saw mentioned on other posts by Per.

Here is the FPA output. I don't really see much wrong but I don't really have any experience in this area.

Can anyone suggest a fix or strategy to identify the problem. I installed JCHoptimise which we didnt use on the previous version, this may just be coincidental. I have disabled JCH but the problem still occurs.

Many thanks

L
Forum Post Assistant (v1.6.2) : 18-Jul-2021 wrote:
Last PHP Error(s) Reported :: wrote:[18-Jul-2021 16:49:09 UTC] PHP Fatal error: 'break' not in the 'loop' or 'switch' context in /home/customer/www/richardsena.co.uk/public_html/libraries/cegcore/helpers/html.php on line 45
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.27-Stable (Amani) 25-May-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Read-Only (444) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: true | CacheTime: 15 | CacheHandler: cachelite | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 45 | Session handler: none | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.27: Yes | Database Supports J! 3.9.27: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache | Encoding: | System TMP Writable: Yes | Free Disk Space : 1251.02 GiB |

PHP Configuration :: Version: 7.3.29 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 1 | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: 18th July 2021 16:49:09. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

Database Configuration :: Version: 5.7.32-35-log (Client:mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | Database Size: 35.12 MiB | #of Tables with config prefix:  114 | #of other Tables:  65 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (7.3.29) | date (7.3.29) | libxml (7.3.29) | openssl (7.3.29) | pcre (7.3.29) | sqlite3 (7.3.29) | zlib (7.3.29) | bcmath (7.3.29) | bz2 (7.3.29) | calendar (7.3.29) | ctype (7.3.29) | curl (7.3.29) | dba (7.3.29) | dom (20031129) | enchant (7.3.29) | hash (7.3.29) | fileinfo (7.3.29) | filter (7.3.29) | ftp (7.3.29) | gd (7.3.29) | gettext (7.3.29) | gmp (7.3.29) | SPL (7.3.29) | iconv (7.3.29) | session (7.3.29) | intl (7.3.29) | json (1.7.0) | mbstring (7.3.29) | standard (7.3.29) | mysqlnd (mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $) | mysqli (7.3.29) | PDO (7.3.29) | pdo_mysql (7.3.29) | pdo_pgsql (7.3.29) | pdo_sqlite (7.3.29) | pgsql (7.3.29) | Phar (7.3.29) | posix (7.3.29) | pspell (7.3.29) | Reflection (7.3.29) | imap (7.3.29) | shmop (7.3.29) | SimpleXML (7.3.29) | soap (7.3.29) | sockets (7.3.29) | sodium (7.3.29) | exif (7.3.29) | sysvmsg (7.3.29) | sysvsem (7.3.29) | tidy (7.3.29) | tokenizer (7.3.29) | wddx (7.3.29) | xml (7.3.29) | xmlreader (7.3.29) | xmlrpc (7.3.29) | xmlwriter (7.3.29) | xsl (7.3.29) | zip (1.15.4) | apache2handler () | memcached (3.1.0-dev) | ionCube Loader (10.4.5) | Zend OPcache (7.3.29) | Zend Engine (3.3.29) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_authn_file | mod_authn_core | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_core | mod_access_compat | mod_auth_basic | mod_so | mod_watchdog | mod_include | mod_substitute | mod_deflate | http_core | mod_mime | mod_log_config | mod_env | mod_mime_magic | mod_expires | mod_headers | mod_unique_id | mod_setenvif | mod_version | mod_slotmem_shm | event | mod_unixd | mod_autoindex | mod_cgi | mod_dir | mod_userdir | mod_alias | mod_rewrite | mod_php7 | mod_dtimeout | mod_filter | mod_robots | mod_rpaf | mod_simpleupdate | mod_backtrace | mod_whatkilledus | mod_idleshutdown | Apache |
Potential Missing Modules :: mod_security | mod_evasive | mod_dosevasive | mod_ssl | mod_qos |
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (---) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 1115609 | Threads: 5 | Questions: 777614667 | Slow queries: 2143 | Opens: 54695052 | Flush tables: 1 | Open tables: 3064 | Queries per second avg: 697.031 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party::

Components :: Admin ::
Core :: com_login (3.0.0) 1 | com_weblinks (2.5.0) 1 | com_templates (3.0.0) 1 | com_checkin (3.0.0) 1 | com_fields (3.7.0) 1 | com_contenthistory (3.2.0) 1 | com_finder (3.0.0) 1 | com_associations (3.7.0) 1 | com_cache (3.0.0) 1 | com_plugins (3.0.0) 1 | com_installer (3.0.0) 1 | com_messages (3.0.0) 1 | com_categories (3.0.0) 1 | com_media (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_modules (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_redirect (3.0.0) 1 | com_privacy (3.9.0) 1 | com_banners (3.0.0) 1 | com_ajax (3.2.0) 1 | com_newsfeeds (3.0.0) 1 | com_admin (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_languages (3.0.0) 1 | com_content (3.0.0) 1 | com_tags (3.1.0) 1 | com_postinstall (3.2.0) 1 | com_menus (3.0.0) 1 | com_search (3.0.0) 1 | com_config (3.0.0) 1 | com_users (3.0.0) 1 |
3rd Party:: COM_EVENTGALLERY (3.12.8) 1 | JCH Optimize Pro (6.5.0) 1 | com_chronoforms5 (5.0.4) 1 | ChronoForms7 (7.0.7) 1 | Akeeba (8.0.6) 1 |

Modules :: Site ::
Core :: mod_random_image (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_weblinks (2.5.0) 1 | mod_stats (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_users_latest (3.0.0) 1 |
3rd Party:: MOD_EVENTGALLERY_CART (3.12.8) 1 | MOD_EVENTGALLERY_EVENT (3.12.8) 1 | MOD_EVENTGALLERY_CATEGORIES (3.12.8) 1 | MOD_EVENTGALLERY_CUSTOM (3.12.8) 1 | MOD_EVENTGALLERY_LATEST (3.12.8) 1 | JS FlexSlider (2.2) 1 | sigplus (1.4.2.19) 1 | MOD_EVENTGALLERY_EVENTS (3.12.8) 1 |

Modules :: Admin ::
Core :: mod_stats_admin (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_sampledata (3.8.0) 1 | mod_version (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_status (3.0.0) 1 | mod_login (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_title (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_extension_joomla (3.0.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_newsfeeds (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_weblinks (2.5.0) 1 | plg_search_content (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_webinstaller (2.1.2) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_weblinks (2.5.0) 1 | plg_finder_content (3.0.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_geshi (2.5.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_stats (3.5.0) 1 | plg_system_log (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_p3p (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 |
3rd Party:: PLG_EVENTGALLERY_PAY_STRIPE (3.12.8) 0 | PLG_EVENTGALLERY_PAY_PAYPAL (3.12.8) 0 | PLG_EVENTGALLERY_PAY_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_PAY_BRAINTREE (3.12.8) 0 | PLG_EVENTGALLERY_PAY_PAYPALBASIC (3.12.8) 1 | PLG_EDITORS-XTD_EVENTGALLERY (3.12.8) 1 | PLG_EDITORS-XTD_EVENTGALLERYIMAGE (3.12.8) 1 | PLG_EVENTGALLERY_SUR_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_SEARCH_FILE (3.12.8) 0 | PLG_EVENTGALLERY_SEARCH (3.12.8) 0 | PLG_ACTIONLOG_AKEEBABACKUP (8.0.6) 0 | PLG_INSTALLER_EVENTGALLERY (3.12.8) 1 | PLG_EVENTGALLERY_FINDER (3.12.8) 0 | PLG_EVENTGALLERY_SHIP_DOWNLOAD (3.12.8) 1 | PLG_EVENTGALLERY_SHIP_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_SHIP_EMAIL (3.12.8) 0 | plg_editors_tinymce (4.5.12) 1 | plg_editors_codemirror (5.60.0) 1 | PLG_EVENTGALLERY_CONTENT (3.12.8) 1 | PLG_EVENTGALLERY_MULTILANGCONTENT (3.12.8) 1 | Content - Image gallery - sigplus (1.4.2.19) 1 | EVENTGALLERY_FIELDS_CATEGORY (3.12.8) 1 | ChronoG3_Plg (1.0) 1 | ChronoG3 (3.0.0) ? | PLG_SYSTEM_EVENTGALLERY_CAPABILITIE (3.12.8) ? | PLG_SYSTEM_JCH_OPTIMIZE (6.5.0) 0 | PLG_SYSTEM_EVENTGALLERYCONSOLE (3.12.8) 1 | PLG_SYSTEM_PICASAUPDATER (3.12.8) 1 | PLG_SYSTEM_BACKUPONUPDATE (8.0.6) 1 | plg_quickicon_akeebabackup (8.0.6) 1 |
Templates Discovered :: wrote:Templates :: Site :: beez3 (3.1.0) 1 | joomspirit_123 (2.0) 1 | joomspirit_76 (2.0) 0 | protostar (1.0) 1 | beez_20 (2.5.0) 1 | j2template (2.5.0) 1 | beez5 (2.5.0) 1 | atomic (2.5.0) 1 |
Templates :: Admin :: bluestork (2.5.0) 1 | hathor (3.0.0) 1 | isis (1.0) 1 |
Last edited by toivo on Sun Jul 18, 2021 8:38 pm, edited 1 time in total.
Reason: mod note: disabled smilies in post Options

User avatar
AMurray
Joomla! Exemplar
Joomla! Exemplar
Posts: 9606
Joined: Sat Feb 13, 2010 7:35 am
Location: Australia

Re: Very slow and very high CPU use

Post by AMurray » Sun Jul 18, 2021 10:24 pm

Note that SiteGround is moving to PHP 7.4.x and above only and 'retiring' anything from 7.3 and below; switch your site to 7.4.21. 7.3.x will end support by end of 2021.

Joomla is out of date - update to 3.9.28.

I think the clue is in the PHP error the FPA reports:
FPA wrote: Last PHP Error(s) Reported :: wrote:
[18-Jul-2021 16:49:09 UTC] PHP Fatal error: 'break' not in the 'loop' or 'switch' context in /home/customer/www/richardsena.co.uk/public_html/libraries/cegcore/helpers/html.php on line 45
.

"cegcore" is connected to Chronoforms: For some reason you have seem to have two versions of Chronoforms (a) 5.0.4 and (b) 7.0.7. Possibly try to reinstall Chronoforms 7.0.7. Seek advice from their support for this issue.
FPA wrote:3rd Party:: COM_EVENTGALLERY (3.12.8) 1 | JCH Optimize Pro (6.5.0) 1 | com_chronoforms5 (5.0.4) 1 | ChronoForms7 (7.0.7) 1 | Akeeba (8.0.6) 1 |
I think 5.0.4 is from earlier Joomla 2.5.x - see if you can remove that entirely(or at very least,disable it in the Extension Manager). v7.0.7 is the most current (( note the JED listing is 7.0.6 so that's slightly behind).

JCHOptimise still seems enabled - indicated by the "1" at the end of the extension name (highlighted in red above). I'd double check it is disabled, or uninstall it and see if that makes a difference.

Check all other third party extensions for updates.

The items below are also potential issues; not all of these things may be related to the problem at hand, but they are issues that need to be attended to - server config issues (e.g. apache2handler) and potential missing (PHP) modules. Check with your host about these, or enable them in the PHP settings of the SiteGround hosting tools in your account.
FPA wrote:Potential Missing Modules :: mod_security | mod_evasive | mod_dosevasive | mod_ssl | mod_qos |
You have some left over Joomla 2.5 extensions (templates) in your site highlighted above that you need to uninstall as they won't work in 3.x:
FPA wrote: Templates Discovered :: wrote:
Templates :: Site :: beez3 (3.1.0) 1 | joomspirit_123 (2.0) 1 | joomspirit_76 (2.0) 0 | protostar (1.0) 1 | beez_20 (2.5.0) 1 | j2template (2.5.0) 1 | beez5 (2.5.0) 1 | atomic (2.5.0) 1 |
Templates :: Admin :: bluestork (2.5.0) 1 | hathor (3.0.0) 1 | isis (1.0) 1 |
Also, while this is likely a Joomla or an extension issue, maybe SiteGround can help you track down the problem.
Regards - A Murray
General Support Moderator

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Mon Jul 19, 2021 1:43 pm

Many thanks AMurray, I will get onto it and report back...

User avatar
darb
Joomla! Hero
Joomla! Hero
Posts: 2036
Joined: Thu Jul 06, 2006 12:57 pm
Location: Stockholm Sweden

Re: Very slow and very high CPU use

Post by darb » Fri Jul 30, 2021 8:26 am

Go for php 8 and hope you have 2 GB hosting memory too is good for speed improvements.

User avatar
changlee
Joomla! Explorer
Joomla! Explorer
Posts: 470
Joined: Tue Nov 20, 2007 11:05 am
Location: Greece
Contact:

Re: Very slow and very high CPU use

Post by changlee » Tue Aug 24, 2021 5:59 am

First of all you should clear the bot visits, thrugh CloudFlare and through a firewall joomla plugin.
If you do not programm your life, someone else will do it for you.
SMTP Newsletter APP: https://www.emailbat.com

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Sun Nov 07, 2021 3:41 pm

The problem remains, I thought it had disappeared but it does infact continue. I think I may have seen the CPU drop to nothing on SG monitoring tools and assumed it was fixed but it may have just been SG shutting things down as the monthly CPU limit was reached.

Today I disabled the plugins, components and modules for everything 3rd party except for the editors. I did so by setting "enabled = 0" in xxx_extensions table for the relevant extensions.

I've had a look in phpmyadmin and the DB is being thrashed, I guess this is the cause (or symptom?) of my issues.
Screenshot 2021-11-07 153136.jpg
The stats look crazy for the DB server stats.
Screenshot 2021-11-07 153537.jpg
FYI the last known PHP error was caused when I switched the PHP version to V8.1.0, it caused issues so I switched back to 7.4.25

Ive been working on this for 2 days and not made much headway and I am about to reach the SG monthly CPU limit which will deactivate everything and lock me out for another 3 weeks before I can try and fix this. Any help/advice would be gratefully received... the sooner the better
Forum Post Assistant (v1.6.3) : 7-Nov-2021 wrote:
Last PHP Error(s) Reported :: wrote:[06-Nov-2021 17:26:30 UTC] PHP Deprecated: Return type of Joomla\CMS\Date\Date::format($format, $local = false, $translate = true) should either be compatible with DateTime::format(string $format): string, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/customer/www/richardsena.co.uk/public_html/libraries/src/Date/Date.php on line 281
Basic Environment :: wrote:Joomla! Instance :: Joomla! 3.9.28-Stable (Amani) 6-July-2021
Joomla! Platform :: Joomla Platform 13.1.0-Stable (Curiosity) 24-Apr-2013
Joomla! Configured :: Yes | Writable (644) |
Configuration Options :: Offline: false | SEF: true | SEF Suffix: false | SEF ReWrite: true | .htaccess/web.config: Yes | GZip: true | Cache: true | CacheTime: 15 | CacheHandler: file | CachePlatformPrefix: false | FTP Layer: false | Proxy: false | LiveSite: | Session lifetime: 15 | Session handler: database | Shared sessions: false | SSL: 2 | Error Reporting: default | Site Debug: false | Language Debug: false | Default Access: 1 | Unicode Slugs: false | dbConnection Type: mysqli | PHP Supports J! 3.9.28: Yes | Database Supports J! 3.9.28: Yes | Database Credentials Present: Yes |

Host Configuration :: OS: Linux | OS Version: 3.12.18-clouder0 | Technology: x86_64 | Web Server: Apache | Encoding: | System TMP Writable: Yes | Free Disk Space : 1185.62 GiB |

PHP Configuration :: Version: 7.4.25 | PHP API: apache2handler | Session Path Writable: Yes | Display Errors: 0 | Error Reporting: 30709 | Log Errors To: php_errorlog | Last Known Error: 06th November 2021 17:26:30. | Register Globals: | Magic Quotes: | Safe Mode: | Allow url fopen: 1 | Open Base: | Uploads: 1 | Max. Upload Size: 256M | Max. POST Size: 256M | Max. Input Time: 120 | Max. Execution Time: 120 | Memory Limit: 768M

Database Configuration :: Version: 5.7.32-35-log (Client:mysqlnd 7.4.25) | Database Size: 32.63 MiB | #of Tables with config prefix:  122 | #of other Tables:  65 | User Privileges : GRANT ALL
Detailed Environment :: wrote:PHP Extensions :: Core (7.4.25) | date (7.4.25) | libxml (7.4.25) | openssl (7.4.25) | pcre (7.4.25) | sqlite3 (7.4.25) | zlib (7.4.25) | bcmath (7.4.25) | bz2 (7.4.25) | calendar (7.4.25) | ctype (7.4.25) | curl (7.4.25) | dba (7.4.25) | dom (20031129) | enchant (7.4.25) | hash (7.4.25) | fileinfo (7.4.25) | filter (7.4.25) | ftp (7.4.25) | gd (7.4.25) | gettext (7.4.25) | gmp (7.4.25) | SPL (7.4.25) | iconv (7.4.25) | session (7.4.25) | intl (7.4.25) | json (7.4.25) | mbstring (7.4.25) | standard (7.4.25) | mysqlnd (mysqlnd 7.4.25) | mysqli (7.4.25) | PDO (7.4.25) | pdo_mysql (7.4.25) | pdo_pgsql (7.4.25) | pdo_sqlite (7.4.25) | pgsql (7.4.25) | Phar (7.4.25) | posix (7.4.25) | pspell (7.4.25) | Reflection (7.4.25) | imap (7.4.25) | shmop (7.4.25) | SimpleXML (7.4.25) | soap (7.4.25) | sockets (7.4.25) | sodium (7.4.25) | exif (7.4.25) | sysvmsg (7.4.25) | sysvsem (7.4.25) | tidy (7.4.25) | tokenizer (7.4.25) | xml (7.4.25) | xmlreader (7.4.25) | xmlrpc (7.4.25) | xmlwriter (7.4.25) | xsl (7.4.25) | zip (1.15.6) | apache2handler (7.4.25) | memcached (3.1.0-dev) | Zend OPcache (7.4.25) | Zend Engine (3.4.0) |
Potential Missing Extensions ::

Switch User Environment :: PHP CGI: No | Server SU: No | PHP SU: No | Potential Ownership Issues: No

Apache Modules :: core | mod_authn_file | mod_authn_core | mod_authz_host | mod_authz_groupfile | mod_authz_user | mod_authz_core | mod_access_compat | mod_auth_basic | mod_so | mod_watchdog | mod_include | mod_substitute | mod_deflate | http_core | mod_mime | mod_log_config | mod_env | mod_mime_magic | mod_expires | mod_headers | mod_unique_id | mod_setenvif | mod_version | mod_slotmem_shm | event | mod_unixd | mod_autoindex | mod_cgi | mod_dir | mod_userdir | mod_alias | mod_rewrite | mod_php7 | mod_dtimeout | mod_filter | mod_robots | mod_rpaf | mod_simpleupdate | mod_backtrace | mod_whatkilledus | mod_idleshutdown | Apache |
Potential Missing Modules :: mod_security | mod_evasive | mod_dosevasive | mod_ssl | mod_qos |
Folder Permissions :: wrote:Core Folders :: images/ (755) | components/ (755) | modules/ (755) | plugins/ (755) | language/ (755) | templates/ (755) | cache/ (755) | logs/ (755) | tmp/ (755) | administrator/components/ (755) | administrator/modules/ (755) | administrator/language/ (755) | administrator/templates/ (755) | administrator/logs/ (755) |

Elevated Permissions (First 10) ::
Database Information :: wrote:Database statistics :: Uptime: 288367 | Threads: 9 | Questions: 258126559 | Slow queries: 508 | Opens: 15951601 | Flush tables: 1 | Open tables: 3072 | Queries per second avg: 895.132 |
Extensions Discovered :: wrote:Components :: Site ::
Core :: com_mailto (3.0.0) 1 | com_wrapper (3.0.0) 1 |
3rd Party::

Components :: Admin ::
Core :: com_login (3.0.0) 1 | com_weblinks (3.7.0) 1 | com_templates (3.0.0) 1 | com_checkin (3.0.0) 1 | com_fields (3.7.0) 1 | com_contenthistory (3.2.0) 1 | com_finder (3.0.0) 1 | com_associations (3.7.0) 1 | com_cache (3.0.0) 1 | com_plugins (3.0.0) 1 | com_installer (3.0.0) 1 | com_messages (3.0.0) 1 | com_categories (3.0.0) 1 | com_media (3.0.0) 1 | com_actionlogs (3.9.0) 1 | com_modules (3.0.0) 1 | com_cpanel (3.0.0) 1 | com_redirect (3.0.0) 1 | com_privacy (3.9.0) 1 | com_banners (3.0.0) 1 | com_ajax (3.2.0) 1 | com_newsfeeds (3.0.0) 1 | com_admin (3.0.0) 1 | com_joomlaupdate (3.6.2) 1 | com_languages (3.0.0) 1 | com_content (3.0.0) 1 | com_tags (3.1.0) 1 | com_postinstall (3.2.0) 1 | com_menus (3.0.0) 1 | com_search (3.0.0) 1 | com_config (3.0.0) 1 | com_users (3.0.0) 1 |
3rd Party:: COM_EVENTGALLERY (3.12.8) 0 | JCH Optimize Pro (6.5.0) 0 | Akeeba (8.0.6) 0 |

Modules :: Site ::
Core :: mod_random_image (3.0.0) 1 | mod_search (3.0.0) 1 | mod_articles_news (3.0.0) 1 | mod_custom (3.0.0) 1 | mod_weblinks (3.7.0) 1 | mod_stats (3.0.0) 1 | mod_finder (3.0.0) 1 | mod_related_items (3.0.0) 1 | mod_wrapper (3.0.0) 1 | mod_syndicate (3.0.0) 1 | mod_banners (3.0.0) 1 | mod_tags_popular (3.1.0) 1 | mod_menu (3.0.0) 1 | mod_articles_category (3.0.0) 1 | mod_articles_popular (3.0.0) 1 | mod_articles_archive (3.0.0) 1 | mod_languages (3.5.0) 1 | mod_login (3.0.0) 1 | mod_articles_categories (3.0.0) 1 | mod_articles_latest (3.0.0) 1 | mod_tags_similar (3.1.0) 1 | mod_breadcrumbs (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_whosonline (3.0.0) 1 | mod_footer (3.0.0) 1 | mod_users_latest (3.0.0) 1 |
3rd Party:: MOD_EVENTGALLERY_CART (3.12.8) 0 | MOD_EVENTGALLERY_EVENT (3.12.8) 0 | MOD_EVENTGALLERY_CATEGORIES (3.12.8) 0 | MOD_EVENTGALLERY_CUSTOM (3.12.8) 0 | MOD_EVENTGALLERY_LATEST (3.12.8) 0 | JS FlexSlider (2.2) 0 | sigplus (1.5.0.287) 0 | MOD_EVENTGALLERY_EVENTS (3.12.8) 0 |

Modules :: Admin ::
Core :: mod_stats_admin (3.0.0) 1 | mod_quickicon (3.0.0) 1 | mod_latestactions (3.9.0) 1 | mod_custom (3.0.0) 1 | mod_privacy_dashboard (3.9.0) 1 | mod_sampledata (3.8.0) 1 | mod_version (3.0.0) 1 | mod_submenu (3.0.0) 1 | mod_menu (3.0.0) 1 | mod_multilangstatus (3.0.0) 1 | mod_toolbar (3.0.0) 1 | mod_popular (3.0.0) 1 | mod_status (3.0.0) 1 | mod_login (3.0.0) 1 | mod_logged (3.0.0) 1 | mod_feed (3.0.0) 1 | mod_latest (3.0.0) 1 | mod_title (3.0.0) 1 |
3rd Party::

Libraries ::
Core ::
3rd Party::

Plugins ::
Core :: plg_extension_joomla (3.0.0) 1 | plg_privacy_user (3.9.0) 1 | plg_privacy_consents (3.9.0) 1 | plg_privacy_content (3.9.0) 1 | plg_privacy_actionlogs (3.9.0) 1 | plg_privacy_message (3.9.0) 1 | plg_twofactorauth_totp (3.2.0) 0 | plg_twofactorauth_yubikey (3.2.0) 0 | plg_editors-xtd_article (3.0.0) 1 | plg_editors-xtd_weblink (3.7.0) 0 | plg_editors-xtd_readmore (3.0.0) 1 | plg_editors-xtd_pagebreak (3.0.0) 1 | plg_editors-xtd_fields (3.7.0) 1 | plg_editors-xtd_image (3.0.0) 1 | plg_editors-xtd_menu (3.7.0) 1 | plg_editors-xtd_module (3.5.0) 1 | plg_search_tags (3.0.0) 0 | plg_search_newsfeeds (3.0.0) 1 | plg_search_contacts (3.0.0) 1 | plg_search_categories (3.0.0) 1 | plg_search_weblinks (3.7.0) 1 | plg_search_content (3.0.0) 1 | PLG_ACTIONLOG_JOOMLA (3.9.0) 1 | PLG_INSTALLER_URLINSTALLER (3.6.0) 1 | plg_installer_webinstaller (2.1.2) 1 | PLG_INSTALLER_FOLDERINSTALLER (3.6.0) 1 | plg_installer_packageinstaller (3.6.0) 1 | plg_finder_tags (3.0.0) 1 | plg_finder_newsfeeds (3.0.0) 1 | plg_finder_contacts (3.0.0) 1 | plg_finder_categories (3.0.0) 1 | plg_finder_weblinks (3.7.0) 1 | plg_finder_content (3.0.0) 1 | plg_fields_list (3.7.0) 1 | plg_fields_radio (3.7.0) 1 | plg_fields_checkboxes (3.7.0) 1 | plg_fields_textarea (3.7.0) 1 | plg_fields_usergrouplist (3.7.0) 1 | plg_fields_calendar (3.7.0) 1 | plg_fields_media (3.7.0) 1 | plg_fields_integer (3.7.0) 1 | plg_fields_sql (3.7.0) 1 | plg_fields_editor (3.7.0) 1 | plg_fields_user (3.7.0) 1 | plg_fields_text (3.7.0) 1 | plg_fields_color (3.7.0) 1 | plg_fields_repeatable (3.9.0) 1 | plg_fields_url (3.7.0) 1 | plg_fields_imagelist (3.7.0) 1 | plg_user_contactcreator (3.0.0) 0 | plg_user_terms (3.9.0) 0 | plg_user_joomla (3.0.0) 1 | plg_user_profile (3.0.0) 0 | plg_authentication_gmail (3.0.0) 0 | plg_authentication_ldap (3.0.0) 0 | plg_authentication_joomla (3.0.0) 1 | plg_authentication_cookie (3.0.0) 1 | plg_content_confirmconsent (3.9.0) 0 | plg_content_vote (3.0.0) 1 | plg_content_loadmodule (3.0.0) 1 | plg_content_emailcloak (3.0.0) 1 | plg_content_pagebreak (3.0.0) 1 | plg_content_finder (3.0.0) 0 | plg_content_fields (3.7.0) 1 | plg_content_geshi (2.5.0) 0 | plg_content_pagenavigation (3.0.0) 1 | plg_content_joomla (3.0.0) 1 | plg_captcha_recaptcha (3.4.0) 0 | plg_captcha_recaptcha_invisible (3.8) 0 | plg_system_languagefilter (3.0.0) 0 | plg_system_languagecode (3.0.0) 0 | plg_system_sef (3.0.0) 1 | plg_system_sessiongc (3.8.6) 1 | plg_system_updatenotification (3.5.0) 1 | plg_system_logout (3.0.0) 1 | plg_system_fields (3.7.0) 1 | plg_system_privacyconsent (3.9.0) 0 | plg_system_highlight (3.0.0) 1 | plg_system_redirect (3.0.0) 1 | plg_system_weblinks (3.7.0) 0 | plg_system_stats (3.5.0) 1 | plg_system_log (3.0.0) 1 | plg_system_cache (3.0.0) 0 | plg_system_remember (3.0.0) 1 | plg_system_logrotation (3.9.0) 1 | plg_system_debug (3.0.0) 1 | PLG_SYSTEM_ACTIONLOGS (3.9.0) 0 | plg_system_p3p (3.0.0) 1 | plg_quickicon_extensionupdate (3.0.0) 1 | plg_quickicon_joomlaupdate (3.0.0) 1 | plg_quickicon_privacycheck (3.9.0) 1 | plg_quickicon_phpversioncheck (3.7.0) 1 |
3rd Party:: PLG_EVENTGALLERY_PAY_STRIPE (3.12.8) 0 | PLG_EVENTGALLERY_PAY_PAYPAL (3.12.8) 0 | PLG_EVENTGALLERY_PAY_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_PAY_BRAINTREE (3.12.8) 0 | PLG_EVENTGALLERY_PAY_PAYPALBASIC (3.12.8) 0 | PLG_EDITORS-XTD_EVENTGALLERY (3.12.8) 0 | plg_editors-xtd_sigplus (1.5.0.287) 0 | PLG_EDITORS-XTD_EVENTGALLERYIMAGE (3.12.8) 0 | PLG_EVENTGALLERY_SUR_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_SEARCH_FILE (3.12.8) 0 | PLG_EVENTGALLERY_SEARCH (3.12.8) 0 | plg_search_sigplus (1.5.0.287) 0 | PLG_ACTIONLOG_AKEEBABACKUP (8.0.6) 0 | PLG_INSTALLER_EVENTGALLERY (3.12.8) 0 | PLG_EVENTGALLERY_FINDER (3.12.8) 0 | PLG_EVENTGALLERY_SHIP_DOWNLOAD (3.12.8) 0 | PLG_EVENTGALLERY_SHIP_STANDARD (3.12.8) 0 | PLG_EVENTGALLERY_SHIP_EMAIL (3.12.8) 0 | plg_editors_tinymce (4.5.12) 1 | plg_editors_codemirror (5.60.0) 1 | PLG_EVENTGALLERY_CONTENT (3.12.8) 0 | PLG_EVENTGALLERY_MULTILANGCONTENT (3.12.8) 0 | plg_content_sigplus (1.5.0.287) 0 | EVENTGALLERY_FIELDS_CATEGORY (3.12.8) 0 | PLG_SYSTEM_EVENTGALLERY_CAPABILITIE (3.12.8) ? | PLG_SYSTEM_JCH_OPTIMIZE (6.5.0) 0 | PLG_SYSTEM_EVENTGALLERYCONSOLE (3.12.8) 0 | PLG_SYSTEM_PICASAUPDATER (3.12.8) 0 | PLG_SYSTEM_BACKUPONUPDATE (8.0.6) 0 | plg_quickicon_akeebabackup (8.0.6) 0 |
Templates Discovered :: wrote:Templates :: Site :: beez3 (3.1.0) ? | joomspirit_123 (2.0) 1 | protostar (1.0) ? | j2template (2.5.0) 1 |
Templates :: Admin :: hathor (3.0.0) ? | isis (1.0) 1 |
You do not have the required permissions to view the files attached to this post.
Last edited by toivo on Mon Nov 08, 2021 8:14 pm, edited 1 time in total.
Reason: mod note: disabled smilies in post Options for readability

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Mon Nov 08, 2021 10:50 am

Over 800 sql queries per second, what be causing this? Please help anyone?

User avatar
Pavel-ww
Joomla! Ace
Joomla! Ace
Posts: 1580
Joined: Tue Jun 30, 2020 12:17 pm

Re: Very slow and very high CPU use

Post by Pavel-ww » Mon Nov 08, 2021 11:42 am

lawrich16 wrote:
Mon Nov 08, 2021 10:50 am
Over 800 sql queries per second, what be causing this? Please help anyone?
Hi.

I noticed the syntax error on your site. script tag inside script tag. You made a mistake in the GTM code when integrate it.
1.jpg
Such things can lead to a long load. In fact, it creates a short circuit, causing new and new appeals to server to get this script, but because of the error it cannot be loaded. When the limit (timeout) of appeals to the server is exceeded, it gives the rest of the DOM or 504 error.

Remove GTM and check.
Judging by the network analysis, this is what happens - the initial getting DOM takes more than 4 minutes. All other resources are loaded normally, after DOM is obtained.
2.jpg
That is an indirect confirmation of the cause (because of this syntax error).

Tip: Browser dev tools - this is the first where you should look in case of any problems.
You do not have the required permissions to view the files attached to this post.

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Mon Nov 08, 2021 5:05 pm

Excellent find and thank you so much, I think it makes sense.

I don't know how to do what you suggest but I am going to look in to it straight away and start googling, the problem is I have only file and DB access at the moment...

I will report back ASAP (:

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Mon Nov 08, 2021 6:02 pm

OK, Ive had a look at an old DB and file backup for something that contains the "19646930" and found it in a DB dump in a joomla table called DB._template_styles

I have edited the following...

"google_code":"<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script async src=\"https:\/\/www.googletagmanager.com\/gtag\/js?id=UA-19646930-1\"><\/script>\r\n<script>\r\n window.dataLayer = window.dataLayer || [];\r\n function gtag(){dataLayer.push(arguments);}\r\n gtag('js', new Date());\r\n\r\n gtag('config', 'UA-19646930-1');\r\n<\/script>"}

to...

"google_code":"<!-- Global site tag (gtag.js) - Google Analytics -->\r\n<script>\r\n window.dataLayer = window.dataLayer || [];\r\n function gtag(){dataLayer.push(arguments);}\r\n gtag('js', new Date());\r\n\r\n gtag('config', 'UA-19646930-1');\r\n<\/script>"}


I am not sure that this is correct as a visit to the home page is still very slow.

Pavel, Sorry I don't recognise the dev tool you are using, please could you tell me the tool and which browser you are using?

thanks again, Lawrie

lawrich16
Joomla! Apprentice
Joomla! Apprentice
Posts: 9
Joined: Wed May 19, 2021 4:19 pm

Re: Very slow and very high CPU use

Post by lawrich16 » Mon Nov 08, 2021 8:16 pm

OK Ive worked out you are using Inspector in safari (thanks to google image translator).

I think I have removed all references to the Google code in the template profile entry in table "_template_styles" for the joomspirit_123 template. Ignore the code in the previous post.

I have refreshed the home page to look at the HTML but its still taking a very long time to give me any HTML back.

Pavel.. would incorrect HTML as you mentioned really cause a run away situation on the server DB SQL?

Thanks

Lawrie

User avatar
Pavel-ww
Joomla! Ace
Joomla! Ace
Posts: 1580
Joined: Tue Jun 30, 2020 12:17 pm

Re: Very slow and very high CPU use

Post by Pavel-ww » Tue Nov 09, 2021 6:52 am

lawrich16 wrote:
Mon Nov 08, 2021 8:16 pm
OK Ive worked out you are using Inspector in safari (thanks to google image translator).
Hi.
I use Firefox Windows. Any browser has dev tools (Firefox, Chrome - F12).

You still have sintax and "undefined" errors because of this code.
1.jpg
Turn OFF JCH and clean its cache folder and Joomla cache folder. Do not turn it ON until you solve the problem. Since all erroneous code gets into its cache and is transmitted to the browser.
Create or restore Super User Access via database. And use Joomla admin to resolve problems.
https://docs.joomla.org/How_do_you_reco ... assword%3F
You do not have the required permissions to view the files attached to this post.

User avatar
changlee
Joomla! Explorer
Joomla! Explorer
Posts: 470
Joined: Tue Nov 20, 2007 11:05 am
Location: Greece
Contact:

Re: Very slow and very high CPU use

Post by changlee » Thu Nov 18, 2021 8:08 am

What is your average hourly visitors count? Can you lock out everyone and allow only your IP in order to check exactly what is happening?

Enable the default theme and see how it goes. Do you work on a dedicated, on a VPS on what exactly?
If you do not programm your life, someone else will do it for you.
SMTP Newsletter APP: https://www.emailbat.com


Locked

Return to “Performance - Joomla! 3.x”