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
t;; <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 7:32 PM
Subject: RE: mysql speed concerns
> With IPC I mean Inter Process Communication - any process that wants
> to talk with something else than with it self _needs_ necessarily IPC.
>
> Particularly an RDBMS needs IPC - othe
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
quot;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
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 t
14 matches
Mail list logo
