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 Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.0.18 OS:
Assigned to: Sergei Glukhov CPU Architecture:Any

[1 Jun 2004 17:13] Tim Bunce
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
  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