We are happy to announce that Vesta is back under active development as of 25 February 2024. We are working on v1 candidate and expect to engage more with the community over the coming months. We are committed to open source, and we encourage contributors to help us build the future of Vesta.
Падает база данных
Падает база данных
SpoilerShow
160910 10:16:24 mysqld_safe Number of processes running now: 0
160910 10:16:24 mysqld_safe mysqld restarted
160910 10:16:27 [Note] /usr/sbin/mysqld (mysqld 5.5.50-0+deb7u2) starting as process 3329 ...
160910 10:16:27 [Note] Plugin 'FEDERATED' is disabled.
160910 10:16:27 InnoDB: The InnoDB memory heap is disabled
160910 10:16:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160910 10:16:27 InnoDB: Compressed tables use zlib 1.2.7
160910 10:16:27 InnoDB: Using Linux native AIO
160910 10:16:28 InnoDB: Initializing buffer pool, size = 128.0M
160910 10:16:28 InnoDB: Completed initialization of buffer pool
160910 10:16:29 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!
160910 10:16:29 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
Killed
160910 10:16:24 mysqld_safe mysqld restarted
160910 10:16:27 [Note] /usr/sbin/mysqld (mysqld 5.5.50-0+deb7u2) starting as process 3329 ...
160910 10:16:27 [Note] Plugin 'FEDERATED' is disabled.
160910 10:16:27 InnoDB: The InnoDB memory heap is disabled
160910 10:16:27 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160910 10:16:27 InnoDB: Compressed tables use zlib 1.2.7
160910 10:16:27 InnoDB: Using Linux native AIO
160910 10:16:28 InnoDB: Initializing buffer pool, size = 128.0M
160910 10:16:28 InnoDB: Completed initialization of buffer pool
160910 10:16:29 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!
160910 10:16:29 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
Killed
Настройки БД
SpoilerShow
[client]
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
skip-name-resolve
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
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=30
max_user_connections=20
wait_timeout=600
interactive_timeout=50
long_query_time=5
!includedir /etc/mysql/conf.d/
port=3306
socket=/var/run/mysqld/mysqld.sock
[mysqld_safe]
socket=/var/run/mysqld/mysqld.sock
[mysqld]
user=mysql
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/run/mysqld/mysqld.sock
port=3306
basedir=/usr
datadir=/var/lib/mysql
tmpdir=/tmp
lc-messages-dir=/usr/share/mysql
log_error=/var/log/mysql/error.log
symbolic-links=0
skip-name-resolve
skip-external-locking
key_buffer_size = 16K
max_allowed_packet = 1M
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=30
max_user_connections=20
wait_timeout=600
interactive_timeout=50
long_query_time=5
!includedir /etc/mysql/conf.d/
Re: Падает база данных
По моим наблюдениям, опция thread_stack в my.cnf может это вызавать. Если её закомментировать, то дефолтное значение выставится в примерно 256K, если смотреть запрос show variables.
Вообще весь этот конфиг ужат по памяти до ужаса, а вот Innodb выделяется Buffer pool 128.0M. На всякий случас смотри dmesg, /var/log/messages или syslog на наличие ошибок OOM, то есть out of memory killer.
Вообще весь этот конфиг ужат по памяти до ужаса, а вот Innodb выделяется Buffer pool 128.0M. На всякий случас смотри dmesg, /var/log/messages или syslog на наличие ошибок OOM, то есть out of memory killer.