Do you have a screenshot of the error?    There are two different types of "Bad Gateway" error message from Cloudflare, and they both look very differently: https://developers.cloudflare.com/support/troubleshooting/cloudflare-errors/troubleshooting-cloudflare-5xx-errors/#error-502-bad-gateway-or-error-504-gateway-timeout ... View more

It sounds like you'll need to do some profiling on the theme and also get in touch with the theme developer about the problem.    If your budget permits, I definitely recommend taking a look at Hyvä themes which is built from the ground up for performance.  ... View more

What sort of caching are you running for your Magento store?    Ideally you will want to have Redis for backend cache and Varnish or LiteMage Cache for Full Page Cache (FPC).    What is your server stack and who is managing it?  ... View more

This table is related to the Content Security Policies (CSP) module, Magento_Csp which was introduced in version 2.3.5: https://developer.adobe.com/commerce/php/development/security/content-security-policies/   If you have no need for the CSP reports, it should be fairly safe to truncate the table but do make sure you take a backup before you go ahead with it just in case.  ... View more

If the slowness is with the frontend only, a Full Page Cache like Varnish should help.    Can you make sure that Varnish is setup correctly within Magento based on the following guide? https://devdocs.magento.com/guides/v2.4/config-guide/varnish/config-varnish-magento.html ... View more

Are you seeing the slowness at the frontend or the backend of the store?    Do you use any Full Page Cache (FPC) like Varnish or LiteMage Cache?   What Web Server are you using?    Is your MySQL properly tuned, especially relating to the InnoDB buffer pool?  ... View more

Are you using Redis? It should help reduce database calls and alleviate the load at the backend.   Here's the guide to enable it for Magento 2: https://devdocs.magento.com/guides/v2.4/config-guide/redis/redis-pg-cache.html   You can either install Redis in your web server, a separate instance or use Amazon ElastiCache for Redis.  ... View more

It depends on the size of your store, the number of products, the location of your target audience, the level of help you require and many more.    What hosting solution are you currently using?  ... View more

What you need is to setup a staging site for your Magento store. There are quite a few guides floating around if you Google the keyword "magento staging".    Basically what you need to do is just to duplicate the files and databases and then go in to the staging database and change all links from your live site to the staging site (most of it should be in the core_config_data table). ... View more

You may want to consider using LiteMage Cache instead of Varnish instead as it supports multiple Magento websites. LiteMage Cache is also faster than Varnish due to overall lower overhead.    The only "downside" to LiteMage Cache is you will need to switch to LiteSpeed Enterprise Web Server which is a paid software and thus you will need to pay for the licensing fee. I do believe that it is worth it though due to the flexibility and the performance boost that it offers.  ... View more

You should be able to set both Base URL and Base Secure URL to HTTPS.    Do you have any rewrites or redirects at the Load Balancer, Web Server or .htaccess level? If you do, make sure you remove them as they shouldn't be needed.  ... View more

LiquidWeb doesn't do shared hosting but I believe they have placed you under Nexcess instead which is their sub-brand.    They should have support techs or engineers that can help you troubleshoot the problem. It is very unlikely to be something done on purpose. My suspicion is their platform may differ from Alpha Hosting so there may be some configuration changes needed to be made in your M1 store or possibly a different caching plugin / extension to use, for example.  ... View more

It is quite unfortunate to see that you are facing performance issue after the migration.    Did you get in touch with their support team to try to troubleshoot and resolve the problem?   LiquidWeb and Nexcess are excellent brands so it is unlikely that their infrastructure is slow. I think it is more likely to be a configuration or compatibility issue which they should hopefully be able to identify and resolve so your store can load quickly again.  ... View more

It sounds to me like your hosting provider isn't really familiar with Magento and when you couple that with the lack of CLI / SSH access, I don't believe that they will be a right fit for you to host a Magento store.    If Elasticsearch is an issue, you can actually setup a separate server for it and connect your Magento store to the server.    Alternatively there are also quite a few solutions out there which allows you to not require Elasticsearch to run Magento 2.4+ that you can Google for. I've not used them myself but they do look decent enough.  ... View more

@jasonloeve wrote: Just replying to this because this still seems to be an issue in 2021, using the "Magento 2 Open Source" droplet app available in the digitalocean marketplace, every 24 hours i would be greeted with a 504 and had to reboot the server, got so annoying i just ended up killing my builds on digital ocean and moving elsewhere and using a different platform. A server that isn't properly optimized out of the box will unfortunately not be able to handle Magento properly.  ... View more

It may or may not help depending if the slowness if related to the lack of PHP memory.    Is the server properly optimized for Magento?    Are you using a Full Page Cache (FPC) like LiteMage Cache or Varnish Cache and also Redis Cache?  ... View more

While a Content Delivery Network (CDN) like CloudFront may help to some extent, I do believe that most performance gains can be obtained only by implementing Full Page Cache (FPC) like LiteMage Cache or Varnish to speed up the frontend while using Redis Cache to speed up the backend.    You will also want to audit all the extensions and bloat that is bundled with Magento and stripped them out to reduce bottleneck.  ... View more

This will only work if proxypass is supported by OpenLiteSpeed.    As far as I know support for proxypass was just added to LiteSpeed Enterprise 6.0 recently so I doubt that OLS has support for it.   Anyway I don't believe it is recommended to use Magento with OLS anyway as you will miss out on the excellent LiteMage Cache. You should use LiteSpeed Enterprise instead which not just supports LiteMage Cache but also has more features and proper support.  ... View more

Do you have a Full Page Cache (FPC) like LiteMage Cache or Varnish?   Are you running Redis Cache?    What other reasons did GTMetrix gives for the slow loading speed? You've cropped out most of them so they aren't visible.  ... View more

Are the two domains part of the same Magento installation or are they separate?    Do they share the document root, any files or database? ... View more

@françois_villon wrote: I have the same issue of CPU load at command cron:run with Siteground. In my case, it is on shared hosting where it is not possible to increase the CPU. You'll need something more than shared hosting to run Magento smoothly.    You should definitely consider an alternative solution with your own server (preferably fully managed) where you have access to more resources.   I will recommend also going with a provider who specializes in Magento so you can seek assistance for Magento related issues.  ... View more

Are you a developer or do you have a developer?    What about server management? Who is managing the server?    It sounds like you will need someone to troubleshoot this from two point of view - the codes and the server.  ... View more

Depending on how high or low the innodb_lock_wait_timeout is set in your my.cnf, you may want to consider increasing it for your server.    I do hope that you are testing this in a staging environment and not in production.  ... View more

You can write a script to take a backup and send it elsewhere like a Cloud storage provider or FTP backup space.    Alternatively, there are also third-party solutions like CodeGuard and a few others that can grab the backup from your server.  ... View more

@andrew_corbett wrote: I am migrating over to a new dedicated server which has daily back-ups as part of the monthly plan. With that in mind, is there any need to do any regular Magento backups, and if so, which one(s)?   I wouldn't fully rely on your hosting provider's backup as they may not be stored offsite and they usually do not guarantee the integrity of the backups.    You should consider taking your own backups as well and store it offsite.  ... View more

I agree with @TutorialMagento.   It is always better to use the CLI instead of running SQL commands directly as there is a slight risk that you may have formatted the command incorrectly and corrupt the database.    And yes, you should definitely take a backup before you do this in production. If you can, try it first in your staging environment (set one up if you don't have one) before pushing it to production.  ... View more

Is there a specific reason that you are using Sphinx search instead of Elasticsearch?    Elasticsearch is supported by Magento out of the box so you do not have to resort to another third-party module/plugin.  ... View more

Did you configure Redis for your Magento store?    You will need to make sure your server support Redis and has it installed.    You can then follow the steps below to configure it for Page Caching and Default Caching:- https://devdocs.magento.com/guides/v2.4/config-guide/redis/redis-pg-cache.html ... View more

A 504 Gateway Timeout error by CloudFlare usually means that CloudFlare isn't able to communicate with your server.    Make sure that your server is not overloaded and CloudFlare IPs are not blocked by your server firewall.  ... View more

@pmcshivamg8dc1 wrote: As far as I know we are using the built-in cache offered by Magento 2 out of the box. Not Varnish. And regarding the server it is a dedicated server offered by Go Daddy with 4 cores.   And regarding the last thing, Only the necessary ones are enabled I believe.   Would you suggest enabling Varnish Cache and Redis? Also which CDN would be better for Magento 2 store? IS it a thing or we can go with any popular CDN provider? Thanks for your time though, appreciate it. Yes, Varnish or LiteMage Cache (either one, not both) and Redis Cache will definitely help improve loading speed.    If your server is managed, your hosting provider should be able to set them up for you although I do have concerns with GoDaddy's ability to setup and support them. Once again I do believe that you are better off moving to a Magento optimized provider where these caches and a whole lot of other server level tuning and optimizations are available out of the box.    I don't believe that a CDN will help much if your target audience are US based as long as your server is located in the US as well.  ... View more