HowTo Get Max Peform with MySQL 5.0 and FreeBSD 5.4 ??

[Ashok Shrestha]

I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64.

The box specs:
CPU: Dual Core AMD Opteron(tm) Processor 275 (2193.76-MHz K8-class CPU)
Memory: 4 GB

My databases will be anywhere from 2GB-20GB.

I would like to get the maximum performance out of this box. What options
(MAKE, kernel, etc...) should I use to achieve this? What about loading the
INDEX file into memory?

Should I build WITH_LINUXTHREADS? Is it still necessary to do so on FreeBSD
5.4? I know it is better on a 4.X machine. Note: It is not possible to build
WITH_LINUXTHREADS on a FreeBSD 5.4 AMD64.

What are the advantages of building with (MAKE) BUILD_OPTIMIZED?
 Is there an advantage in using a 64bit FreeBSD?

How should I configure the following in /etc/loader.conf? I could not find
an authoritative definition any of these variables; do you know of any?

kern.maxdsiz="3221225472" # 3GB; should it be closer to 4GB?
kern.dfldsiz="3221225472" # 3GB; should it be closer to 4GB?
kern.maxssiz="134217728" # 128MB; what is this? stack size? how large should
I make it?


--
Ashok Shrestha
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"

[Joseph Koshy]

On 11/15/05, Ashok Shrestha <[hidden email]> wrote:
> I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64.

> I would like to get the maximum performance out of this box.
> What options (MAKE, kernel, etc...) should I use to achieve
> this? What about loading the INDEX file into memory?

You might want to take a look at:

  http://wikitest.freebsd.org/moin.cgi/MySQL


--
FreeBSD Volunteer,     http://people.freebsd.org/~jkoshy
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"

[Ashok Shrestha]

Thanx.
 I wanted to add more info to the wiki, but it appears that only developers
are allowed to make changes. =(
 Do you know if this wiki will turn more public?

 On 11/15/05, Joseph Koshy <[hidden email]> wrote:

>
> On 11/15/05, Ashok Shrestha <[hidden email]> wrote:
> > I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64.
>
> > I would like to get the maximum performance out of this box.
> > What options (MAKE, kernel, etc...) should I use to achieve
> > this? What about loading the INDEX file into memory?
>
> You might want to take a look at:
>
> http://wikitest.freebsd.org/moin.cgi/MySQL
>
>
> --
> FreeBSD Volunteer, http://people.freebsd.org/~jkoshy
>

--
Ashok Shrestha
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"

[Joseph Koshy]

> I wanted to add more info to the wiki, but it appears that
> only developers are allowed to make changes. =(

The wiki is experimental I believe.

You could just post your info here on the mailing lists.  It
will probably reach a wider audience in a more timely manner too.

--
FreeBSD Volunteer,     http://people.freebsd.org/~jkoshy
_______________________________________________
[hidden email] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-database
To unsubscribe, send any mail to "[hidden email]"

[Simon L. B. Nielsen-4]

On 2005.11.17 12:57:58 -0500, Ashok Shrestha wrote:

>  On 11/15/05, Joseph Koshy <[hidden email]> wrote:
> >
> > On 11/15/05, Ashok Shrestha <[hidden email]> wrote:
> > > I'm using MySQL 5.0.15 with FreeBSD 5.4-RELEASE amd64.
> >
> > > I would like to get the maximum performance out of this box.
> > > What options (MAKE, kernel, etc...) should I use to achieve
> > > this? What about loading the INDEX file into memory?
> >
> > You might want to take a look at:
> >
> > http://wikitest.freebsd.org/moin.cgi/MySQL
>
>  I wanted to add more info to the wiki, but it appears that only developers
> are allowed to make changes. =(
>  Do you know if this wiki will turn more public?

The people administering the FreeBSD.org systems are already quite
busy, so we unfortunatly don't have time to handle all the issues that
comes with having a public wiki.  That's the reason the FreeBSD wiki
is only for FreeBSD committers and selected contributors (mainly the
Google Summer of Code participants), which is also the purpose the
wiki was originally created for.

--
Simon L. Nielsen
Hat of the day: wikitest.FreeBSD.org admin