Beefy Boxes and Bandwidth Generously Provided by pair Networks Bob
Don't ask to ask, just ask

Comment on


jaybonci sent me patches to speed up group membership testing (which I don't think we do that much of compared to where it was a huge difference). But it looks like ar0n might be applying those soon.

The simple search is not a potential huge problem like it used to be, but it looks like it is still too much load. I think fixing it requires that the first stab at search be much simpler and then you get the option to "try harder" if it didn't find what you wanted.

Good caching of "other users" and all of the places that make use of that could be a big win. Not an easy problem.

The "navigation nodelet" keeps showing up on my radar. The solution there may just be to turn it off (or at least the parts that MySQL does a poor job of optimizing, despite them appearing extremely simple).

I've done a lot of work toward better caching of chatter. I'm less convinced that is a big source of slowness at the moment, but it would also lead to better features.

There is tons of room for performance improvements on the web servers (like caching the compiled code from templates), but that isn't where the bottleneck is (and adding a third webserver is a good solution since I'm not paying for it). (update: that's a joke)

I think the newest nodes ticker never got optimized.

There are probably others I don't recall at the moment.

Update: Moving each user's scratchpad to a separate node. This is a performance improvement and makes features easier (like a "d/l code" link for scratchpads).

Hide the fact that user nodes contain a "settings" and "document" records. Probably a relatively big performance improvement.

                - tye

In reply to Re^2: Recent slowness and outage (other speed-ups) by tye
in thread Recent slowness and outage by tye

and:  <code> code here </code>

  • Please read these before you post! —
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Log In?

    What's my password?
    Create A New User
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others avoiding work at the Monastery: (5)
    As of 2014-03-16 13:10 GMT
    Find Nodes?
      Voting Booth?

      Have you used a cryptocurrency?

      Results (326 votes), past polls