*Hi JS,* I never see socket file on MS Windows...are you sure about it? But, the other question is "*yes*", if you make a connection with the MySQL Server (mysqld) using -h localhost, you will connect with the server using a socket file (linux only), but, if you make using -h 127.0.0.1, TCP/IP will be use.
*See this: * *--protocol<http://dev.mysql.com/doc/refman/5.0/en/connecting.html#option_general_protocol>Value * *Connection Protocol* *Allowable Operating Systems* TCP TCP/IP connection to local or remote server All SOCKET Unix socket file connection to local server *Unix only* PIPE Named-pipe connection to local or remote server Windows only MEMORY Shared-memory connection to local server Windows only *Source*: http://dev.mysql.com/doc/refman/5.0/en/connecting.html -- Wagner Bianchi 2010/1/29 Jerry Schwartz <jschwa...@the-infoshop.com> > *From:* Wagner Bianchi [mailto:wagnerbianch...@gmail.com] > *Sent:* Thursday, January 28, 2010 2:03 PM > *To:* Jerry Schwartz > *Subject:* Re: WAMP vs LAMP > > > > [JS] The file paths were all the same, actually, and the address for MySQL > is just “localhost”. > > [WB]*Consider to use MySQL on Unix like environment because the socket > file. This way you will get more performance then use TCP/IP on MS Windows > *. > > > > *[JS] That’s an interesting suggestion. Windows has socket files, but I’ve > never looked at them. In fact, I don’t even know if MySQL can us a socket > file and TCP/IP at the same time. We’re going to have more ODBC traffic > than web traffic, I expect.* > > > > Regards, > > > > Jerry Schwartz > > The Infoshop by Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > www.the-infoshop.com > > > > * * > > > > > > Best regards. > > -- > Wagner Bianchi > > 2010/1/28 Jerry Schwartz <jschwa...@the-infoshop.com> > > > > From: vegiv...@gmail.com [mailto:vegiv...@gmail.com] On Behalf Of Johan De > Meersman > Sent: Wednesday, January 27, 2010 12:18 PM > To: Jerry Schwartz > Cc: shawn.gr...@sun.com; Daevid Vincent; Dan Nelson; mysql@lists.mysql.com > Subject: Re: Event feature already working in Server 5.1.37 > > > > > > On Wed, Jan 27, 2010 at 5:52 PM, Jerry Schwartz < > jschwa...@the-infoshop.com> wrote: > > [JS] I second this. Instead of using a LAMP development environment, I went > with WAMP -- even though our production environment was LAMP. > > > Generally a bad idea - you keep running into annoying minor differences > between the systems. File paths, for example :-) > > > > [JS] The file paths were all the same, actually, and the address for MySQL > is just “localhost”. > > > > I’ve only run into one incompatibility, and that one bit me yesterday: On > Windows, the PHP rand() function has a native range of 1 – 32767. I replaced > that with a call to mt_rand(), and all’s right with the world. (Why are we > using random numbers? It would take a psychiatric evaluation of my > predecessor to determine that.) > > > > It was a lot easier than setting up LAMP in a virtual machine. > > > I'll set up up in under an hour, if you want :-) > > > > [JS] I’m sure you could. I actually did, before deciding that it wasn’t > worth it what with the port forwarding and all. > > > > When we shut down our LAMP > site for cost reasons, I moved it to a WAMP environment that I bought off > the > > > Wait. You shut down machines for cost reasons, and then go buy new ones ? > > > [JS] The one we shut down was externally hosted, and had > customer-accessible information on it. When management decided to > consolidate our customer-accessible sites in Japan, there was no reason to > have our administrative stuff hosted externally. > > > > shelf for $800. For that money I got 8GB of RAM, four cores, and a RAID > controller. Another $90 for a second drive, and I've got mirroring going. > > Granted, it's a low-traffic site used for internal administration; but I > think > this box could handle a lot more traffic than it does. It seems to be > loafing > all of the time. > > > Oh, probably. Webserving isn't all that hard of a job, if the site is > reasonably well-designed. If you're implying that the LAMP setup you had > earlier didn't perform quite as well, though, I'll go out on a leg and say > that it probably wasn't managed very well. > > > [JS] It was fine. > > > > It's a home/SOHO/gamer system, so it probably isn't as > physically robust as a "server" grade machine at twice the price; but if it > dies, I can be up and running on a newer, bigger, cheaper machine in little > more than the time it takes me to run to the nearest big-box store. > > > True. Me and my server grade machine, however, will not have had that > downtime, because I'll have been notified that a redundant component has > failed, and will have replaced it while the machine was running. > > It's ultimately a matter of how much your uptime is worth to you, and keep > in mind that on a saturday evening you may not even find a new machine until > monday morning, and then you still have to start installing everything, not > to mention find the latest backups of your data. > > Me, I'll go for the expensive server ones for my professional needs, thanks > :-) > > > > [JS] Since this is used internally by a relatively small number of people, > the cost of downtime is mostly my embarrassment. Our stores are open on > Sundays. The ones who would scream are the two in our Tokyo office who use > it for a few minutes when they come in. There’s nothing I can do about that. > > > > > > Regards, > > > > Jerry Schwartz > > The Infoshop by Global Information Incorporated > > 195 Farmington Ave. > > Farmington, CT 06032 > > > > 860.674.8796 / FAX: 860.674.8341 > > > > www.the-infoshop.com > > > > > > > > > > > -- > Bier met grenadyn > Is als mosterd by den wyn > Sy die't drinkt, is eene kwezel > Hy die't drinkt, is ras een ezel > > >
