|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
What version of MySQL, Apache, and PHP versions does your server run? This is for gross curiosity sake... You can find the PHP and Apache versions on a PHPInfo page, you can create this by making a new file named phpinfo.php which contains: The PHP version will be in the top most portion of the page, and the apache version will be in a section like "SERVER_SIGNATURE" or "SERVER_SOFTWARE". You can find your MySQL version on the landing page of PHPMyAdmin. Specifically I'd like to know the MySQL version (Either Pre-4, 4, 4.1, or 5+)
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Optimization // Encoding Do you have Zend Optimizer or IonCube installed? These will show on the PHPInfo script mentioned in my aforementioned post in the area mentioning: This program makes use of the Zend Scripting Language Engine it will specifically mention IonCube or "Zend Optimizer" if installed (there are several Zend extensions pre-installed, we're specifically looking for Zend Optimizer here).
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
grazie
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
I run 3 different configurations so far Server 1 (Debian 3.1 32-bit): Lighttpd with PHP 5.2.3, APC Cache and MySQL 5.0.45 Server 2 (Debian 3.1 32-bit): Apache 1.3.33 with PHP 4.4.7, eAccelerator and MySQL 5.0.45 Server 3 (Debian 4.0 64-bit): Apache 2.2.3 MPM Worker with FastCGI module and PHP 5.2.0 and PHP 4.4.4 (switchable for each virtual host), APC Cache, ionCube Loader and MySQL 5.0.32. Zend Optimizer 3.3 was originally also installed, but I removed it because of incompatibilities with APC Cache
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
PHP 4.4.4 MySQL 4.1.20 Apache 2.0 Zend
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Hey Phillip, how do APCCache and eAccelerator work for you? I was reading up on some of them some time ago but couldn't find any decent real world findings of true benefits... BTW, all is looking well at this point, I'm seeing that so far everyone (who's at least cared to share) is running MySQL 4.1 (vs 4.0), so that at least allows for some of what I was looking for... So thanks to everyone who's voted, feel free to vote more though ...
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
IIS6, PHP 5.20, MySQL 5.027 IIS6, PHP 5.23, MySQL 5.045
Don't see option (aside from other) for IIS7, PHP 6.0, MySQL 6.0 Will be attempting to set that up this week if time permits.
Well might be difficult to locate but I would assume that someone has those details for hosting providers - ie. I would think that the majority have 4.1 and up for MySQL and unfortunately 4.x for PHP as well.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Don't see option (aside from other) for IIS7, PHP 6.0, MySQL 6.0 Well, thats not really a "standard webhosting" environment, so that's why I threw out other ... Honestly, all I care about is apache or iis, mysql pre/post 4.1, php pre/post 5 ...
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Okay just saying. IE7 is coming and I'm sure that with that you will start to see even more Hosting Companies offering it.
I know you're not a MS fan there Giz but some of the new stuff from IIS7 will help it to grab even more Web Server share of the market I'm sure.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
iis6, mssql 2005, asp.net clr2, clr3 (x2) -- also has wamp for local testing apache2, mysql 5.latest, php 5.2.3 (x2) no zend optimizer, because i don't run 'zen guarded' php code. ps: i'd be interested to know more about eAccelerator too.. since i can install it, if it's worth it
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
It wasn't an OS thing here NT, it was more a "production" thing...
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
It wasn't an OS thing here NT, it was more a "production" thing... No, I fully understand. Just saying that you're asking about this for some potential upcoming coding that would require dropping support for anything pre 4.1 for MySQL isn't that the quest? So, if so then just saying that I think one of the sites that gathers that information might be a better overall look as to what sites are running. Potentially (haven't looked yet) that the overall numbers (in the millions) might be very small for pre 4.1 Even if a hundred people replied (I seriously doubt that will happen) that still leaves hundreds if not thousands of UBBT users that have not or will not reply here. Thus an overall view of hosting companies might provide more information. AS for Windows either current or up coming I would venture to say that the numbers for pre 4.1 MySQL are very small (just my guess) If I'm off target for the overall quest then I apologize for that.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
No, I fully understand. Just saying that you're asking about this for some potential upcoming coding that would require dropping support for anything pre 4.1 for MySQL isn't that the quest? Generally... Since 4.0 isn't really available I wanted a rough draft of if anyone was actually using it... So, if so then just saying that I think one of the sites that gathers that information might be a better overall look as to what sites are running. Potentially (haven't looked yet) that the overall numbers (in the millions) might be very small for pre 4.1 AA had the same sugguestion; the problem here is that most of these sites auto read some information based on what your system provides them publicly, the MySQL version isn't displayed openly... Even if a hundred people replied (I seriously doubt that will happen) that still leaves hundreds if not thousands of UBBT users that have not or will not reply here. Thus an overall view of hosting companies might provide more information. well, I just want a rought "shout" of what's actually being used, by those who don't mind providing that information... as the above information isn't really accurately obtainable imo.
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
I would have thought that Threads could easily move to 4.1 and above now.
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
how do APCCache and eAccelerator work for you? I was reading up on some of them some time ago but couldn't find any decent real world findings of true benefits... That depends on the website. You see no big difference on a site with 1-2 visitors daily but on sites with a few thousand visitors. Opcode accelerators such as APC or eAccelerator can dramatically decrease the server load on high traffic websites. I would suggest APC over eAccelerator after it is (or was planned to become) part of PHP 6. The windows package of PHP comes already with the APC cache extension though.
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
Don't think you need zend guarded code to run the optimizer. At least you didn't need to last time I messed with it. But that's been a couple of years.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Phillip, thanks for the heads up, will give it some definate thought . And dave, as usual, thanks for the idea ...
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
well, then i'd be curious as to which accelerator (if any) is the way to go ..
zend eAccel ACP
?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Well, I was thinking, but could be mistaken as dave said otherwise, that zend items needed to be zend encoded... I believe several of the guys at UBBDev are actually Zend certified so they may be the ones to ask...
So if it was a choice between eAccel and ACP then I may be willing to take phillip's sugguestion...
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
Okay just saying. IE7 is coming and I'm sure that with that you will start to see even more Hosting Companies offering it. IE7 is here.
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
Well at least someone is reading.
I meant IIS7 (Internet Information Services)
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
Leave it to me NOT to read the next page lol
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
Well, I was thinking, but could be mistaken as dave said otherwise, that zend items needed to be zend encoded... I believe several of the guys at UBBDev are actually Zend certified so they may be the ones to ask... Zend Optimizer will optimize visible source scripts as well, but it is nowhere near as fast as Opcode cache accelerators. So if it was a choice between eAccel and ACP then I may be willing to take phillip's sugguestion... Another good reason to go with APC is that Rasmus Lerdorf (the father of PHP ) is one of the project leads.
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
You know, something tells me that ACP at this point has won out lol... Wonder if it's in the yum repo :x...
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
Is PEAR install on your server? Then just run:
|
|
|
|
Joined: Nov 2006
Posts: 3,095 Likes: 1
Carpal Tunnel
|
Carpal Tunnel
Joined: Nov 2006
Posts: 3,095 Likes: 1 |
If you have PHP 5.20 there was an error in the PEAR module that prevents it from completing properly. There is a fix available on the site though.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
well Philipp, i'm going to give APC a shot and see what it does.. thanks for the input(s).
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
I can't get APC to compile on my Mac. I'm going to try the other one.
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
Compile? On a Mac? Get the MAMP instead http://www.mamp.info/en/download.htmlMAMP 1.7 Included applications and libraries:
Apache 2.0.59 MySQL 5.0.33 PHP 4.4.4 & 5.2.0 APC 3.0.14 eAccelerator 0.9.5 XCache 1.2.0 phpMyAdmin 2.9.2 Zend Optimizer 3.2.2 SQLiteManager 1.2.0 Freetype 2.3.0 t1lib 5.1.0 curl 7.15.5 jpeg 6b libpng-1.2.15 gd 2.0.28 libxml 2.6.27 libxslt 1.1.20 gettext 0.16.1 libidn 0.6.14 iconv 1.11 mcrypt 2.5.8 YAZ 3.0.6 & PHP/YAZ 1.0.12 Yes, you can switch between APC Cache, eAccelerator, XCache and Zend Optimizer
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
No, thank you. I have almost everything on that list installed already.
I have it compiled finally. I figured out the problem there. Now I'm running into problems with shared memory settings, which I'll need to work out regardless which cache I use.
Last edited by David Dreezer; 08/17/2007 6:56 PM.
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
holy crap. i can notice an improvement on load times with APC.
ty Philipp!
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
see, my bored little threads breed decent discussions!
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
well.. it's noticeable.. i guess i can do timings, but i don't want to go back to the old configuration to time it
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
No, thank you. I have almost everything on that list installed already. Many things (Apache etc.) are already installed on any Macintosh The main advantage of MAMP is that it is an independent installation that will not touch any system files or installations. I use MAMP on my 3 Mac’s for development and I am pleased with it. well.. it's noticeable.. i guess i can do timings, but i don't want to go back to the old configuration to time it Here are some benchmarks: http://itst.net/wp-content/uploads/2006/10/PHP%20Bytecode%20Cacher%20Review.html
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
nice chart!
i notice there is a GUI for APC and it says '3rd party' -- can you tell me what that is ?
|
|
|
|
Joined: Jul 2006
Posts: 116 Likes: 4
Member
|
Member
Joined: Jul 2006
Posts: 116 Likes: 4 |
The GUI shows which PHP scripts are cached and a few other details. Here are screenshots from an older version: http://www0.fh-trier.de/~beckerr/apcphpgui.phtml The GUI is now official part of APC
|
|
|
|
Joined: Apr 2007
Posts: 3,940 Likes: 1
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
oh.. oops.. i didn't know that.. i just untar'ed and did the pear install.. didn't look for a gui option..
ty
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
No, thank you. I have almost everything on that list installed already. Many things (Apache etc.) are already installed on any Macintosh The main advantage of MAMP is that it is an independent installation that will not touch any system files or installations. I use MAMP on my 3 Mac’s for development and I am pleased with it. well.. it's noticeable.. i guess i can do timings, but i don't want to go back to the old configuration to time it Here are some benchmarks: http://itst.net/wp-content/uploads/2006/10/PHP%20Bytecode%20Cacher%20Review.html I do know what MMAMP is but I don't want more than one installation of anything on my computer. That leads to more confusion that I need. I've got the latest MySQL on here, the latest PHP, and the version of Apache that I want to run. Honestly, I can't stand downloading someone else's package which for one probably isn't built the way I want it, and for two sits next to an existing installation creating a huge path nightmare. While I appreciate the recommendation it's just not to my liking.
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
0 members (),
834
guests, and
246
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|