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?
Unfortunate
%% 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 tim
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> 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 serve
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.
%% 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 quer
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).
"Ronan Lucio" <[EMAIL PROTECTED]> wrote:
> I had a problem with our MySQL server-4.0.18 where
> it suddenly stoped working.
> Even a KILL command didn´t killed the mysqld process.
Use brute force - kill -9.
> Does anyone knows what could make MySQL hangs?
Improper build, wrong hardware, miscon
Back in 3.23.x we used to see MySQL hang on a corrupt table (typically
caused by an improper shutdown). A kill -9 was needed to stop the
process, upon restart we'd run a mysqlcheck (MyISAM tables) and repair
the table. We didn't see anything obvious in the logs except the last
query, which was
