MySQL's built-in profiler

[kjkoster]

Dear All,

I just ran into a short howto introducing MySQL's query profiler (http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html). Crazy cool. Available from version 5.0.37 of MySQL.

Thanks to IRC user lmorgado on #mysql on freenode,net.

Kees Jan

[Barry]

Hi Kees Jan,

Sorry for the late reply.
You sent me this link as well and I must say it's an excellent addition to our toolset.
The fact that the results are stored in the database itself and you can retrieve them with SQL makes it possible write any sort of tools on top of it using current components.

[kjkoster]

Dear Barry,

We need a downloadable Hibernate mapping for this. :-)

Kees Jan

[Barry]

Generate the JPA code for it using Netbeans.

[kjkoster]

Dear Barry,

Yeah, well, you'd also need a clever DAO wrapper. The profiling information is session-based. So you need more than just a few generated DAO's.

Kees Jan