« Ordnance Survey 2.0 – Bring it on! Geograph, Creative Commons and Ordnance Survey – Oh My! »

Pastebin performance improved

Wednesday, 17 May 2006, 10:12 | Category : Pastebin

Pastebin never used to retain more than a few thousand posts, but the recent feature to allow longer post retention exposed a few performance issues. If you noticed pastebin.com being a little slow, my apologies.

I’ve made a number of fixes to address the problem, if you notice further issues, do let me know with a comment below.

28 Comments for “Pastebin performance improved”

  1. 1dezral

    wrote on 17 May 2006 at 21:18

    there is a lot of “maybe old” patchs missing?…

    e.g. ones listed here

  2. 2lordelph

    wrote on 17 May 2006 at 21:57

    Prior to the release of the expiry control feature on May 7th, posts were kept for a maximum of 30 days. Now, you can choose to store posts which are kept forever.

  3. 3peterpowell

    wrote on 21 May 2006 at 7:13

    it is way way slow

  4. 4Zac

    wrote on 22 May 2006 at 2:47

    Running really slow at the moment.

  5. 5lordelph

    wrote on 22 May 2006 at 10:59

    Damn, seems I didn’t do quite enough. I’ve added a simple cache for recent posts which seems to be helping now…

  6. 6sean t

    wrote on 22 May 2006 at 16:53

    lots of old posts have been deleted :(

  7. 7lordelph

    wrote on 22 May 2006 at 17:10

    Old posts have *always* been deleted, that’s not new. What’s new is you can now opt to retain your posts. None of those have ever been deleted.

    The server that runs pastebin is pretty much dedicated to it but has been rather slow again today, despite a number of performance fixes. I’ll do some more benchmarking to see where the bottleneck has moved to…

  8. 8Blizt

    wrote on 22 May 2006 at 18:26

    Slow again :(
    Discussing some VBS (which sucks anyway, but I have to use it :( ) with someone and we use VBS now and then… Very slow, won’t load sometimes.

  9. 9lordelph

    wrote on 23 May 2006 at 16:01

    OK, pastebin is rocking again :)

  10. 10PChott

    wrote on 23 May 2006 at 16:59

    Recent Posts are not shown!

  11. 11Brian

    wrote on 23 May 2006 at 19:23

    Seconding the recent posts not showing

  12. 12lordelph

    wrote on 23 May 2006 at 21:02

    yeah, quiet, private pastebins didn’t show posts older than a few days ago. I’ve fixed this…

  13. 13{|omega|}

    wrote on 28 May 2006 at 20:11

    im still having a shitload of speed problems….

  14. 14otaku42

    wrote on 1 June 2006 at 9:12

    @lordelph: Wondering if all the changes you’ve mentioned in this post automatically show up in the file that can be downloaded at http://pastebin.com/pastebin.tar.gz …

  15. 15lordelph

    wrote on 1 June 2006 at 9:32

    I haven’t build a new tarball yet as there are incomplete changes for the translation. Should be ready this week.

    Unless you’re running a pastebin site with similar volume to pastebin.com, chances are you won’t really need the optimizations I’ve added though.

  16. 16Matthias

    wrote on 10 June 2006 at 18:34

    I’m getting database error like this:
    table pastebin.pastebin does not exist

  17. 17Julian Mehnle

    wrote on 10 June 2006 at 19:09

    I get the same errors Matthias gets. And http://xyz.pastebin.com dies, too, without even getting a page delivered!

  18. 18hello

    wrote on 10 June 2006 at 20:23

    pastebin isnt working

  19. 19ODZ

    wrote on 10 June 2006 at 20:57

    shits busted y0!

    Query failure: Table ‘pastebin.pastebin’ doesn’t exist
    select *,date_format(posted, ‘%a %D %b %H:%i’) as postdate from pastebin where pid=’771260′ and domain=”

  20. 20ratboy

    wrote on 10 June 2006 at 22:04

    god damn its not really that hard to fix. if you need a good coder just email me

  21. 21bonesxtr

    wrote on 11 June 2006 at 1:04

    Im sure the guy does this for pleasure and not business. He can’t be online 24/7, things will get fixed in his own time frame. Just appreciate all the hard work he puts in. Ive used this site countless times and appreciate it fully….

  22. 22Linuxer

    wrote on 11 June 2006 at 4:52

    Query failure: Table ‘pastebin.pastebin’ doesn’t exist

    Table pastebin doesn’ exist, i don’t think lordelph deleted table pastebin just for fun.
    I think someone have hacked pastebin and deleted table pastebin (maybe) as you can see the last user that posted in pastebin was PalazzO and you can see the time (1 sec)
    # PalazzO
    1 sec ago
    This means that after he posted something went wrong and the time stopped to count in that moment.

  23. 23sunzi

    wrote on 11 June 2006 at 14:30

    Hi,

    we are missing the private pastebin-service “ubunux.pastebin.com”. what’s up …?

    regards
    sunzi

  24. 24fearphage

    wrote on 11 June 2006 at 17:53

    All private pastebins are out of commission. What’s wrong?

  25. 25lordelph

    wrote on 11 June 2006 at 21:06

    Thanks for all the messages, unusually, I’ve been “off the grid” for 3 days and am sorting this out now. Thanks for the alerts, sorry about the problems…

  26. 26madmac

    wrote on 2 August 2006 at 18:33

    As you probably know, it’s extremely slow again nowadays. Seems to mostly affect subdomains. Apologies if you were aware, but ya did ask for us to comment =).

  27. 27Jules

    wrote on 21 August 2006 at 12:24

    Doesn’t seem to work at all for me.

    I’ve tried it a couple of times over the last week or so and I cannot get a response at all. It always times out before returning anything.

    Jules.

  28. 28Alessio Pace

    wrote on 8 September 2006 at 2:13

    Hi, I’m trying to post something on pastebin and never get a response back from the POST submission. Some performance issue or other problems?

    alessio.

Leave a comment