List:General Discussion« Previous MessageNext Message »
From:BAUMEISTER Alexandre Date:March 11 2000 4:06pm
Subject:Re[4]: Locked tables while "Sending data" !?
View as plain text  
Bonjour Michael,

Tim>> On Fri, Mar 10, 2000 at 05:04:09PM -0500, Thimble Smith wrote:
>>> 
>>> >Can you, or anyone else from TcX, comment more constructively on the
>>> >last two paragraphs of my previous message?
>>> 
>>> I don't know what the answer is, because I don't know that code
>>> well enough.  It seems like the server should be able to copy from
>>> a temporary results table to the client and unlock the tables used
>>> in the query.  It would be nice to be able to force this to happen,
>>> either in the SQL statement or with a connection flag (or both).
>>> 
>>> >Also, Alexandre has just observed that the problem does not appear to
>>> >be resolved by adding an ORDER BY. That doesn't match your explanation
>>> >of the cause of the problem.
>>> >
>>> >I believe that there is a serious concurrency issue here that needs
>>> >addressing, not dismissing.
>>> 
>>> I will look into it, and find out what it would take to make this
>>> happen (or, maybe find out why it isn't happening and give a full
>>> account).

Tim>> Thank you. Much appreciated.

Tim>> Tim.

MW> A last note about this thread:

MW> It would be trivial to add a new flag that will force creation of
MW> temporary sets on file.

MW> Thimbley should be able to do this for MySQL 3.23.14 :)


   And  it would be great if instead of using a temporary table on the
   hard  disk  (slow)  a memory buffer would be use if SMALL_RESULT is
   notified in the query.

   Regards,
   Alex.


Thread
Interbase vs. mySQL Opinions WantedJSC-OA)7 Mar
  • Locked tables while "Sending data" !?BAUMEISTER Alexandre8 Mar
    • Re: Locked tables while "Sending data" !?sinisa9 Mar
      • Re: Locked tables while "Sending data" !?Tim Bunce9 Mar
      • Re[2]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
        • Re: Re[2]: Locked tables while "Sending data" !?sinisa10 Mar
          • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce10 Mar
            • Re: Re[2]: Locked tables while "Sending data" !?sinisa10 Mar
              • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
                • Re: Re[4]: Locked tables while "Sending data" !?sinisa10 Mar
              • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce10 Mar
                • Re: Re[2]: Locked tables while "Sending data" !?Thimble Smith11 Mar
                  • Re: Re[2]: Locked tables while "Sending data" !?Tim Bunce11 Mar
                    • Re: Re[2]: Locked tables while "Sending data" !?Michael Widenius11 Mar
                      • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre11 Mar
                        • Re[4]: Locked tables while "Sending data" !?Michael Widenius12 Mar
                          • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                            • Re: Locked tables while "Sending data" !?Michael Widenius13 Mar
                              • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                                • Re: Locked tables while "Sending data" !?Michael Widenius13 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce13 Mar
                                • Re: Locked tables while "Sending data" !?Michael Widenius14 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce14 Mar
                                  • Re: Locked tables while "Sending data" !?Tim Bunce24 Apr
                                    • Re: Locked tables while "Sending data" !?Michael Widenius26 Apr
                                      • Re: Locked tables while "Sending data" !?Tim Bunce26 Apr
                                        • Re: Locked tables while "Sending data" !?Michael Widenius27 Apr
                    • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre11 Mar
            • Re[4]: Locked tables while "Sending data" !?BAUMEISTER Alexandre10 Mar
              • Re[4]: Locked tables while "Sending data" !?Michael Widenius11 Mar