Hello i have this server:
Intel® Xeon® E5-1650 v3
Hexa-Core Haswell
incl. Hyper-Threading Technology
I use interspire email marketer to send email but many times each day the mariadb goes down, sometimes i found the smtp (postfix) OFF.
I have many and many problems.
I try this configuration:
my.cnf
[mysqld]
local-infile=0
user=mysql
innodb_buffer_pool_size = 28G
innodb_file_per_table = 1
query_cache_size = 128M
query_cache_limit = 2G
thread_cache_size = 24
innodb_lock_wait_timeout = 100
innodb_flush_log_at_trx_commit=0
table_open_cache = 3072
table_definition_cache = 4096
max_heap_table_size= 64M
tmp_table_size = 64M
max_connections= 3000
max_user_connections = 500
max_allowed_packet = 16M
thread_cache_size = 32
slow_query_log = 1
long_query_time = 1
log_queries_not_using_indexes = 1
min_examined_row_limit = 20
max_allowed_packet = 16M
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
someone can help me?
Intel® Xeon® E5-1650 v3
Hexa-Core Haswell
incl. Hyper-Threading Technology
- RAM256 GB DDR4 ECC RAM
- Hard Drive2 x 4 TB SATA 6 Gb/s 7200 rpm
HDD (Software-RAID 1)
Class Enterprise - Connection1 Gbit/s-Port
- Guaranteed Bandwidth1 Gbit/s
- Backup Space100 GB
- Inclusive Traffic50 TB*
I use interspire email marketer to send email but many times each day the mariadb goes down, sometimes i found the smtp (postfix) OFF.
I have many and many problems.
I try this configuration:
my.cnf
[mysqld]
local-infile=0
user=mysql
innodb_buffer_pool_size = 28G
innodb_file_per_table = 1
query_cache_size = 128M
query_cache_limit = 2G
thread_cache_size = 24
innodb_lock_wait_timeout = 100
innodb_flush_log_at_trx_commit=0
table_open_cache = 3072
table_definition_cache = 4096
max_heap_table_size= 64M
tmp_table_size = 64M
max_connections= 3000
max_user_connections = 500
max_allowed_packet = 16M
thread_cache_size = 32
slow_query_log = 1
long_query_time = 1
log_queries_not_using_indexes = 1
min_examined_row_limit = 20
max_allowed_packet = 16M
key_buffer = 512M
sort_buffer_size = 512M
read_buffer = 8M
someone can help me?
