maria-discuss team mailing list archive

[MARK CALLAGHAN <mdcallag@xxxxxxxxx>]

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@xxxxxxxxx