I am having a PIII 933 / 256 MB RAM/ 9GB SCSII HDD.
I want to run servlets and database sites. How many hits can it handel and how many user can use the database at one time.
Is mysql 3.22.32 is good enough for BBS and other programs. Please let me know.

Im sure it would have to do with how CPU intensive your apps are
Good question, anyone know??

Lets use the same system as mentioned above, if the database usage was moderate to light how many simultaneous users could a server with those specs handle?

Anyone Know?

I run a site based on servlets with a MySQL db on a RaQ 3 with 256M. It seems to do just fine with about 50K page views a day. I'd guess that on your setup I'd be able to run at least 150K pages a day.

Of course it'll depend a lot on how your app is coded. When I first moved onto this machine things crawled. I noticed one particular query was really slow and added an index. It went from a table scan of 60K rows to using the index to get the 250 relevant rows and the server went from a 2 load average with 0% idle CPU to 0.5 load average with 50% idle CPU. I plan to utilize the slow query log to look for other optimizations in the future.

As others have stated... you can't know until you profile your application.

Nice thing is that once you get on your own system, it is pretty easy to tell system load. Just a basic check of:

Number of users on site
RAM usage
CPU usage
Disk usage

I do consulting where I rewrite applications that don't perform well. It amazes me how poorly some are designed. Web developers just don't understand how you have to profile all your pages to find out how much time they take take to execute. Concurrent programming, database record locking, etc.

Other basic things that often web developers overlook... proper database key selection and knowing to add an index to a field. All too often I've seen web developers use text fields for things that are coded better as a INTEGER or SMALLINT. Or text fields that are way oversized...

What about mysql database. How much user can it handel. Can this PIII 933 , 256 MB, 9GB SCSI handel few BBS like webhostingtalk and email service like yahoo.
How often we should reboot the system. Once a week or month.
If the user increase we should increase RAM or Processor.
What will the MAXIMUN output of this server or after how much load this server will crash.
Let't talk about this........ :)

Haha. I'll just blurt it out... these questions are anything but simple. There are so many things that influence this.

A forum of very large size should be able to run on that system. I'm not sure what you mean by "email like Yahoo"...

As for the rest... if you run your system correctly, do a good OS install, keep up on security and bug fixes, no reason it shouldn't run for months at a time.

Maybe someone else can tell you that has this exact configuration... I don't have much else to offer.

I mean by web based email service like yahoo and hotmail.
how many user can use it at one time + BBS + chat service.
How much can this server handel if the OS is linux running apache and Tomcat for servlets.
What will be maximum output of this server.
And when should we reboot our server. After one week or month or daily.

How better is Dual 550 MHZ than 933 single processor.

You may want to try some web perfomance stress tools, there are hundreds of them:

http://google.yahoo.com/bin/query?p=web+stress+testing&hc=0&hs=2