[NBLUG/talk] Multiple Server Setup Advice

troy fryman at sonic.net
Tue Aug 19 13:36:01 PDT 2003


On Tue, Aug 19, 2003 at 12:19:00PM -0700, Walter Hansen wrote:
>      That's good advice on the Pentium Pro. I knew they were fast and
> sonic used to use them alot. The only problem is I don't think that
> MB has dimm sockets, but 72 pin SIMMs. It's loaded with 128 right
> now. I'll have to do a search on the MB and see if it can handle
> bigger simms. I assume they made 64meg 75 pin simms? Yes I think my
> main problem is memory gets pretty squeaky. That and I know mySQL is
> intended for machines with 128-512 for it alone. So build up the 200
> and switch to it, perhaps buying a router/firewall to take a little
> stress of the server.

Unless it's loaded, Mysql does fine with little ram.  See the
"my-small.cnf" that ships with MySQL.  It's only when you have many
clients or large tables/indexes that performance suffers.  If MySQL
starts swapping, you'll rapidly get into trouble.

> 
> System normal (after a reboot I think typical free memory is much less):

When considering memory, remember to look at both free and cached.  For
your examples below, the system really has about 95mB readily available.

Run the nastiest typical Mysql query that you might have, start a
couple of large samba file transfers and see what you get.
There's a perl script running around called "siege" that I used to use
to test systems.  You may be flat-out amazed at what low end hardware
can do as far as serving web.  

>  12:17pm  up 6 min,  1 user,  load average: 0.21, 0.26, 0.14
> 54 processes: 52 sleeping, 2 running, 0 zombie, 0 stopped
> CPU states:  1.5% user,  1.3% system,  0.0% nice, 97.0% idle
> Mem:   126512K av,   70600K used,   55912K free,       0K shrd,    6736K buff
> Swap:  265064K av,       0K used,  265064K free                   38328K
> cached
> 
> 
> Running CGI Search:
>  12:17pm  up 7 min,  1 user,  load average: 0.19, 0.25, 0.14
> 55 processes: 53 sleeping, 2 running, 0 zombie, 0 stopped
> CPU states: 95.9% user,  3.8% system,  0.0% nice,  0.1% idle
> Mem:   126512K av,   72512K used,   54000K free,       0K shrd,    6792K buff
> Swap:  265064K av,       0K used,  265064K free                   38328K
> cached
> 



More information about the talk mailing list