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."

3 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".

  2. Re:Postgre-SQL by dotgain · · Score: 3, Funny

    PHB: I think we should build an SQL database.
    Dilbert (thinking):Does he know what he's talking about, or did he read it in a trade magazine ad?
    Dilbert (speaking):What color would you like that database?
    PHB: I think mauve has the most RAM. -

  3. Re:MySQL replication. by fleck_99_99 · · Score: 2, Funny

    Be careful with those slave replicants. Sometimes, they get cranky and want to know their expiration dates.

    --
    seven two six five
    seven four six one seven
    two six four two e