2~3달에 한번 signal11이 발생하면서 DB가 죽는 현상이 있어 문의 드립니다.
wordpress와 php로 구성한 사내 홈페이지용 DB서버입니다.
웹서버는 2대로 구성되어 있고 DB서버는 1대인 구성입니다.
에러내용
=========================================================================================
180530 16:21:23 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.
Server version: 10.1.14-MariaDB
key_buffer_size=4294967296
read_buffer_size=2097152
max_used_connections=57
max_threads=514
thread_count=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 6310156 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48400
2018-05-30 16:35:43 140641065323264 [Note] /usr/local/mariadb/bin/mysqld: Normal shutdown
2018-05-30 16:35:43 140641065323264 [Note] Event Scheduler: Purging the queue. 0 events
2018-05-30 16:36:03 140641065323264 [Warning] /usr/local/mariadb/bin/mysqld: Forcing close of thread 343525 user: 'wordpress'
===========================================================================================
1. 서버사양
HP DL360 G9
CPU : Xeon 2.6GHz 1 socket(8core)
RAM : 32GB(16*2)
HDD : SAS 600GB * 4
OS : CentOS 6.8 64bit
2. my.cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /MariaDB/data
#datadir = /MariaDB/data_21803011_bak
key_buffer_size=4096M
max_allowed_packet=64M
table_open_cache=4096
table_definition_cache=400
sort_buffer_size=2M
read_buffer_size=2M
thread_cache_size=32
#thread_concurrency=8
myisam_sort_buffer_size=32M
max_connections=512
wait_timeout=60
long_query_time=5
query_cache_size=256M
open_files_limit=32000
character_set_client_handshake = FALSE
character_set_server=utf8
init_connect = "set names utf8"
skip_name_resolve
skip_external_locking
default_storage_engine=aria
local_infile=0
explicit_defaults_for_timestamp = 1
# load file security
#secure_file_priv=/var/tmp
slow_query_log = 1
slow_query_log_file = /MariaDB/logs/slow.log
log_error = /MariaDB/logs/error.log
######### Aria BEGIN ###################################################
aria_pagecache_buffer_size=256M
aria_sort_buffer_size=256M
######### Aria END #####################################################
######### InnoDB BEGIN #################################################
# Uncomment the following if you are using InnoDB tables
innodb=1 # 0:not use innodb, 1:use innodb
innodb_status_file=1
innodb_file_per_table=1
innodb_data_home_dir = /MariaDB/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /MariaDB/data
#innodb_log_arch_dir = /MariaDB/data
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 10G
innodb_buffer_pool_instances=8
innodb_file_io_threads = 4
innodb_thread_concurrency = 10
innodb_flush_log_at_trx_commit = 1
sync_binlog = 1
innodb_log_files_in_group=4
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size=64M
innodb_log_buffer_size=8M
innodb_lock_wait_timeout=120
[mysqld]
port = 3306
socket = /tmp/mysql.sock
datadir = /MariaDB/data
#datadir = /MariaDB/data_21803011_bak
key_buffer_size=4096M
max_allowed_packet=64M
table_open_cache=4096
table_definition_cache=400
sort_buffer_size=2M
read_buffer_size=2M
thread_cache_size=32
#thread_concurrency=8
myisam_sort_buffer_size=32M
max_connections=512
wait_timeout=60
long_query_time=5
query_cache_size=256M
open_files_limit=32000
character_set_client_handshake = FALSE
character_set_server=utf8
init_connect = "set names utf8"
skip_name_resolve
skip_external_locking
default_storage_engine=aria
local_infile=0
explicit_defaults_for_timestamp = 1
# load file security
#secure_file_priv=/var/tmp
slow_query_log = 1
slow_query_log_file = /MariaDB/logs/slow.log
log_error = /MariaDB/logs/error.log
######### Aria BEGIN ###################################################
aria_pagecache_buffer_size=256M
aria_sort_buffer_size=256M
######### Aria END #####################################################
######### InnoDB BEGIN #################################################
# Uncomment the following if you are using InnoDB tables
innodb=1 # 0:not use innodb, 1:use innodb
innodb_status_file=1
innodb_file_per_table=1
innodb_data_home_dir = /MariaDB/data
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /MariaDB/data
#innodb_log_arch_dir = /MariaDB/data
# You can set .._buffer_pool_size up to 50 - 80 %
|