Bug #25438 Typo in Excessive Disk Temporary Table Usage Detected advisor

• Submitted: 5 Jan 2007 17:08
• Modified: 25 Jan 2007 4:21
• Reporter: Peter Lavin
• Status: Closed
• Severity: S3 (Non-critical)
• Version: 1.1.0.4428
• OS: Any (All)
• Assigned to: Andy Bang
• CPU Architecture: Any
• Tags: advisor typo

[5 Jan 2007 17:08] Peter Lavin

Description:
In the "Details" tab describing the "Excessive Disk Temporary Table Usage Detected" advisor find:

"... Keep in mind that tmp_table_size is a per thread variable, so this amount of memory may used by all connected threads."

Should perhaps read:

"...this amount of memory may *be* used by *each connected thread*."

It looks like the word "be" is missing. Doesn't each thread us the
"tmp_table_size" amount of memory rather than all?

Also noted with respect to advisor "Temporary Tables To Disk Ratio Excessive" - bug 25391.

How to repeat:
Go to the Advisors page and under Performance find the "Excessive Disk Temporary Table Usage Detected" advisor. Click this advisor.

Suggested fix:
See above.

[16 Jan 2007 0:26] Andy Bang

Fixed in revision 4465.