Skip to main content

Ken Wei's Library tagged innodb   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.
    glibc may 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_size additional
    memory.

1 - 13 of 13
Showing 20 items per page

Diigo is about better ways to research, share and collaborate on information. Learn more »

Join Diigo