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