discuss

discuss@lists.mariadb.org

June 2010

3 participants
2 discussions

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

08 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

3 3

[Maria-discuss] (no subject)
by Justin Swanhart 16 Jun '10

16 Jun '10

http://wafejqh.wifethen.ru -- -- Justin Swanhart, Consultant, Percona Inc. Bay Area, USA (PDT, GMT -7) +1 888 401 3401 | Justin x503 | 24x7 Help x911 Our Services: http://www.percona.com/services.html Our Blog: http://www.mysqlperformanceblog.com/

3 2