Memo Spam Statistics June-July 2018 Update by drakos

View this thread on steempeak.com
· @drakos · (edited)
$32.77
Memo Spam Statistics June-July 2018 Update
View this post on Hive: [Memo Spam Statistics June-July 2018 Update](https://hive.blog/@drakos/memo-spam-statistics-june-july-2018-update)
👍  , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , and 61 others
properties (23)
post_id59,021,944
authordrakos
permlinkmemo-spam-statistics-june-july-2018-update
categoryspam
json_metadata"{"app":"pruner","message":"See you on the other side!"}"
created2018-08-07 18:06:27
last_update2020-03-23 05:19:54
depth0
children21
net_rshares22,699,387,736,464
last_payout2018-08-14 18:06:27
cashout_time1969-12-31 23:59:59
total_payout_value27.390 SBD
curator_payout_value5.384 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length138
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (125)
@samiurrehman10 ·
Good post alot of good excel work by you 💋
@drakos
properties (22)
post_id59,022,209
authorsamiurrehman10
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180807t181006159z
categoryspam
json_metadata{"users":["drakos"],"app":"steemit\/0.1","tags":["spam"]}
created2018-08-07 18:10:06
last_update2018-08-07 18:10:06
depth1
children1
net_rshares0
last_payout2018-08-14 18:10:06
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length50
author_reputation796,363,068,104
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@drakos ·
MySQL and Excel.
properties (22)
post_id59,022,353
authordrakos
permlinkre-samiurrehman10-re-drakos-memo-spam-statistics-june-july-2018-update-20180807t181147926z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-07 18:11:48
last_update2018-08-07 18:11:48
depth2
children0
net_rshares0
last_payout2018-08-14 18:11:48
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length16
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@zipporah ·
I find these stats rather mind-boggling. Those spammy memos seem so tiny and inconsequential. Yet I suppose even piddly messages take up space when occurring at such high volume. 😳
properties (22)
post_id59,022,809
authorzipporah
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180807t181810470z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-07 18:18:09
last_update2018-08-07 18:18:09
depth1
children4
net_rshares0
last_payout2018-08-14 18:18:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length180
author_reputation23,085,183,622,427
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@drakos ·
That's what spam is: trash accumulating. Unfortunately on a blockchain, they can't be deleted, so we're stuck with them forever.

https://us.123rf.com/450wm/blueringmedia/blueringmedia1603/blueringmedia160300645/53746039-stock-vector-man-and-smelly-trashbags-illustration.jpg?ver=6
👍  
properties (23)
post_id59,023,427
authordrakos
permlinkre-zipporah-re-drakos-memo-spam-statistics-june-july-2018-update-20180807t182643595z
categoryspam
json_metadata{"tags":["spam"],"image":["https:\/\/us.123rf.com\/450wm\/blueringmedia\/blueringmedia1603\/blueringmedia160300645\/53746039-stock-vector-man-and-smelly-trashbags-illustration.jpg?ver=6"],"app":"steemit\/0.1"}
created2018-08-07 18:26:45
last_update2018-08-07 18:26:45
depth2
children3
net_rshares6,593,017,099
last_payout2018-08-14 18:26:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length281
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@zipporah ·
Ugh! *I hadn't thought of that.* • The downside to blockchain permanence.
properties (22)
post_id59,025,734
authorzipporah
permlinkre-drakos-re-zipporah-re-drakos-memo-spam-statistics-june-july-2018-update-20180807t185843154z
categoryspam
json_metadata{"tags":["spam"],"app":"steemit\/0.1"}
created2018-08-07 18:58:42
last_update2018-08-07 18:58:42
depth3
children2
net_rshares0
last_payout2018-08-14 18:58:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length73
author_reputation23,085,183,622,427
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@josediccus ·
It's taking toll on the blockchain, so much for irrelevancies taking so much space  the data is alarming though
properties (22)
post_id59,023,124
authorjosediccus
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180807t182221745z
categoryspam
json_metadata{"tags":["spam"],"app":"steemit\/0.1"}
created2018-08-07 18:22:30
last_update2018-08-07 18:22:30
depth1
children0
net_rshares0
last_payout2018-08-14 18:22:30
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length111
author_reputation430,967,424,524,957
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@smitop ·
Did you include memos from savings transfers?
properties (22)
post_id59,023,630
authorsmitop
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180807t182919481z
categoryspam
json_metadata{"users":[],"image":[],"links":[],"community":"busy","format":"markdown","tags":["spam"],"app":"busy\/2.5.4"}
created2018-08-07 18:29:21
last_update2018-08-07 18:29:21
depth1
children3
net_rshares0
last_payout2018-08-14 18:29:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length45
author_reputation1,262,150,405,365
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@drakos · (edited)
I'm using steemsql's TxTransfers table which includes all the transfer types. That being said, the savings transfers are a tiny fraction (few MB's) and rarely have any memos. Who uses savings anyways?
👍  ,
properties (23)
post_id59,025,467
authordrakos
permlinkre-smitop-re-drakos-memo-spam-statistics-june-july-2018-update-20180807t185436266z
categoryspam
json_metadata{"tags":["spam"],"app":"steemit\/0.1"}
created2018-08-07 18:54:36
last_update2018-08-07 18:55:09
depth2
children2
net_rshares7,282,212,038
last_payout2018-08-14 18:54:36
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length200
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (2)
@smitop ·
The advantage of savings transfers is that you can memo spam people for free, by starting a savings withdrawal of any amount of STEEM/SBD, and then immediately cancelling it. It still costs bandwidth, though. 
It doesn't seem like many people are using this, though. (I do, though)
properties (22)
post_id59,036,552
authorsmitop
permlinkre-drakos-re-smitop-re-drakos-memo-spam-statistics-june-july-2018-update-20180807t212625832z
categoryspam
json_metadata{"format":"markdown","users":[],"links":[],"app":"busy\/2.5.4","image":[],"community":"busy","tags":["spam"]}
created2018-08-07 21:26:27
last_update2018-08-07 21:26:27
depth3
children1
net_rshares0
last_payout2018-08-14 21:26:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length281
author_reputation1,262,150,405,365
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@myskye ·
It is obvious that the number of memos slightly got better, as we all know the activity of Steemians also went down since the Steem price is going down. I absolutely agree with you, to have a control over spam memos is important, we do not think about that in global way because we do not see that volume of spam on our accounts but when we think about the email boxes daily filled with spam mails that only stopped or got better after anti-spam programs them this is only decision to improve that on Steemit platform too.
properties (22)
post_id59,027,989
authormyskye
permlinkre-drakos-201887t202754484z
categoryspam
json_metadata{"encrypted":0,"tags":["spam","abuse","community","steemit","statistics"],"format":"markdown+html","community":"esteem.app","app":"esteem\/1.0.11-surfer"}
created2018-08-07 19:27:54
last_update2018-08-07 19:27:54
depth1
children0
net_rshares0
last_payout2018-08-14 19:27:54
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length522
author_reputation935,645,021,559
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries
0.
accountesteemapp
weight1,000
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@silentscreamer ·
Drakos you know that you could have easily use these stats to make a utopian contribution and gotten a potentially nice upvote and more exposure for this with a bit more work.. And its something id love to see get more traction. 

Its stuff like this we see as inconsequential that seem to have more effect then we thought.
properties (22)
post_id59,036,690
authorsilentscreamer
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180807t212842245z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-07 21:28:42
last_update2018-08-07 21:28:42
depth1
children0
net_rshares0
last_payout2018-08-14 21:28:42
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length323
author_reputation88,217,664,418,519
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@zen-art ·
That trash accumulating really is getting too serious and annoying. The info is useful but is there any idea in sight on how to get rid of this? The blockchain as such (at least in my opinion) does not really provide solutions for removing anything but then again, maybe that is just an excuse we keep telling ourselves in lack of useful solutions. I refuse to think that it is impossible, maybe just not doable at the moment. A person could dream, right?
properties (22)
post_id59,094,943
authorzen-art
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180808t121250076z
categoryspam
json_metadata{"users":[],"links":[],"tags":["spam"],"community":"busy","image":[],"app":"busy\/2.5.4","format":"markdown"}
created2018-08-08 12:12:51
last_update2018-08-08 12:12:51
depth1
children1
net_rshares0
last_payout2018-08-15 12:12:51
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length455
author_reputation70,613,687,112,481
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@drakos ·
I proposed some solutions to reduce spam in the first link of this post.
👍  
properties (23)
post_id59,106,341
authordrakos
permlinkre-zen-art-re-drakos-memo-spam-statistics-june-july-2018-update-20180808t142944020z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-08 14:29:45
last_update2018-08-08 14:29:45
depth2
children0
net_rshares6,639,157,020
last_payout2018-08-15 14:29:45
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length72
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@buckaroo ·
Those figures boggle the brain. And probably block the drain ;)But I guess the bottom line is we are stuck with spam
properties (22)
post_id59,132,171
authorbuckaroo
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180808t200209007z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-08 20:02:09
last_update2018-08-08 20:02:09
depth1
children0
net_rshares0
last_payout2018-08-15 20:02:09
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length116
author_reputation11,809,247,432,396
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@tecnosgirl ·
On the bright side it cost them to spam us and we get a fraction of a cent which does add up. I hate memo spam though I would rather not have that fraction of a cent.
properties (22)
post_id59,207,471
authortecnosgirl
permlinkre-drakos-memo-spam-statistics-june-july-2018-update-20180809t135726320z
categoryspam
json_metadata{"app":"steemit\/0.1","tags":["spam"]}
created2018-08-09 13:57:27
last_update2018-08-09 13:57:27
depth1
children2
net_rshares0
last_payout2018-08-16 13:57:27
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length166
author_reputation42,657,951,880,159
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@drakos ·
One idea was to increase the minimum memo cost.
👍  
properties (23)
post_id59,213,561
authordrakos
permlinkre-tecnosgirl-re-drakos-memo-spam-statistics-june-july-2018-update-20180809t150018875z
categoryspam
json_metadata{"tags":["spam"],"app":"steemit\/0.1"}
created2018-08-09 15:00:21
last_update2018-08-09 15:00:21
depth2
children1
net_rshares13,258,282,246
last_payout2018-08-16 15:00:21
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length47
author_reputation106,605,049,898,479
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)
@tecnosgirl ·
Shit if they are spamming me I could live with more of a fraction of a cent but seriously would love a way to stop it or at least curb it down, that would likely curb it some
properties (22)
post_id59,213,952
authortecnosgirl
permlinkre-drakos-re-tecnosgirl-re-drakos-memo-spam-statistics-june-july-2018-update-20180809t150400224z
categoryspam
json_metadata{"tags":["spam"],"app":"steemit\/0.1"}
created2018-08-09 15:04:00
last_update2018-08-09 15:04:00
depth3
children0
net_rshares0
last_payout2018-08-16 15:04:00
cashout_time1969-12-31 23:59:59
total_payout_value0.000 SBD
curator_payout_value0.000 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length174
author_reputation42,657,951,880,159
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries[]
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
@stef1 ·
$0.15
Spam is really annouying I remember in the past in early years of emailing, I was surprise to get email from strangers offering something or some advertisement so you have to seach through to find a relevant email that you are really waiting for. And those spam mails were appearing so quickly even when you just created email address. Nowaday using spam-blocker you can deep breath and finally have freedom from that spam. Is something like that could be created or these spam accounts marked somhow and blocked that would make s change. While being our witness @drakos I am glad you bringing such hot topics up. It is obvious problem for others but sometimes it is very human that we try to ignore it until it interferes the whole system.
👍  
properties (23)
post_id59,209,492
authorstef1
permlinkre-drakos-201889t151944253z
categoryspam
json_metadata{"format":"markdown+html","community":"esteem.app","encrypted":0,"tags":["spam","abuse","community","steemit","statistics"],"app":"esteem\/1.0.11-surfer"}
created2018-08-09 14:19:45
last_update2018-08-09 14:19:45
depth1
children0
net_rshares123,939,569,224
last_payout2018-08-16 14:19:45
cashout_time1969-12-31 23:59:59
total_payout_value0.109 SBD
curator_payout_value0.040 SBD
pending_payout_value0.000 SBD
promoted0.000 SBD
body_length740
author_reputation1,490,504,643,386,197
root_title"Memo Spam Statistics June-July 2018 Update"
beneficiaries
0.
accountesteemapp
weight1,000
max_accepted_payout1,000,000.000 SBD
percent_steem_dollars10,000
author_curate_reward""
vote details (1)