Questions tagged [database]
Discussion related to selection and use of different database types
12
questions
2
votes
1
answer
27
views
In which file monero is getting this "last_reward" and "last_timestamp" and how it is calculating that?
In which file is Monero getting this "last_reward" and "last_timestamp" and how it is calculating that?
Get stats
- 21
0
votes
1
answer
21
views
Graft blockchain
I want to make a node to mine on p2pool, but i don't want to download 100GB of the blockchain.
Is it possible to skip downloading the beginning of the blockchain, like how git can graft when setting ...
2
votes
2
answers
458
views
What settings for ZFS dataset containing blockchain directory?
The ZFS file system allows the user to specify various characteristics when creating datasets, or even after their creation. For example:
zfs create -o compress=lz4 -o atime=off zroot/data/monero
...
- 5,495
4
votes
1
answer
1k
views
Understanding the structure of Monero's LMDB and how explore its contents using mdb_stat
I am interested in understanding the structure of Monero's database LMDB and using mdb_stat to extract relevant information from it. I am assuming querying it directly (i.e. via mdb_stat) for ...
- 3,327
0
votes
1
answer
114
views
monerod is sync or not?
Is my monerod database sync or not?
status
Height: 1554546/1554546 (100.0%) on mainnet, not mining, net
hash 502.65 MH/s, v7, up to date, 8(out)+1(in) connections, uptime 0d
0h 2m 14s 2018-04-19 09:...
- 3
8
votes
1
answer
734
views
Is the Monero blockchain database portable between 32 and 64 bit architectures, and little/big endian architectures?
Monero uses LMDB for its database. Various data is saved in this database, including integers, such as the difficulty for a given block. LMDB is type agnostic, so does not any particular processing on ...
- 34.8k
5
votes
1
answer
428
views
Why would you need multiple daemons using one LMDB database?
From the release notes of the latest monero 0.10.2 version:
added support for multiple daemons using the same LMDB database
What sensible use case should that cover? From my understanding, LMDB ...
- 2,681
2
votes
1
answer
136
views
Running monerod in the cloud on SSD volume, but with a tight limit on IOPS imposed by the provider. Will the PR #1506 help?
I'm running monerod on an Amazon EC2 instance with an SSD volume (gp2 volume type), and synchronization from scratch gets extremely slow after I've used up my burst credits (allowing me up to 3000 ...
- 1,205
2
votes
1
answer
179
views
Equivalent of TX index=1 in Bitcoin
I believe that the Monero blockchain database is already the equivalent of running Bitcoin core with txindex set to 1. Is this correct?
Are there any options to increase the TX or other metadata ...
- 4,393
12
votes
2
answers
1k
views
How can one query the blockchain's database?
I realize that LMDB is very different from your typical SQL database, but is there a query language, or scripting language interface, that can be used to query the blockchain's database?
I am aware ...
- 4,519
5
votes
1
answer
283
views
How can I increase the database cache size?
I'm running a full node on Windows and have plenty of RAM, is there a switch I can use to allocate a larger cache size? (Similar to -dbcache=X in Bitcoin/Litecoin core)
The Monero synchronization ...
- 51
10
votes
3
answers
530
views
Blockchain database file size variance by Operating System
I have a full node on both an Ubuntu 16.04 LTS and a Windows 10 device.
Why is the database file containing blockchain a different size on each OS?
- 579