Why does UNION ALL use a temp table? Many users are surprised by this.
It would be faster to return rows from each branch of a UNION ALL
query directly to the network.
--
Mark Callaghan
mdcallag(a)gmail.com
Does MariaDB have any plans to support explain for
insert/update/delete/replace/CTAS? There have been feature requests
open for a very long time on official MySQL without any progress. I
have had a few problems in production from 'bad' delete statements
that had a very different plan than the select statement with the same
where clause. The only way to check for a bad plan today is to use
SHOW INNODB STATUS to determine whether the statement locks all rows
in a table.
http://bugs.mysql.com/bug.php?id=14745http://bugs.mysql.com/bug.php?id=35355
--
Mark Callaghan
mdcallag(a)gmail.com
FYI ...
> Launchpad will be in read-only mode for an hour on Wednesday, 22nd
> July while we roll out new code.
>
> Going read-only: 22.00 UTC, Wednesday 22 July 2009
> Expected back to normal: 23.00 UTC, Wednesday 22 July 2009
>
> There will be a couple of minutes around 22.00 UTC during which
> Launchpad is unavailable while we switch into read-only mode, and then
> another couple of minutes again when we switch back to read-write.
>
> Note that’s “UTC”. Actual time in your time zone may be different,
> and remember Britain is in BST right now, which is 1 hour later than
> UTC.
>
> Watch this list for details of the new release later this week.
>
> Best,
> -Karl Fogel
--
./k
kurt von finck
http://www.mneptok.com
public key: keyserver.ubuntu.com
key id: 5229D26A
fingerprint: 127A A484 ADBF A5AD E7FB 8CD2 8913 18F4 5229 D26A
Music is the space between the notes. - Debussy
