www.harryfay.co.uk Posted February 9, 2014 Share Posted February 9, 2014 Hi, I'm moving my shop harryfay.co.uk from JustHost to OVH using OVH Web Hosting Performance option. This comes with two types of MySql: shared and private with 128MB of RAM. Do you have any suggestions which one should I use? Shared is limited to 30 simultaneous connections and private has no such limit. On the other hand the private one has only 128MB of memory - will that be enough? Thank you, Marcin Gorecki Link to comment Share on other sites More sharing options...
vekia Posted February 9, 2014 Share Posted February 9, 2014 if i were you i will use private sql, but in fact, everything depends on how big your store is and how many online users you've got if more than 20+ select definitely private sql server. if less, you can select shared sql. Link to comment Share on other sites More sharing options...
NemoPS Posted February 10, 2014 Share Posted February 10, 2014 Also consider 20+ simultaneous visits is actually A LOT for a store which is just starting out! Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted February 14, 2014 Author Share Posted February 14, 2014 Thank you for you answers. I set up my shop using private sql. The 128MB option won't last long - with a very light traffic MySQL uses ~90MB. I hope I'll grow up out of it soon. I'm quite happy with current performance on ovh - much better than justhost.com. Link to comment Share on other sites More sharing options...
benjamin utterback Posted February 14, 2014 Share Posted February 14, 2014 Thank you for you answers. I set up my shop using private sql. The 128MB option won't last long - with a very light traffic MySQL uses ~90MB. I hope I'll grow up out of it soon. I'm quite happy with current performance on ovh - much better than justhost.com. You can see with OVH if you can tweak your php.ini settings to slightly optimize performance and bypass some memory limit errors. Read the post here http://www.prestashop.com/blog/en/php-ini-file/ 2 Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted February 17, 2014 Author Share Posted February 17, 2014 You can see with OVH if you can tweak your php.ini settings to slightly optimize performance and bypass some memory limit errors. Read the post here http://www.prestashop.com/blog/en/php-ini-file/ It's not possible to tweak php.ini on OVH shared hosting. Still thanks for good reading! It will be handy when I move to VPS. Link to comment Share on other sites More sharing options...
benjamin utterback Posted February 17, 2014 Share Posted February 17, 2014 It's not possible to tweak php.ini on OVH shared hosting. Still thanks for good reading! It will be handy when I move to VPS. Okay, have you contacted OVH to see if they can change it on their end? Many hosting companies will allow you to change it even on shared hosting. Link to comment Share on other sites More sharing options...
NemoPS Posted February 18, 2014 Share Posted February 18, 2014 I second Benjamin, also, one of my clients ran a site with ovh and they did change some php.ini settings as far as I can remember (like a year or 2 ago) Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted February 18, 2014 Author Share Posted February 18, 2014 Okay, have you contacted OVH to see if they can change it on their end? Many hosting companies will allow you to change it even on shared hosting so that is a bit surprising. I second Benjamin, also, one of my clients ran a site with ovh and they did change some php.ini settings as far as I can remember (like a year or 2 ago) Thank you. At the moment the page is performing very well - ~700ms to for main page, ~1.25s for a category page. Does it make sense to try to optimize it even more? My original question was about MySQL server - OVH offers separate private MySQL, which has no connection limit and guaranteed resources, but a hard memory limit of 128MB. With default settings this private MySQL works fine for me - current MySQL memory usage is 96MB. Btw: OVH is listed as a Prestashop partner. It would be great if they shared more information about suggested configuration. Link to comment Share on other sites More sharing options...
NemoPS Posted February 19, 2014 Share Posted February 19, 2014 I see. That speed is more than good, but of course optimizing is a neverending process so that you can always get the best out of the site Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted February 19, 2014 Author Share Posted February 19, 2014 I see. That speed is more than good, but of course optimizing is a neverending process so that you can always get the best out of the site Good reminder, thanks. I think I will focus now on getting more customers to put some real stress on the server. The fastest server doesn't sell if no one is using it Link to comment Share on other sites More sharing options...
MaximeHurtrel Posted February 28, 2014 Share Posted February 28, 2014 Hi Everyone and thanks for your interest concerning OVH hosting offers. I am Maxime, product manager at OVH. Here are some quick details : - Yes we advise you to use the dedicated SQL with your PrestaShop installation. The 128 Mb one thats comes free with any Performance plan is enough for most cases. If your activity grows you can then upgrade this RAM limit. - We are currently working on PAAS offering for our Performance customers; This will give you more flexibility on the environnement, including the executions of more languages + more cutomization for the environnement you choose. 1 Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted March 1, 2014 Author Share Posted March 1, 2014 - Yes we advise you to use the dedicated SQL with your PrestaShop installation. The 128 Mb one thats comes free with any Performance plan is enough for most cases. If your activity grows you can then upgrade this RAM limit. Maxime, Thank you for your answer. Memory usage on my private mysql stabilized around 102MB (out of 128MB) with my pretty small shop, which seems to confirm this configuration as a viable option. Thank you! Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted April 26, 2014 Author Share Posted April 26, 2014 Maxime, Thank you for your answer. Memory usage on my private mysql stabilized around 102MB (out of 128MB) with my pretty small shop, which seems to confirm this configuration as a viable option. Thank you! Update: we have moved out from OVH. There were two major outages in less than two months and the only way to get a response was to ask a public question on twitter - they took long time to reply to tickets. I've very disappointed. Link to comment Share on other sites More sharing options...
vekia Posted April 26, 2014 Share Posted April 26, 2014 Update: we have moved out from OVH. There were two major outages in less than two months and the only way to get a response was to ask a public question on twitter - they took long time to reply to tickets. I've very disappointed. hello may i know where you moved your store? what hosting you use now? Link to comment Share on other sites More sharing options...
www.harryfay.co.uk Posted May 13, 2014 Author Share Posted May 13, 2014 hello may i know where you moved your store? what hosting you use now? I moved to http://www.heartinternet.co.uk/ due to stability, recommendation from PC Pro magazine and really good support for .co.uk domains. Link to comment Share on other sites More sharing options...
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