We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically, mysqld gets into a state where we can't query just one
table in all of our DBs--queries just hang. Restarting mysqld always
fixes the problem, but a SIGKILL is required to stop it.
Could this be something is
What does show processlist return when this is happening? Is anything being
logged to the error log?
-Original Message-
From: Brandon Metcalf
To: [EMAIL PROTECTED]
Sent: 5/25/04 2:33 PM
Subject: DB hanging
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically
V == [EMAIL PROTECTED] writes:
V What does show processlist return when this is happening? Is anything being
V logged to the error log?
Nothing in the error log, but here's the output from show processlist:
mysql show processlist;
Brandon Metcalf wrote:
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically, mysqld gets into a state where we can't query just one
table in all of our DBs--queries just hang. Restarting mysqld always
fixes the problem, but a SIGKILL is required to stop it.
Have you
m == [EMAIL PROTECTED] writes:
m Brandon Metcalf wrote:
m We are running 3.23.58 on Solaris 8 and seeing the following problem.
m Periodically, mysqld gets into a state where we can't query just one
m table in all of our DBs--queries just hang. Restarting mysqld always
m fixes the
How big is this table?
Do you run maintenance on this table?
What does the show index for this table look like?
-Original Message-
From: Brandon Metcalf
To: Victor Pendleton
Cc: '[EMAIL PROTECTED] '
Sent: 5/25/04 2:56 PM
Subject: RE: DB hanging
V == [EMAIL PROTECTED] writes:
V What
V == [EMAIL PROTECTED] writes:
V How big is this table?
It has 7325 rows.
V Do you run maintenance on this table?
Not regularly. I just ran myisamchk against it and here's what I got.
I'm not sure if this is useful since there are current connections:
Checking MyISAM file:
Pendleton
Cc: ''[EMAIL PROTECTED] ' '
Sent: 5/25/04 3:35 PM
Subject: RE: DB hanging
V == [EMAIL PROTECTED] writes:
V How big is this table?
It has 7325 rows.
V Do you run maintenance on this table?
Not regularly. I just ran myisamchk against it and here's what I got.
I'm not sure
Brandon Metcalf wrote:
We are running 3.23.58 on Solaris 8 and seeing the following problem.
Periodically, mysqld gets into a state where we can't query just one
table in all of our DBs--queries just hang. Restarting mysqld always
fixes the problem, but a SIGKILL is required to stop it.
Could