October 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 isn't SO_SNDTIMEO used?
by MARK CALLAGHAN 21 Mar '10

21 Mar '10

I describe how read/write is done for sockets in mysqld. http://www.facebook.com/note.php?note_id=122655300932 Can someone explain the history of this code? -- Mark Callaghan mdcallag(a)gmail.com

4 7

[Maria-discuss] Additional promise to the MCA
by Henrik Ingo 08 Oct '09

08 Oct '09

Hi all As Monty blogged some time ago http://monty-says.blogspot.com/2009/08/thoughts-about-dual-licensing-open.h… ...we want to add a promise to our MariaDB contributors signing the MCA, that we will not use their contributions to restrict other licensees ability to contribute to Open Source. This text has now been approved by a lawyer. The question is, is it understandable? ********************************** Additional promise to contributions under the Monty Program Contributor Agreement Monty Program Ab promises to each contributor assigning rights under the Monty Program Ab Contributor Agreement, that when licensing 'products' (software), that include a contribution, to other 3rd parties, the license will be either i) an Open Source license (www.opensource.org) or ii) another license, in which case: * the other license will NOT restrict the licensee from making his own modifications to the product, including adding other suitably licensed code or other 'materials' from other sources (such as code available under suitable Open Source licenses) * the license will NOT restrict the licensee from publishing his own code or other 'materials' including, but not limited to, under an Open Source license. As a special note, it is observed that the Monty Program Ab Contributor Agreement itself fulfills these requirements. Also note that this promise does not not extend as a requirement to 3rd parties so as to restrict their rights to license products containing contributions. ********************************** We are especially interested to get feedback on the understandability of the last paragraph. henrik -- email: henrik.ingo(a)avoinelama.fi tel: +358-40-5697354 www: www.avoinelama.fi/~hingo book: www.openlife.cc

5 17