We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on Vesta 2.0 and expect to release it by the end of 2024. Read more about it: https://vestacp.com/docs/vesta-2-development
Падает 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