The innodb_buffer_pool_size value in a MySQL server
by Jason.nix from LinuxQuestions.org on (#6ESJ4)
Hello,
How can I choose the right value for innodb_buffer_pool_size in a MySQL server?
My server has the following amount of memory:
Code:# free
total used free shared buff/cache available
Mem: 5924976 1726272 2069744 353176 2128960
3547828
Swap: 2097148 0 2097148My MySQL's configuration is as follows:
Code:thread_cache_size = 151
query_cache_type = 1
query_cache_size = 64M
sort_buffer_size = 2M
tmp_table_size = 32M
read_buffer_size = 128k
read_rnd_buffer_size = 256k
join_buffer_size = 128k
table_definition_cache = 400
table_open_cache = 400
long_query_time = 0.5
min_examined_row_limit = 100
max_heap_table_size = 64M
innodb_buffer_pool_size = 10M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 100MIn some examples, I saw that the amount of innodb_buffer_pool_size was as big as gigabytes.
How do I determine this value?
Thank you.
How can I choose the right value for innodb_buffer_pool_size in a MySQL server?
My server has the following amount of memory:
Code:# free
total used free shared buff/cache available
Mem: 5924976 1726272 2069744 353176 2128960
3547828
Swap: 2097148 0 2097148My MySQL's configuration is as follows:
Code:thread_cache_size = 151
query_cache_type = 1
query_cache_size = 64M
sort_buffer_size = 2M
tmp_table_size = 32M
read_buffer_size = 128k
read_rnd_buffer_size = 256k
join_buffer_size = 128k
table_definition_cache = 400
table_open_cache = 400
long_query_time = 0.5
min_examined_row_limit = 100
max_heap_table_size = 64M
innodb_buffer_pool_size = 10M
innodb_file_per_table = 1
innodb_flush_log_at_trx_commit = 2
innodb_log_buffer_size = 8M
innodb_log_file_size = 100MIn some examples, I saw that the amount of innodb_buffer_pool_size was as big as gigabytes.
How do I determine this value?
Thank you.