On Wed, 25 Aug 2004 12:21:23 -0700 (PDT), Dennis Allison <allison@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.