Discussion related to selection and use of different database types
Questions tagged [database]
12 questions
12
votes
2 answers
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 of this question on displaying the output histogram…
dpzz
- 4,539
- 4
- 22
- 46
10
votes
3 answers
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?
animal instinct
- 579
- 4
- 10
8
votes
1 answer
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 integers and other types.
Is this database…
user36303
- 34,928
- 2
- 58
- 123
5
votes
1 answer
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 databases are meant to be used locally, so for what…
janowitz
- 2,691
- 12
- 30
5
votes
1 answer
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 process was almost an order of magnitude faster…
cntrblst
- 51
- 3
4
votes
1 answer
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 information should be a lot faster and easier than doing…
user141
- 3,337
- 14
- 34
2
votes
1 answer
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 IOPS for a limited time instead of 100). See also my…
villabacho
- 1,215
- 6
- 15
2
votes
1 answer
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 stored in the blockchain database, or is everything…
jwinterm
- 4,413
- 1
- 21
- 34
2
votes
1 answer
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
Asif MD
- 21
- 1
2
votes
3 answers
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
or
zfs set recordsize=1024k zroot/data/monero
When…
scoobybejesus
- 5,515
- 21
- 42
0
votes
1 answer
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:57:49.516
[P2P4] INFO …
plc
- 3
- 1
0
votes
1 answer
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 the depth to 1?
