Page 1 of 1

I have some problems with my db

Posted: Fri Apr 01, 2016 10:50 am
by goooooch
I have some problems with my MariaDB. Server stops daily. Logs here. I need help.

Code: Select all

160331 17:57:31 mysqld_safe Number of processes running now: 0
160331 17:57:31 mysqld_safe mysqld restarted
160331 17:57:33 [Note] /usr/libexec/mysqld (mysqld 5.5.44-MariaDB) starting as process 1587 ...
160331 17:57:33 InnoDB: The InnoDB memory heap is disabled
160331 17:57:33 InnoDB: Mutexes and rw_locks use GCC atomic builtins
160331 17:57:33 InnoDB: Compressed tables use zlib 1.2.7
160331 17:57:33 InnoDB: Using Linux native AIO
160331 17:57:33 InnoDB: Initializing buffer pool, size = 128.0M
160331 17:57:33 InnoDB: Completed initialization of buffer pool
160331 17:57:33 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!
160331 17:57:33  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...
160331 17:57:49  InnoDB: Waiting for the background threads to start
160331 17:57:50 Percona XtraDB (http://www.percona.com) 5.5.43-MariaDB-37.2 started; log sequence number 1141797084
160331 17:57:50 [Note] Plugin 'FEEDBACK' is disabled.
160331 17:57:50 [Note] Server socket created on IP: '0.0.0.0'.
160331 17:57:50 [Note] Event Scheduler: Loaded 0 events
160331 17:57:50 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.44-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

Re: I have some problems with my db

Posted: Fri Apr 01, 2016 11:40 am
by skurudo
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
Drop your ib_log files and put innodb_force_recovery=6 in config file
and restart your mysql, it may resolve your problem, but
I think you need tune your mysql settings.

Re: I have some problems with my db

Posted: Fri Apr 01, 2016 12:07 pm
by leisegang
You could try to use this script to find whats wrong. maybe some settings.
https://raw.githubusercontent.com/major ... qltuner.pl