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]> > 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
