Weird. I tried the mysql_pconnect thing a few days ago (on a suggestion from
Brion), and I didn't see any noticable effect at all, so I didn't commit it
to the repository.
Must be the multiple-user effect, or the configuration.
-----Original Message-----
From: wikitech-l-admin(a)nupedia.com
[mailto:wikitech-l-admin@nupedia.com]On Behalf Of Jimmy Wales
Sent: Friday, February 08, 2002 11:56 PM
To: wikitech-l(a)nupedia.com
Subject: Re: [Wikitech-l] Speedup suggestions
Axel Boldt wrote:
3) Assuming that php runs as an apache module, we
should use
persistent database connections. That way, we won't repeatedly send
over the username and password; one connection is reused by apache
even after the php script dies.
(
http://www.phpbuilder.com/manual/features.persistent-connections.php
and
http://www.phpbuilder.com/manual/function.mysql-pconnect.php)
After reading these two pages, it seemed that all I needed to do
was change
mysql_connect in databaseFunctions.php to mysql_pconnect.
It's a little early to get *too* excited, but so far the results
seem astonishing!
This is the first time I've seen the 5 minute load on the machine
under 3 in days.
And it's 0.46 now.
Also, I'm getting 2.52 pages per second from my little
benchmarking tool. This is
dramatically better than the 1/2 page per second pace we've been seeing.
--Jimbo
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)ross.bomis.com
http://ross.bomis.com/mailman/listinfo/wikitech-l