Filip Sergeys wrote: > Is there a way to get an overview of recently executed queries on the > db? Queries are stored in the catalog cache, only I cannot find the > view that gives me this information. > Can queries be linked to statistics? How many times executed, disk > reads/writes or cash reads/writes, ...
Not in general but you could enable "diagnose analyze" feature. You could switch it on with the command "diagnose analyze on". Afterwards the table syscmd_analyze is filled with the text of the sql command and the table sysdata_analyze with some information about resource consumption of the statements. HTH. Kind regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
