List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:September 10 2011 4:23am
Subject:Re: MySQL daemons restarting every 7 minutes
View as plain text  
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.smith@stripped> 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=sureshkumarilu@stripped<http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Thanks
Suresh Kuna
MySQL DBA

Thread
MySQL daemons restarting every 7 minutesa.smith7 Sep
  • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
    • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
      • Re: MySQL daemons restarting every 7 minutesSuresh Kuna9 Sep
        • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
          • Re: MySQL daemons restarting every 7 minutesReindl Harald9 Sep
            • Re: MySQL daemons restarting every 7 minutesa.smith9 Sep
              • Re: MySQL daemons restarting every 7 minutesSuresh Kuna10 Sep
                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                  • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                      • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                        • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                          • Re: MySQL daemons restarting every 7 minuteswalter harms10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                                • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                            • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
                              • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                  • Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep
                    • Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesa.smith10 Sep
Re: MySQL daemons restarting every 7 minutesReindl Harald10 Sep