MySQL Forums
Forum List  »  InnoDB

Posted by: Lee Harper
Date: September 11, 2012 01:50PM

Hi there,

MYSQL keeps crashing and I'm not sure what to do.

From mysqld.log I'm getting this each time I run my multi thread script.

120808 18:49:14 mysqld_safe mysqld restarted
120808 18:49:15 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
120808 18:49:15 [Warning] '--log_slow_queries' is deprecated and will be removed in a future release. Please use ''--slow_query_log'/'--slow_query_log_file'' instead.
120808 18:49:15 [Warning] '--safe-show-database' is deprecated and will be removed in a future release. Please use 'GRANT SHOW DATABASES' instead.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
120808 18:49:17 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...
120808 18:49:20 InnoDB: Started; log sequence number 6 1006139620
120808 18:49:20 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=mysqld-relay-bin' to avoid this problem.
120808 18:49:20 [Note] Event Scheduler: Loaded 0 events
120808 18:49:20 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.52-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
120910 18:21:27 mysqld_safe Number of processes running now: 0

My PHP log is outputting [nativecode=2006 ** MySQL server has gone away]]
I'm also getting the error mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
nativecode=2013 ** Lost connection to MySQL server during query

Thank you for any help, or pointing me in the right direction for troubleshooting!


Options: ReplyQuote

Written By
September 11, 2012 01:50PM
September 12, 2012 08:20PM

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.