> -----Message d'origine----- > De : Zabach, Elke [mailto:[EMAIL PROTECTED] > Envoye : mardi 4 janvier 2005 10:06 > A : Fabrice Bourdel; [email protected] > Objet : AW: simple question about tracing queries with database manager > > > Fabrice Bourdel wrote: > > > > > -----Message d'origine----- > > > De : Zabach, Elke [mailto:[EMAIL PROTECTED] > > > Envoye : mercredi 29 decembre 2004 13:39 > > > A : Fabrice Bourdel; [email protected] > > > Objet : AW: simple question about tracing queries with database > manager > > > > > > > > > Fabrice Bourdel > > > > > > > > hi, > > > > > > > > i have a simple question : what do i have to do to > > > > simply see all queries executing on the database > > > > with the database manager program ? > > > > > > > > I know i has something to do with the "Database Trace" > > > > I tried to check : > > > > - "DEFAULT" in "Option" > > > > - "Trace sessions = All sessions" in "Advanced" > > > > - [a] (order interface AK) in "Protocol" > > > > > > > > ... and execute queries... > > > > > > > > there is so less help about that that i don't really know > > > > precisely what are thoses options really about... > > > > > > > > i know that i should then see the results in "Diagnostic files", > > > > with "Kernel trace protocol" after clicking on le flush button, > > > > > > > > could you tell me what to do ? > > > > > > 1. Oops, why do you want to see the queries sent by DBM? What do you > > > want to know? Can we help with some info? > > > 2. Database Trace will switch on some info written in the server. > > > Usually the output of this is useful for developers/MaxDB-support, > but > > > not for customers. Therefore my first question to shorten this. > > > 3. Option DEFAULT will write much more than the command itself. And > as > > > the trace-storing-area is written as a cycle this 'much more' can > easily > > > overwrite the info YOU want. For your needs not the option Default, > but > > > ORDER is convenient. > > > 4. trace sessions = All sessions, ok > > > 5. NOW do the queries > > > 6. Then flush the vtrace (look for the flash-button) > > > 7. NOW [a] for order interface and 'make protocol' has to be done > > > 8. read Kernel Trace Protocol (if you like, but as I said before: > why??? > > > In this case?) > > > > > > Elke > > > SAP Labs Berlin > > > > > > > > thanks for help. > > > > > > > > > > > > -- > > > > MaxDB Discussion Mailing List > > > > For list archives: http://lists.mysql.com/maxdb > > > > To unsubscribe: > > > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > Thank you for your response. > > > > I would like to see all the queries send to the database for > > my application debugging/optimisation purpose. > > > > I a perfect world, you would like to see information about > > the execution time, the query plan used, this, in a "real > > time" console, i would be great... a bit like the profiler > > tool (with sql server from ms) > > Is this kind of feature already planned by your developement > > people ? > > Naturaly, i can test, execute and do timing things before > > implementing, but i do not do it for all queries an such a > > tool would be nice to check globally and see where there > > could be hot spot... > > > There are no such plans. > But with some versions >= 7.6 using shared sql there will be a > systemview commandstatistics with the text of the statement and (beside > some info of > no interest for your needs) info (if counting is switched on) about the > time-needs during execution and the number of rows read/qualified. This > may help to find hot-spots which may need further evaluation with > explain > and so on. > > Elke > SAP Labs Berlin > > > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
thank you for your response ! i was waiting for the 7.6, and now a bit much more... (ie for the functions, the data synchroniser, the auto-expand of the files... and what you specified in then systemview command statistics...) -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
