Bug #19781 mysql_explain_log can't analyse slow logs

• Submitted: 12 May 2006 18:03
• Modified: 4 Dec 2007 21:31
• Reporter: Jan Willamowius
• Status: Unsupported
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.18
• OS: Any
• CPU Architecture: Any

[12 May 2006 18:03] Jan Willamowius

Description:
Since the slow logs uses a different  format, mysql_explain_log can't be used to explain the slow queries. The attached script mysql_explain_slow_log works on slow logs (only on slow logs).

How to repeat:
.

Suggested fix:
use script provided

[12 May 2006 18:04] Jan Willamowius

mysql_explain_slow_log

Attachment: mysql_explain_slow_log (application/octet-stream, text), 7.33 KiB.

[14 May 2006 15:01] Valeriy Kravchuk

As far as I know, mysql_explain_log utility is not maintained by MySQL. Looks like http://forge.mysql.com/ is now the best place to maintain and discuss it.

[14 May 2006 17:18] Jan Willamowius

mysql_explain_log is part of the standard MySQL distribution. It was initially
contributed by a third party, but as long as it it is shipped with MySQL, MySQL
AB should at least keep it up to date by accepting patches.

[15 May 2006 21:04] Valeriy Kravchuk

I'll mark this bug report as verified. We should either keep mysql_explain_log updated or exclude it from the official distribution (and move to forge.mysql.com).

[28 Nov 2006 1:59] Jay Pipes

Just going back over some older bugs looking for easy to fix/resolve ones.

mysqldumpslow program is the documented way to analyze the MySQL Slow Query log, per docs:

http://dev.mysql.com/doc/refman/5.1/en/slow-query-log.html

Recommend moving this to status Not A Bug or Unsupported.

[4 Dec 2007 21:31] Konstantin Osipov

Accepting Jay's suggestion.