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
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
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;
+-+--++---
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 corru
[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 privli
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 se
