30 messages in com.mysql.lists.mysqlRe[4]: Locked tables while "Sending d...| From | Sent On | Attachments |
|---|---|---|
| PHILLIPS, CORY H. (JSC-OA) | 07 Mar 2000 08:48 | |
| BAUMEISTER Alexandre | 08 Mar 2000 10:33 | |
| sin...@mysql.com | 09 Mar 2000 05:14 | |
| Tim Bunce | 09 Mar 2000 05:45 | |
| BAUMEISTER Alexandre | 10 Mar 2000 06:11 | |
| sin...@mysql.com | 10 Mar 2000 07:20 | |
| Tim Bunce | 10 Mar 2000 08:48 | |
| sin...@mysql.com | 10 Mar 2000 09:56 | |
| BAUMEISTER Alexandre | 10 Mar 2000 10:05 | |
| BAUMEISTER Alexandre | 10 Mar 2000 10:09 | |
| sin...@mysql.com | 10 Mar 2000 10:20 | |
| Tim Bunce | 10 Mar 2000 11:53 | |
| Thimble Smith | 10 Mar 2000 14:03 | |
| Tim Bunce | 10 Mar 2000 17:08 | |
| Michael Widenius | 11 Mar 2000 03:43 | |
| Michael Widenius | 11 Mar 2000 03:44 | |
| BAUMEISTER Alexandre | 11 Mar 2000 08:01 | |
| BAUMEISTER Alexandre | 11 Mar 2000 08:05 | |
| Michael Widenius | 11 Mar 2000 14:59 | |
| Tim Bunce | 12 Mar 2000 13:14 | |
| Michael Widenius | 12 Mar 2000 15:12 | |
| Tim Bunce | 13 Mar 2000 01:41 | |
| Michael Widenius | 13 Mar 2000 07:35 | |
| Tim Bunce | 13 Mar 2000 08:02 | |
| Michael Widenius | 13 Mar 2000 16:33 | |
| Tim Bunce | 14 Mar 2000 03:49 | |
| Tim Bunce | 24 Apr 2000 10:15 | |
| Michael Widenius | 25 Apr 2000 19:21 | |
| Tim Bunce | 26 Apr 2000 03:47 | |
| Michael Widenius | 26 Apr 2000 18:08 |
| Subject: | Re[4]: Locked tables while "Sending data" !? |
|---|---|
| From: | Michael Widenius (mon...@monty.pp.sci.fi) |
| Date: | 03/11/2000 02:59:28 PM |
| List: | com.mysql.lists.mysql |
"BAUMEISTER" == BAUMEISTER Alexandre <al...@finance-net.com> writes:
BAUMEISTER> 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 :)
BAUMEISTER> And it would be great if instead of using a temporary table on the BAUMEISTER> hard disk (slow) a memory buffer would be use if SMALL_RESULT is BAUMEISTER> notified in the query.
This will of course be the default.
Regards, Monty