On Wed, Sep 12, 2001 at 03:18:37PM +0200, Marcin Pyla wrote:
>
> Hello,
>
> How I can make my mysql faster ? Can I compile it with special
> options ?
(1) good database design
(2) properly indexed tables
(3) write fast queries
(4) tune the mysql server
(5) add hardware if still necessary
Here'
Marcin wrote:
>How I can make my mysql faster ? Can I compile it with special options?
Check out section 5.5 of the manual. I found there's also some very useful
information
readily available in the file INSTALL-SOURCE* in the top level of the
source directory. I'm not
sure whether GCC v3.0 mig
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 "mak
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 dep
Look and "making MySQL fly"
The hard stuff is where to start. Raid 0 and lost of memory
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
Simon
-Original Message-
From:
