`analyze table` returns ok but does not generate stats
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 9h
- Merged PRs (30d)
- 121
Description
Potentially related to: https://github.com/dolthub/dolt/issues/8324
```
$ du -h
4.0K ./.doltcfg
479G ./.dolt/noms/oldgen
479G ./.dolt/noms
0B ./.dolt/temptf
0B ./.dolt/stats/.dolt/noms/oldgen
1.0M ./.dolt/stats/.dolt/noms
0B ./.dolt/stats/.dolt/temptf
1.0M ./.dolt/stats/.dolt
1.0M ./.dolt/stats
479G ./.dolt
654G .
$ dolt sql -q "analyze table actor, revision, comment"
+----------+---------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------+---------+----------+----------+
| actor | analyze | status | OK |
| revision | analyze | status | OK |
| comment | analyze | status | OK |
+----------+---------+----------+----------+
$ du -h
4.0K ./.doltcfg
479G ./.dolt/noms/oldgen
479G ./.dolt/noms
0B ./.dolt/temptf
0B ./.dolt/stats/.dolt/noms/oldgen
1.0M ./.dolt/stats/.dolt/noms
0B ./.dolt/stats/.dolt/temptf
1.0M ./.dolt/stats/.dolt
1.0M ./.dolt/stats
479G ./.dolt
654G .
$ dolt sql -q "select count(*) from dolt_statistics;"
+----------+
| count(*) |
+----------+
| 0 |
+----------+
```
These are large tables:
```
$ dolt sql -q "select count(*) from actor"
+----------+
| count(*) |
+----------+
| 290054 |
+----------+
$ dolt sql -q "select count(*) from revision"
+----------+
| count(*) |
+----------+
| 4013041 |
+----------+
$ dolt sql -q "select count(*) from comment"
+----------+
| count(*) |
+----------+
| 1409589 |
+----------+
```
Seems like something should have gotten written to disk.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.