Jump to:

558 Posts in 3589 Topics by 244 members

Hosting Requirements

SilverStripe Forums » Hosting Requirements » Mysql Service shuts down

What you need to consider when choosing a hosting provider and plan.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 1391 Views
  • kindlemanwill
    Avatar
    Community Member
    67 Posts

    Mysql Service shuts down Link to this post

    Hello.

    We have just deployed a site to our stage environment. Its a 500m Ram, "Cloud" VPS with Crucial Paradigm.

    If we both test it together, the cms ends up hanging, and then if i refresh the page i get:

    PHP Fatal error: DataObjects have been requested before the database is ready.

    Looking in cpanel, the mysql service is off. Rebooting it gets us going again until the next topple.

    Whats to be done? could there be a configuration i have missed in the Silverstripe? Or does it need something special turned on at the server?

    Thanks, will

  • kindlemanwill
    Avatar
    Community Member
    67 Posts

    Re: Mysql Service shuts down Link to this post

    Just to confirm this,

    We have to edit the site one at a time. If i click on a item in the tree 5 times rapid fire, the mysql proccess falls down. every time.

    At this stage we can live with the slowness but it needs to be reliable.

    Is there anything we can do to fix this?

    w

  • kominiarz
    Avatar
    Community Member
    1 Post

    Re: Mysql Service shuts down Link to this post

    Well, are you sure that it's CMS fault?
    maybe it's VPS internal problem?

  • jasonsypolt
    Avatar
    Community Member
    5 Posts

    Re: Mysql Service shuts down Link to this post

    I have several sites running on a micro instance on AWS (613mb) and had this problem. The server was getting low on memory and was shutting down mysql. Changing the php memory_limit and adjusting some my the mysql memory parameters helped. So I reduced the memory that php and mysql used and installed varnish to compensate, and the sites are actually pretty fast.

    1391 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.