This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

MySQL server (mariadb) auto shutdown without overload
#1
MySQL server (mariadb) auto shutdown without overload
Hi there

I have this issue several days, MySQL server automatically shut down, while watched via DO Graph monitoring, I realized seem it shut down every time CPU overloaded (>100%).

Then I tried making :
 - some MySQL server optimizations in etc/my.cnf; convert to innodb, accept localhost only, cache configs, etc
 - turn off all sites in server, leave 1 WordPress site only

After restarting Mariadb server, seem everything is okay, I tested for a while, it works normally. But then when I'm offline about 1 hour, now it shuts down again but all loads are normal, seems this issue does not involve to overload?

Please help me for this, currently I'm on mobile, show can't show log, anyone face this problem?

--- updated ---
and may tell me what is process crypto with top command? thanks

here's full log from /var/log/mariadb/mariadb.log since last crash
PHP Code:
180918 10:02:50 mysqld_safe Number of processes running now0
180918 10
:02:50 mysqld_safe mysqld restarted
180918 10
:02:50 InnoDBThe InnoDB memory heap is disabled
180918 10
:02:50 InnoDBMutexes and rw_locks use GCC atomic builtins
180918 10
:02:50 InnoDBCompressed tables use zlib 1.2.7
180918 10
:02:50 InnoDBUsing Linux native AIO
180918 10
:02:50 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDBstarting as process 32632 ...
180918 10:02:50 InnoDBInitializing buffer poolsize 800.0M
InnoDB
mmap(860979200 bytesfailederrno 12
180918 10
:02:50 InnoDBCompleted initialization of buffer pool
180918 10
:02:50 InnoDBFatal errorcannot allocate memory for the buffer pool
180918 10
:02:50 [ERRORPlugin 'InnoDB' init function returned error.
180918 10:02:50 [ERRORPlugin 'InnoDB' registration as a STORAGE ENGINE failed.
180918 10:02:50 [NotePlugin 'FEEDBACK' is disabled.
180918 10:02:50 [ERRORUnknown/unsupported storage engineInnoDB
180918 10
:02:50 [ERRORAborting

180918 10
:02:50 [Note] /usr/libexec/mysqldShutdown complete

180918 10
:02:50 mysqld_safe mysqld from pid file /var/run/mariadb/mariadb.pid ended
180918 10
:10:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
180918 10
:10:07 InnoDBThe InnoDB memory heap is disabled
180918 10
:10:07 InnoDBMutexes and rw_locks use GCC atomic builtins
180918 10
:10:07 InnoDBCompressed tables use zlib 1.2.7
180918 10
:10:07 InnoDBUsing Linux native AIO
180918 10
:10:07 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDBstarting as process 1625 ...
180918 10:10:07 InnoDBInitializing buffer poolsize 800.0M
180918 10
:10:08 InnoDBCompleted initialization of buffer pool
180918 10
:10:08 InnoDBhighest supported file format is Barracuda.
180918 10:10:08  InnoDBStarting crash recovery from checkpoint LSN=698432796
InnoDB
Restoring possible half-written data pages from the doublewrite buffer...
180918 10:10:08  InnoDBStarting final batch to recover 2 pages from redo log
180918 10
:10:09  InnoDBWaiting for the background threads to start
180918 10
:10:10 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence nu$
180918 10:10:10 [NotePlugin 'FEEDBACK' is disabled.
180918 10:10:10 [NoteServer socket created on IP'127.0.0.1'.
180918 10:10:10 [Warning'proxies_priv' entry '@ root@sentora.mydomain.com' ignored in --skip-name$
180918 10:10:10 [NoteEvent SchedulerLoaded 0 events
180918 10
:10:10 [Note] /usr/libexec/mysqldready for connections.
Version'5.5.56-MariaDB'  socket'/var/lib/mysql/mysql.sock'  port3306  MariaDB Server
180918 11
:19:10 mysqld_safe Number of processes running now0
180918 11
:19:10 mysqld_safe mysqld restarted
180918 11
:19:10 InnoDBThe InnoDB memory heap is disabled
180918 11
:19:10 InnoDBMutexes and rw_locks use GCC atomic builtins
180918 11
:19:10 InnoDBCompressed tables use zlib 1.2.7
180918 11
:19:10 InnoDBUsing Linux native AIO
180918 11
:19:10 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDBstarting as process 3017 ...
180918 11:19:10 InnoDBInitializing buffer poolsize 800.0M
InnoDB
mmap(860979200 bytesfailederrno 12
180918 11
:19:10 InnoDBCompleted initialization of buffer pool 

and here are optimizations I made in /etc/my.cnf
PHP Code:
[mysqld]
# custom
bind-address 127.0.0.1

skip
-name-resolve
skip
-external-locking

key_buffer_size 
32K
max_allowed_packet 
4M
table_open_cache 
8
sort_buffer_size 
128K
read_buffer_size 
512K
read_rnd_buffer_size 
512K
net_buffer_length 
4K
thread_stack 
480K
thread_cache_size 
8

innodb_file_per_table
=1
max_connections 
100
max_user_connections
=50
wait_timeout
=50
interactive_timeout
=50
long_query_time
=5

query_cache_type 
1
query_cache_limit
=1M
query_cache_min_res_unit 
2k
query_cache_size
=32M ## 32MB for every 1GB of RAM

tmp_table_size64M
max_heap_table_size
64M

log_error 
= /var/log/mariadb/error.log
expire_logs_days    
5
max_binlog_size   
100M
innodb_buffer_pool_size
=800M
innodb_buffer_pool_instances 


here's top command
[Image: attachment.php?aid=764]


Attached Files Thumbnail(s)
       
Reply
Thanks given by:
#2
RE: MySQL server (mariadb) auto shutdown without overload
Did you install any third-party items?

I can see here in your log this:
180918 10:10:10 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence nu$
'' Life is full of important choices ''
Help Sentora Donate now => http://sentora.org/donate Blush
Reply
Thanks given by:


Possibly Related Threads…
Thread Author Replies Views Last Post
Server Crash rsthomas 3 8 ,002 05-18-2022, 09:26 AM
Last Post: Nigel
Server Vs. Workstation zHostingSolutions 4 9 ,242 09-14-2021, 06:30 AM
Last Post: sparkrack
MySQL Database user prefix MosleyCale 1 5 ,621 10-17-2020, 09:11 PM
Last Post: Ron-e

Forum Jump:


Users browsing this thread: 1 Guest(s)