On 15 Feb 2014, at 11:35, Roberto Spadim <roberto@spadim.com.br> wrote:
here: https://lists.launchpad.net/maria-developers/msg05719.html
isn't this just the standard DBUG_ENTER(), DBUG_PRINT() of the SE API? extracts from https://mariadb.com/kb/en/plans-for-10x/ : • QA request: better EXPLAIN (HIGH priority; MP; Spetrunia) • required in order to debug performance issues in queries without knowing the query or the data; • the customer will only provide EXPLAIN and SHOW output, we need to debug based on that; (need examples) • Perhaps optimizer trace is what we need • U/C at Oracle: OPTIMIZER tracing spetrunia: report actual estimates, and all decisions of the optimizer, including why an index was *not* picked, etc. • want to change for 5.7
2014-02-15 1:21 GMT-02:00 Justin Swanhart <greenlion@gmail.com>: Can you point to the docs on the mariadb implementation? Writing tools to support competing implementations of the same feature is not fun.
i don't think they are the same feature. optimizer tracing, and its accompanying json output is something that mariadb 10.0 will not have, but something we probably need in future versions (10.1) to remain "backwards compatible". i see mysql workbench as a front-end tool supporting optimizer trace -- do you know of more justin? cheers, -colin
Sent from my iPhone
On Feb 14, 2014, at 2:12 PM, Roberto Spadim <roberto@spadim.com.br> wrote:
that's the "same" feature of dbug in mariadb
2014-02-14 19:01 GMT-02:00 Tim Callaghan <tmcallaghan@gmail.com>: Is this feature or something similar already in MariaDB 10? If not, is it on the roadmap?
http://dev.mysql.com/doc/internals/en/optimizer-tracing.html
-Tim Callaghan
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Roberto Spadim SPAEmpresarial Eng. Automação e Controle _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
-- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles