July 2009 - discuss - lists.mariadb.org

[Maria-discuss] explain for insert/update/delete
by MARK CALLAGHAN 11 Jul '25

11 Jul '25

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=14745 http://bugs.mysql.com/bug.php?id=35355 -- Mark Callaghan mdcallag(a)gmail.com

2 1

[Maria-discuss] why does UNION ALL use a temp table?
by MARK CALLAGHAN 03 Aug '09

03 Aug '09

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

3 6

[Maria-discuss] Launchpad RO mode
by Kurt von Finck 22 Jul '09

22 Jul '09

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

1 0