RE: Question about best hardware

["Josh Berry" <josh.berry () netschematics com>]

For MySQL I recently upgraded to 4.0 and it seems to be much faster.  I
run mysql with --skip-external-locking --skip-name-resolve
--skip-host-cache --key_buffer-size=128M --table_cache=512
--sort_buffer_size=8M --read_buffer_size=2M.

I have set the noatime option in fstab for the MySQL partition.

For CPU I patched the kernel with some latency patches.  I ran TCP/IP
parameters that I found on a Linux TCP/IP tuning howto.  Apache settings
are also from an Apache Tuning howto.

> --On 08 March 2004 13:31 -0600 Josh Berry <josh.berry () netschematics com>
> wrote:
>
> > I don't have a performance issue over 100K.  My DB has reached into the
> > Gig's before and been fine, I just spread the load, tune
> > MySQL/Apache/and
> > the ACID config file and am fine.  Once a week I run an optimize table
> > script.  I have a dual P4 2.0 Gig System with 2 Gigs of RAM running the
> > DB
> > and a dual P4 2.0 Gig System with 1 Gig of RAM running the web
> > interface.
> > I also keep all of the sensors separate from the servers.
> >
> > I have also performance tuned the TCP/IP, Disk IO, and CPU settings
> > where
> > I could.  I keep Apache (Redhat Version) up-to-date but run an older
> > MySQL
> > (from MySQL.com) version (3.23.56).
>
> What settings have you tuned? I've configured mudpit, tuned disc IO using
> hdparm and built Snort for i686, but is there anything else you'd suggest
> doing for MySQL/Apache/ACID/TCPIP/CPU?
>
> Best Regards,
> Alex.
> --
> Alex Butcher: Security & Integrity, Personal Computer Systems Group
> Information Systems and Computing             GPG Key ID: F9B27DC9
> GPG Fingerprint: D62A DD83 A0B8 D174 49C4 2849 832D 6C72 F9B2 7DC9





-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users