> -----Original Message-----
> From: Dicky Wahyu Purnomo [mailto:[EMAIL PROTECTED]]
> Subject: Memory Limit
> And what is the calculation for the memory also ....
The formula you want is (this does not account for InnoDB buffers either):
key_buffer_size + (record_buffer + sort_buffer)*max_connections
768M + 16M * 1,200 = 19,968M
That's way more than 4gb of ram. Do you mean 120 connections? That would
set you right underneath the magic 2GB which has been plauging me as well on
Intel. (4xXeon, 4gb ram)
> I know if I set my configuration to lower value than I had slow
> query performance. And I found with sortbuffer : 12M and
> recordbuffer : 12M ... my query performance is good. but I can't
> have more than 1200 concurrent threads :((
I've been able to increase our connections to above 600 by using 1M sort and
record buffers and key_buffer sizes of only 256M. Of course, with settings
like these, at 600 connections it's dog slow and useless to connect that
many threads anyway.
Under Linux, any maybe Solaris as well, the problem lies in the fact that
MySQL is one application with multiple threads. Thus all threads share a
single memory 'ceiling'. A fork-based model wouldn't have this problem. Or
I don't think it would anyway.
Not much help, I know, but if you do find a way around this let me know.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
