Questions tagged [database]

Discussion related to selection and use of different database types

Filter by
Sorted by
Tagged with
0
votes
0answers
29 views

blockchain corrupted, backup failed

2022-01-08 05:55:04.400 8316 ERROR daemon src/daemon/main.cpp:362 Exception in main! Failed to open db handle for m_blocks : MDB_CORRUPTED: Located page was wrong type - you may want to start ...
2
votes
2answers
233 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 ...
4
votes
1answer
670 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 ...
0
votes
1answer
93 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:...
8
votes
1answer
630 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 ...
5
votes
1answer
396 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
votes
1answer
123 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 ...
2
votes
1answer
164 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 ...
12
votes
2answers
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 ...
5
votes
1answer
235 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 ...
10
votes
3answers
493 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?