Re: Ram needed for production Mysql

[Richard Welty <rwelty@averillpark.net>]

On Wed, 09 Jul 2003 20:19:52 +0000 Brad Brad <braddeicide@hotmail.com> wrote:
> Hi, I couldn't find any up to date info on the Ram needed for production 
> Mysql servers.  The Dell salesman is recommending 3-4Gb of ram but that 
> sounds excessive to me though, what do you guys think?
 
> The server is 2.8Ghz and may have as many as 230 mysql sessions with 13 
> queries a second, the rest will be sleeping (ftp sessions maintain 
> connection).  The old server is seems quite happy with 512mb.  The
> server 
> also does low levels of firewall/ftp/http-perl/email.

13 queries per second isn't much of a query rate. i'd say that the fact
that the old server is happy with 512mb is a powerful signal. can't you
check memory stats and see what the MySQL server is consuming right now?

now i'd be more concerned with the overloading of multiple functions on
a single box; you've created quite a single-point-of-failure there. i am of
the school of thought that says that firewalls should just be firewalls,
nothing else.

how about using the box freed up by the new system as your firewall?

richard
--
Richard Welty                                         rwelty@averillpark.net
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security