List:General Discussion« Previous MessageNext Message »
From:Ramesh G Date:May 13 2005 5:35am
Subject:Read past Equivalent in MySQL
View as plain text  
Hi All,

Is there a way by which I can tell the Mysql to ignore the rows that are  
locked by someone else and take the next available record. The problem is,  
I have a Query like this:

Select * from Table1 where Fld1=2 FOR UPDATE Limit 1

I will have multiple clients running this same query with the same where  
clause. For the second instance of the query mysql seems to wait till the  
transaction of the first instance gets completed. This makes this query  
slow as the time taken for the transaction to complete is somewhere  
between 1 and 1.5 seconds.

Regards,
Ramesh G

Thread
Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLmfatene13 May
    • Re: Read past Equivalent in MySQLmfatene13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLmfatene13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLRamesh G13 May
      • Re: Read past Equivalent in MySQLDuncan Hill13 May
  • Re: Read past Equivalent in MySQLMartijn Tonies13 May
    • Re: Read past Equivalent in MySQLEric Bergen13 May
      • Re: Read past Equivalent in MySQLDuncan Hill13 May
        • RE: Read past Equivalent in MySQLGordon13 May
          • Re: Read past Equivalent in MySQLDuncan Hill14 May
            • Re: Read past Equivalent in MySQLmfatene14 May