Re: [cobalt-users] MySQL Load Limits (especially on a RaQ2)

["J. Masterson" <masterson@xxxxxxxxxxxx>]

I wouldn't call myself a MySQL expert, but I worked with it at my
previous job as webmaster at the biggest ISP in Montana (yeah, big woop
;).

You'd do well to post your question to the MySQL mailing list, or search
at http://lists.mysql.com/ 

Anyway, I think for queries like you're talking about, the main issue is
going to be RAM... 128 megs won't be enough...

-- 
John Masterson
Web Developer
WAM!NET Missoula
masterson@xxxxxxxxxxxx



Steven Werby wrote:
> 
> MySQL users, I am interested in knowing what MySQL's load limits are on a
> RaQ2 and on a more powerful server?  I know it "depends", but I'm just
> trying to get a feel for what others are getting it to do.  In particular,
> I'm interested in simple to complex queries of large tables (500,000 -
> 10,000,000+ records) in order to return matching records to a webpage using
> PHP.
> 
> I'm looking for responses like "I have a webpage on a RaQ2 that does a
> straight select on a 5 million record table through PHP and that page gets
> 400,000 hits per day, primarily over a 10 hour period with no problems".
> 
> I'm trying to determine whether MySQL is a feasible solution for a project I
> am developing and also whether a RaQ2 or RaQ3 are up to the task.
> 
> Steven {steven@xxxxxxxxxxxx}
> 
> _______________________________________________
> cobalt-users mailing list
> cobalt-users@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-users