Questions tagged [database]

Discussion related to selection and use of different database types

Filter by
Sorted by
Tagged with
0 votes
0 answers
73 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 ...
user avatar
  • 1
2 votes
2 answers
301 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 ...
user avatar
4 votes
1 answer
859 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 ...
user avatar
  • 3,327
0 votes
1 answer
100 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:...
user avatar
  • 3
8 votes
1 answer
660 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 ...
user avatar
  • 34.6k
5 votes
1 answer
409 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 ...
user avatar
  • 2,552
2 votes
1 answer
125 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 ...
user avatar
  • 1,205
2 votes
1 answer
167 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 ...
user avatar
  • 4,373
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 ...
user avatar
  • 4,489
5 votes
1 answer
252 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 ...
user avatar
10 votes
3 answers
512 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?
user avatar