Bug #88997 Seeing "converting HEAP to ondisk" instead of "converting HEAP to MyISAM"

• Submitted: 20 Dec 2017 18:24
• Modified: 5 Jan 2018 13:49
• Reporter: Shahriyar Rzayev
• Status: Closed
• Category: MySQL Server: Documentation
• Severity: S3 (Non-critical)
• Version: 5.7
• OS: Any
• CPU Architecture: Any

[20 Dec 2017 18:24] Shahriyar Rzayev

Description:

There is an entry "converting HEAP to MyISAM"  in
https://dev.mysql.com/doc/refman/5.7/en/general-thread-states.html

But I saw "converting HEAP to ondisk" in processlist.

5.7.20>show processlist;
+------+------+-----------+------+---------+-------+---------------------------+-------------------------------------------------------------------------+-----------+---------------+
| Id   | User | Host      | db   | Command | Time  | State                     | Info                                                                    | Rows_sent | Rows_examined |
+------+------+-----------+------+---------+-------+---------------------------+-------------------------------------------------------------------------+-----------+---------------+
|  461 | root | localhost | test | Query   |     0 | starting                  | show processlist                                                        |         0 |             0 |
| 1409 | root | localhost | NULL | Sleep   | 11923 |                           | NULL                                                                    |         0 |           337 |
| 1410 | root | localhost | NULL | Query   |     0 | converting HEAP to ondisk | SELECT NAME FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE SPACE = 650 |         0 |             0 |
| 2087 | root | localhost | NULL | Query   |     0 | altering table            | create unique index ix on sysbench_test_db.sb2 (id)                     |         0 |             0 |
+------+------+-----------+------+---------+-------+---------------------------+-------------------------------------------------------------------------+-----------+---------------+
4 rows in set (0.00 sec)

How to repeat:
See description.

Suggested fix:
Change entry if appropriate.

[21 Dec 2017 7:05] MySQL Verification Team

Hello Shahriyar,

Thank you for the report.

Thanks,
Umesh

[4 Jan 2018 18:58] Paul DuBois

This change occurred in MySQL 5.7.5, presumably with the introduction of the internal_tmp_disk_storage_engine system variable.

[5 Jan 2018 13:49] Paul DuBois

Posted by developer:
 
Thread description updated.