dolthub / dolthub/dolt

`analyze table` returns ok but does not generate stats

Open
#8,326 2 comments 0 reactions 0 assignees View on GitHub
bug performance sql
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.