Hi Pawel,
At 04:48 17-08-2007, =?iso-8859-2?Q?Pawe=B3_T=EAcza?= wrote:
>My hardware seems to be good enough. It's Sun Fire x4100 M2 server
>with 2 x Dual-Core AMD Opteron 2220 SE CPUs and 8GB RAM on the board
>and it's bored with its job I think I rather need faster disks.

That should be fast. Disk I/O is generally the bottleneck for a
database. MySQL provides several sample configuration files. Use the
one which is appropriate for your installation. Adjust the buffer
size (engine specific). See how effective your query cache is. Turn
on the slow query log and monitor it.