We have a magento + marketplace website and a good web server by 128G RAM and other hardwares in this level and about 15000 products + not many visitors (about 5000 per days).
BUT we have a trouble on performance.
so…
I would like to know where is our problem?
1- apache webserver? (and we can solve by Engin-X or Litespeed/litemage)
2- mysql many quesries?
3- coding problems?
4- magento is just this!
Is there any webserver monitoring software to see where is exactly our problem?
thanks.
2
Answers
yeah. newrelic apm or any other profiler like blackfire.io or tideways.io
It could be that you are not effectively using the 128GB.
It could be that you have slow queries.
It could be that Magneto is doing a sloppy job of creating SQL, or what you are telling Magneto leads to sloppy SQL.
Is that 5000 unique visitors_ per day? Or 5000 visits per day?
Try to see which of Apache, Magneto, or MySQL is the slow part.
Adding a cache in front of MySQL sometimes slows things down; don’t bother.
For more help from the MySQL point of view, follow the steps in http://mysql.rjweb.org/doc.php/mysql_analysis