Sushant Sanjay Khadilkar
Forum Replies Created
-
Thanks for the feedback. We will try out the recommendations and update you if its resolves the issue or not.
Regards,
SushantHi @deliciousbrains,
Please find below information from “Support”.
site_url(): https://www.mcafee.com/blogs
home_url(): https://www.mcafee.com/blogs
Database Name: consumerblog
Table Prefix: m6af33_
WordPress: 5.9.1
Web Server: Apache/2.4.6 (CentOS) PHP/8.1.8
PHP: 8.1.8
MySQL: 8.0.28
ext/mysqli: yes
PHP Memory Limit: 256M
WP Memory Limit: 256M
Memory Usage: 77 MB
Blocked External HTTP Requests: None
WP Locale: en_US
Organize offloads by month/year: Enabled
WP_DEBUG: No
WP_DEBUG_LOG: No
WP_DEBUG_DISPLAY: No
SCRIPT_DEBUG: No
WP Max Upload Size: 2 MB
PHP Time Limit: 30
PHP Error Log:
WP Cron: Enabled
fsockopen: Enabled
allow_url_fopen: Enabled
OpenSSL: OpenSSL 1.0.2k 26 Jan 2017
cURL: 7.29.0
Zlib Compression: Enabled
PHP GD: 2.3.3
Imagick: Disabled
Basic Auth: Disabled
Proxy: DisabledMedia Files: 35,674
Offloaded Media Files: 32,552
Not Offloaded Media Files: 3,122Number of Image Sizes: 12
Names and Dimensions of Image Sizes:
thumbnail (150×150)
medium (300×300)
large (1024×1024)
1536×1536 (1536×1536)
2048×2048 (2048×2048)
category-listing (205×129)
profile_24 (24×24)
profile_48 (48×48)
profile_96 (96×96)
profile_150 (150×150)
profile_300 (300×300)WP_CONTENT_DIR: /var/www/html/blogs/wp-content
WP_CONTENT_URL: https://www.mcafee.com/blogs/wp-content
UPLOADS: Not defined
WP_PLUGIN_DIR: /var/www/html/blogs/wp-content/plugins
WP_PLUGIN_URL: https://www.mcafee.com/blogs/wp-content/pluginsAS3CF_PROVIDER: Not defined
AS3CF_BUCKET: Not defined
AS3CF_REGION: Not defined
AS3CF_SETTINGS: Not definedLocal URL:
https://www.mcafee.com/blogs/wp‑content/uploads/2022/10/photo.jpg
Offload URL:
https://www.mcafee.com/blogs/wp‑content/uploads/2022/10/photo.jpgOME Metadata Version: 12
Custom tables:
m6af33_as3cf_items: OkStorage Provider: Amazon S3
Use Server Roles: On
Key File Path: N/A
Access Keys Set: No
Access Key ID Define: Not defined
Secret Access Key Define: Not definedBucket: blogs-prod-s3
Region: us-west-2
Block All Public Access: EnabledCopy Files to Bucket: On
Enable Path: On
Custom Path: blogs/wp-content/uploads/
Use Year/Month: On
Object Versioning: OffDelivery Provider: Amazon CloudFront
Rewrite Media URLs: On
Enable Custom Domain (CNAME): On
Custom Domain (CNAME): http://www.mcafee.comForce HTTPS: On
Remove Files From Server: On
Active Theme Name: McAfee Blog | Securing Tomorrow – Brillio
Active Theme Version: 1.0
Active Theme Folder: securingtomorrow-brillioActive Plugins:
Activity Log (v2.8.3) by Activity Log Team
AddFunc Head & Footer Code (v2.3) by AddFunc
AddToAny Share Buttons (v1.8.4) by AddToAny
Advanced Custom Fields (v5.11.4) by Delicious Brains
C3 Cloudfront Cache Controller (v6.1.3) by hideokamoto
Classic Editor (v1.6.2) by WordPress Contributors
Co-Authors Plus (v3.4.92) by Mohammad Jangda, Daniel Bachhuber, Automattic
Disable Comments (v2.3.3) by WPDeveloper
Highlight Search Terms (v1.8.1) by RavanH
Image Widget (v4.4.7) by Modern Tribe, Inc.
Imsanity (v2.7.2) by Exactly WWW
Limit Post Titles (v1.0.2) by Cocoon Development Ltd
Reading Time WP (v2.0.10) by Jason Yingling
Redirection (v5.2.3) by John Godley
Simple Custom Post Order (v2.5.6) by Colorlib
User Profile Picture (v2.6.0) by Cozmoslabs
WP Missed Schedule (The Original) (v2014.1231.2017.12) by sLaNGjIs Team
WP Offload Media Lite (v2.6.2) by Delicious Brains
WPML Multilingual CMS (v4.5.5) by OnTheGoSystems
WPML String Translation (v3.2.1) by OnTheGoSystems
WPS Hide Login (v1.9.3) by WPServeur, NicolasKulka, wpformation
Yoast Duplicate Post (v4.4) by Enrico Battocchi & Team Yoast
Yoast SEO (v18.0) by Team Yoast
jQuery Updater (v3.6.0.1) by RamoonusDrop-ins:
advanced-cache.php – advanced-cache.php`We can’t find any SQL queries during that period and also doesn’t have debug.log. Also sometimes RDS connections spike goes upto 850, the website goes down. We are unable to access admin and frontend of website.
Thanks,
SushantAny feedback here?
Thanks for the quick response.
Just wanted to confirm, If I turn off “Rewrite Media URLs”, then it will not impact the plugins functionality? Plugin will work same right? Just I will loose Object Versioning benefits.
Regards,
SushantHello Support,
Thanks for the response.
Please check below “Diagnostic Info“:
site_url(): https://www.mcafee.com/blogs home_url(): https://www.mcafee.com/blogs Database Name: consumerblog Table Prefix: m6af33_ WordPress: 5.9.1 Web Server: Apache/2.4.6 (CentOS) PHP/8.1.8 PHP: 8.1.8 MySQL: 8.0.25 ext/mysqli: yes PHP Memory Limit: 256M WP Memory Limit: 256M Memory Usage: 77 MB Blocked External HTTP Requests: None WP Locale: en_US Organize offloads by month/year: Enabled WP_DEBUG: No WP_DEBUG_LOG: No WP_DEBUG_DISPLAY: No SCRIPT_DEBUG: No WP Max Upload Size: 2 MB PHP Time Limit: 30 PHP Error Log: WP Cron: Enabled fsockopen: Enabled allow_url_fopen: Enabled OpenSSL: OpenSSL 1.0.2k 26 Jan 2017 cURL: 7.29.0 Zlib Compression: Enabled PHP GD: 2.3.3 Imagick: Disabled Basic Auth: Disabled Proxy: Disabled Media Files: 33,419 Offloaded Media Files: 30,597 Not Offloaded Media Files: 2,822 Number of Image Sizes: 12 Names and Dimensions of Image Sizes: thumbnail (150x150) medium (300x300) large (1024x1024) 1536x1536 (1536x1536) 2048x2048 (2048x2048) category-listing (205x129) profile_24 (24x24) profile_48 (48x48) profile_96 (96x96) profile_150 (150x150) profile_300 (300x300) WP_CONTENT_DIR: /var/www/html/blogs/wp-content WP_CONTENT_URL: https://www.mcafee.com/blogs/wp-content UPLOADS: Not defined WP_PLUGIN_DIR: /var/www/html/blogs/wp-content/plugins WP_PLUGIN_URL: https://www.mcafee.com/blogs/wp-content/plugins AS3CF_PROVIDER: Not defined AS3CF_BUCKET: Not defined AS3CF_REGION: Not defined AS3CF_SETTINGS: Not defined Local URL: https://www.mcafee.com/blogs/wp‑content/uploads/2022/08/photo.jpg Offload URL: https://www.mcafee.com/blogs/wp‑content/uploads/2022/08/photo.jpg OME Metadata Version: 12 Custom tables: m6af33_as3cf_items: Ok Storage Provider: Amazon S3 Use Server Roles: On Key File Path: N/A Access Keys Set: No Access Key ID Define: Not defined Secret Access Key Define: Not defined Bucket: blogs-prod-s3 Region: us-west-2 Block All Public Access: Enabled Copy Files to Bucket: On Enable Path: On Custom Path: blogs/wp-content/uploads/ Use Year/Month: On Object Versioning: Off Delivery Provider: Amazon CloudFront Rewrite Media URLs: On Enable Custom Domain (CNAME): On Custom Domain (CNAME): www.mcafee.com Force HTTPS: On Remove Files From Server: On Active Theme Name: McAfee Blog | Securing Tomorrow - Brillio Active Theme Version: 1.0 Active Theme Folder: securingtomorrow-brillio Active Plugins: Activity Log (v2.8.3) by Activity Log Team AddFunc Head & Footer Code (v2.3) by AddFunc AddToAny Share Buttons (v1.8.4) by AddToAny Advanced Custom Fields (v5.11.4) by Delicious Brains C3 Cloudfront Cache Controller (v6.1.3) by hideokamoto Classic Editor (v1.6.2) by WordPress Contributors Co-Authors Plus (v3.4.92) by Mohammad Jangda, Daniel Bachhuber, Automattic Disable Comments (v2.3.3) by WPDeveloper Highlight Search Terms (v1.8.1) by RavanH Image Widget (v4.4.7) by Modern Tribe, Inc. Imsanity (v2.7.2) by Exactly WWW Limit Post Titles (v1.0.2) by Cocoon Development Ltd Reading Time WP (v2.0.10) by Jason Yingling Redirection (v5.2.3) by John Godley Simple Custom Post Order (v2.5.6) by Colorlib User Profile Picture (v2.6.0) by Cozmoslabs WP Missed Schedule (The Original) (v2014.1231.2017.12) by sLaNGjIs Team WP Offload Media Lite (v2.6.2) by Delicious Brains WPML Multilingual CMS (v4.5.5) by OnTheGoSystems WPML String Translation (v3.2.1) by OnTheGoSystems WPS Hide Login (v1.9.3) by WPServeur, NicolasKulka, wpformation Yoast Duplicate Post (v4.4) by Enrico Battocchi & Team Yoast Yoast SEO (v18.0) by Team Yoast jQuery Updater (v3.6.0.1) by Ramoonus Drop-ins: advanced-cache.php - advanced-cache.phpSite is using Amazon Cloudfront for CDN. The issue is same query executing multiple times which is increasing number of DB connections and slow down website. Client is unable to access the admin when website is down.
Request to please let us know the solution for the above issue.
Thanks,
SushantHi Support Team,
Any updates here?
Regards,
Sushant