List:General Discussion« Previous MessageNext Message »
From:Daniel Koch Date:September 16 1999 3:35am
Subject:Re: Can MySQL handle 20,000+ hits per day???
View as plain text  
Education Image - Omer Altay wrote:

> hi there,
>              Just a technical question: We are about to build a website
> using MySQL as its database
> and PhP on a linux server running Apache Web server, i was just curious
> to see if the MySQL database can handle somewhere between 20,000 -
> 40,000 hits per day, it will roughly have 20 tables with a hell of a lot
> of large sized Blobs. Or should we go something more serious like Sybase
> or Oracle etc...
>

% mysqladmin status

Uptime: 11777943  Threads: 91  Questions: 149901924  Slow queries: 8816
Opens: 39766  Flush tables: 6  Open tables: 127

That's 12 queries/sec over 136 days. (About 1,000,000 queries daily).  Peaks
are around 300-400 queries/sec.   That's a 95%/5% select/insert mix over 40
or so tables, almost always involving a BLOB.

% w

 11:28pm  up 205 days,  2:42,  2 users,  load average: 0.08, 0.09, 0.14

The server isn't sweating much.

I doubt if MySQL will be a bottleneck.


Regards,

Dan Koch

Thread
Can MySQL handle 20,000+ hits per day???Education Image - Omer Altay16 Sep
  • Re: Can MySQL handle 20,000+ hits per day???Joshua Chamas16 Sep
  • Re: Can MySQL handle 20,000+ hits per day???James Manning16 Sep
  • Re: Can MySQL handle 20,000+ hits per day???Daniel Koch16 Sep
    • Re: Can MySQL handle 20,000+ hits per day???Tommie M. Jones16 Sep
      • Re: Can MySQL handle 20,000+ hits per day???cag16 Sep
      • Re: Can MySQL handle 20,000+ hits per day???Daniel Koch16 Sep
  • Re: Can MySQL handle 20,000+ hits per day???Vivek Khera16 Sep
RE: Can MySQL handle 20,000+ hits per day???John Millaway16 Sep