Re: Interpreting "Usage Advisor" output
Posted by: Mark Matthews
Date: June 16, 2005 11:32AM

Dave Cosgrove wrote:
> After enabling Usage Advisor, several potentially
> useful WARNings are now provided, but I am not
> sure how to interpret some of the results.
> Specifically, in the following example, what do
> 'statement: 224 resultset: 95' represent? IDs that
> I can use for cross-referencing using some other
> method?
[snip]

Dave,

Only useful in correlating with other usage advisor output.

What are you using for a logging mechanism? Log4J? If so, you'll probably want to include location information in your log output, otherwise this feature won't be very helpful for you, because you won't be able to see where the "violation" occurred.

If you use a nightly snapshot of C/J 3.1.x (from http://downloads.mysql.com/snapshots.php#connector-j), you'll see that we dump the location for warnings now, irrespective of what logger you're using.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
Re: Interpreting "Usage Advisor" output
June 16, 2005 11:32AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.