joce@presence-pc.com wrote:
> Hi,
>
> How much memory do you have on your system ? (the current setting in your
> my.cnf could eat *a lot* of memory)
>
min_memory_needed = global_buffers + (thread_buffers * max_connections)

thread_buffers
---------------------------+---------
sort_buffer_size | 12M
myisam_sort_buffer_size | 64M
read_buffer_size | 12M
join_buffer_size | 12M
read_rnd_buffer_size | 12M
---------------------------+----------
TOTAL | 112M

global_buffers
---------------------------+----------
key_buffer_size | 2048M

So worst case we're talking 33 and a bit Gig, but late night worst case scenario? maybe a 1000 connections?
So something like 15G, that's not that bad. I'd run mtop as someone suggested and see if some query is hammering it, maybe some other process on the machine is hogging or going IO bound?

Regards,
Phil