List:General Discussion« Previous MessageNext Message »
From:System Administrator a.k.a. The Root of the Problem Date:June 9 2002 7:24pm
Subject:suddenly mysql is up and down
View as plain text  
Since 020606 mysql has been crashing and then I have to manually 
restart.

The error log is below:

020607 00:46:27  mysqld started
/usr/contrib/libexec/mysqld: ready for connections
020607 19:30:58  mysqld restarted
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at  Fri Jun 7 19:31:14 MDT 2002
A mysqld process already exists at  Sat Jun 8 09:00:35 MDT 2002
020608 09:01:30  mysqld started
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020608  9:01:31  Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections

Status information:

Current dir: /usr/contrib/var/
Current locks:
lock: 8a259d4:

lock: 8a5b1d4:

lock: 89e91e0:

lock: 8a1d9d4:

lock: 8a0d1d4:

lock: 8a2e1d4:

lock: 8a039d4:

lock: 8a261d4:

lock: 8a529d4:

lock: 8a32dd4:

lock: 8a739d4:

lock: 8a521d4:

lock: 8a5fdd4:

lock: 8a549d4:

lock: 81e09d4:

lock: 81e1dd4:

lock: 8a731d4:

lock: 8a541d4:

lock: 8a2d9d4:

lock: 8a671d4:

lock: 8a001d4:

lock: 8a311d4:

lock: 8a0a5d4:

lock: 8a359d4:

lock: 89fb9d4:

lock: 8a30de0:

lock: 8a885e0:

lock: 8a151e0:

lock: 89f0de0:

lock: 8a4a9e0:

lock: 8a911e0:

lock: 8a349e0:

lock: 81e01e0:

lock: 8a859e0:

lock: 8a081d4:

lock: 8a8b1d4:

lock: 89fc9d4:

lock: 89fc1d4:

lock: 89e99d4:

lock: 8a5a9d4:

lock: 8a5a1d4:

lock: 8a591d4:

lock: 8a0a9d4:

lock: 8a01dd4:

lock: 8a0a1d4:

lock: 89fe1d4:

lock: 8a689d4:

lock: 8a4e9d4:

lock: 8a8d9d4:

lock: 8a639d4:

lock: 8a459d4:

lock: 8a471d4:

lock: 8a3a9d4:

lock: 8a3d1d4:

lock: 8a7a5d4:

lock: 8a091d4:

lock: 8a3b1d4:

lock: 8a64dd4:

lock: 8a1c5d4:

key_cache status:
blocks used:       990
not flushed:         0
w_requests:       1805
writes:           1704
r_requests:      99548
reads:             973

handler status:
read_key:         2944
read_next:     2843694
read_rnd        340282
read_first:        658
write:         3299360
delete              57
update:            107

Table status:
Opened tables:        510
Open tables:           61
Open files:           120
Open streams:           0
020609 05:28:08  mysqld restarted
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020609  5:28:08  Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at  Sun Jun 9 05:28:27 MDT 2002
020609 13:07:46  mysqld restarted
/usr/contrib/libexec/mysqld: File './doctor.log' not found (Errcode: 13)
020609 13:07:46  Could not use doctor.log for logging (error 0)
/usr/contrib/libexec/mysqld: ready for connections
A mysqld process already exists at  Sun Jun 9 13:10:23 MDT 2002

Questions and fixes needed.  Running mysql  3.23.49

-- 
contact:
Dave Yadallee  NetKnow  The Internet Knowledge Company
root@stripped	 http://www.nl2k.ab.ca
990-3244
Thread
suddenly mysql is up and downSystem Administrator a.k.a. The Root of the Problem9 Jun
  • Re: suddenly mysql is up and downEgor Egorov10 Jun