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
90
91
92
93
94
95
96
97
98
99
100
101
102

# inno find

Search a MySQL data directory for pages matching a given page number.

## Synopsis

```text
inno find -d <datadir> -p <page> [-c <checksum>] [-s <space_id>] [--first] [--json] [--page-size <size>]
```

## Description

Recursively discovers all `.ibd` files under a MySQL data directory, opens each as a tablespace, and reads the FIL header of every page looking for a matching `page_number` field. This is useful for locating which tablespace file contains a specific page when you have a page number from an error log or diagnostic tool.

Optional filters narrow results when the same page number appears in multiple tablespaces:

- `--checksum`: Only match pages whose stored checksum (bytes 0-3 of the FIL header) equals the given value.
- `--space-id`: Only match pages whose space ID (bytes 34-37 of the FIL header) equals the given value.

With `--first`, searching stops after the first match across all files, providing a fast lookup when only one hit is expected.

A progress bar is displayed for the file-level scan (suppressed in `--json` mode).

## Flags

| Flag | Short | Required | Default | Description |
|------|-------|----------|---------|-------------|
| `--datadir <path>` | `-d` | Yes | -- | MySQL data directory path to search. |
| `--page <number>` | `-p` | Yes | -- | Page number to search for across all tablespace files. |
| `--checksum <value>` | `-c` | No | -- | Only match pages with this stored checksum value. |
| `--space-id <id>` | `-s` | No | -- | Only match pages in this tablespace (by space ID). |
| `--first` | -- | No | Off | Stop after the first match for faster lookups. |
| `--json` | -- | No | Off | Output in JSON format. |
| `--page-size <size>` | -- | No | Auto-detect | Override page size. |

## Examples

### Search for page 3 across all tablespaces

```bash
inno find -d /var/lib/mysql -p 3
```

### Search with space ID filter

```bash
inno find -d /var/lib/mysql -p 3 -s 42
```

### Stop at first match

```bash
inno find -d /var/lib/mysql -p 3 --first
```

### JSON output

```bash
inno find -d /var/lib/mysql -p 3 --json | jq '.matches'
```

### Search with checksum filter

```bash
inno find -d /var/lib/mysql -p 3 -c 2741936599
```

## Output

### Text Mode

```text
Checking sakila/actor.ibd..
Checking sakila/film.ibd..
Found page 3 in sakila/actor.ibd (checksum: 2741936599, space_id: 42)

Found 1 match(es) in 2 file(s) searched.
```

If no match is found:

```text
Page 3 not found in any .ibd file.
```

### JSON Mode

```json
{
  "datadir": "/var/lib/mysql",
  "target_page": 3,
  "matches": [
    {
      "file": "sakila/actor.ibd",
      "page_number": 3,
      "checksum": 2741936599,
      "space_id": 42
    }
  ],
  "files_searched": 2
}
```