| Bug #3950 | Check/Repair caused by "Field List" doesn't show table name in processlist | ||
|---|---|---|---|
| Submitted: | 1 Jun 2004 19:13 | Modified: | 23 Jun 2004 17:11 |
| Reporter: | Tim Bunce | ||
| Status: | Closed | ||
| Category: | Server | Severity: | S3 (Non-critical) |
| Version: | 4.0.18 | OS: | |
| Assigned to: | Sergey Gluhov | Target Version: | |
[10 Jun 2004 2:27]
Dean Ellis
Just changing this to a feature request so that it can be handled properly. Good idea, of course.
[17 Jun 2004 15:39]
Sergey Gluhov
ChangeSet 1.1867 04/06/17
[23 Jun 2004 11: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 17:11]
Sergey Gluhov
Fixed in 4.1 source tree
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.