Ken Wei's Library tagged → View Popular
26 Jun 07
14.2.3 InnoDB Configuration
-
# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is < 2GB
innodb_buffer_pool_size=1G -
Warning: On 32-bit GNU/Linux x86,
you must be careful not to set memory usage too high.
glibcmay allow the process heap to grow over
thread stacks, which crashes your server. It is a risk if the
value of the following expression is close to or exceeds 2GB:
innodb_buffer_pool_size
+ key_buffer_size
+ max_connections*(sort_buffer_size+read_buffer_size+binlog_cache_size)
+ max_connections*2MB
Each thread uses a stack (often 2MB, but only 256KB in MySQL AB
binaries) and in the worst case also uses
sort_buffer_size + read_buffer_sizeadditional
memory.
1 - 13 of 13
Showing 20▼ items per page
Selected Tags
Related Tags
Sponsored Links
Ads by Google
Top Contributors
Related Lists on Diigo
-
MyISAM vs InnoDB
Items: 5 | Visits: 114
Created by: Ken Wei
Diigo is about better ways to research, share and collaborate on information. Learn more »
Join Diigo
