Randall Shimizu wrote:
Unfortunately there is a lot of clunky sites on the web. UCSD's web site has
slowed down since they started using a content management system. A lot of
content on the web is published so this makes it more difficult for search
engines to find and classify results. I am not a fan of web publishing it tends
to slow down sites.
I agree, a DB based CMS is simply not a good way to go.
Interesting, your reply above is all one line.
We had that problem (slow sites) with *ALL* of the web sites that used
Joomla at Greenest Host. The problem is that whenever a Joomla site is
touched, it checks the MySQL DB for a valid session record. This creates
thousands of DB accesses per second on a busy site. The default engine
for Joomla DB tables is MyISAM which are not well optimized for this
type of traffic. The result is a LOT of disk accesses (especially on
servers with low physical memory) and very poor response with frequent
timeouts and site crashes. The problem was compounded by the fact that
we wanted search engines to hit the sites, so whenever Yahoo! and Google
were crawling the web server, everything when to hell in a hand basket
when a poorly designed Joomla site was hit. (Most of the sites were
designed and built by the site owners, not us.)
The solution I had was to convert all session tables to HEAP engine
types and the rest of the tables to InnoDB. The session table does not
need to be stored on disk because no records are permanent and leaving
the data in memory is a lot faster. InnoDB tables have more options for
optimization and can be cached/buffered in memory better than MyISAM
tables as well.
Another thing I noticed is that many of these Joomla sites do not use
stored procedures, making things just that much slower.
Of course, having enough physical memory for the DB server to handle the
HEAP tables and other tables caching/buffering is a must.
PGA
--
Paul G. Allen, BSIT/SE
Owner, Sr. Engineer
Random Logic Consulting Services
www.randomlogic.com
--
KPLUG-List@kernel-panic.org
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
