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
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, misconfigured
Hello,
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.
I looked for any error message in the file
/usr/local/mysql/hostname.err, but I couldn´t see any error
message about such time.
Does anyone knows what
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
11 matches
Mail list logo