Try Quests to earn cryptoFlash Bounty: Miners Moving?
Introduction
WHAT IS ETHEREUM MINING?
Mining is the process of creating a block of transactions to be added to the Ethereum blockchain.
The word mining originates in the context of the gold analogy for crypto currencies. Gold or precious metals are scarce, so are digital tokens, and the only way to increase the total volume is through mining. This is appropriate to the extent that in Ethereum too, the only mode of issuance post launch is via mining. Unlike these examples however, mining is also the way to secure the network by creating, verifying, publishing and propagating blocks in the blockchain.
Mining ether = Securing the Network
Ethereum, like Bitcoin, currently uses a proof-of-work (PoW) consensus mechanism. Mining is the lifeblood of proof-of-work. Ethereum miners - computers running software - using their time and computation power to process transactions and produce blocks.
WHY DO MINERS EXIST?
In decentralized systems like Ethereum, we need to ensure that everyone agrees on the order of transactions. Miners help this happen by solving computationally difficult puzzles to produce blocks, securing the network from attacks.
WHO CAN BECOME A MINER ON ETHEREUM?
Technically, anyone can mine on the Ethereum network using their computer. However, not everyone can mine ether (ETH) profitably. In most cases, miners must purchase dedicated computer hardware to mine profitably. While it is true anyone can run the mining software on their computer, it is unlikely that the average computer would earn enough block rewards to cover the associated costs of mining.
Cost of mining
- Potential costs of the hardware necessary to build and maintain a mining rig
- Electrical cost of powering the mining rig
- If you are mining in a pool, mining pools typically charge a flat % fee of each block generated by the pool
- Potential cost of equipment to support mining rig (ventilation, energy monitoring, electrical wiring, etc.)
To further explore mining profitability, use a mining calculator, such as the one Etherscan provides.
HOW ETHEREUM TRANSACTIONS ARE MINED
-
A user writes and signs a transaction request with the private key of some account.
-
The user broadcasts the transaction request to the entire Ethereum network from some node.
-
Upon hearing about the new transaction request, each node in the Ethereum network adds the request to their local mempool, a list of all transaction requests they’ve heard about that have not yet been committed to the blockchain in a block.
-
At some point, a mining node aggregates several dozen or hundred transaction requests into a potential block, in a way that maximizes the transaction fees they earn while still staying under the block gas limit. The mining node then:
- Verifies the validity of each transaction request (i.e. no one is trying to transfer ether out of an account they haven’t produced a signature for, the request is not malformed, etc.), and then executes the code of the request, altering the state of their local copy of the EVM. The miner awards the transaction fee for each such transaction request to their own account.
- Begins the process of producing the proof-of-work “certificate of legitimacy” for the potential block, once all transaction requests in the block have been verified and executed on the local EVM copy.
-
Eventually, a miner will finish producing a certificate for a block which includes our specific transaction request. The miner then broadcasts the completed block, which includes the certificate and a checksum of the claimed new EVM state.
-
Other nodes hear about the new block. They verify the certificate, execute all transactions on the block themselves (including the transaction originally broadcasted by our user), and verify that the checksum of their new EVM state after the execution of all transactions matches the checksum of the state claimed by the miner’s block. Only then do these nodes append this block to the tail of their blockchain, and accept the new EVM state as the canonical state.
-
Each node removes all transactions in the new block from their local mempool of unfulfilled transaction requests.
-
New nodes joining the network download all blocks in sequence, including the block containing our transaction of interest. They initialize a local EVM copy (which starts as a blank-state EVM), and then go through the process of executing every transaction in every block on top of their local EVM copy, verifying state checksums at each block along the way.
Every transaction is mined (included in a new block and propagated for the first time) once, but executed and verified by every participant in the process of advancing the canonical EVM state. This highlights one of the central mantras of blockchain: Don’t trust, verify.[1]
Method
To solve this question, I got all the information I thought the comic could do from the ethereum.core.fact_blocks table. I subtracted the start date of the top miners and the date of the last block that mined and obtained the age of the miner. I joined the addresses with the ethereum.core.dim_labels table to get the names of the pools.
I considered the date '2022-06-15' to date for this analysis
Please accept my apologies for my inappropriate accent and dialect.
Conclusion
- Miners continued to work until the last moment and only merge was able to stop them, however, a handful are still working.
- Among the old miners, nanopool and ethpool_2 were among the oldest, their age reaches 7 years, but they turned off their devices after merging.
- ethermine and f2pool 2 have mined nearly 50% of the blocks from June 15 to today
- In the days after the merge, the miners who mined more than 50 blocks per day before the merge did not have any traces left.
observations
It seems that the miners were working until the last moment and they stopped only on the merge day (September 15), however, even on September 15, they were on until the last moment
In the days after the merge, the miners who mined more than 50 blocks per day before the merge did not have any traces left.
On September 15, 16 and 17, nearly 1,500 new miners have been added
ethermine and f2pool 2 have mined nearly 50% of the blocks from June 15 to today
==A handful of miners have continued to work after the merge==
Appendix
The solution of this question and the queries are completely used from the filipside database
The construction of the dashboard was also used from the site
app.flipsidecrypto.com/velocity, which belongs to flipside