[UPHPU] Running out of ideas to speed up a site
wattwood at gmail.com
Sat Mar 1 10:50:52 MST 2008
You might also look into the MySQL configuration file to check your
memory settings for queries and query caching.. I had three quad-core xeon
machines running and a single query brought down the MySQL database running
4GB of ram -- I went in and re-created the entire configuration file with
all needed options and it's running like a beast.
I also recommend upgrading PHP and not using CGI. You might be running
into an instance where there are too many connections. One other thought is
your internet connection to that server-- it might be worthwhile to install
a 2nd or 3rd NIC card for communications.
On Sat, Mar 1, 2008 at 10:24 AM, Jason Porter <lightguard.jp at gmail.com>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
> Rusty Keele was heard saying on 03/01/2008 09:31 AM:
> | Hey,
> | Here are some ideas:
> | - Statistics scripts like Stat Counter can load slowly if their site
> is having problems or under heavy load
> | - Poorly written database queries can really drag performance down.
> Is there anywhere you could use one query instead of multiple calls to
> the db?
> | - You could install the Firebug add-on (if you're using Firefox) - it
> has a tool that allows you to time how long each element on the page is
> taking to load. That could be useful in finding the problem.
> | Good luck,
> | -Rusty
> | Jason Porter <lightguard.jp at gmail.com> wrote: -----BEGIN PGP SIGNED
> | Hash: SHA256
> | I took some freelance work to improve the speed of a site. I've done
> | all of the things that I could think of, improve the includes in the php
> | code (instead of doing url includes to the same site), configure
> | mod_expires, mod_deflate (site is on apache2 (2.0.52)), I've even gone
> | so far as to install eaccelerator thinking maybe it was PHP stuff.
> | Sometimes the site loads really fast, other times it takes 20 seconds to
> | load up the site. PHP is running in CGI mode, which may have something
> | to do with it (php 4.3.9 BTW).
> | Box is a coloc box running RHEL ES 4. There's hardly any server load on
> | it, top shows it typically staying around 5% or less on the CPU load.
> | He has 60ish sites setup as virtual hosts and they each have a few
> | mod_rewrite rules, but this really shouldn't be much of a problem.
> | Anyone have experience in tweaking apache or troubleshooting slow sites?
> | ~ I'm currently at a brick wall, I have no idea what to look at next.
> | - --
> | - -Jason Porter
> | Real Programmers think better when playing Adventure or Rogue.
> | ---------------------------------
> | Never miss a thing. Make Yahoo your homepage.
> | _______________________________________________
> | UPHPU mailing list
> | UPHPU at uphpu.org
> | http://uphpu.org/mailman/listinfo/uphpu
> | IRC: #uphpu on irc.freenode.net
> Thanks for the ideas Rusty. I've already looked at the database (that
> was my first thought). I added a bunch of indexes and looked over the
> queries. The stats stuff is something I haven't tried and firebug has
> been on my box since 0.5 or something like that :) Any other thoughts
> from the list?
> - --
> - -Jason Porter
> Real Programmers think better when playing Adventure or Rogue.
> PGP key id: 926CCFF5
> PGP fingerprint: 64C2 C078 13A9 5B23 7738 F7E5 1046 C39B 926C CFF5
> PGP key available at: keyserver.net, pgp.mit.edu
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
> -----END PGP SIGNATURE-----
> UPHPU mailing list
> UPHPU at uphpu.org
> IRC: #uphpu on irc.freenode.net
More information about the UPHPU