Questions tagged [database]

Discussion related to selection and use of different database types

Filter by
Sorted by
Tagged with
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's user avatar
  • 21
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 ...
PranshuTheGamer's user avatar
2 votes
2 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 ...
scoobybejesus's user avatar
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 ...
user141's user avatar
  • 3,327
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:...
plc's user avatar
  • 3
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 ...
user36303's user avatar
  • 34.8k
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 ...
janowitz's user avatar
  • 2,681
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 ...
villabacho's user avatar
  • 1,205
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 ...
jwinterm's user avatar
  • 4,393
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 ...
dpzz's user avatar
  • 4,519
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 ...
cntrblst's user avatar
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's user avatar