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.
I'm using MyISAM tables. When I wrote this application InnoDB wasn't
even an option :-).
I don't think it's hung queries, because even new queries that I know
are very fast fail. Heck, I can't even attach to the DB except through
the admin interface (mysqladmin).
Unless you're saying that the hung queries are using up the
processes/threads in the DB so that new queries can't get through?
Thanks for the response...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
