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.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
96MB Problem Mysql
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.
Here from syslog: http://pastebin.com/cT7FMJf6
mysql folder was emtpy
It also says at first installation, mysql failed to set root pw.
If its burst ram check your failcnt in user beancounters.. maybe not enough memory on server. Also make sure innodb is disabled
skip-innodb
96MB is gurranted not SWAP, so it should work....
How should i check failcnt in user beancounters?
Here: http://s7.directupload.net/file/d/3313/wfppza7a_png.htm
@Infinity580 A failure on mysqld process start IMHO is not indicative of a usage/resource problem..Not inherently.
Yeah but its only on the one Hoster..... because it works on 64MB Lowendspirit.
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.
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:
http://lowendtalk.com/discussion/1097/mysql-not-starting
Any of those solutions work?
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.
That guide is OLLLDDDD @Liam should take it down, some of the config lines don't even work on modern mysql server either.
Try reinstalling using minstall.
Its fixed now thanks to zhuanyi, dont remove the tutorial i just love it