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
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;
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
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:
[EMAIL PROTECTED] writes:
^^ Oh forgot to ask in the last post, how are you setting the password in the
^^ first place? Are you using a grant statement or inserting values into the
^^ table. I reckon the former is better (and safer) but if you're doing the
^^ later the you need to flush
Okay, I'm obviously missing something here. Even though the
submit_write user has a password set according to the SELECT output
below, I can't use that password or any password to login as this user.
Only a null password is accepted. The first attempt I enter the correct
password; no go. The