E COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
To: Gelu <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 2:04 PM
Subject: RE: mysql speed concer
PROTECTED]
- Original Message -
From: Michael Chang <[EMAIL PROTECTED]>
To: Gelu <[EMAIL PROTECTED]>
Cc: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>; Jason Yates
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 10:29 PM
Subject: Re: mysql sp
.sorry ... RFC 793
- Original Message -
From: Gelu <[EMAIL PROTECTED]>
To: Michael Chang <[EMAIL PROTECTED]>
Cc: Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>; Jason Yates
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 10:52 AM
Sub
On Wed, May 01, 2002 at 10:49:36AM -0400, Jason Yates wrote:
> 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
Svensson, B.A.T. (HKG) <[EMAIL PROTECTED]>
> To: Gelu <[EMAIL PROTECTED]>
> Cc: Jason Yates <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Wednesday, May 01, 2002 7:32 PM
> Subject: RE: mysql speed concerns
>
>
> > With IPC I mean Inter Process Communi
> > From: Gelu
> > Sent: Wednesday, May 01, 2002 6:12 PM
> > To: Svensson, B.A.T. (HKG); Shaun Bramley
> > Cc: Jason Yates; [EMAIL PROTECTED]
> > Subject: Re: mysql speed concerns
> >
> >
> > Hi,
> > MySQL don't
Hi,
We have faced this kind of problem for our main web site. When a single
server was not enough any
more (2 years ago), we have separated the database from Apache server.
Last year, we added 3 more Apache servers with load-balancing and
upgraded the database server
with a faster machine (2x1
limit number of
connections/jobs on the machine, and then assume the
worst case scenario from this.
> -Original Message-
> From: Gelu
> Sent: Wednesday, May 01, 2002 6:12 PM
> To: Svensson, B.A.T. (HKG); Shaun Bramley
> Cc: Jason Yates; [EMAIL PROTECTED]
> Subject: Re: mysql sp
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
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
er 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,
>
&
[snip]
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
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 Yat
13 matches
Mail list logo
