server performance help

[Anon]

Hi , i got a question to ask :

A page with 4 sql queries and refresh every 10 secs.
One of the query join between 4 tables which will produce
few hundred of records, but at the end show less than 50 record
to the client.

It's something like stock-exchange.

This page will got around 100 concurrent users which they login
at the same times and view the above page at the same times.
user will keep on open the page 1 to 2 hours

Php + MySql able to support that?
what hardware resources require ? do you think a dedicated linux server
with pentium 3 proccessor and 8 GB RAm able to perform that ?

thanks for ur answer.
regards,Michael

[brandonschnell]

100 users / 10 seconds between refresh = 10 users refresing every second.

10 users * 4 sql queries = 40 sql queries a second.

php will have no problems keeping up, but mysql might. it all comes down to how optimized the join is. make sure you're joining on the index and limit the result set as much as possible. use the sql EXPLAIN command to show how mysql wants to run the query.

if all else fails, use cheap tricks. slow down the refresh rate or run a cron job every minute to generate a static page and let users view that.

[Anon]

While there are 100 concurent users
running the page, minimum is 40 queries
as u mentioned. The server slow
down while there are many users connected
to the server. I had shut down the unneccessary linux services but still
performan slow to the client.

I heard that a dedicated server can handle
100 of websites which got 5000 of user a day.
but for my case, just one application
already running slow.......

any solution ??

regards,
mICHAEL

[smarlowe]

Are each of these pages unique, or are you showing the same page over and over to 100 different people?

If you are showing the same information over and over, then just generate it every minute or so and then serve it up as a static page.

If you are using a small subset of your data set most of the time, harvest that into a static table that is ready to deliver with no joins or complext syntax to it.

Are you writing new data into the database all the time, or is this dataset fairly static? If you're updating it all the time then don't use the stock mysql, move on the either the newer version 4 or postgresql or some other database that supports mixed read/write better than early mysqls do.

Do you have your linux box configured to give up lots of memory to your database application? That will likely help since more buffers in the database layer will lower disk reads / writes.

If each and every one of these views is unique and must be updated every single time, then you'll need to improve your database performance. Postgresql would likely be a better choice than MySQL, but both will need tweaking and performance tuning to keep up with this kind of load likely.