Release 3.3.0.0.1: performance improvements

[Jesse Wiley]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA512

Hello,

Stacks core developers have released Stacks Core version 3.3.0.0.1, available here: https://github.com/stacks-network/stacks-core/releases/tag/3.3.0.0.1.

This release improves stacks-core performance by adding two database indexes which significantly reduce disk reads.
Depending on your hardware, index creation takes between 2-15 minutes per index (there are two).


We **strongly recommend all signer operators** to manually create indexes before applying this upgrade to avoid any downtime.


Apply the indexes as follows:
*Note*:
    - The following commands require running from your config `working_dir` directory. ex: `cd /stacks` where `working_dir = "/stacks"`
    - You may need to install the sqlite binary. On Debian based systems: `sudo apt-get install sqlite3`

```
$ echo "CREATE INDEX IF NOT EXISTS naka_block_headers_by_burn_hash ON nakamoto_block_headers(burn_header_hash);" | sqlite3 ./mainnet/chainstate/vm/index.sqlite

$ echo "CREATE INDEX IF NOT EXISTS naka_block_headers_by_burn_ht ON nakamoto_block_headers(burn_header_height);" | sqlite3 ./mainnet/chainstate/vm/index.sqlite
```


This release is compatible with chainstate directories from 3.x.x.x.x.

The version of stacks-signer compatible with this release is 3.3.0.0.1.0, available at: https://github.com/stacks-network/stacks-core/releases/tag/signer-3.3.0.0.1.0.


### Added

- Add indexes to `nakamoto_block_headers` to fix a performance regression. Node may take a few minutes to restart during the upgrade while the new indexes are created.


------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Stacks Core:

Git commit hash: 1cba695b09690790b1220b0f5d149f70f78ddea5

SHA512SUMS:
81e7911e8935ca26cf0e0be8696c3f823e0b8cb7bdd4c086892a5beac68b714fc3da00967b48fc151f8df5d0f58d489e8c11047286797090966c911b423255ec  linux-glibc-arm64.zip
b965cf58f515e5f7a8aa92c657a21e483913e9eafacf8fff629e1fb832fe45e5215c08e719844bf6f82c8588be5cb1fdee7d7e9b770efafc7beedba3d5457aa4  linux-glibc-x64.zip
b60f855049cb3620bd7ed4f4e7ad8bbd0bcffff16aeccbe72d8ba7e53e5afe65f943933c9d729bf56a7b8df121c1fbacfac7aa2a8877d937c3c4fbb2b37856df  linux-musl-arm64.zip
adc64184ace7a6d7bcbd9c7834846ccaa7ce5abff6e1664558a628189659245f4ce1b0202f1d28788e25e4acaa8bddebf96e54555b5e34931d7423cc716b96ec  linux-musl-x64.zip
b1af1b11a3f783d864dedc0a2652c2da2df039b2b9f72e65b07fc4efe6c7719475302a16f92f15ad29f3c7e134adb8f0c0e7145a694ea5e603299f05d77cd1ae  macos-arm64.zip
cc065349ab51b959c6e9f85373636ebc21b0610e4b0f373da0fe8c9519c3a4951688a7c223d7ce3664c1048dd1e7011b0d2f79ec4cecc6ba88e1155d20284949  windows-x64.zip

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Stacks Signer:

Git commit hash: 1cba695b09690790b1220b0f5d149f70f78ddea5

SHA512SUMS:
f7900b88b64f1c65637a9030ac5fbaf699aa059ebea87f671bcd18ac80f99ab8e675e4c332e0d3d5cdc351620736605a43ba2675a8eb60f821fac1d0949eff54  linux-glibc-arm64.zip
1bb3c022a39fd8bf6fc5a63546c7d2aa7228100099df5fa3de66c970244220739951751c0431966e570ec7d39c7dacd660c1022a4bd8720e7aec1637c92f0366  linux-glibc-x64.zip
4dbd0524ed5ef793df053318f60974ae3688ca2345dd942a3267725ada994c5c1a46e12bafb2026a40c58bf9c4b3f406da36dd106afa93b2363271eb54690647  linux-musl-arm64.zip
dce94e6aa45303bb11033269f41c2d683540e83d7b012bc9f72ed8f0b5a4989196f57e95dac33fcf54a77318fb9ea59fdad1d9f84ad14d84b11fe06aa2ea2599  linux-musl-x64.zip
06c0b2015b1ffddd3d448caaa34ac950404f585944730d0cd9c09785f9edb5447fff5e20b1d78274ae0082ff5c72e75c9cbcf1e48e60cd285971380e66d00a16  macos-arm64.zip
04937df219df876775d145ed16e83ae5844c91200a31e9e7fbbb0321174d00a4206fef218a2d62a86c78e1a2f29f4080707bb90392131dfeedbf79de0451655c  windows-x64.zip


Best,
Jesse Wiley
Engineering Partner, Stacks Foundation
-----BEGIN PGP SIGNATURE-----

iQJFBAEBCgAvFiEEcyLAWCVQ3ogXwlXZge1cNguBENcFAmkORUoRHGplc3NlQHN0
YWNrcy5vcmcACgkQge1cNguBENc3qBAAv100No+D4BLMoDbBAn6OFah5TvL1712l
s77RbBcph6yedfxECLXnSNTUPOwPrV8Zn6uhlXBqq4/1l9UFtsnKu3t//b5HHL3T
W+aXzQmaoeOMp+Ya37XZKKU5xd7wo4hcZ+Q7TAG8H66njut/IHKv7ItEvoguxv3P
4ui2eg5aP30BkumjBlEa1cqVatayUQljhQjWRJXncS8cUm/lZuE+JsOVjyoD+HaU
tQE80uFJWQ07B7GPlTSGqHrgkROP4l9TpHvyixzmsMpT7qqC2yOrzBp72UhD4MDa
R8hLT+hytw0enG//xb/szlJuCN4bnBLmBriEg4DlT6kGYL4s+gDS2KPu7Dn4oqri
eWOLb8H7HCR0OLAkLaiijMcwGU2TtobsWOlbmw2QSFIrNfPxXfyFRDdP2Y1yrgDy
oFWi5BStNVRPtuUoVp7TmXuziqQUSCHQOlsi3bjtsu7R9VcaVlcCxx42c7ErhHZ9
g5QrdmB5lBAy+HcKrMWq/FWhZfJM+YAeepRp18d88BMZzgfpD829RG8cjWikujCM
cmY9GMGVNWrieroTIsXzNdPkx1Ct0L0gBzlCmAe1pO3v4uGPLfm2+OzA9tnmPWTf
dPJiv8mPtybbAZrqt1l2yNz8op85+pf+gkE0Zcz7HHvTMdCCUP5ONDhfBkh84WYI
lF0hN1/vHGI=
=RklR
-----END PGP SIGNATURE-----