MySQL Forums
Forum List  »  Install & Repo

Re: Mini VPS need a tiny config for a server under 250Mb memory
Posted by: Rick James
Date: May 25, 2011 07:32PM

> I have a VPS server with 256Mb memory
Ouch! But possible.

max_connections = 200 --> 10 (You probably won't have more than 1-2 connections.)
query_cache_type = 1 --> 0 (Turn the Query cache off to save the space.)

> I have tried to tune it in order to force it to consume less memory without any success.
Eh? Your settings seem quite small. Any messages in mysqld.err ?

For more discussion (but the numbers in it do not apply to that small a server):
http://mysql.rjweb.org/doc.php/memory

Options: ReplyQuote


Subject
Written By
Posted
Re: Mini VPS need a tiny config for a server under 250Mb memory
May 25, 2011 07:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.