mySQL hanging and shutting down.
This happens only every once in a while and I have no clue whats casuing it. The only way I can start it again is If I kill mySQL (even after it is supposedly shutdown) Would blocking all remote access to the mySQL port help?? Is there any way I can get more information on whats going on?
Code:
Number of processes running now: 1 mysqld process hanging, pid 23709 - killed 030619 17:46:10 mysqld restarted 030619 17:46:11 InnoDB: Started 030619 17:46:11 Found an entry in the 'db' table with empty database name; Skipped /usr/libexec/mysqld: ready for connections Number of processes running now: 3 mysqld process hanging, pid 27787 - killed mysqld process hanging, pid 27787 - killed mysqld process hanging, pid 27787 - killed 030619 17:46:12 mysqld restarted 030619 17:46:12 Can't start server: Bind on TCP/IP port: Address already in use 030619 17:46:12 Do you already have another mysqld server running on port: 3306 ? 030619 17:46:12 Aborting 030619 17:46:12 /usr/libexec/mysqld: Shutdown Complete 030619 17:46:12 mysqld ended 030619 19:22:33 mysqld started 030619 19:22:33 Can't start server: Bind on TCP/IP port: Address already in use 030619 19:22:33 Do you already have another mysqld server running on port: 3306 ? 030619 19:22:33 Aborting