TCP/IP is a protocol for data interchange, host to host, on the network
(RFC731).
Sockets ,indeed , are also used for IPC.
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL 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 speed concerns
>
> Technically speaking, TCP/IP communication *is* a form of IPC.
> IPC isn't restricted to semaphores or message queues, etc.
> I think that's what he meant (i.e.: mysql client on one box communicating
> via TCP/IP to a MySQL server on another box).
>
>
> Michael
>
>
>
> On Wed, 1 May 2002, Gelu wrote:
>
> > 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]
.com>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
> --
>
/*--------------------------------------------------------------------------
> * "It might look like I'm doing nothing, but at the cellular level
> * I'm really quite busy."
> * ---anonymous
> *
> *
> * -----BEGIN GEEK CODE BLOCK-----
> * Version: 3.1
> * GCS/P/H/L/O d- s-:-- a26 C++(+++) UL+++$>++++ P++ L+++ !E W+++ N- o? K-
> * w--(---) !O M+ !V PS+ PE- Y-- PGP- t+ 5-(--) X(-) R* tv b+ DI-- D-- G
e+>++
> * h+ r* y--
> * ------END GEEK CODE BLOCK------
> --------------------------------------------------------------------------
*/
>
>
---------------------------------------------------------------------
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
