Fine tuning mysql

I need to get MySQL running has fast has possible.
Can someone suggest a Hardware config or config file that will fine tune it
to the fastest possible speed.

At the moment it is running one site/ one database PHP/MySQL on a dual Xeon
4 3.06 with 4gig of ram and I've allocated 150mb memory to MySQL.

Will increasing the memory allocation increase the performance?

Regards
Nik

On Tue, 21 Jun 2005 13:55:41 +0100, zen wrote:

> I need to get MySQL running has fast has possible.
> Can someone suggest a Hardware config or config file that will fine tune it
> to the fastest possible speed.
>
> At the moment it is running one site/ one database PHP/MySQL on a dual Xeon
> 4 3.06 with 4gig of ram and I've allocated 150mb memory to MySQL.
>
> Will increasing the memory allocation increase the performance?

Depending on the application it is running I would suggest to use the
mysql query_cache:

set global query_cache_size=<bytes>

When a lot of selects are being used and they are indexed correctly it
will increase speed and lower the load of the machine.


Regards,

Hans

--
http://spamikaze.nl.linux.org/