Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
 
Go Back   Zimbra - Forums > Zimbra Collaboration Suite > Developers
Reload this Page Building SVN for CentOS 4.4 (mysql)

Welcome to the Zimbra - Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 12-08-2006, 11:25 AM
Member
  
Posts: 10
Default Building SVN for CentOS 4.4 (mysql)
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!
Reply With Quote
  #2 (permalink)  
Old 12-13-2006, 02:05 PM
Member
  
Posts: 10
Default
I found a solution to the too many mysqld processes. I just compiled mysql with none of the extra flags (just prefix) and it worked.

Code:
./configure --prefix=/opt/zimbra/mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23
I now have a working CentOS 4.4 Zimbra build (4.0.4_GA_494)!

Does anyone know if there is a way to checkout the 4.0.4_GA_457 version from SVN? Are the updates put into the EDISON branch safe enough for production?
Reply With Quote
  #3 (permalink)  
Old 12-14-2006, 05:15 PM
Senior Member
  
Posts: 65
Default
It would be helpful if you haven't already, to put your solutions in the wiki so that people can more easily find them.
__________________
Jacob Turner
http://ringnebula.net - Ringnebula Systems
Reply With Quote
  #4 (permalink)  
Old 12-29-2006, 10:54 PM
Zimbra Employee
  
Posts: 538
Default
The goal is to get the SVN versions tagged with the appropriate releases but until then, internally the EDISON branch is locked so it is should be considered stable.

Mysql is internally compiled for each platform but we try to maintain options as close to the Mysql binary releases as possible. Usually these are just pulled straight from the options in the rpm spec files they publish.

Code:
CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --enable-local-infile --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-readline --with-mysqld-ldflags=-all-static --libdir=/opt/zimbra/mysql-$(MYSQL_VERSION)/lib --prefix=/opt/zimbra/mysql-$(MYSQL_VERSION)
Reply With Quote
Reply

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

Zimbrablog.com


Home - Blog - Contact Us - Archive - Top


 

Search Engine Optimization by vBSEO 3.1.0