DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
-
- Joomla! Virtuoso
- Posts: 3173
- Joined: Sun Apr 16, 2006 12:20 am
- Location: 127.0.0.1
DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
This is the discussion topic for "Tuing for Speed with PHP5 and MySQL 5" located here: http://forum.joomla.org/index.php/topic,88070.
Backup, backup, backup!
The "Master" .htacess file by Nicholas http://snipt.net/nikosdion/the-master-htaccess
The "Master" .htacess file by Nicholas http://snipt.net/nikosdion/the-master-htaccess
-
- Joomla! Apprentice
- Posts: 22
- Joined: Fri Feb 10, 2006 3:43 pm
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
Hi, thank you for the information.
I was wondering if you could recommend a good php accelerator that is opensource/free?
I know of Zend but this is for zend encoded php.
The setting of mysql cache settings does not make massive increases in speed.
I would also be interested if there and tools that can look at your weburl and give you a detailed report as to the efficiency your code is?
Thanks
I was wondering if you could recommend a good php accelerator that is opensource/free?
I know of Zend but this is for zend encoded php.
The setting of mysql cache settings does not make massive increases in speed.
I would also be interested if there and tools that can look at your weburl and give you a detailed report as to the efficiency your code is?
Thanks
-
- Joomla! Apprentice
- Posts: 38
- Joined: Thu Dec 01, 2005 4:38 pm
- Location: Belgium
- Contact:
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
For caching and zipping, check Port80software.com, they have online checks for both content cache settings and page compression statistics.
For profiling code, I guess your best of using a good development suite like Eclipse with the PHP extensions and setting+checking MySQL slow query logs and such.
Zend Performance suite also has built in tools for PHP and SQL performance profiling.
For Windows, you can get the Performance suite for free for development purpouses, don't know about the Linux version.
Also, for IIS, you don't need to use a script like that to compress CSS and JS scripts, you can add that to the metabase.
For profiling code, I guess your best of using a good development suite like Eclipse with the PHP extensions and setting+checking MySQL slow query logs and such.
Zend Performance suite also has built in tools for PHP and SQL performance profiling.
For Windows, you can get the Performance suite for free for development purpouses, don't know about the Linux version.
Also, for IIS, you don't need to use a script like that to compress CSS and JS scripts, you can add that to the metabase.
Last edited by thematrix on Wed Sep 13, 2006 11:25 am, edited 1 time in total.
-
- Joomla! Enthusiast
- Posts: 233
- Joined: Sat Feb 18, 2006 3:31 pm
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
How do I check a shared hosting server to see what they have installed for PHP caching?
-
- Joomla! Apprentice
- Posts: 38
- Joined: Thu Dec 01, 2005 4:38 pm
- Location: Belgium
- Contact:
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
create a file "info.php" with the following code:
and goto to it with your browser.
If you can't find any mention of eaccelerator or APC on that page, it isn't installed.
and goto to it with your browser.
If you can't find any mention of eaccelerator or APC on that page, it isn't installed.
-
- Joomla! Enthusiast
- Posts: 233
- Joined: Sat Feb 18, 2006 3:31 pm
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
Thanks, and this host doesn't have either.
-
- Joomla! Apprentice
- Posts: 38
- Joined: Thu Dec 01, 2005 4:38 pm
- Location: Belgium
- Contact:
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
If the server is setup right you don't even need a cacher.
-
- Joomla! Enthusiast
- Posts: 233
- Joined: Sat Feb 18, 2006 3:31 pm
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
I have to say that I am no server admin (like that wasn't apparent? :P lol) but I would not doubt if the server is not set up with optimum performance in mind. But nothing I can do about who the client chooses to host with...just try to make the best with what I am given, and hope to convince them otherwise down the road.
-
- Joomla! Apprentice
- Posts: 36
- Joined: Sun Jan 28, 2007 8:49 pm
- Location: San Diego
- Contact:
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
I went to port80software.com and discovered that my Joomla's site can definitely benefit from compression / cacheing, etc.
I downloaded the httpzip app (free trial) but I am not sure how to install it on my site....I don't own the server where the site is hosted, so I am not sure how I would run it on my hosting account....Same with the other apps that port80 offers. Can anyone shed light on this for me? I am afraid of just ftp'ing the zip.exe to my root directory and double-clicking to execute it...(if that would even work..) it makes me nervous. I just recently had a site scrambled by running a so-called patch and I don't want to re-live the experience of doing a fresh install of a CMS and re-creating the content.
Any help will be appreciated,
Dougg
I downloaded the httpzip app (free trial) but I am not sure how to install it on my site....I don't own the server where the site is hosted, so I am not sure how I would run it on my hosting account....Same with the other apps that port80 offers. Can anyone shed light on this for me? I am afraid of just ftp'ing the zip.exe to my root directory and double-clicking to execute it...(if that would even work..) it makes me nervous. I just recently had a site scrambled by running a so-called patch and I don't want to re-live the experience of doing a fresh install of a CMS and re-creating the content.
Any help will be appreciated,
Dougg
- Jason
- Joomla! Intern
- Posts: 70
- Joined: Sat Aug 20, 2005 7:08 am
- Location: Midwest, USA
- Contact:
Re: DISCUSSION: Tuning for Speed with PHP5 and MySQL 5
For the 4th step, how would you include this?
In the head area would you do a simple include_once to a php file?
Ex:
Thanks.
In the head area would you do a simple include_once to a php file?
Ex:
Code: Select all
<?php include_once(css_js.php); ?>
web standards and usability expert