.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 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 : [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 > > --------------------------------------------------------------------- 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
