469,313 Members | 2,577 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

MySQL handling heavy loads

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
Jul 20 '05 #1
2 2004
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
Jul 20 '05 #2
"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
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by OneSolution | last post: by
reply views Thread by Kayra Otaner | last post: by
10 posts views Thread by smorrey | last post: by
39 posts views Thread by Mairhtin O'Feannag | last post: by
12 posts views Thread by howa | last post: by
15 posts views Thread by Cirene | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.