Ramblings

Ramblings which occasionally resemble reality. This is the blog of Stewart Smith.

http://pastebin.flamingspork.com/

A pastebin running Drizzle andÂ the Drizzle PHP Extension (which is on top of libdrizzle).

cody on 03/07/2009 at 4:22 am said:

paste the text from this http://www.fcc.gov/Reports/tcom1996.txt in and it blows up.
Paul Dixon on 03/07/2009 at 6:58 am said:

Nice! (I run pastebin.com). How’s the performance? I can see there’s only a few posts but would be interested in any load testing you’ve done :)
MacPlusG3 on 03/07/2009 at 12:28 pm said:

I have done absolutely no load testing :) It should perform better than the MySQL adapter for a number of reasons: Drizzle is faster, using transactions and not LOCK TABLES, using InnoDB so can have concurrent readers and writers.

I’m running with InnoDB and converted the LOCK TABLES bit into a real transaction (as we don’t support LOCK TABLES in Drizzle).

and I’ve been meaning to email you with the patches on top of pastebin too.

The next things I was thinking of was to move the “recent posts” generation into a gearman job and have the result in memcached – just to really eat all of our groups dog food. That could get over the performance problems you were seeing with that.
MacPlusG3 on 03/07/2009 at 12:31 pm said:

I had another thought of changing the schema to have the content of the paste be compressed…. at least for retreiving via text we could then pump out the gzip stream directly to client….

not sure how we’d do the HTML formatted one though…
Stewart Smith on 03/07/2009 at 3:35 pm said:

Found the weird error thing there. It was related to max_allowed_packet. Bug filed :)