Re: Moving MySQL to its own host

On Mon, Jun 25, 2007 at 08:18:23PM -0400, Jonathan Yu wrote:
>
> There is a lot of overhead for databases because they need to maintain
> ACID compliance; thus they tend to be really disk-intensive. Apache
> and MySQL will both compete for the disk as well as the CPU, which is
> why there are scalability issues for large web sites.
>

Two things:

• calling MySQL ACID compliant is a bit of a stretch
• if Apache is hammering your disk, then you very likely don't have enough RAM (unless your website has gargantuan amounts of content not in a database with a fairly uniform access pattern)

Regards,

-Roberto

P.S. Please don't top post.

-- 
Roberto C. Sánchez
http://people.connexer.com/~robertohttp://www.connexer.com

-- To UNSUBSCRIBE, email to debian-isp-REQUEST@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org