MySQL handling heavy loads

[T. Elsas]

Has anyone used MySQL in a public web site environment that receives 1
- 1.5 million sessions/day? Sessions are mostly content and light
commerce.

Site spikes to 3 million sessions/day about 4 times/year.

Trying to find a good example of MySQL holding up under this kind of
load.

Thanks!

T. Elsas

[Wouter]

Yes..
I have.. :)

0.5 milion in 3 hours (every week).

The best you can do is buy a very fast, dual (or more better) processor
decated system, lots of memory and remove as much overhead as possible.

You have to calculate the most buzziest time;

3 milion a day or...
1 milion in 4 hours and 2 in 20 hours.., or
what is the most buzziest minute?

, be more detailed on that for yourself.
And then try to get the connection+query time much below the avarage time
you have for one session in that minute.
It's not enough to get it at the avarage time you have for one session.

Wouter
"T. Elsas" <te****@interlign.net> wrote in message
news:cd**************************@posting.google.c om...
: Has anyone used MySQL in a public web site environment that receives 1
: - 1.5 million sessions/day? Sessions are mostly content and light
: commerce.
:
: Site spikes to 3 million sessions/day about 4 times/year.
:
: Trying to find a good example of MySQL holding up under this kind of
: load.
:
: Thanks!
:
: T. Elsas

[steve]

"telsas" wrote:

Has anyone used MySQL in a public web site environment that receives 1 - 1.5 million sessions/day? Sessions are mostly content and light
commerce.

Site spikes to 3 million sessions/day about 4 times/year.

Trying to find a good example of MySQL holding up under this kind of load.

Thanks!

T. Elsas

I belive mysql holding up to a large part (maybe 90%) would depend on
proper structuring of table indecis. Make sure thare are NO table
scans (of larger tables) in queries. This makes a tremendous
difference. Presuming you have root access, enable slow query log for
mysql (see mysql docs), and optimize every query that is hanging up
and not performing in subsecond.

steve

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-handli...ict166762.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=560125