Re: MySQL 3.23.x preformance on MacOS 10.2
At 8:12 -1000 12/17/02, [EMAIL PROTECTED] wrote: Hello all, I have checked the mailing list and the documentation but have been unable to find any information regarding the level of support for MySQL on the MacOS 10.2 platform. After moving a production database from a linux to MacOS 10.2 for development I have noticed that on my MacOS machine there is a significant performance hit on the MySQL server. Perhaps this is just hardware related but it seems as though the performance should be at least comparable on the following machines. Intel Pentium III 933 MHz Mandrake Linux v8.2 No windowing system running 512 MB RAM Query takes about 12 seconds. Apple G4 1GHz MacOS X 10.2 No windowing system running 512 MB RAM Query Takes about 25 seconds. I have noticed that on linux the mysqld runs as many processes and on MacOS 10.2 it runs as a single process. Is this an architectural decision? or have i configured the server incorrectly? Thank you, Christophe Banal No, actually, it always runs as a single process. What you're seeing is that ps reports separate threads as processes on Linux. - 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
Re: MySQL 3.23.x preformance on MacOS 10.2
I'm not surprised OSX is slower than Linux. Apple still has a way to go toward fully optimizing the Unix underpinnings for their hardware. They are also a few versions behind in the BSD they are using. I'm presuming you have similar settings for each setup. As for the processes you see on Linux, in a nutshell Linux used threads and other Unix uses processes. That's one of the fundamental differences between Linux and other Unix flavors. Your actually seeing threads. Threads don't have the launch overhead that a process does so you should get better performance with threads. On Thursday, December 19, 2002, at 01:43 PM, Paul DuBois wrote: Apple G4 1GHz MacOS X 10.2 No windowing system running 512 MB RAM Query Takes about 25 seconds. I have noticed that on linux the mysqld runs as many processes and on MacOS 10.2 it runs as a single process. Is this an architectural decision? or have i configured the server incorrectly? Thank you, Christophe Banal No, actually, it always runs as a single process. What you're seeing is that ps reports separate threads as processes on Linux. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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
Re: MySQL 3.23.x preformance on MacOS 10.2
Having built several Linux boxes on slower macs I can atest that linux on a slower mac (uing linuxppc or one of the other variants) is way faster than my terminal window is on my dual 1.25 gig processor G4. Just accessing commands are slower on the new mac. This surprises me as unix is the base for the operating system on Jaguar just as linuxppc was the base for the slower mac. Gary -- Original Message -- From: Brent Baisley [EMAIL PROTECTED] Date: Thu, 19 Dec 2002 17:03:45 -0500 I'm not surprised OSX is slower than Linux. Apple still has a way to go toward fully optimizing the Unix underpinnings for their hardware. They are also a few versions behind in the BSD they are using. I'm presuming you have similar settings for each setup. As for the processes you see on Linux, in a nutshell Linux used threads and other Unix uses processes. That's one of the fundamental differences between Linux and other Unix flavors. Your actually seeing threads. Threads don't have the launch overhead that a process does so you should get better performance with threads. On Thursday, December 19, 2002, at 01:43 PM, Paul DuBois wrote: Apple G4 1GHz MacOS X 10.2 No windowing system running 512 MB RAM Query Takes about 25 seconds. I have noticed that on linux the mysqld runs as many processes and on MacOS 10.2 it runs as a single process. Is this an architectural decision? or have i configured the server incorrectly? Thank you, Christophe Banal No, actually, it always runs as a single process. What you're seeing is that ps reports separate threads as processes on Linux. -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - 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
MySQL 3.23.x preformance on MacOS 10.2
Hello all, I have checked the mailing list and the documentation but have been unable to find any information regarding the level of support for MySQL on the MacOS 10.2 platform. After moving a production database from a linux to MacOS 10.2 for development I have noticed that on my MacOS machine there is a significant performance hit on the MySQL server. Perhaps this is just hardware related but it seems as though the performance should be at least comparable on the following machines. Intel Pentium III 933 MHz Mandrake Linux v8.2 No windowing system running 512 MB RAM Query takes about 12 seconds. Apple G4 1GHz MacOS X 10.2 No windowing system running 512 MB RAM Query Takes about 25 seconds. I have noticed that on linux the mysqld runs as many processes and on MacOS 10.2 it runs as a single process. Is this an architectural decision? or have i configured the server incorrectly? Thank you, Christophe Banal - 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