Bonjour Christophe, > I have a 200Mhz + 64 mo + 2Go > > I want install php + mysql + apache => easyPhp > > But what is better ? Windows ( which?) or Linux ( which?)
NB I have re-attached the MySQL list address, because I think others will be able to offer better advice than can I. Has anyone conducted a like-for-like performance comparison between OpSys? I currently use Windows to run the PHP Triad (PHP, MySQL, Apache). This is because I had (paid for) the Windows machine already, and I run other applications which are Windows-compatible (shush - don't tell any of our "*nix is the best" list-colleages!) However I am learning about 'open systems' and will shortly attempt my first Linux system, and am planning for the full LAMPs environment to follow... Reading the section of the manual I quoted earlier (2.2.2 ), and then "2.6.2.7 MySQL-Windows Compared to Unix MySQL", I find no direct performance comparisons. There is mention of one or two 'disadvantages' to using Windows though. Overall I get the impression that MySQL is first developed on the Sun and SuSE systems. It is tested under Windows subsequently. This implies that if there are any compromises to be made, they will likely disadvantage the Windows implementation. (IMHO!) However, I have had no problems running MySQL/the Triad under Windows - I am not running a system that is particularly demanding of its back-end database. As far as the different Win32 implementations are concerned, my views (FWIW) are: that it is too early for WinXP, and that I wouldn't expect Win9n to run any form of daemon well (they weren't built to do it/don't have named pipes, etc), so that leaves NT (which I have used for years) or 2000 (which I have also used, but not been sufficiently motivated to upgrade my own machines to use). When it comes down to a decision (at home) I'm thinking that it depends upon what you have now. If you have Win2000, use it. If you have Linux, use it. If you currently have Win95 and no compulsion to stay in the M$ doma in, save money and upgrade to Linux. As far as the hardware goes, I would think carefully. If you have a demanding application, once development is complete you will probably want to run it on a newer PC. My CPU is 266MHz and it's fine for what I'm doing. The 64MB of RAM will let you down first - this amount is ok for a user machine, but a server needs more RAM to support the 2 or 3 servers (daemon software) and multiple user-accesses. Similarly the HDD sounds 'old', and depending upon your application may be too small/too slow. However these two 'obvious' discussion points pale into insignificance: which operating system do you know how to use? If you have to learn a whole new set of skills to use the OpSys before you can start, then that is going to interfere with your MySQL/PHP progress in a big way, isn't it!? If you are planning a major/professional application you may want to think about getting 'the best'. If you are starting off at home, learning a little at a time, then you'll most likely be quite happy with what you have - and when you're ready to 'fly', you'll be prepared to spend some money on traveling 'first class'! Please let me know if my choice of language/words was not clear to you. A bientot, =dn > -----Original Message----- > From: DL Neil [mailto:[EMAIL PROTECTED]] > Sent: lundi 21 janvier 2002 15:39 > To: [EMAIL PROTECTED] > Subject: Re: Suse V/S Redhat - mysql performance difference. > > Particularly given MySQL AB's comments in 2.2.2 Operating Systems > Supported by MySQL. > =dn > > > > Jatin Nansi wrote: > > >I have 2 servers 1 running redhat 7.2 and the other running suse 7.3. > > >the hardware config is : > > >RH7.2: Fast desktop (IDE HDD/128 MB memory PIII 550 MHz). > > >Suse 7.3: Low end server (Ultra SCSI 2, PIII 850 MHz, 256 MB RAM). > > >Now i expect to see the suse server go faster than RH, but i am > > >having the reverse happening. The RH server returns a query about > > >5 times faster. > > > [here be snippage....] > > > > Jatin, not sure about the low level stuff in MySQL, but a couple of > things > > occur to my challenged brain: > > 1. It's not necessarily true that a U-SCSI system will go faster > than an > > IDE one. I've seen some pretty convincing > > benchmarks with 'old' 7200 rpm SCSI disks against the latest 7200 > ATA-100, > > which show that the IDE system is faster > > in real world tests. Now if it were a 10K UltraStar disk on a fancy > U160 > > controller, that might be different.... > > 2. Check what else the Suse system has installed and is running in > the > > background. I've migrated my two systems, > > (Athlon-based 'base' station and PII/266 laptop) to Suse 7.3 from > RH7.0, > > and there appears to be way more background > > systems running on Suse than on the old RH one. (Like why do > > Mandrake/Suse/RedHat insist on running the PCMCIA service > > on a system that doesn't have PCMCIA sockets?) > > 3. What file system are you running. I've heard that ReiserFS, and > > journalling systems in particular, make better use > > of the device-peering facilities that SCSI has, presumably where > you've got > > a multi disk setup. > > > > That said, I'm concerned about the 5x difference. If this is the same > RPM > > binary (from MySQL where else?), then I'd be VERY > > tempted to put in a support call or, failing that, raise it on one of > the > > Suse user lists. At the end of the day, the best way to benchmark > > OSs is to put one on, do the tests, then clear system, install OS#2 > and > > repeat test. > > > > --------------------------------------------------------------------- > 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 > > > _________________________________________________________ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > --------------------------------------------------------------------- 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
