.sorry ... RFC 793
----- Original Message -----
From: Gelu <ggelu@stripped>
To: Michael Chang <miranda@stripped>
Cc: Svensson, B.A.T. (HKG) <B.A.T.Svensson@stripped>; Jason Yates
<jyates@stripped>; <mysql@stripped>
Sent: Thursday, May 02, 2002 10:52 AM
Subject: Re: mysql speed concerns
> 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 : gg@stripped
> gelugogancea@stripped
>
> ----- Original Message -----
> From: Michael Chang <miranda@stripped>
> To: Gelu <ggelu@stripped>
> Cc: Svensson, B.A.T. (HKG) <B.A.T.Svensson@stripped>; Jason Yates
> <jyates@stripped>; <mysql@stripped>
> 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 : gg@stripped
> > > gelugogancea@stripped
> > >
> > > ----- Original Message -----
> > > From: Svensson, B.A.T. (HKG) <B.A.T.Svensson@stripped>
> > > To: Gelu <ggelu@stripped>
> > > Cc: Jason Yates <jyates@stripped>;
> <mysql@stripped>
> > > 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; mysql@stripped
> > > > > 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 : gg@stripped
> > > > > gelugogancea@stripped
> > > > > ----- Original Message -----
> > > > > From: Svensson, B.A.T. (HKG) <B.A.T.Svensson@stripped>
> > > > > To: Shaun Bramley <s_bramley@stripped>
> > > > > Cc: Jason Yates <jyates@stripped>;
> <mysql@stripped>
> > > > > 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:s_bramley@stripped]
> > > > > > > Sent: Wednesday, May 01, 2002 5:13 PM
> > > > > > > To: Jason Yates; mysql@stripped
> > > > > > > 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 <mysql-thread107739@stripped>
> > > To unsubscribe, e-mail
<mysql-unsubscribe-miranda=uranus.com@stripped
> .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 <mysql-thread107785@stripped>
> To unsubscribe, e-mail <mysql-unsubscribe-ggelu=arctic.ro@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
