@gaurav_harsh1 wrote: 3). Follow this Store > Configuration > Catalog. Then click on Catalog which is under the Catalog tab. In here, you will see the Storefront section. When you have seen it, find two fields which are Use Flat Catalog Category and Use Flat Catalog Product, and change these fields to Yes. You should really put a disclaimer when it comes to recommending Flat Catalog.   For the record, Magento no longer recommends the use of a flat catalog as a best practice as of version 2.1.x and above so I wouldn't recommend enabling it.    You can read more about it here:- https://support.magento.com/hc/en-us/articles/360034631192   ... View more

You can write a simple bash script (or have your hosting provider do it) that will automatically compress your files and dump your database, then transfer it to an offsite backup service.    If you use S3, the bash script will need to use AWS CLI to transfer the backed up files and if you use an offsite backup storage service, the backup script can incorporate utilities like Rsync, Duplicity or even Borg to transfer the backup files.  ... View more

In my experience Magento 2 requires more resources than Magento 1 to run smoothly so shared hosting may not be the right way to go.    I recommend that you consider a server of your own but it does increase your budget when compared to shared hosting. You will want to go with a fully managed service and consider going with a provider who is familiar with Magento and can provide assistance better than most providers.  ... View more

Magento 2 doesn't work too well with shared hosting due to its resource consumption and starting from Magento 2.4, you will need Elasticsearch which is not available in shared hosting.    Do you have any specific requirements and what is your budget?  ... View more

I haven't looked to see if someone made it yet, but it may be possible for a third-party module to restore the MySQL search functionality to Magento 2.4 and above.    You can also consider setting up a VM of your own, install Elasticsearch on it and connect your Magento 2.4 store to the VM.  ... View more

Each web server is different so without taking a closer look at the server, it will be very difficult to give you a proper advice so my advise is to seek help from a Magento experienced server administrator or hosting provider.    Do also note that the t2 instance in EC2 run on CPU Credits so make sure you have enough of them or you will suffer poor performance.  ... View more

@ahamdycrafa6c5 wrote: How can I check the server times out? max_execution_time in php.ini or something else? It will be part of your Web Server configuration.     @ahamdycrafa6c5 wrote: If I split my import batch to smaller files, it will work fine, but do you think that batch with 1500 products with size 5 MB is too larger to split it? It depends on how your server is configured and whether it is properly optimized.    If these are outside of your expertise, I highly recommend that you either hire a sever administrator or shift to a Managed Hosting service as it is very risky to manage a server running eCommerce stores yourself if you are not a server administrator.    Besides that, you have not answered me as to what EC2 instance type you are using? That can possibly make a difference as well. ... View more

Are you planning to shift your website from WordPress to Magento?    If you are just shifting your WordPress websites from one server to another, there will be no changes to the website's structure and no data loss if the migration is handled correctly.   If you are planning to shift from WordPress to Magento, you will most likely need to rebuild your website and then export + import the data over.  ... View more

Magento 2.4 officially supports Elasticsearch 7.6.x but should work with 7.8.x as well.   If you are risk averse, you can go with 7.6.x but otherwise you can give 7.8.x a try since it is still part of the same branch. ... View more

But when I try to upload products using the (Import) method with uploading products more than 1000, the products are uploaded successfully but the website is showing the upload loading icon is loading forever and don't show me the results at the end, if it's a success or there are some errors. Check this screenshot: https://prnt.sc/tx8i6s Check if your web server level timeouts are causing this behavior.    While you are running the import, monitor your server's CPU and Memory usage to see if you are maxing them out.    Try splitting your import into smaller batches and see if it works better?     Besides that, what EC2 instance type are you using? Some of them like the T2 or T3 run on CPU Credits so if you run out of CPU Credits, your CPU will be limited quite heavily and thus experience very slow performance.  ... View more

I don't believe that it make sense to run Elasticsearch in a shared hosting environment, especially with the conflicts that may occur, the high memory requirements of Elasticsearch along with the security and privacy risks involved.    You may want to consider either getting your clients to upgrade to their own environment to run Magento 2.4 or consider have them installing a third-party module to restore the MySQL search capability.  ... View more

@gaurav_harsh1 wrote: 3). Follow this Store > Configuration > Catalog. Then click on Catalog which is under the Catalog tab. In here, you will see the Storefront section. When you have seen it, find two fields which are Use Flat Catalog Category and Use Flat Catalog Product, and change these fields to Yes. 4). Go to Store > Configuration > Advanced. Under the Advanced tab, click Developer. In the Javascript Settings section, change the values in three fields Merge JavaScript Files, Enable JavaScript Bundling and Minify JavaScript Files to Yes. Then, change the fields Merge CSS Files and Minify CSS Files in the CSS Settings tab to Yes. Just to point out that Magento no longer recommends the use of a flat catalog as a best practice as of version 2.1.x and above.    You can read more about it here:- https://support.magento.com/hc/en-us/articles/360034631192 ... View more

It can be due to any number of factors but for your case it is most likely software level optimizations or the lack of it.    Are you managing the server yourself or do you have a managed provider that can help you take a close look at the server and diagnose the cause of the performance issue?  ... View more

What caching system do you run? Do you only use Magento's built-in caching?    The latest version for the Magento 1.9 branch is 1.9.4.5 so your version of 1.9.3.8 is quite old now.    You'll also want to consider rebuilding your site with Magento 2 now that Magento 1 has reaches End of Life with no further support or updates (including security updates).  ... View more

@nusquare wrote: @JLHC wrote: I Googled the keyword "INSERT INTO search_tmp" and I found:- - https://github.com/magento/magento2/issues/15545 - https://magento.stackexchange.com/questions/227386/magento2-unknown-query-insert-into-search-tmp   Did you perform mass attribute values update recently?  i did update some attribute of the products but that was a bit before the issue started. It looks like the processes are still running now based on what you provided.    You may want to monitor that and see if they stop or continue to run.  ... View more

I Googled the keyword "INSERT INTO search_tmp" and I found:- - https://github.com/magento/magento2/issues/15545 - https://magento.stackexchange.com/questions/227386/magento2-unknown-query-insert-into-search-tmp   Did you perform mass attribute values update recently?  ... View more

The first thing to do is to find out what MySQL processes are running which are eating up CPU.    You can use the SHOW PROCESSLIST; MySQL command to find out what MySQL processes are running at the moment.  ... View more

What caching system are you running at the moment?   You'll want to look into a full page cache solution like Varnish or LiteMage Cache.    The other less efficient alternative is to upgrade your server so you will have more CPU resources.  ... View more

Instead of doing a redirect, have you considered just shifting all the Magento files up to the main directory?   That should be easier to achieve and have less possibility to break down the road.  ... View more

It looks like only the AMP version of your website isn't working.    Do you have a firewall or other configurations that may be blocking CloudFlare from the AMP version?  ... View more

Honestly I will say that GoDaddy is not a hosting provider you want to go with when you run a Magento 2 store.    I highly suggest that you go with a Magento focused provider instead as you will not just have better performance but their support team will be more familiar with Magento and as such can assist you better when you face any issues.  ... View more

What hosting or server environment are you using to host your Magento 2 store?    As for backups, you may want to consider taking backup externally (for example, just run mysqldump in SSH) instead of doing it within Magento.  ... View more

IMO you should definitely use Varnish in a production environment and it is also strongly recommended by Magento.    The only other alternative to Varnish that I would consider is LiteMage Cache but it is a commercial software that needs to be coupled with LiteSpeed Enterprise Web Server.  ... View more

What is the IOPS limit in your cPanel?    Hitting the limit explains the slowness you are experiencing as CloudLinux at the server level will throttle / limit your account to keep your usage within the limit.  ... View more

Is this a fresh installation?   If it has been running for a while, is it always this slow or did you make some changes to the server level or application level recently?  ... View more

You should have no problems in starting with a Magento optimized shared hosting as long as there are proper upgrade path with the provider when your store grows.    I will not suggest going with the normal shared hosting provider as their servers are not tuned for Magento and they provide very low CPU and RAM limits which will not be enough to run Magento smoothly.  ... View more

I agree with @Robert Rand.    It does seem like you are with an unmanaged provider.    You will either need to get a Magento specialized company to manage your unmanaged server or move to a fully managed provider so you will not need to worry about your server environment.  ... View more

When you say "all in one package", does that include doing SEO and updates for Magento, etc?    Generally a Magento focused hosting provider will make sure that the server is properly setup and optimized to run Magento smoothly (this includes maintenance server level software and server level security). They will also be able to assist and help troubleshoot when you face any Magento related issues.    Beyond that however, they will generally not help with application level matters like your Magento configurations, SEO, modules update, etc.  ... View more

Firstly, you will want to install the latest version 2.3 instead of 2.2. Besides that, you will also want to implement a full page cache system like LiteMage Cache or Varnish. Finally, you need to make sure that your server is properly optimized for Magento which I do not think NameCheap will do. Is there a specific reason you went with them for Magento instead of a Magento specialized provider? ... View more