can you check for any table crashes in the db by using mysqlcheck. and enable the general log for the database.
On Fri, Sep 9, 2011 at 10:37 PM, <a.sm...@ukgrid.net> wrote: > No need for that really is there? I posted what was requested. > The part for the shutdown: > > 110909 17:27:31 InnoDB: Starting shutdown... > 110909 17:27:32 InnoDB: Shutdown completed; log sequence number 1589339 > 110909 17:27:32 [Note] /usr/local/libexec/mysqld: Shutdown complete > > 110909 17:27:32 mysqld_safe mysqld from pid file /var/db/mysql/tau.pid > ended > > 110909 17:27:35 mysqld_safe Starting mysqld daemon with databases from > /var/db/mysql > 110909 17:27:35 InnoDB: The InnoDB memory heap is disabled > 110909 17:27:35 InnoDB: Mutexes and rw_locks use GCC atomic builtins > 110909 17:27:35 InnoDB: Compressed tables use zlib 1.2.3 > 110909 17:27:35 InnoDB: Initializing buffer pool, size = 2.0G > 110909 17:27:36 InnoDB: Completed initialization of buffer pool > 110909 17:27:36 InnoDB: highest supported file format is Barracuda. > 110909 17:27:36 InnoDB: Waiting for the background threads to start > 110909 17:27:37 InnoDB: 1.1.8 started; log sequence number 1589339 > 110909 17:27:37 [Note] Slave SQL thread initialized, starting replication > in log 'mysql-bin.002830' at position 293541, relay log > './tau-relay-bin.000920' position: 253 > 110909 17:27:37 [Note] Event Scheduler: Loaded 0 events > 110909 17:27:37 [Note] /usr/local/libexec/mysqld: ready for connections. > Version: '5.5.15' socket: '/tmp/mysql.sock' port: 3306 Source > distribution > 110909 17:27:37 [Note] Slave I/O thread: connected to master > 'slave_user@kappa:3306',**replication started in log 'mysql-bin.002830' at > position 293541 > > > > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?** > unsub=sureshkumar...@gmail.com<http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com> > > -- Thanks Suresh Kuna MySQL DBA