Slashdot Mirror

← Back to Stories (view on slashdot.org)

Improving Database Performance?

Posted by Cliff on from the lead-foot-meet-database-gas-pedal dept.

An anonymous reader asks: "An acquaintance of mine runs a fair sized web community. Having nearly 280,000 users in a single MySQL database with about 12 mirrors accessing it, performance has become an big issue. I was wondering what practical methods could be used to lessen the load and decrease user query times. Funds are limited, so he'd rather not pay for a commercial database system at this time."

1 of 95 comments (clear)

  1. Re:Just... by dotgain · · Score: 4, Funny

    Just randomly abort the CGI scripts and throw out an HTTP/503. That's how slashdot does it, and he did "ask slashdot".