Description:
Hi,
We are continuously facing performance issue in our existing MYSQL db server. It using Innodb table space. Database current size is 1.5 GB.
Existing RAM on server is 3 GB and 2.5 GHz - 32 bit
We are planning to move 64 bit platform and increasing memory to 7.5 GB and 2.5 GHz dual core
Following are current my.cnf settings. Could someone please guide me to set new value in my.cnf according to 64 bit 7.5 GB RAM.
# #optimizer_prune_level=0
#optimizer_search_depth=3
# </optimization>
# 02/23/2007
# Setting charset, based on http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
collation_server=utf8_general_ci
character_set_server=utf8
# Set default table type to innodb
default-storage-engine=innodb
skip-locking
skip-name-resolve
#key_buffer = 256M
#Modified by Yunus
key_buffer = 1024M
join_buffer = 1024M
innodb_buffer_pool_size = 1024M
innodb_additional_mem_pool_size = 1024M
max_allowed_packet = 31M
table_cache = 1024M
thread_cache = 256M
thread_stack = 1M
optimizer_prune_level=1
optimizer_search_depth=62
group_concat_max_len = 10240
#Modification ends here
#max_allowed_packet = 8M
#table_cache = 256
#sort_buffer_size = 1M
sort_buffer_size = 8M
net_buffer_length = 128K
read_buffer_size = 8M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
#thread_cache = 8
# <optimization>
query_cache_type=1
query_cache_size= 16M
# </optimization>
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 10
set-variable=max_connections=500
query_cache_type=1
innodb_file_per_table=1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
How to repeat:
--
Suggested fix:
--