RE: Question about best hardware

["AJ Butcher, Information Systems and Computing" <Alex.Butcher () bristol ac uk>]

--On 10 March 2004 09:58 -0600 Josh Berry <josh.berry () netschematics com> 
wrote:

> 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.

Thanks, for those, Josh.

FYI, Fedora's standard kernel includes the low latency patches, so that's 
one less job to do for some folks.

For MySQL 3.23, Josh's options can be set by editing /etc/my.cnf:

[mysqld]
...
set-variable = key_buffer_size=128M
set-variable = table_cache=512
set-variable = sort_buffer=8M
set-variable = record_buffer=2M

More information about these settings can be found at 
<http://www.mysql.com/doc/en/Server_parameters.html>. Extrapolating, it 
looks as though Josh's settings are suitable with machines with at least 
512MB memory. Halve/double each setting if you have half/double this amount 
of memory.

It looks as though the only TCP/IP tuning parameters worth bothering with 
are set by adding to Fedora's /etc/sysctl.conf:

net.core.rmem_max = 262143
net.core.rmem_default = 262143

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