Server Configuration Help
Installation and Configuration
serveion:
thank you for the url and documentation you provide help me to reduce the mysql time.
Here's the mysqld section for a 1GB RAM JR server:
key_buffer = 64M
max_allowed_packet = 32M
table_cache = 1536
table_definition_cache = 1536
open_files_limit = 10240
tmp_table_size = 64M
max_heap_table_size = 64M
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 768K
max_connections = 50
innodb_buffer_pool_size = 128M
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len = 3
ft_stopword_file = ""
I would consider that the
minimum MySQL config for any decent performance.
Hope this helps!
updated by @brian: 01/26/16 04:19:46PM