Hi all;
I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2
version downloaded from Mysql.com). The system is a Ultra-250 server
with multiple CPUs and 2G RAM. There are many databases but they're not
large and the load on the system is not high at all. We're using this
older
Hello.
Very often similar symptoms causes various lock problems. Do you use
InnoDB? Try log_slow_queries to find hung queries.
Paul Smith [EMAIL PROTECTED] wrote:
Hi all;
I have a Mysql 3.2.58 server running on Solaris 8 (the latest 3.2
version downloaded from Mysql.com). The
%% Gleb Paharenko [EMAIL PROTECTED] writes:
gp Very often similar symptoms causes various lock problems. Do you
gp use InnoDB? Try log_slow_queries to find hung queries.
I'm using MyISAM tables. When I wrote this application InnoDB wasn't
even an option :-).
I don't think it's hung
When the database is in a `hung` state, is the file system where the
MYI, MYD and frm files accessible?
Paul Smith wrote:
%% Gleb Paharenko [EMAIL PROTECTED] writes:
gp Very often similar symptoms causes various lock problems. Do you
gp use InnoDB? Try log_slow_queries to find hung queries.
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp When the database is in a `hung` state, is the file system where
vp the MYI, MYD and frm files accessible?
Definitely. I can log in, see the files, run the mysqladmin commands,
etc. The databases live on the local disk, not a remote server
What state are the queries in while they are hung? What command or SQL
are they executing?
Paul Smith wrote:
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp When the database is in a `hung` state, is the file system where
vp the MYI, MYD and frm files accessible?
Definitely. I can log in,
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp What state are the queries in while they are hung? What command or
vp SQL are they executing?
Unfortunately I lost the output of the processlist command. Whenever
the server hangs it's always a crazy race to get it back up again.
Next time
Understandable. The state, command and info values from `show
processlist` could shed some light on what is occurring.
Paul Smith wrote:
%% Victor Pendleton [EMAIL PROTECTED] writes:
vp What state are the queries in while they are hung? What command or
vp SQL are they executing?
Unfortunately