MySQL Load with PHP

[Peter Bach]

Would a medium sized (~500 pages) database driven website, search
engine and mailing list be too much for one MySQL database? Instead of
making using different databases I would use different tables. I would
use PHP for all of this.

Any help would be greatly appreciated.

[Michael Austin]

Re: MySQL Load with PHP

Peter Bach wrote:
[color=blue]
> Would a medium sized (~500 pages) database driven website, search
> engine and mailing list be too much for one MySQL database? Instead of
> making using different databases I would use different tables. I would
> use PHP for all of this.
>
> Any help would be greatly appreciated.[/color]

that will depend on the OS and hardware involved and the number of
anticipated hits. for maybe a few hundred hits a week it might not be
too bad, but if your talking many hits per minute, then you might want
to use something better. MySQL was designed to used in small-ish
environments, but some people seem to push whatever technology to the
edge of the envelope. Try to ensure that your database "doesn't
matter". And by that I mean that you will be able to move it to a more
enterprise-class database engine if need be (I currently do not consider
SQL Server to be "Enterprise " class, although there are those who would
disagree with me :)....

Michael Austin
DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS).

[Margaret MacDonald]

Re: MySQL Load with PHP

Peter Bach wrote:
[color=blue]
>Would a medium sized (~500 pages) database driven website, search
>engine and mailing list be too much for one MySQL database? Instead of
>making using different databases I would use different tables. I would
>use PHP for all of this.
>
>Any help would be greatly appreciated.[/color]

Not according to the mysql documentation, it wouldn't: 'Handles large
databases. We use MySQL Server with databases that contain 50 million
records. We also know of users who use MySQL Server with 60,000 tables
and about 5,000,000,000 rows.'

HTH,
Margaret
--
(To mail me, please change .not.invalid to .net, first.
Apologies for the inconvenience.)

[Five Cats]

Re: MySQL Load with PHP

In message <qp8sd09pevi442 h8dgl87sg9pe6ks l7ulu@4ax.com>, Margaret
MacDonald <scratch65536@a tt.not.invalid> writes[color=blue]
>Peter Bach wrote:
>[color=green]
>>Would a medium sized (~500 pages) database driven website, search
>>engine and mailing list be too much for one MySQL database? Instead of
>>making using different databases I would use different tables. I would
>>use PHP for all of this.
>>
>>Any help would be greatly appreciated.[/color]
>
>Not according to the mysql documentation, it wouldn't: 'Handles large
>databases. We use MySQL Server with databases that contain 50 million
>records. We also know of users who use MySQL Server with 60,000 tables
>and about 5,000,000,000 rows.'[/color]

Not much help without knowing what the load is, IMHO.
[color=blue]
>
>HTH,
>Margaret[/color]

--
Five Cats
Email to: cats_spam at uk2 dot net

[Garp]

Re: MySQL Load with PHP


"Five Cats" <cats_spam@[127.0.0.1]> wrote in message
news:bQNj+OBTpm 3AFwAS@[127.0.0.1]...[color=blue]
> In message <qp8sd09pevi442 h8dgl87sg9pe6ks l7ulu@4ax.com>, Margaret
> MacDonald <scratch65536@a tt.not.invalid> writes[color=green]
> >Peter Bach wrote:
> >[color=darkred]
> >>Would a medium sized (~500 pages) database driven website, search
> >>engine and mailing list be too much for one MySQL database? Instead of
> >>making using different databases I would use different tables. I would
> >>use PHP for all of this.
> >>
> >>Any help would be greatly appreciated.[/color]
> >
> >Not according to the mysql documentation, it wouldn't: 'Handles large
> >databases. We use MySQL Server with databases that contain 50 million
> >records. We also know of users who use MySQL Server with 60,000 tables
> >and about 5,000,000,000 rows.'[/color]
>
> Not much help without knowing what the load is, IMHO.
>[color=green]
> >
> >HTH,
> >Margaret[/color][/color]

The OP hasn't even mentioned the rate of potential hits, just the size of
the data. To which the answer is "yes, easily". Access speed is a function
of hardware, table design and the ability of the database drivers to handle
multiple concurrent requests. Any shortcoming of those three will drop you
in it; I don't believe MySQL will be the weak link.

Chances are, if the OP is asking about design questions on Usenet, s/he's
not going to be in charge of a project where hit rate is going to be an
issue. No offence. 8)

Garp

[Peter Bach]

Re: MySQL Load with PHP

I use Intel servers with Dual Xeon processors and Linux/Red Hat &
Apache. A "few hundred hits a week" is probably all I'll get. But
traffic may increase...

Michael Austin <maustin@firstd basource.com> wrote in message news:<PnpDc.857 4$_L4.2580@news svr22.news.prod igy.com>...[color=blue]
> Peter Bach wrote:
>[color=green]
> > Would a medium sized (~500 pages) database driven website, search
> > engine and mailing list be too much for one MySQL database? Instead of
> > making using different databases I would use different tables. I would
> > use PHP for all of this.
> >
> > Any help would be greatly appreciated.[/color]
>
> that will depend on the OS and hardware involved and the number of
> anticipated hits. for maybe a few hundred hits a week it might not be
> too bad, but if your talking many hits per minute, then you might want
> to use something better. MySQL was designed to used in small-ish
> environments, but some people seem to push whatever technology to the
> edge of the envelope. Try to ensure that your database "doesn't
> matter". And by that I mean that you will be able to move it to a more
> enterprise-class database engine if need be (I currently do not consider
> SQL Server to be "Enterprise " class, although there are those who would
> disagree with me :)....
>
> Michael Austin
> DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS).[/color]

[Chung Leong]

Re: MySQL Load with PHP

"Garp" <garp7@no7.blue yonder.co.uk> wrote in message
news:MXxDc.4013 $Eg3.43165899@n ews-text.cableinet. net...[color=blue]
> The OP hasn't even mentioned the rate of potential hits, just the size of
> the data. To which the answer is "yes, easily". Access speed is a function
> of hardware, table design and the ability of the database drivers to[/color]
handle[color=blue]
> multiple concurrent requests. Any shortcoming of those three will drop you
> in it; I don't believe MySQL will be the weak link.[/color]

Not that having multiple databases would have any material affect on server
load. We are still dealing with the same amount of data regardless of how
you divide it up.

[Blah]

Re: MySQL Load with PHP

MySQL will quite easily handle this. In any case this could be
considered over-kill. SQLite could even handle this.

Grant

Peter Bach wrote:
[color=blue]
> I use Intel servers with Dual Xeon processors and Linux/Red Hat &
> Apache. A "few hundred hits a week" is probably all I'll get. But
> traffic may increase...
>
> Michael Austin <maustin@firstd basource.com> wrote in message news:<PnpDc.857 4$_L4.2580@news svr22.news.prod igy.com>...
>[color=green]
>>Peter Bach wrote:
>>
>>[color=darkred]
>>>Would a medium sized (~500 pages) database driven website, search
>>>engine and mailing list be too much for one MySQL database? Instead of
>>>making using different databases I would use different tables. I would
>>>use PHP for all of this.
>>>
>>>Any help would be greatly appreciated.[/color]
>>
>>that will depend on the OS and hardware involved and the number of
>>anticipated hits. for maybe a few hundred hits a week it might not be
>>too bad, but if your talking many hits per minute, then you might want
>>to use something better. MySQL was designed to used in small-ish
>>environment s, but some people seem to push whatever technology to the
>>edge of the envelope. Try to ensure that your database "doesn't
>>matter". And by that I mean that you will be able to move it to a more
>>enterprise-class database engine if need be (I currently do not consider
>>SQL Server to be "Enterprise " class, although there are those who would
>>disagree with me :)....
>>
>>Michael Austin
>>DBA (Oracle and OracleRdb - formerly DEC Rdb on OpenVMS).[/color][/color]