Can yo paste the complete error log, Ram memory size and configuration file
here and make sure the machine has enough memory to run the services.
Check the sys log for what is happening just before the service restart.
On Wed, Sep 7, 2011 at 10:51 PM, <a.smith@stripped> wrote:
> as of yesterday the MySQL Daemons keep restarting every 7 mins or so on
> one of my FreeBSD servers. The only work carried out recently related to
> MySQL on this server was to temporarily disable replication (its a slave) of
> one DB, and then re-enable it (via restore of data and updating the log file
> and pos).
> Now I keep seeing this:
> 110907 18:03:58 mysqld_safe mysqld restarted
> 110907 18:03:58 [Note] Plugin 'FEDERATED' is disabled.
> 110907 18:03:58 InnoDB: Initializing buffer pool, size = 2.0G
> 110907 18:03:59 InnoDB: Completed initialization of buffer pool
> 110907 18:03:59 InnoDB: Started; log sequence number 0 44233
> 110907 18:03:59 [Note] Event Scheduler: Loaded 0 events
> 110907 18:03:59 [Note] Slave SQL thread initialized, starting replication
> in log 'mysql-bin.002818' at position 46048, relay log
> './tau-relay-bin.000037' position: 251
> 110907 18:03:59 [Note] /usr/local/libexec/mysqld: ready for connections.
> Version: '5.1.58' socket: '/tmp/mysql.sock' port: 3306 FreeBSD port:
> 110907 18:03:59 [Note] Slave I/O thread: connected to master
> started in log 'mysql-bin.002818' at position 46048
> Not seeing any other info, such as why the daemons stopped, just this
> repeated over and over...
> I didn't find much useful info searching on the internet, came up with
> but its an unresolved bug.
> I have tried, restoring all DBs from a working server and that didn't work.
> So wouldnt seem to be related to the contents of the databases.
> System is FreeBSD 8.2 amd64, MySQL 5.1.58 (I upgrade this from 5.1.51 as a
> try and fix it quick approach but no joy).
> Any one chip in from experience what this may be?? I'm considering
> upgrading to 5.5 to give that a try...
> thanks in advance,
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?**