This link has been bookmarked by 21 people . It was first bookmarked on 25 May 2007, by Ken Wei.
-
31 Jan 12
-
key_buffer_size, innodb_buffer_pool_size, innodb_additional_memory_pool_size, innodb_log_buffer_size, query_cache_size
-
-
28 Jun 11
-
07 Mar 11
-
26 Aug 10
-
05 Jul 10
-
28 Feb 10
-
11 Dec 08
-
04 Nov 08
-
03 Sep 08
-
28 Apr 08
-
07 Apr 08
-
About 256K is allocated at once even if thread is idle - they are used by default thread stack, net buffer etc.
-
if table will perform complex operations such as full table scans, sorts, or need temporary tables as much as read_buffer_size, sort_buffer_size, read_rnd_buffer_size, tmp_table_size of memory might be allocated. But they are only allocated upon the need and freed once given stage of query is done
-
32bit limits into account and probably limit “mysqld” size to about 2.5GB
-
Thread buffers can be allocated more than once for each thread.
-
MyISAM may allocate buffer which is large enough to contain largest record in the given table which is held until table is closed.
-
For example you may find out increasing sort_buffer_size from 1MB to 4MB and 1000 max_connections increases peak memory consumption just 30MB not 3000MB as you might have counted.
-
In practice however you would not have more than 2-3 connections doing it at the same time so you happen to be fine.
-
-
25 May 07
-
But they are only allocated upon the need and freed once given stage of query is done.
-
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.