Tariq Murtaza said: > Thanks Fortuno, Adam > > Actually, I was thinking about concurrent users that mysql can handle, > provided with reasonable hardware. > Looking for comments / suggestions. > > Regards, > > Tariq > > Fortuno, Adam wrote: > >>Tariq, >> >>Check the list's history - this is actually a frequent question. The >> answer everyone is about to give you is generic. "MySQL's ability is >> havily based on the hardware and OS it runs on. Therefore, a >> multi-processor machine with lots of memory can handle more than a >> single processor workstation with 256 MB of RAM. The faster the machine >> the faster MySQL... etc." >> >>Be more specific, whats the hardware and software. How much information >> are you storing in the DB? Any replication? >> >>Regards, >>Adam >> >>-----Original Message----- >>From: Tariq Murtaza [mailto:[EMAIL PROTECTED] >>Sent: Tuesday, September 02, 2003 8:40 AM >>To: [EMAIL PROTECTED] >>Subject: How much user LOAD can Mysql bear??? >> >> >>Hi All! >> >>How much user LOAD can Mysql bear before die. >> >>Regards, >> >>Tariq You haven't changed the question. The number of concurrent users is the same as the number of connections...if they are TRUELY concurrent. That is is they all hit the submit button at the same time. You set the number on connections. Each connection takes up a bit of memory, even if idle (php and mod_perl hold open connections. .jsp may or may not. Your response time (how long is acceptable) will depend on you actual database and questions you ask it as well as the hardware. It might help if you told us what hardware you are planning to use or what kinds of questions or environment it will support. Then the list can get more specific.
William R. Mussatto, Senior Systems Engineer Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]