Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! ??? [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community ? Dear Jerry, Did you means : php (32 Bit) + Apache (32 Bit) + MySQL (32 Bit) on Windows (64 Bit) OS ? [JS] Sorry I didn?�t specify: PHP (32 bit) Apache (32 bit) MySQL (64 bit) Dear Jerry, 1, Would you mind to send me your php.ini for reference ? 2, how to config the php connect to remote MS-SQL 2000 Server ? 3, And do you know does it good for working with aspx and MS-SQL 2000 Server also ? Due to the dot net framework 32Bit / 64Bit problem... Thank for your help ! Edward.
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Did you means : php (32 Bit) + Apache (32 Bit) + MySQL (32 Bit) on Windows (64 Bit) OS ? Thanks ! Edward.
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Did you means : php (32 Bit) + Apache (32 Bit) + MySQL (32 Bit) on Windows (64 Bit) OS ? [JS] Sorry I didn’t specify: PHP (32 bit) Apache (32 bit) MySQL (64 bit) Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 http://www.the-infoshop.com www.the-infoshop.com Thanks ! Edward.
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Friday, January 15, 2010 8:03 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Did you means : php (32 Bit) + Apache (32 Bit) + MySQL (32 Bit) on Windows (64 Bit) OS ? [JS] Sorry I didn� specify: PHP (32 bit) Apache (32 bit) MySQL (64 bit) Dear Jerry, OH 32 Bit php is good for working with 64 Bit MySQL ? Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Dear Jerry, OH 32 Bit php is good for working with 64 Bit MySQL ? [JS] Yes, it's fine. Remember, MySQL is a server - it doesn't care who is on the other end, so long as the queries are properly formed. 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 Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Dear Jerry, Would you mind to tell me how to update ( what tool/editor ) all of your php source code for using with your new version of php and mysql ? [JS] If I had one, I would do it. I've been using an editor named Textpad for a very, very long time but despite its many features I wouldn't recommend starting up with it. For one thing, I don't think it has been under development for years; and the one real problem is that its regular expression handling is always greedy. I'm sure there are better choices. 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 Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
-Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Sunday, January 03, 2010 2:13 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Dear Jerry, Sorry... I just visit www.php.net... BUT I don't quite understanding the online manual: http://www.php.net/manual/en/install.windows.iis.php 1, Which installation mode is suitable of it ? 2, I want to know which tool must we download for install php and related program for IIS of Win2k3 OS ? [JS] Go to http://www.php.net/manual/en/install.windows.installer.msi.php for instructions, and http://www.php.net/downloads.php for the actual PHP 5.2.12 installer download. It should give you the option to configure IIS automatically. I use Apache, not IIS, so I can't help you any further. 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 Many Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags are deprecated in 5.x they are not allowed in 6.x; and the construct ?= $something ? is not allowed. I would have to go through all of our source code with a fine-tooth comb to fix these. We do run an international shop, with heavy use of UTF-8, so the internationalization features of PHP 6.x would be very useful. If you have the time to fix up your PHP code, then I would suggest that you go to 6.x. BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Do you know which version of newer version of php which support the short tags ( allowed ) ? Or would you mind to tell me how to fix the problem of php source code and connect with mysql db ? [JS] I believe that all 5.x versions of PHP support short tags, but there is a setting in php.ini that you have to set. As for your second question, I don� know what you mean. With PHP 5.2.10, I�e used the mysql, mysqli, and PDO interfaces in both procedural and object-oriented forms (just to stretch my mind). I think that anything in 4.x would be using the mysql interface, although I� not positive. In any event, it probably is upward-compatible. You�l want a decent text editor that can search for strings in multiple files, preferably one that can use regular expressions. You really need to check the PHP documentation. Dear Jerry, Sorry... I just visit www.php.net... BUT I don't quite understanding the online manual: http://www.php.net/manual/en/install.windows.iis.php 1, Which installation mode is suitable of it ? 2, I want to know which tool must we download for install php and related program for IIS of Win2k3 OS ? Many Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags are deprecated in 5.x they are not allowed in 6.x; and the construct ?= $something ? is not allowed. I would have to go through all of our source code with a fine-tooth comb to fix these. We do run an international shop, with heavy use of UTF-8, so the internationalization features of PHP 6.x would be very useful. If you have the time to fix up your PHP code, then I would suggest that you go to 6.x. BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Do you know which version of newer version of php which support the short tags ( allowed ) ? Or would you mind to tell me how to fix the problem of php source code and connect with mysql db ? [JS] I believe that all 5.x versions of PHP support short tags, but there is a setting in php.ini that you have to set. As for your second question, I don� know what you mean. With PHP 5.2.10, I�e used the mysql, mysqli, and PDO interfaces in both procedural and object-oriented forms (just to stretch my mind). I think that anything in 4.x would be using the mysql interface, although I� not positive. In any event, it probably is upward-compatible. You�l want a decent text editor that can search for strings in multiple files, preferably one that can use regular expressions. Dear Jerry, Would you mind to tell me how to update ( what tool/editor ) all of your php source code for using with your new version of php and mysql ? Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Monday, December 28, 2009 9:25 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: -Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? [JS] I'm using that combination on 64-bit Vista. The last time I checked, there was no 64-bit Windows build of PHP. Besides, the database engine doesn't (shouldn't) care who it's talking to. Dear Jerry, In our exiting Server, it is running with 4.4.x php and 4.1.x MySQL in Windows 2000 OS... Now, we are planning to upgrade the Windows OS ( of course include Hardware )... BUT I don't know which new version of php and MySQL is compatiable with the source code ( old ) of php and MySQL... So, would you mind to share your experience with us(me) ? [JS] Unfortunately, I� not sure I can help you. Our databases were fairly small (under 2GB total), so I simply did a mysqldump from the old system (Linux) and imported it into the new one (Vista). PHP is going to be more of a problem. There are some compatibility issues between 4.x and 5.x, and more between 4.x and 6.x. We were already running 5.x, so I didn� have a lot of trouble with that. You can probably get things running, but I strongly suggest that you read up on the newer versions of PHP. There are some changes between 5.x and 5.y that you need to pay attention to. The biggest issue will probably be the deprecation of short tags. There is a setting in php.ini that you can change to allow them. Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags are deprecated in 5.x they are not allowed in 6.x; and the construct ?= $something ? is not allowed. I would have to go through all of our source code with a fine-tooth comb to fix these. We do run an international shop, with heavy use of UTF-8, so the internationalization features of PHP 6.x would be very useful. If you have the time to fix up your PHP code, then I would suggest that you go to 6.x. BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community 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 Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags are deprecated in 5.x they are not allowed in 6.x; and the construct ?= $something ? is not allowed. I would have to go through all of our source code with a fine-tooth comb to fix these. We do run an international shop, with heavy use of UTF-8, so the internationalization features of PHP 6.x would be very useful. If you have the time to fix up your PHP code, then I would suggest that you go to 6.x. BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Do you know which version of newer version of php which support the short tags ( allowed ) ? Or would you mind to tell me how to fix the problem of php source code and connect with mysql db ? Thanks ! Edward.
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Tuesday, December 29, 2009 10:35 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: Dear Jerry, Sorry, did you suggest to use 5.x / 5.y ( NO 6.x ) ? [JS] No, I am not saying that. The system I inherited was running 5.x, and I have not had the time nor urgent need to move upwards. There are some incompatibilities that I would have to deal with. For example, although short tags are deprecated in 5.x they are not allowed in 6.x; and the construct ?= $something ? is not allowed. I would have to go through all of our source code with a fine-tooth comb to fix these. We do run an international shop, with heavy use of UTF-8, so the internationalization features of PHP 6.x would be very useful. If you have the time to fix up your PHP code, then I would suggest that you go to 6.x. BTW, would you mind to tell me which newer version of php and mysql are you running now ? Due to I want to download a version of them and do the test under win2003... Then, I want to tell(reply) you the result(stable)! [JS] PHP 5.2.10, Apache 2.2.14 (Win32), MySQL 5.1.36-community Dear Jerry, Do you know which version of newer version of php which support the short tags ( allowed ) ? Or would you mind to tell me how to fix the problem of php source code and connect with mysql db ? [JS] I believe that all 5.x versions of PHP support short tags, but there is a setting in php.ini that you have to set. As for your second question, I don’t know what you mean. With PHP 5.2.10, I’ve used the mysql, mysqli, and PDO interfaces in both procedural and object-oriented forms (just to stretch my mind). I think that anything in 4.x would be using the mysql interface, although I’m not positive. In any event, it probably is upward-compatible. You’ll want a decent text editor that can search for strings in multiple files, preferably one that can use regular expressions. You really need to check the PHP documentation. Thanks ! Edward.
Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Jerry Schwartz wrote: -Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? [JS] I'm using that combination on 64-bit Vista. The last time I checked, there was no 64-bit Windows build of PHP. Besides, the database engine doesn't (shouldn't) care who it's talking to. Dear Jerry, In our exiting Server, it is running with 4.4.x php and 4.1.x MySQL in Windows 2000 OS... Now, we are planning to upgrade the Windows OS ( of course include Hardware )... BUT I don't know which new version of php and MySQL is compatiable with the source code ( old ) of php and MySQL... So, would you mind to share your experience with us(me) ? Anyone can help the problem ? Thanks ! Edward.
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Monday, December 28, 2009 9:25 AM To: Jerry Schwartz Cc: mysql@lists.mysql.com Subject: Re: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Jerry Schwartz wrote: -Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? [JS] I'm using that combination on 64-bit Vista. The last time I checked, there was no 64-bit Windows build of PHP. Besides, the database engine doesn't (shouldn't) care who it's talking to. Dear Jerry, In our exiting Server, it is running with 4.4.x php and 4.1.x MySQL in Windows 2000 OS... Now, we are planning to upgrade the Windows OS ( of course include Hardware )... BUT I don't know which new version of php and MySQL is compatiable with the source code ( old ) of php and MySQL... So, would you mind to share your experience with us(me) ? [JS] Unfortunately, I’m not sure I can help you. Our databases were fairly small (under 2GB total), so I simply did a mysqldump from the old system (Linux) and imported it into the new one (Vista). PHP is going to be more of a problem. There are some compatibility issues between 4.x and 5.x, and more between 4.x and 6.x. We were already running 5.x, so I didn’t have a lot of trouble with that. You can probably get things running, but I strongly suggest that you read up on the newer versions of PHP. There are some changes between 5.x and 5.y that you need to pay attention to. The biggest issue will probably be the deprecation of short tags. There is a setting in php.ini that you can change to allow them. Anyone can help the problem ? Thanks ! Edward.
32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance
-Original Message- From: Edward S.P. Leong [mailto:edward...@ita.org.mo] Sent: Thursday, December 17, 2009 7:25 AM To: mysql@lists.mysql.com Subject: 32bit ( php + mysql server ) on 64bit Windows 2003 Server performance Dear all, Would you mind to give me the suggestion ? I want to use 32bit php and mysql server on 64bit Windows 2003 Server... So, is it possible ( good for work also ) ? [JS] I'm using that combination on 64-bit Vista. The last time I checked, there was no 64-bit Windows build of PHP. Besides, the database engine doesn't (shouldn't) care who it's talking to. 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 Thanks ! Edward. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=jschwa...@the- infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
