database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL Q&A 31173 게시물 읽기
No. 31173
mariaDB 에러관련 문의 드립니다.
작성자
박환철(mullman)
작성일
2018-05-31 10:47ⓒ
2018-05-31 10:49ⓜ
조회수
4,481

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 % 

 

[Top]
No.
제목
작성자
작성일
조회
31179하나의 Master에서 여러 개의 Slave에 부분적인 database를 replication 하는 방법 [4]
정성철
2018-06-20
3518
31178이런 쿼리도 가능할까요? [1]
이졍재
2018-06-18
3599
31176order by를 사용하지 않고 select 시 정렬 기준이 궁금합니다.
호기심천국
2018-06-15
3503
31173mariaDB 에러관련 문의 드립니다.
박환철
2018-05-31
4481
31170순환SQL을 XML 형태로 출력 [1]
초보
2018-04-23
5066
31168통계data추출시 떨어지는 DB성능.. 같은 서버에서 DataBase를 하나 더 생성하는게 의미가 있을까요?? [1]
궁금타
2018-04-18
4707
31167이런 경우 퍼포먼스를 향상시킬수 있는 방법이 없을까요? [2]
김용식
2018-04-02
4926
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2023 DSN, All rights reserved.
작업시간: 0.051초, 이곳 서비스는
	PostgreSQL v16.1로 자료를 관리합니다