Mark Callaghan

Thanks, with respect to the last point (indexes might take more space because they store the primary key value) the pkey in this case is just a bigserial -- [see...

> It is likely `main.mysqld--help-notwin` test needs a re-record Done

From PMP, hierarchical [is here](https://gist.github.com/mdcallag/36348bf9a4162113c5c0b9fd1ad0f426), flat [is here](https://gist.github.com/mdcallag/ea72b6bb189679ad930cb60c2d8578e0) I saved the RocksDB LOG file but it is 1.6M compressed and I don't know where to put it. It is saved...

From PMP, and starting with hierarchical output after removing lines with abstimed_wait (output [is here](https://gist.github.com/mdcallag/00414bce09d150dc4296dc210f745eb6)) Many threads stuck in RocksDB, maybe trying to write the WAL ``` 9 __futex_abstimed_wait_common64,__futex_abstimed_wait_common,__GI___futex_abstimed_wait_cancelable64,__pthread_cond_wait_common,___pthread_cond_wait,wait

Another hang [is here](https://gist.github.com/mdcallag/7699ccd30f1ede7d08c6fba3fee0c331) This one from a build that uses CMAKE_BUILD_TYPE=RelWithDebInfo. The previous hang uses a build with CMAKE_BUILD_TYPE=Relase.

It happened again. This is very intermittent. I will soon switch to a more recent build and hope it is gone. After kill -9 the database seems to be OK.

From the hang today, which is with the same binary as the first hang: * show processlist [is here](https://gist.github.com/mdcallag/ae5e04d11f8f8fc8709cd88c65184d55) * PMP flat [is here](https://gist.github.com/mdcallag/1386281bcee31685774e1850263a6bcf) * PMP hierarchical [is here](https://gist.github.com/mdcallag/4b0adf5e062bec78e46edf8aa1b0f834)

The world has moved on to 8.0.32

AFAIK this has been fixed

thank you