[Zope] Performance problems after upgrade

[Andy Dustman]

On Wed, 25 Aug 2004 12:21:23 -0700 (PDT), Dennis Allison
<allison at sumeru.stanford.edu> wrote:
> 
> I upgraded from mysql-3.23.56-1.9 to mysql--4.0.20-0 using the mysql.org
> RPMS, from Zope 2.6.2b3 (Python 2.1.3) to Zope 2.6.4 (Python 2.3.4) under
> Linux RH7.3 with kernel 2.4.20-28.7.  Host is a dual Athalon processor
> with 4GB of memory, 3ware RAID (configured as RAID 10) and not much else.
> 
> Performance is way down from the earlier configuration with "bursty"
> slowdowns.

What version of MySQL-python (MySQLdb) are you using, and how did you
install it? I'd recommend 1.1.1 or 1.0.0 for use with Python-2.3.4.
Whatever version you have needs to be built for your major version of
Python (you upgraded from 2.1 to 2.3) and MySQL (you upgraded from
3.23 to 4.0). Get the mysql-devel package for your version, and then
build MySQL-python according to the README; there are instructions for
building RPM packages. I am no longer building RPM packages, so you
have to do it yourself.

You do not need to upgrade ZMySQLDA, but I recommend the latest beta,
which is about 2 yrs old. It seems to be stable enough...
-- 
Computer interfaces should never be made of meat.