Forum Replies Created

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    Thanks for the feedback. We will try out the recommendations and update you if its resolves the issue or not.

    Regards,
    Sushant

    Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    Hi @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: Disabled

    Media Files: 35,674
    Offloaded Media Files: 32,552
    Not Offloaded Media Files: 3,122

    Number 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/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/10/photo.jpg
    Offload URL:
    https://www.mcafee.com/blogs/wp‑content/uploads/2022/10/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): http://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.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,
    Sushant

    Thread Starter Sushant Sanjay Khadilkar

    (@skhadilk)

    Any 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,
    Sushant

    Hello 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.php

    Site 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,
    Sushant

    Hi Support Team,

    Any updates here?

    Regards,
    Sushant

Viewing 6 replies - 1 through 6 (of 6 total)