>Description:
When running a select that will take a long time due to the "order by" at the
end mysql still keeps the table locked during the ordering.
After it gets the result set is should unlock the table during the ordering
phase
>How-To-Repeat:
Issue a select with an order by (or multiple order by's) and issue an update
to that table. Notice that the update doesn't go through until the query is completly
done with it's ordering.
>Fix:
code fix?
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
RightNow Technologies
>MySQL support: [ extended email support ]
>Synopsis: <order by keeps tables locked>
>Severity:
>Priority:
>Category: mysql
>Class:
>Release: mysql-3.23.47 (Source distribution)
>Environment:
System: Linux dbsc01.rightnowtech.com 2.4.17 #2 SMP Fri Jan 4 17:47:51 EST 2002 i686
unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make
Compilation info: CC='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc' CXXFLAGS='-O3
-mpentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 13 Oct 15 2000 /lib/libc.so.6 -> libc-2.1.3.so
-rwxr-xr-x 1 root root 4103980 Jul 31 2000 /lib/libc-2.1.3.so
Configure command: ./configure --prefix=/usr/local/pkg/mysql/mysql-3.23.47
--enable-assembler --with-mysql-ldflags=-all-static --disable-shared
--with-extra-charsets=complex
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
