Bug #3950 Check/Repair caused by "Field List" doesn't show table name in processlist

• Submitted: 1 Jun 2004 17:13
• Modified: 23 Jun 2004 15:11
• Reporter: Tim Bunce
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.18
• Assigned to: Sergei Glukhov
• CPU Architecture: Any

[1 Jun 2004 17:13] Tim Bunce

Description:
Check/Repair caused by "Field List" doesn't show table name in processlist:

+----+----------+---------------------------+----------+------------+------+-------------------+-------------------+
| Id | User     | Host                      | db       | Command    | Time | State             | Info              |
+----+----------+---------------------------+----------+------------+------+-------------------+-------------------+
|  2 | vcdbuser | b3.jp.valueclick.com:3000 | VC_count | Field List | 854  | Checking table    |                   |

The lack of info means you can't judge how long the check/repaid will take
or check for progress when many tables are involved.

How to repeat:
Kill mysqld when it has a large table open.
Use mysql client to connect.
It'll hang waiting for "Field List" to complete.
Use mysql -A to connect (on different window)
Do "show processlist;"
Note lack of table info in processlist results.

Suggested fix:
Put the table name currently being checked/repaired into the Info column.

[10 Jun 2004 0:27] Dean Ellis

Just changing this to a feature request so that it can be handled properly.  Good idea, of course.

[17 Jun 2004 13:39] Sergei Glukhov

ChangeSet
  1.1867 04/06/17

[23 Jun 2004 9:28] Michael Widenius

Patch approved (with some minor adjustments)
This will be added in 4.1 as it's not critical for 4.0

[23 Jun 2004 15:11] Sergei Glukhov

Fixed in 4.1 source tree