>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:
Iss
>Description:
I have the max_user_connections set to 150 on every one of my servers but a
single user is still able to use up to 250 connections. (max_connections=250)
>How-To-Repeat:
execute a huge query then send 250 updates separately to that same table.
>Fix:
>Description:
The following query results in a different # of rows if the sql_big_tables is
set to 1:
select count(incidents.ref_no) from incidents, labels where incidents.ref_no like
'020531%' group by labels.label, incidents.ref_no;
The query seems unusual because it was a lot mor
