innodb-utils 3.1.0

InnoDB file analysis toolkit
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89

# inno tsid

List or look up tablespace IDs from files in a MySQL data directory.

## Synopsis

```text
inno tsid -d <datadir> [-l] [-t <tsid>] [--json] [--page-size <size>]
```

## Description

Scans `.ibd` (tablespace) and `.ibu` (undo tablespace) files under a MySQL data directory, opens page 0 of each, and reads the space ID from the FSP header at offset `FIL_PAGE_DATA` (byte 38). The space ID uniquely identifies each tablespace within a MySQL instance and appears in error logs, `INFORMATION_SCHEMA.INNODB_TABLESPACES`, and the FIL header of every page.

Two modes are available:

- **List mode** (`-l`): Prints every discovered file alongside its space ID, sorted by file path. Useful for building a map of the data directory.

- **Lookup mode** (`-t <id>`): Filters results to only the file(s) with the given space ID. Useful for resolving a space ID from an error message back to a physical `.ibd` file on disk.

If neither `-l` nor `-t` is specified, all discovered tablespaces are listed (same behavior as `-l`).

## Flags

| Flag | Short | Required | Default | Description |
|------|-------|----------|---------|-------------|
| `--datadir <path>` | `-d` | Yes | -- | MySQL data directory path to scan. |
| `--list` | `-l` | No | Off | List all tablespace IDs found in the data directory. |
| `--tsid <id>` | `-t` | No | -- | Find the tablespace file with this specific space ID. |
| `--json` | -- | No | Off | Output in JSON format. |
| `--page-size <size>` | -- | No | Auto-detect | Override page size. |

## Examples

### List all tablespace IDs

```bash
inno tsid -d /var/lib/mysql -l
```

### Find which file owns space ID 42

```bash
inno tsid -d /var/lib/mysql -t 42
```

### JSON output for all tablespaces

```bash
inno tsid -d /var/lib/mysql -l --json
```

### Look up a space ID from an error log

```bash
# Error log says: "InnoDB: Error in space 42"
inno tsid -d /var/lib/mysql -t 42
```

## Output

### Text Mode

List mode:

```text
sakila/actor.ibd - Space ID: 42
sakila/film.ibd - Space ID: 43
sakila/film_actor.ibd - Space ID: 44
```

Lookup mode when no match is found:

```text
Tablespace ID 999 not found.
```

### JSON Mode

```json
{
  "datadir": "/var/lib/mysql",
  "tablespaces": [
    { "file": "sakila/actor.ibd", "space_id": 42 },
    { "file": "sakila/film.ibd", "space_id": 43 },
    { "file": "sakila/film_actor.ibd", "space_id": 44 }
  ]
}
```