[EMAIL PROTECTED] 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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
