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
