An webserver uses mostly CPU resources while a DB uses I/O, or?
Separation between the webserver and the RDBMS also suggest increased
delays with IPC. I think one needs to find a balance somewhere in between,
and I guess the only way to tell is to actually measure the performance of
the system to see what's need to be adjusted in order to get better
performance.
I would start out by collecting some stats from the RDBMS and the OS, lets
say during a weeks time or so, and then just create dummy instances that
perform the very same things and slowly increases the load in steps in
order to see what happens with the system.
//Anders
> -----Original Message-----
> From: Shaun Bramley [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 01, 2002 5:13 PM
> To: Jason Yates; [EMAIL PROTECTED]
> Subject: Re: mysql speed concerns
>
>
> Hello,
>
> The first thing that I would do would be to separate the DB and apache. Set
> the DB up so that it is on a box of it's own. The system cannot serve pages
> if it is crunching through the db tables looking for information (and vice
> versa).
>
> Shaun
>
> ----- Original Message -----
> From: "Jason Yates" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, May 01, 2002 10:49 AM
> Subject: mysql speed concerns
>
>
> > Currently our MySQL server runs around 20-30 queries per second. The
> > upper management decided they wanted to add about 4 times the customers
> > in the next two or three weeks. I'm worried that MySQL on this
> > particular box won't be able to handle the load of around 100-120
> > queries per second. Not to mention the CGI scripts are also getting run
> > on the same box with apache.
> >
> > The system has 1gb of RAM, 1 Pentium III 700Mhz, and some ultrascsi HDs
> > (no raid), running Red Hat 7.1 and Linux 2.4.6.
> >
> > What are my options here?
> >
> > Replication? I not sure about that since the box is about 60-70% select
> > and the rest inserts and deletes. Won't I lose "real-time" data.
> >
> > I not familiar with any type of load balancing with MySQL? SQL Relay?
> >
> > I also thought of separating the Apache server and MySQL server.
> >
> > I'll take any ideas. I need them pretty bad.
> >
> > -Jason
> >
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
