Bug #71690 mysqlindexcheck should display tables w/o primary key

• Submitted: 12 Feb 2014 20:52
• Modified: 21 May 2014 3:57
• Reporter: Daniël van Eeden (OCA)
• Status: Closed
• Category: MySQL Utilities
• Severity: S3 (Non-critical)
• Version: 1.3.6
• OS: Any
• CPU Architecture: Any

[12 Feb 2014 20:52] Daniël van Eeden

Description:
mysqlindexcheck should have an option to report on tables w/o primary key and/or unique key as this can be bad for performance etc.

It probably easy to implement as it seems to have a partial support already:
mysqlindexcheck mydb -vv | grep 'is not indexed'

How to repeat:
See description

[13 Feb 2014 5:11] MySQL Verification Team

Hello Daniel,

Thank you for the report.

Thanks,
Umesh

[12 May 2014 14:38] Chuck Bell

Fixed in release-1.4.3.

[21 May 2014 3:57] Philip Olson

Fixed as of the upcoming MySQL Utilities 1.4.3 release, and here's the changelog entry:

An "indexcheck" option was added to the "mysqlindexcheck" utility. It
reports on tables without a PRIMARY or UNIQUE key. Previously, this
information was only available with a high verbosity level ("-vv").

Thank you for the bug report.