Metadata Locking issue

Hi, I have a question about Metadata Locking. The short story is that I have a magento installation. It ran on a mysql 5.1.41 (ubuntu). It was crashing every now and then. (when trying to insert or delete from certain tables that ware running sone DDL statements like truncate and alter table)

Locking issue with MyISAM on Solaris 10

Hi! Nowadays we've conducted something what I can call extended testing of MySQL on Solaris10/x86. The most annoying issue is a problem with locking queries to MyISAM-type tables. Mechanism seems to be simple to explain - long running query locks table for READ, next there is some DML query wh

Re: Locking Issue

The first thing I would do is to upgrade the Kernel, as per you r mail u said u were running 2.4.20-8, get the latest one for RH9 that is 2.4.20-31.9 SMP, and you might see a huge difference, if it doesn't work, then make sure you have properly indexed the colums, mytop is a great tool for diagnos

Re: Locking Issue

Hello. Use SHOW PROCESSLIST and slow-query log to catch the query which locks tables for a long time. Upgrade to 4.1.13. If you use MyISAM, think about moving towards InnoDB. Aaron <[EMAIL PROTECTED]> wrote: > Hi all , > > I have been experiencing intermittent locking issues with MY

Locking Issue

Hi all , I have been experiencing intermittent locking issues with MYSQL. It appears that sometimes a query will lock reliease its lock, and is causing other queries to wait and wait until the connection limit is reached and i am locked out of the database. Has anyone ever had anything like t

Re: Locking Issue?

Heikki, - Original Message - > Terry, > > - Original Message - > From: "Terry Riley" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Monday, December 06, 2004 8:15 PM > Subject: Locking Issue? > > > > Can so

Re: Locking Issue?

Terry, - Original Message - From: "Terry Riley" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Monday, December 06, 2004 8:15 PM Subject: Locking Issue? Can someone help, please? We set up a server to handle a coldfusion web application (CFMX 6.1) runni

RE: Locking Issue?

- Original Message - Thanks for those hints, Dathan (see below): > > -Original Message- > From: Terry Riley [mailto:[EMAIL PROTECTED] > Sent: Monday, December 06, 2004 10:12 AM > To: [EMAIL PROTECTED] > Subject: Locking Issue? > > Can someone help,

RE: Locking Issue?

-Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: Monday, December 06, 2004 10:12 AM To: [EMAIL PROTECTED] Subject: Locking Issue? Can someone help, please? We set up a server to handle a coldfusion web application (CFMX 6.1) running against MySQL 4.1.3b-beta on

Locking Issue?

s happens, the other requests to the server are inevitably slow, and these seem never to be cleared unless I kill the threads - and I'm not 100% sure how much damage I'm doing in that action. Is this a possible locking issue? If so, how do I get around it. The settings for the server are

Re: InnoDB Table Locking Issue

Thanks for the message. I should rephrase - the data set is millions of rows, but the tables are indexed, and an EXPLAIN looks like it is using indexes effectively. The query produces the exact same results both times (with and without LOCKing). Is there a reason that by calling the query vi

Re: InnoDB Table Locking Issue

On Tue, 27 Apr 2004, Scott Switzer wrote: > Hi, > > I am having a difficult time with a query. My environment is MySQL > v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel). > Basically, I am running a query of the form: > > INSERT INTO temp_tbl > SELECT c1,c2... > FROM t1,t2,t3,t4 > WHE

InnoDB Table Locking Issue

Hi, I am having a difficult time with a query. My environment is MySQL v4.0.16 (InnoDB tables) running on Linux (latest 2.4 kernel). Basically, I am running a query of the form: INSERT INTO temp_tbl SELECT c1,c2... FROM t1,t2,t3,t4 WHERE ... It is a very complex query, which looks at millions

SELECT/UPDATE and locking issue

ECT]); UNLOCK TABLES; Then I loop through the ids, performing various actions and updating b with the result. There's obviously something wrong here, because now that our volume has ramped up, I'm seeing what looks to be a locking issue. After the UNLOCK, I do a sanity check, compa

Odd Table locking issue

If you've read my last email, you know what the problem is, but I have now pinpointed it a bit further using the processlist feature. [EMAIL PROTECTED] MBPlatforms]# mysqladmin -v processlist -p Enter password: +-+--+---+-+-+--++-

RE: Row Locking issue in 3.23.x

use InnoDB which does support row-locking (MySQL-Max) -Original Message- From: Sherzod B. Ruzmetov [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 14, 2002 9:23 AM To: [EMAIL PROTECTED]; MySQL Maling list Subject: Row Locking issue in 3.23.x Hi. As far as I know, MySQL doesn't s

Row Locking issue in 3.23.x

Hi. As far as I know, MySQL doesn't suport row-locking, only table locking is available. But I figured table locking for sessions table of CGI::Session::MySQL would be quite inefficient, for there might be millions of rows and hundreds of them could be active at any time. So what do you guys