Hi,
MySQL don't seems to use IPC.!?...Strange ..!?...And if Shaun will need
"real-time" response from RDBMS,in my opinion, is strongly recomended to set
up MySQL on the other host.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
To: Shaun Bramley <[EMAIL PROTECTED]>
Cc: Jason Yates <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 6:20 PM
Subject: RE: mysql speed concerns
> 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.
>
> file://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
>
>
---------------------------------------------------------------------
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
