Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


96MB Problem Mysql
New on LowEndTalk? Please Register and read our Community Rules.

All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.

96MB Problem Mysql

NeoonNeoon Community Contributor, Veteran

Hi.

I have one of these vps things with 96MB from httpzoom, the problem is i could not run on them Mysql with this tutorial:
http://www.lowendbox.com/blog/yes-you-can-run-18-static-sites-on-a-64mb-link-1-vps/

It runs on all my other vps's also 64MB but not there.
So the Support says the problem is not on our side.
Have anyone a solution for this?

Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Comments

  • Check mysql error log, and post output.

  • NeoonNeoon Community Contributor, Veteran

    Here from syslog: http://pastebin.com/cT7FMJf6
    mysql folder was emtpy

  • NeoonNeoon Community Contributor, Veteran

    It also says at first installation, mysql failed to set root pw.

  • earlearl Member

    If its burst ram check your failcnt in user beancounters.. maybe not enough memory on server. Also make sure innodb is disabled

  • DerekDerek Member

    skip-innodb

    Thanked by 1natestamm
  • NeoonNeoon Community Contributor, Veteran

    96MB is gurranted not SWAP, so it should work....
    How should i check failcnt in user beancounters?

  • @Infinity580 A failure on mysqld process start IMHO is not indicative of a usage/resource problem..Not inherently.

  • NeoonNeoon Community Contributor, Veteran
    edited July 2013

    Yeah but its only on the one Hoster..... because it works on 64MB Lowendspirit.

  • CloudxtnyHostCloudxtnyHost Member, Host Rep

    I'd be very surprised if this was due to a lack of free ram on the node.

    Currently its got a whole load of memory not used.

    You'd need to get the MySQL log outputting debug information and then find out why MySQL is failing to start.

  • dnomdnom Member

    Assuming everything is setup exactly the same way, maybe yes. But I seriously doubt that the hosts oversells to the point that the OOM kills process. If it's really about the memory, it's probably because LowEndSpirit uses the newer ovz kernel.
    @Infinity580 said:

    Yeah but its only on the one Hoster..... because it works on 64MB Lowendspirit.

  • edited July 2013
  • zhuanyizhuanyi Member
    edited July 2013

    Your innodb is clearly on from your error log. What's your MySQL version? If it is 5.5 and above then add the following:
    innodb=OFF default-storage-engine=MyISAM

    to your .cnf file.

  • AnthonySmithAnthonySmith Member, Patron Provider

    That guide is OLLLDDDD @Liam should take it down, some of the config lines don't even work on modern mysql server either.

  • netomxnetomx Moderator, Veteran

    Try reinstalling using minstall.

  • NeoonNeoon Community Contributor, Veteran

    Its fixed now thanks to zhuanyi, dont remove the tutorial i just love it :D

Sign In or Register to comment.