Yes, that is what I meant. Thank you for the clarification and response. Any ideas on maximizing *server* performance besides the usual db-specific optimizations like indexing? If not too much trouble, could you give me a brief explanation why I would not see a performance boost if running separate servers on the same box? My thoughts, if have one MySQL server running on one box with 10 databases, and 1 or 2 of those databases are getting the majority of the requests and tying up the processes, seems like the other 8 would suffer.
----- Original Message ----- From: "Iikka Meriläinen" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Cc: "Raymer, Chris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 12:42 AM Subject: Re: mysqld_multi On Wed, 6 Nov 2002, Paul DuBois wrote: > At 13:22 -0600 11/6/02, Raymer, Chris wrote: > >Any opinions on running mysqld_multi? Our architecture, X-serve, > >2GBs RAM,Dual Procs, 480 GB stogage as "Master" MySQL server > >replicated to a less impressive server. Seems logical to separate > >the "heavy-hitter" dbs to their own "servers" and take more > >advantage of the server's resources. > > What's this got to do with mysqld_multi, which is used for running > multiple servers on the *same* machine? Hi! Maybe Mr. Raymer means that he would get more performance when running multiple _MySQL_ servers (i.e. instances) on a same _physical_ server (i.e. box). Getting more performance this way is unfortunately a false assumption, though. More stability, perhaps, but not performance. Iikka ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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