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 this
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 w
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: /home/cmvobad
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:
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
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 t
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;
+-+--++---
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,
