Thanks @thomas for reply, have tested but still slow, I have confirmed all shipping methods (UPS, USPS, Fedex) are disable, I have also disable other payments except money order
By MySQL Variables, I’m referring to things like innodb. However, if you don’t know what that is then don’t worry because it means you’ve never messed with them.
I read something last night slightly relating to this issue, where it turned out that disabling all of the RSS Options made a positive impact. Try Disabling all of the options under Stores > Configuration > Catalog > RSS Feeds
You might also want to disable anything like M2E Pro in case that is the route course. The issue you’re experiencing isn’t well documented online, leading me to believe it’s not a common issue - Therefore, must be impacted by some 3rd party module.
You might have to play a process of elimination with other 3rd party modules to try and narrow this down further.
There’s definitely no harm on trying a clean install. But without knowing the issue, who’s to say the problem could crop back up again in the future?
If you drop @thomas a PM, he should be available for hire if you want someone to dig deeper on the server. I think it’s wiser to address the issue than start over - But obviously go with whatever choice you think is best.
Hey. i decided to test the site on a different server(GCP). I backed up and restored db files and everything works. I suspect it mysql or the server resources that caused the issue
Though the server has 8GB RAM but there is other application running on the server ie an ERP
right now this what I can see from cpanel
Real memory 4.19 GB used / 2.81 GB cached / 7.75 GB total
I also checked on the url_rewrite table which has 5541 rows the same with catalog_url_rewrite_product_category which has 3184 rows. Could any of the above be the reason
Thank you for sharing your findings. If the problem was the data within the database, then the issue would be present in both servers. Therefore, I don’t think url_rewrite is related.
Editing MySQL Variables via PhpMyAdmin
If you log in phpMyAdmin as root, you will see a tab in the upper-right of the screen:
This shows you all of the MySQL Variables that you can set, which can also be edited from here.
1. Compare MySQL Variables
I would compare the variables of the 2 servers to see if you can identify a “dodgy” variable on your main server that is having an adverse effect.
2. Tweak MySQL Variables
Personally, I find the default MySQL Variables a little low. And this has caused me issues with larger sites in the past because I forgot to tweak them. Try amending the following MySQL Variables for improved performance:
innodb-log-file-size = 100M
innodb-buffer-pool-size = 2G
innodb-log-file-size = 250M
Making MySQL Variable changes permanent
For the most part, any changes you make will likely be overwritten next time the mysql service is restarted. So, in order to make sure any MySQL Variable changes are permanent you will have to edit the MySQL Configuration file. This requires root or superuser privileges. The location of the file will vary depending on both your Web Host, SQL Version and OS - So, you’ll have to find this yourself.
If you setup your Web Server using my tutorial then there is a good chance that you’ll find the file in one of these 2 locations:
/etc/mysql/mysql.conf.d/mysqld.cnf
or /etc/mysql/my.cnf
Simply replace the Variable that you want to change. If it doesn’t exist, then it will assign a default value - In this scenario just create a new line in the file. Once you’ve edited and saved the file, restart mysql to apply the changes.
There is no “undo” button. Always backup or take a note of any variables you Add/Edit/Remove.
How many concurrent users do have on the site?
How many products and split between config’s and simeple/virtual?
How many attributes do you have apart from system ones?
Is your hosting shared,dedicated or vps?
Min spec I would choose would be 26GB Ram
Have you minify’d html, css and js?
If you bundled your js. undo it.
When was the last time you optimised your database?
Sadly this has nothing to do with front-end or even enabling/clearing cache. M2 place order is slow in general, and am too still trying to figure out a way around it. I’ve developed a headless store front and with that, EVERYTHING is super quick…except “placeOrder()”.
Configuring the environment might be the only way…
@Stephen_Oduor This issue appears unrelated to the original post. Please, can you create a dedicated post and let us know the events leading up to this issue. Such as what you were doing when it stopped working or when it worked last.