HelioHost Posted June 15, 2017 Posted June 15, 2017 Hi, A few days ago I've created an account on Helios so I can make a schoolproject where database is involved. Not sure if this is normal or not, butthere are some problems with the database, is running slow and somethingdoesn't even run, takes a lot of time to execute a query in Workbench orrunning it from c#. xrodionu.heliohost.orgdb: xrodionu_licentauser: xrodionu_licenta Cheers,Catalin D.
wolstech Posted June 15, 2017 Posted June 15, 2017 Ricky has been experiencing somewhat slow response times since yesterday. HTTP seems to be the most-impacted function, however I wouldn't be surprised if MySQL was having issues as well. Thank you for reporting the issue. I've added your concern to the performance issues topic I already have open on our forum for Ricky: http://www.helionet.org/index/topic/28419-rickys-http-performance/?do=findComment&comment=129931 We'll keep you updated as this is looked into.
HelioHost Posted June 15, 2017 Author Posted June 15, 2017 Thank you very much. 2017-06-15 17:06 GMT+03:00 Heliohost Support : > Ricky has been experiencing somewhat slow response times since yesterday.> HTTP seems to be the most-impacted function, however I wouldn't be> surprised if MySQL was having issues as well. Thank you for reporting the> issue. I've added your concern to the performance issues topic I already> have open on our forum for Ricky: http://www.helionet.org/index/> topic/28419-rickys-http-performance/#entry129931> > We'll keep you updated as this is looked into.>>> You may view the status of your ticket by visiting:>> http://www.helionet.org/index/index.php?showtopic(421>> Thank you,> Heliohost support> http://www.heliohost.org/> http://www.helionet.org/>>
wolstech Posted June 16, 2017 Posted June 16, 2017 The performance issues from earlier have been corrected. Are you still experiencing issues using your databases?
HelioHost Posted June 16, 2017 Author Posted June 16, 2017 The database is still slow. 2017-06-16 4:45 GMT+03:00 Heliohost Support : > The performance issues from earlier have been corrected. Are you still> experiencing issues using your databases?>>> You may view the status of your ticket by visiting:>> http://www.helionet.org/index/index.php?showtopic(421>> Thank you,> Heliohost support> http://www.heliohost.org/> http://www.helionet.org/>>
wolstech Posted June 16, 2017 Posted June 16, 2017 I've posted this over in the escalations forum so the root admins will take a look at it for you: http://www.helionet.org/index/topic/28437-ricky-mysql/ You can follow that topic for more information. Also, if you wish, you can log onto our forum and post additional information in that topic too.
HelioHost Posted June 16, 2017 Author Posted June 16, 2017 I've just moved from a server where the query execution time was '0.040'..thisis 3-5 times slower. 2017-06-16 15:02 GMT+03:00 Heliohost Support : > I've posted this over in the escalations forum so the root admins will> take a look at it for you: http://www.helionet.org/index/> topic/28437-ricky-mysql/> > You can follow that topic for more information. Also, if you wish, you can> log onto our forum and post additional information in that topic too.>>> You may view the status of your ticket by visiting:>> http://www.helionet.org/index/index.php?showtopic(421>> Thank you,> Heliohost support> http://www.heliohost.org/> http://www.helionet.org/>>
wolstech Posted June 17, 2017 Posted June 17, 2017 If you're seeing ~0.2 (0.04 x5), then the speeds are normal for Ricky. Tommy is a little faster than Ricky but not by much. Tommy's average is 0.15, and minimum time was 0.07. Below are the numbers from two benchmarks that were run this morning (Ricky and Tommy servers). The numbers shown are about normal for their respective servers, Each server is hosting over a thousand accounts, so the speeds aren't quite as fast as a commercial host that has more hardware and puts only a few hundred on a server. If you need faster performance, you could try moving to Tommy, but ultimately you may need to find a paid hosting company if you really need the speeds you used to have. Ricky Benchmark: Average number of seconds to run all queries: 0.271 secondsMinimum number of seconds to run all queries: 0.182 secondsMaximum number of seconds to run all queries: 0.375 secondsNumber of clients running queries: 50 Tommy Benchmark: Average number of seconds to run all queries: 0.150 secondsMinimum number of seconds to run all queries: 0.073 secondsMaximum number of seconds to run all queries: 0.291 secondsNumber of clients running queries: 50
Recommended Posts