Feedback Is there a way to change our user id on this forum?

Discussion in 'Support & Feedback' started by flipmytext, Oct 12, 2009.

0
Page 2 of 2
  1. MhW

    MhW Active Member

    Messages:
    370
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    85
    #21
    The cost is justified by the strain each username change puts on the servers. The forum goes down for 10-15 seconds each time somebody's username is changed. Why should hundreds of users be inconvenienced because one person isn't happy with something as small as a user name? :rolleyes:
     
    MhW, Oct 17, 2009 IP
  2. DomainMagnate

    DomainMagnate Illustrious Member

    Messages:
    10,932
    Likes Received:
    1,022
    Best Answers:
    0
    Trophy Points:
    455
    #22
    actually I haven't noticed any downtime when I changed mine
     
    DomainMagnate, Oct 17, 2009 IP
  3. MhW

    MhW Active Member

    Messages:
    370
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    85
    #23
    oh?

    I was just going by what I've seen Shawn post. *shrug*
     
    MhW, Oct 17, 2009 IP
  4. imranais

    imranais Active Member

    Messages:
    109
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #24
    Thanks for your comments, but if you would had used VB as an Admin and if you had seen the admin panel, you would not post that. Username change does not involve any downtime.

    I even requested deletion of my userid so i could register a new id and start fresh even though this id is of 2007, but even that was denied.

    Anyways, no use of requesting, money talks here... $25 is way too much for me(atleast), but yes some "rich dudes" here even claimed to pay $25 just for "italicizing" their username.
     
    imranais, Oct 17, 2009 IP
  5. Helvetii

    Helvetii Notable Member

    Messages:
    4,412
    Likes Received:
    90
    Best Answers:
    1
    Trophy Points:
    205
    #25
    Have you used "VB as an Admin" at a forum which is the size of DP? :)
     
    Helvetii, Oct 17, 2009 IP
  6. imranais

    imranais Active Member

    Messages:
    109
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    60
    #26
    FYI: (A Must Read):

    Hijacking Thread - Do not hijack people's thread/topic. This includes (but not limited to) purposely changing the subject, posting in someone's sales thread to offer your opinion (like "great design" or "unlimited hosting is a scam" when you have no intention of buying).

    ...."Short (7 day) discretionary bans are used to "remind" users of these rules."

    More:
    http://forums.digitalpoint.com/faq.php?faq=rules#faq_rules_replying

    A premium member is not exempted from the rules of this forum! If you dont have any relation to the Topic or anything related to post then why not keep out of it, instead of provoking others?
     
    imranais, Oct 17, 2009 IP
  7. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #27
    Clearly... we are all about the money by introducing a service we DON'T particularly want people to use at a price point that makes it so most people would not buy it. A pretty sweet business decision don't you think? Offer something in the hopes people don't buy it? {rolls eyes}

    So I'm curious, what is your "GENUINE reason" you need your username changed?

    Primarily it locks up the Private Message area, so unless you were in there...

    When was the last time you tried it on a forum with the most recent private message IDs over 28,000,000? :)

    In particular there are 15 SQL queries that update all the denormalized tables containing username. These queries are called within the $vB_DataManager_User->update_username() method.

    The particularly nasty one is:

    $this->dbobject->query_write("
	UPDATE " . TABLE_PREFIX . "pmtext SET
		touserarray = REPLACE(touserarray,
			'i:$userid;s:" . strlen($this->existing['username']) . ":\"" . $this->dbobject->escape_string($this->existing['username']) . "\";',
			'i:$userid;s:" . strlen($username) . ":\"" . $this->dbobject->escape_string($username) . "\";'
		)
	WHERE touserarray LIKE '%i:$userid;s:" . strlen($this->existing['username']) . ":\"" . $this->dbobject->escape_string_like($this->existing['username']) . "\";%'
");
    PHP:
    A full table scan that locks the table because it's also being written to. On a table that is multiple gigabytes in size.

    How big is the pmtext table on the one you "easily" do it with no downtime? :)
     
    digitalpoint, Oct 17, 2009 IP
  8. DomainMagnate

    DomainMagnate Illustrious Member

    Messages:
    10,932
    Likes Received:
    1,022
    Best Answers:
    0
    Trophy Points:
    455
    #28
    so every time a username is changed everyone is unable to read/send pms for about 15 seconds, is that correct?
     
    DomainMagnate, Oct 17, 2009 IP
  9. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #29
    That is exactly correct. The table lockout period gets longer the larger the database (well that particular table) gets. It would be far longer if the DB servers didn't have very fast hard drives. 15 seconds to scan (read entirely) a 2.8GB file is pretty quick. :) The lockout period will only get longer the larger that table gets.
     
    digitalpoint, Oct 17, 2009 IP
Page 2 of 2