[MDEV-32687] After the drop table, only the ibd file remains, and the frm file has been deleted Created: 2023-11-06 Updated: 2024-01-08 Resolved: 2024-01-08 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.5.17 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | kennyliao | Assignee: | Unassigned |
| Resolution: | Incomplete | Votes: | 0 |
| Labels: | None | ||
| Environment: |
windows |
||
| Description |
|
After the drop table, only the ibd file remains, and the frm file has been deleted err log info: 2023-08-07 4:33:32 0 [Note] InnoDB: Uses event mutexes |
| Comments |
| Comment by Marko Mäkelä [ 2023-11-06 ] |
|
Because InnoDB reports that the table does no exist in its data dictionary, it should be safe to remove the .ibd file from the data directory. Before MariaDB Server 10.6, DDL operations such as DROP TABLE were not crash safe. What exactly happened the first time when table was attempted to be dropped? Was the server killed? |
| Comment by kennyliao [ 2023-11-11 ] |
|
markoMarko Mäkelä ,Group commit is an optimization method for MYSQL to process logs(binlog/redo log), mainly to solve the problem of frequent disk flushing during log writing. Has mariadb done this optimization? |
| Comment by Sergei Golubchik [ 2023-12-11 ] |
|
kennyliao, yes, binlog in MariaDB can group commits. Is it relevant for this bug? |