Hi,
About at the same IPC(semaphore,share memory,message) i make references
too.Are more ways to made a inter process communication mechanism.
For example, in my applications i don't use semaphores and messages.This are
system functions available from the Kernel.
If you type "ipcs" you can see that mySQL don't use the system functions for
inter process communication.
My opinion is referencing at, if this CGI (about Shaun said early) retrieve
huge data from RDBMS ,sure can create unbalanced processes.
For this reason i "said" it's "strongly recommended to setup MySQL on the
other host".
I have a bad experience with INFORMIX mounted on SCO running in a dual XEON
machine.And i think SCO it's more stable than Linux.
Of course who use mainframe don't must have any concern.
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: 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 Communication - any process that wants
> to talk with something else than with it self _needs_ necessarily IPC.
>
> Particularly an RDBMS needs IPC - otherwise it is useless.
>
> Anyhow. one way one might get faster performance could be to
> (if possible with the OS) move the swap space from disk into
> RAM instead. Or even better for speed and response time
> don't use swap at all! - but then you must know how much
> RAM memory your system will consume - otherwise you might
> get into big trouble. It is not impossible to estimate
> this, but tricky. One way could be to 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 speed concerns
> >
> >
> > 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
> > > >
>
---------------------------------------------------------------------
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
