Steps In Compiling MySQL
Use the right compiler
Use pgcc = Pentium optimzed gcc on Pentium
Strip unnecessary parts
Only use character sets you will use
Skip BDB tables, replication if you don't need them
compile MySQL without support for exceptions (as MySQL does not use C++
exceptions)
Simon
PS there is more you can do please read the manual...
-----Original Message-----
From: Marcin Pyla [mailto:[EMAIL PROTECTED]]
Sent: 12 September 2001 14:45
To: Simon Green
Cc: [EMAIL PROTECTED]
Subject: RE: Faster mysql
On Wed, 12 Sep 2001, Simon Green wrote:
> Look and "making MySQL fly"
> The hard stuff is where to start. Raid 0 and lost of memory
I used Raid 5 + 1 (hardware) and it gaves only 2 seconds faster...
> Then yes there are a few things that you can remove when compiling to make
> things faster depending what you need to do.....
> And then theirs stuff to do in my.cnf........
Can you give me an exempels ?
>
> Simon
>
> -----Original Message-----
> From: Marcin Pyla [mailto:[EMAIL PROTECTED]]
> Sent: 12 September 2001 14:19
> To: [EMAIL PROTECTED]
> Subject: Faster mysql
>
>
>
>
> Hello,
>
> How I can make my mysql faster ? Can I compile it with special options
> ?
>
>
>
> Pozdrawiam,
> Marcin Pyla
>
> (o_ [ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> ]
> (/)_ [ "God, root, what's the difference?" -- "God is more forgiving" ]
>
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
Pozdrawiam,
Marcin Pyla
(o_ [ Marcin Pyla - Cubbi <[EMAIL PROTECTED]> | <<+ NetArt ISP +>> ]
(/)_ [ The system is going down to maintenance mode NOW !! ]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
