hi,
I run a web server on a linux box from which PHP connect to a mySQL 4 server
running on another linux box.
tis works well but when the number of concurent connection/queries go high, the
DB server runs very slowly.
while trying to find a fix to this problem, I've been told that whatever the
number of concurent queries the DB server receive, it process them thru a
queue, that no more than 1 query may be performed by mySQL at a time.
is this true ?
true or not, will I gain speed by by preventing the web server to perform too
many connections/queries at the same time? I mean, will 10000
connection/queries be executed faster if there is at most 25 concurent queries
than if there are 100 or more concurent connections/queries? (by queries, I
mean a mix of select (lot) and update (few))
TIA,
Pierre.
