Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Language specific forums Russian (Русский) Сервер баз данных
  • Search

Падает MariaDB

Вопросы по работе Сервера баз данных
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
1 post • Page 1 of 1
candybober
Posts: 1
Joined: Wed Apr 25, 2018 12:43 pm

Os: CentOS 6x
Web: nginx + php-fpm
Падает MariaDB
  • Quote

Post by candybober » Wed Apr 25, 2018 12:59 pm

Добрый день!
Подскажите пожалуйста? в чем проблема, 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
Сейчас в весте написано: Процессор: 0.8 Память: 1183 Мб
Несколько минут назад упала, теперь указано так: Процессор: 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
Top


Post Reply
  • Print view
1 post • Page 1 of 1

Return to “Сервер баз данных”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password