Posted by Colin McKinnon on 09/27/05 22:29

pierre.bru@gmail.com wrote:

> hi,
>
> fist the context: I have a web server which query a mySql database. but
> as the number of parralel queries increase, the server slows down too
> much.
>

Not a PHP question.

MySQL doesn't do parallel queries. Queries are processed in a queue.

Your suggestion - to run more code with more layers of abstraction is more
likely to slow your machine down. Are you sure that it is purely down to
the size of the returned dataset? IME most DB performance issues can be
fixed by tweaking your schema. What does EXPLAIN say for your queries? Are
you logging slow queries?

I've never been a great fan of BLOBs in DBMS - filesystems are much more
capable of handling them.

Assuming that these avenues have been exhausted, you might think about
setting up a MySQL5 parallel cluster with partitioned data (not a
replicated cluster).

HTH

C.

[Back to original message]