Introduction

To add new transactions to the distributed ledger of Ethereum, a procedure known as "mining" must first be completed.

In decentralized systems like Ethereum, we must assure transaction order. Miners secure the network by solving computationally challenging tasks to produce blocks.

Any computer can mine Ethereum. ETH mining isn't profitable for everyone. Profitable mining requires dedicated computer hardware. While anyone can run mining software on their computer, the ordinary PC won't earn enough block rewards to cover mining expenditures. Link

Method

This dashboard aimed to reveal the activity of Ethereum miners by tracking the number of blocks they generated. So, we're checking to see whether any miners specialize in mining blocks with a low number of transactions versus those that mine just blocks with a big number of transactions.

The ethereum.core.fact blocks table and a miner definition based on transaction count distribution per block have been employed to reach this goal.

As a first step, we can see which miners have mined blocks with an interval greater than or equal to a given value (the default is 50, but you can change it to any number you like in the above tape) (50 by default). So, if I set Interval to 50, it would indicate that miners would only mine blocks with a transaction count of 50 or higher if they had just mined a block with a count of less than 50, and vice versa if they had just mined a block with a count of fewer than 50.

I set the Interval by this method: where tx_count < '{{interval}}'

At the end to have a assessment based on transactions fee, I used ethereum.core.fact_transactions table and calculated total amount of gained fees per block to comparision the miner behavior based on transactions fees.

NOTE:None of the miners has any mining transactions in another category; to be more specific, miners who are in the category with more than ==50== transactions per block have no mining transactions in blocks with less than 50 transactions, and vice versa.

Analysis

Overall View

In this part can take a look at on overall view of total count of Miner, total count of transactions , Average, Median, Max & Minimum of transactions per blocks.

and in the following table, the types of miners listed by the number of transactions they mined per block are shown.

✍🏻 Conclusion

I tried to find a reason for this tend of miners to prefer mining blocks with lower transaction count, so I thought its must be because of more gained transaction fees on blocks with lower transactions count, so calculated the amount sum of fees volume in $USD and found that most of paid fees, were has spent on blocks with transactions count lower than 50 number per block. so I think, miners are tends to mining blocks with lowest transactions count per blocks because of more profitable in gained fees.

Although the amount of calculated fees per volume doesn’t make sense, that can be because of a lack of data in the database, but we can still get an overview of the total fees spent per block.

About:

• Author: HaM☰d

  \

• Discord: 0xHaM☰d#8391

  \

• Twitter: @arjmandi_hamed

  \

• Email: h_arjmandi2012@yahoo.com

Miners Behaving

• Do certain miners prefer mining blocks with lower transaction count?
• Do certain miners only mine blocks with high transaction count?
• You can define what can be considered low or high transaction count based on the transaction count distribution

Image

Hey there 👋!

Firstly, I appreciate you sticking with it until the conclusion.

I’m Hamed, Ph.D. In Civil Engineering and interested in data science.

I've made many similar dashboards and visualizations since I started at Flipside in January.

Please have a look at my various contact information and let me know what you think.

:telescope: Findings:

From the above bar charts, we can see that most miners tend to mine blocks with fewer than 50 transactions per block. This is true for 86% of miners, according to the PIE chart. in contract only 14% of miners only mine blocks with high transaction count.

In the following section, I classified miners into categories based on the 100 number of transactions per block (you can change this to your preference using the Interval tape above). 

As of these charts, its observable that closely 64% of miners prefer mining blocks with lower than 100 transactions count per block.

Also more than 51% of total count of transactions took placed on block with less than 100 transactions per block.

Total amount of fees volume in $USD was calculated and results shown in the following bar & PIE chart.