MySQL Forums
Forum List  »  Italian

Mysql Crash
Posted by: Simone Cigni
Date: May 03, 2017 06:32AM

Salve, Ho un Mysql 5.6.
Ogni tanto trovo che รจ andato in crash.
Facendolo semplicemente ripartire con "service mysqld start" riparte e funziona sibo a che non muore di nuovo.
Nel /var/log/mysqld.log trovo:
170502 22:49:36 mysqld_safe Number of processes running now: 0
170502 22:49:36 mysqld_safe mysqld restarted
2017-05-02 22:50:31 0 [Warning] TIMESTAMP with implicit DEFAULT value is depreca ted. Please use --explicit_defaults_for_timestamp server option (see documentati on for more details).
2017-05-02 22:50:32 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as proces s 6138 ...
2017-05-02 22:50:39 6138 [Note] Plugin 'FEDERATED' is disabled.
2017-05-02 22:50:39 6138 [Note] InnoDB: Using atomics to ref count buffer pool p ages
2017-05-02 22:50:39 6138 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-02 22:50:39 6138 [Note] InnoDB: Mutexes and rw_locks use GCC atomic buil tins
2017-05-02 22:50:39 6138 [Note] InnoDB: Memory barrier is not used
2017-05-02 22:50:39 6138 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-02 22:50:39 6138 [Note] InnoDB: Using Linux native AIO
2017-05-02 22:50:39 6138 [Note] InnoDB: Not using CPU crc32 instructions
2017-05-02 22:50:40 6138 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2017-05-02 22:50:40 6138 [Note] InnoDB: Completed initialization of buffer pool
2017-05-02 22:50:40 6138 [Note] InnoDB: Highest supported file format is Barracu da.
2017-05-02 22:50:40 6138 [Note] InnoDB: The log sequence numbers 43916007 and 43 916007 in ibdata files do not match the log sequence number 414447313 in the ib_ logfiles!
2017-05-02 22:50:40 6138 [Note] InnoDB: Database was not shutdown normally!
2017-05-02 22:50:40 6138 [Note] InnoDB: Starting crash recovery.
2017-05-02 22:50:40 6138 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-05-02 22:50:46 6138 [Note] InnoDB: Restoring possible half-written data pag es
2017-05-02 22:50:46 6138 [Note] InnoDB: from the doublewrite buffer...
170502 22:50:48 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
-------------------

Qualcuno sa aiutarmi?

Grazie

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Crash
666
May 03, 2017 06:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.