Anybody can tell me about way which will force the mysqld write more
information into logs (.err file)?
My mysqld restarted every 20-30 minutes without reasonable info in log
file and I dont understand why it occurs.
I see only string "mysqld restarted" and nothing more! :(
Example of log:
090417 16:34:14 InnoDB: Started; log sequence number 0 73771
090417 16:34:14 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.0.77-log' socket: '/tmp/mysql.sock' port: 3306 FreeBSD
090417 16:34:14 [Note] Slave SQL thread initialized, starting
replication in log 'mysql-bin.000576' at position 530085643, relay log
'./beta23-relay-bin.000174' position: 93504
090417 16:34:14 [Note] Slave I/O thread: connected to master
'beta23@stripped:3306', replication started in log
'mysql-bin.000576' at position 530085643
090417 16:39:38 mysqld restarted
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
090417 16:39:39 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
090417 16:39:39 InnoDB: Started; log sequence number 0 73781