Hi,
I am currently working on a project in which we are using MySQL to store
data.
The database server (basic installation) is installed on Windows NT version
4. We
are currently doing some load testing on the software and have encountered
some
problems. The database server is hanging.
Our intention is eventually to create a farm of application servers to host
the system
for scalability reasons. So, at the moment we want to find the limits of a
single app
server.
1. We have employed the Singleton pattern to control the connection to that
database, which is a point of concern. Will the load testing strain the
single
connection thus hanging the Mysql Server?
2. Should each request create a new database connection or is this too slow
and
costly
3. Should connection pooling be considered and if so which app server do you
recommend
4. Could antone tell me how many connections can be open at any one time?
5. Are there any know reasons why the database server should hang?
6. Are there any know reasons why a connection to the database should hang
thus
crippling the database server?
Any comments or suggestion as to wh this is happening would be most useful.
Cheers
Daire Treanor.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
