Падает MariaDB
-
- Posts: 1
- Joined: Wed Apr 25, 2018 12:43 pm
- Os: CentOS 6x
- Web: nginx + php-fpm
Падает MariaDB
Добрый день!
Подскажите пожалуйста? в чем проблема, mariadb не работает больше 30-40 минут, рестарт происходит сам по себе. И я даже не могу по логам понять в чем причина:
Сейчас в весте написано: Процессор: 0.8 Память: 1183 Мб
Несколько минут назад упала, теперь указано так: Процессор: 1.6 Память: 605 Мб
Конфиг:
Подскажите пожалуйста? в чем проблема, mariadb не работает больше 30-40 минут, рестарт происходит сам по себе. И я даже не могу по логам понять в чем причина:
Code: Select all
180425 18:09:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
180425 18:27:04 mysqld_safe Number of processes running now: 0
180425 18:27:04 mysqld_safe mysqld restarted
180425 18:27:04 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 22471 ...
180425 18:27:04 InnoDB: The InnoDB memory heap is disabled
180425 18:27:04 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180425 18:27:04 InnoDB: Compressed tables use zlib 1.2.7
180425 18:27:04 InnoDB: Using Linux native AIO
180425 18:27:04 InnoDB: Initializing buffer pool, size = 128.0M
180425 18:27:04 InnoDB: Completed initialization of buffer pool
180425 18:27:04 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180425 18:27:04 InnoDB: Waiting for the background threads to start
180425 18:27:05 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 16919764
180425 18:27:06 [Note] Plugin 'FEEDBACK' is disabled.
180425 18:27:06 [Note] Server socket created on IP: '0.0.0.0'.
180425 18:27:06 [Note] Event Scheduler: Loaded 0 events
180425 18:27:06 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
180425 18:28:41 [Warning] IP address '221.229.204.38' could not be resolved: Name or service not known
180425 18:30:02 mysqld_safe Number of processes running now: 0
180425 18:30:02 mysqld_safe mysqld restarted
180425 18:30:02 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 29988 ...
180425 18:30:02 InnoDB: The InnoDB memory heap is disabled
180425 18:30:02 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180425 18:30:02 InnoDB: Compressed tables use zlib 1.2.7
180425 18:30:02 InnoDB: Using Linux native AIO
180425 18:30:02 InnoDB: Initializing buffer pool, size = 128.0M
180425 18:30:03 InnoDB: Completed initialization of buffer pool
180425 18:30:03 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
180425 18:30:03 InnoDB: Waiting for the background threads to start
180425 18:30:04 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 16919774
180425 18:30:04 [Note] Plugin 'FEEDBACK' is disabled.
180425 18:30:04 [Note] Server socket created on IP: '0.0.0.0'.
180425 18:30:04 [Note] Event Scheduler: Loaded 0 events
180425 18:30:04 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
180425 18:31:02 [ERROR] mysqld: Table './admin_default/oc_cron' is marked as crashed and should be repaired
180425 18:31:02 [Warning] Checking table: './admin_default/oc_cron'
180425 18:31:24 [Warning] IP address '111.73.46.80' could not be resolved: Name or service not known
Несколько минут назад упала, теперь указано так: Процессор: 1.6 Память: 605 Мб
Конфиг:
Code: Select all
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
symbolic-links=0
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 50M
table_open_cache = 4
sort_buffer_size = 64K
read_buffer_size = 256K
read_rnd_buffer_size = 256K
net_buffer_length = 2K
thread_stack = 240K
#innodb_use_native_aio = 0
innodb_file_per_table
max_connections=70
max_user_connections=70
wait_timeout=120
interactive_timeout=120
long_query_time=5
#slow_query_log=1
#slow_query_log_file=/var/log/mysql-slow-queries.log
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d