Hello,

According to the build howto, it has you use the binary mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23 tarball. However looking at the directory structure and md5sums of the binaries included in the RHEL4 binary package, it would seem that a real compile is being done.

I have compiled my own using these configure options:

Code:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
./configure --prefix=/opt/zimbra/mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23 --enable-assembler --with-mysqld-ldflags=-all-static
It seems to work (I can add users at least), however the mysqld processes are quite abundant:

Code:
12883 pts/1    S      0:00 su - zimbra
12884 pts/1    S      0:00 -bash
16658 ?        S      0:00 [pdflush]
16662 ?        S      0:00 [pdflush]
17097 ?        Ssl    0:00 /opt/zimbra/openldap-2.3.21/libexec/slapd -l LOCAL0 -
17380 pts/1    S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --de
17397 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-
17423 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
17515 pts/1    S      0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-
17520 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17543 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.17397
17550 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17551 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17552 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17553 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17578 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17599 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17611 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
17628 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17629 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17630 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17631 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17632 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17636 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17637 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17638 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17639 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17668 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17669 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17672 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17673 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
17760 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
17912 ?        Ss     0:00 /opt/zimbra/libexec/zmtomcatmgr start -Xms55m -Xmx55m
17913 ?        Sl     0:41 /opt/zimbra/jdk1.5.0_08/bin/java -Xms55m -Xmx55m -cli
18104 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/swatch --config-fil
18112 ?        Ss     0:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/z
18114 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.18104
18117 ?        Ss     0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18119 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18120 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18121 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18122 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18123 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
18210 ?        Ss     0:00 /opt/zimbra/clamav/sbin/clamd --config-file /opt/zimb
18230 ?        Ss     0:00 /opt/zimbra/postfix-2.2.9/libexec/master
18247 ?        S      0:00 pickup -l -t fifo -u
18248 ?        S      0:00 qmgr -l -t fifo -u
18282 ?        Ss     0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
18283 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
18284 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
18285 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
18286 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
18302 ?        Ss     0:02 amavisd (master)
18395 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
18497 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
18524 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
18538 ?        S      0:00 amavisd (ch1-avail)
18539 ?        S      0:00 amavisd (virgin child)
18540 ?        S      0:00 amavisd (virgin child)
18541 ?        S      0:00 amavisd (virgin child)
18546 ?        S      0:00 amavisd (virgin child)
18547 ?        S      0:00 amavisd (virgin child)
18548 ?        S      0:00 amavisd (virgin child)
18549 ?        S      0:00 amavisd (virgin child)
18558 ?        S      0:00 amavisd (virgin child)
18559 ?        S      0:00 amavisd (virgin child)
19478 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
19536 ?        S      0:00 tlsmgr -l -t unix -u
19935 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
21386 ?        S      0:00 showq -t unix -u
With the RHEL4 binary package the mysqld processes are much fewer:

Code:
23211 pts/1    S      0:00 su - zimbra
23212 pts/1    S+     0:00 -bash
23304 ?        Ssl    0:00 /opt/zimbra/openldap-2.3.21/libexec/slapd -l LOCAL0 -
23594 pts/1    S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --de
23613 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-
23668 pts/1    Sl     0:01 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
23670 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
23724 pts/1    S      0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-
23806 pts/1    Sl     0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
23845 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.23613
23860 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
24126 ?        Ss     0:00 /opt/zimbra/libexec/zmtomcatmgr start -Xms55m -Xmx55m
24127 ?        Sl     0:17 /opt/zimbra/jdk1.5.0_08/bin/java -Xms55m -Xmx55m -cli
24316 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/swatch --config-fil
24322 ?        Ss     0:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/z
24323 pts/1    S      0:00 /usr/bin/perl /tmp/.swatch_script.24316
24327 ?        Ss     0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24330 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24331 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24332 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24343 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24344 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
24423 ?        Ss     0:00 /opt/zimbra/postfix-2.2.9/libexec/master
24426 ?        S      0:00 pickup -l -t fifo -u
24427 ?        S      0:00 qmgr -l -t fifo -u
24436 ?        Ss     0:00 /opt/zimbra/clamav/sbin/clamd --config-file /opt/zimb
24471 ?        Ss     0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
24472 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
24473 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
24474 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
24475 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
24514 ?        Ss     0:02 amavisd (master)
24751 ?        S      0:00 amavisd (virgin child)
24752 ?        S      0:00 amavisd (virgin child)
24768 ?        S      0:00 amavisd (virgin child)
24769 ?        S      0:00 amavisd (virgin child)
24770 ?        S      0:00 amavisd (virgin child)
24771 ?        S      0:00 amavisd (virgin child)
24780 ?        S      0:00 amavisd (virgin child)
24781 ?        S      0:00 amavisd (virgin child)
24782 ?        S      0:00 amavisd (virgin child)
24783 ?        S      0:00 amavisd (virgin child)
24948 ?        S      0:00 showq -t unix -u
Does anyone know what configure options I should be using to build the mysql source? Whatever the Zimbra folks are using for the RHEL4 mysql build would be most useful.

Any help/suggestions would be greatly appreciated!