hallo,
i need help concerning general database
theory for mysql, because i have to build
a high traffic banner rotation system.
the system will have to manage several
hundred users per second.
where is the border of mysql and how shall
the server be configured?
(assume a big & strong dell server as server)
-pconnect or connect
-max_connections ?
-seperated server db server ?
-kernel patches?
-special system
i want to sourround the "common too many connections problem"!
how many concurrent can be managed by mysql?
it will be mainly an READ system. every hit
will have to execute several queries.
i searched for ressources describing this theme, but i failed in finding a qualitative one. are there any sites or books that could help ?
i need help concerning general database
theory for mysql, because i have to build
a high traffic banner rotation system.
the system will have to manage several
hundred users per second.
where is the border of mysql and how shall
the server be configured?
(assume a big & strong dell server as server)
-pconnect or connect
-max_connections ?
-seperated server db server ?
-kernel patches?
-special system
i want to sourround the "common too many connections problem"!
how many concurrent can be managed by mysql?
it will be mainly an READ system. every hit
will have to execute several queries.
i searched for ressources describing this theme, but i failed in finding a qualitative one. are there any sites or books that could help ?