ocpistol Posted February 20, 2015 Share Posted February 20, 2015 My Website http://beverageequipmentcompany.com Browsing the catalog runs quick but when add a product to the cart or try to access account settings it goes really slow. anything I can check for? Link to comment Share on other sites More sharing options...
shacker Posted February 21, 2015 Share Posted February 21, 2015 in preferences, performance, or advanced parameters, performance, you enable the cache, and disable force compile? and enable all the ccc options for javascript and css? this helps to speed the site. also you can enable apache optimization Link to comment Share on other sites More sharing options...
ocpistol Posted February 26, 2015 Author Share Posted February 26, 2015 in preferences, performance, or advanced parameters, performance, you enable the cache, and disable force compile? and enable all the ccc options for javascript and css? this helps to speed the site. also you can enable apache optimization I have had all those setting set to that, I watch Top and it runs a mysql query and then stops doing everything then about 5 seconds later starts to load apache and mysql. Could it be that my database is to large and its taking to long to search it? I have it on a raid 10 of 6 re4 1tb drives. Link to comment Share on other sites More sharing options...
shacker Posted February 26, 2015 Share Posted February 26, 2015 you can use our free module delete connections to save db space. This optimize db and delete stats tables that eat all your db, and i recommend to use google analitycs Link to comment Share on other sites More sharing options...
ocpistol Posted February 26, 2015 Author Share Posted February 26, 2015 you can use our free module delete connections to save db space. This optimize db and delete stats tables that eat all your db, and i recommend to use google analitycs Thanks for the advice. It cleaned up alot, but its still taking decades to add something to cart or view the cart. Link to comment Share on other sites More sharing options...
shacker Posted February 27, 2015 Share Posted February 27, 2015 try disable stats modules, and modules that you dont use and check. the carts is strange that works very slow. do you have any tracking code? Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 Ok here is an update, I tried to disable all the stats and everything that is required for the site to run. I Tried optimizing the database with programs. I am running ubuntu Server I tried updating mysql to 5.6, that didnt change anything. I am running it in Windows Server 10 Hyper-V alone with a Hex core Xeon 2.0ghz So I thought maybe it is the actual server not being able to keep up with hard drive speed (raid 6 of 6 re4 1tb drives) so I put a Samsung 850 Pro SSD in for it to run on. I Have the entire server allocated to running just this site at the moment. It is still the same load time when it comes to checkout. There are no errors in logs I am at a loss at what it could be. When I watch "top" and click on add to card I see it running apache and mysql for about 200ms then it stops about 10 seconds later it does it again and finally loads the page. Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 wait a second I forced SSL on the entire site and everything is having problems loading and is extremely slow. Link to comment Share on other sites More sharing options...
El Patron Posted March 4, 2015 Share Posted March 4, 2015 wait a second I forced SSL on the entire site and everything is having problems loading and is extremely slow. Learn more here about implications using SSL. https://www.prestashop.com/forums/topic/162017-tip-performance-https-and-keep-alive-connections-persistant-connections/ Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 Learn more here about implications using SSL. https://www.prestashop.com/forums/topic/162017-tip-performance-https-and-keep-alive-connections-persistant-connections/ I have keepAlive enabled. Link to comment Share on other sites More sharing options...
El Patron Posted March 4, 2015 Share Posted March 4, 2015 I have keepAlive enabled. Please post all other values that go with keepAlive, possible it is not optimally configured. Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 Please post all other values that go with keepAlive, possible it is not optimally configured. # # KeepAlive: Whether or not to allow persistent connections (more than # one request per connection). Set to "Off" to deactivate. # KeepAlive On # # MaxKeepAliveRequests: The maximum number of requests to allow # during a persistent connection. Set to 0 to allow an unlimited amount. # We recommend you leave this number high, for maximum performance. # MaxKeepAliveRequests 100 # # KeepAliveTimeout: Number of seconds to wait for the next request from the # same client on the same connection. # KeepAliveTimeout 100 Link to comment Share on other sites More sharing options...
El Patron Posted March 4, 2015 Share Posted March 4, 2015 what was your analysis? just posting the values without out your input makes me think you want me to do it alone. maybe do some push ups then post your thoughts. Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 what was your analysis? just posting the values without out your input makes me think you want me to do it alone. maybe do some push ups then post your thoughts. I am sorry I am not sure what you are asking me for, Im not sure how to get you more info. kind of why i am having a problem figuring out what is wrong. Link to comment Share on other sites More sharing options...
El Patron Posted March 4, 2015 Share Posted March 4, 2015 I am sorry I am not sure what you are asking me for, Im not sure how to get you more info. kind of why i am having a problem figuring out what is wrong. yes well I was just looking for your thoughts on research compared to your configuration. So you are saying when I turn on https it's slow, but ssl not enabled it is fast? and only for add to cart or entire site? Link to comment Share on other sites More sharing options...
ocpistol Posted March 4, 2015 Author Share Posted March 4, 2015 (edited) When its on http is runs fast switching to https takes about 8 Seconds. Once running in https it runs acceptable slower but still quick. Adding to cart takes about 10-15 seconds in both modes. When looking at server activity during it it uses about 18% cpu on apache for those 10 secs. Edited March 4, 2015 by ocpistol (see edit history) Link to comment Share on other sites More sharing options...
.png.022b5452a8f28f552bc9430097a16da2.png)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now