Date: Wed, 04 Jun 2008 11:36:29 +0200 From: Joerg Bruehe <joerg@mysql.com> To: VeeJay <maanjee@gmail.com> Cc: mysql@lists.mysql.com, FreeBSD-Questions <freebsd-questions@freebsd.org> Subject: Re: FreeBSD MySQL Performance Tunning suggestions??? Message-ID: <4846621D.6020102@mysql.com> In-Reply-To: <2cd0a0da0806030343o68dcf30bj447d4174b93c30d2@mail.gmail.com> References: <2cd0a0da0806030343o68dcf30bj447d4174b93c30d2@mail.gmail.com>
next in thread | previous in thread | raw e-mail | index | archive | help
Hi all !
VeeJay wrote:
> [[...]]
>=20
> At my job, I am going to build a Web Server with
>=20
> 1. FreeBSD 7.0-RELEASE amd64
> 2. Apache 2.2.8
> 3. PHP 4.4.8 (or may be PHP5, what do you suggest?)
>=20
> Server's hardware configuration is as follow:
>=20
> 2 x Quad Core Xeon E5450 3.0GHz,2x6MB,1333FSB
> 16GB (8x2GB Dual Rank DIMMs) 667MHz FBD
> 6 x 450GB SAS 15k 3.5" HD Hot Plug
> PERC 6/i, Integrated Controller Card x6 backplane
> PE2950 III C5 MSS R10 Add-in PERC 5/i / 6/i 1 S
> TCP/IP Offload Engine 2P
> Broadcom TCP/IP Offload Engine functionality (TOE) Not Enabled
>=20
> For FreeBSD 7.0-RELEASE amd64 Which MySQL 5.0 would be used ?
> 1. FreeBSD 7.x (x86_64)
> or
> 2. FreeBSD 6.x (x86)
Your machine has 16 GB of RAM.
If you ever want to use really large caches in the MySQL server process, =
you need to use a 64 bit binary, called "x86_64" in the MySQL package=20
file names.
>=20
> I have done some googling and made these configuration files for Apache=
and
> MySQL?
>=20
> Apache:
> httpd.conf-----------------------------------------------------start---=
---------
> [[... file snipped ...]]
>=20
>=20
> MySQL:
> my.cnf------------------------------------------------------------start=
--------
> [[... file snipped ...]]
>=20
>=20
> Is there something you can tune?
You cannot tune without knowing which bottleneck you should widen, and=20
how much resources still are available.
IMNSHO, you need to start with some configuration, put load onto it (as=20
representative as possible), then watch the system's behavior (take=20
measurements !), and only then determine which part you want to improve.
Example: Database caches are good to reduce disk I/O and so to increase=20
performance, but you will not increase caches if your system is already=20
paging heavily (=3D your RAM is too small).
There is no need to change any parameter unless
a) its current setting restricts your performance, and you have
sufficient resources to raise the limit, or
b) its current setting allocates more resources than needed here,
which could be used better at some other place.
You need some initial run and measurement to check that.
HTH,
J=F6rg
--=20
Joerg Bruehe, MySQL Build Team, joerg@mysql.com
Sun Microsystems GmbH, Sonnenallee 1, D-85551 Kirchheim-Heimstetten
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering Muenchen: HRB161028
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4846621D.6020102>