Upgrading to MySQL 5.0.37 on RHEL and CentOS

March 9, 2007 by · 11 Comments 

Well, I'm back again with yet another release of MySQL. Coming only a few short days after the Enterprise release of 5.0.36 under the Monthly Rapid Update program, MySQL has decided to release 5.0.37 as a community edition.

As with my last release, this one is based on the latest Fedora src.rpm from the development tree and has been modified to use the newest source package, package new files that didn't exist before, remove patches that have been integrated into the main code-base, and, as a first for me, to add a patch to reverse part of a recent commit that breaks regression testing.

The end of last month a change was pushed into the public 5.0 repository that changed the expected result set for the "information_schema" test. Now, I've been looking pretty hard, but I have yet to find where the test input was changed in order to support this new expected result. As a consequence, this package includes a patch to undo part of that commit so that the package can be built.

In any case, aside from that patch, the only other changes between my last release of 5.0.36 and this release of 5.0.37 was the inclusion of 19 man pages that appeared in the build tree.

As always, I've provided the src.rpm below, as well as binary packages for i386. If someone would like to use the src.rpm to create 64-bit packages, let me know and I can host them for you if you'd like.

Update (9/24/2009): Packages deleted, use the yum repository instead.

Comments

11 Responses to “Upgrading to MySQL 5.0.37 on RHEL and CentOS”
  1. Eneko Alonso says:

    Hi there!

    I'm kind of newbie here, very glad to have found your scripts and guides for setting up a CentOS server. I just got my new dedicated server and I couldn't do anything until I found your web, so thanks a lot.

    However, not everything has gone fine so far, and I think I have messed up MySQL somehow, so it doesn't start.

    First I've got mysql-5.0.22-1.centos.1.i386.rpm and mysql-devel-5.0.22-1.centos.1.i386.rpm from your page about MySQL 5.0.22, and installing those rmp made it possible to compile PHP with mysql. But apparently I missed how to setup the server, so I got your next tutorial for MySQL 5.0.33, downloaded all your *jason* rmp's and installed them.

    But whenever I try to run mysqld daemon or mysqld_safe it automatically stops.

    Now I don't know what to do. How can I uninstall everything related to MySQL and reinstall it from scratch?

    As I said, I'm kind of newbie here.

    Thanks a lot.

  2. Eneko Alonso says:

    One more question I have.
    What is the difference between the 5.0.37 rpm packages available on mysql.com and those you have put in here? Aren't the official ones compatible with CentOS?

    Thanks in advanced.

  3. Jason says:

    The mysqld daemon is part of the "mysql-server" package. If you don't install that one, it won't work. Once you have installed it, you should use the init script to start and stop the daemon ("service mysqld start" & "service mysqld stop").

    As to the differences between these packages and those from mysql.com, they are legion. The RPMs I've posted above are designed to provide maximum compatibility with the build styles used in RHEL, CentOS, and Fedora. This compatibility is accomplished by starting with an official package as a base and then modifying it as needed to build the latest version of the software.

    The packages posted on mysql.com will work with RHEL & CentOS but they are named differently, have slightly different functionality, and use a different init script. If you use those, you take a risk on breaking dependencies and having some of your software not working (the Plesk Management Panel, for example, will flake out if you use the packages from mysql.com).

    MySQL.com has also stated that they will NOT be providing binary packages for every community release. I, on the other hand, will build every community (and occasionally enterprise) tar.gz that is posted to their site. If you want to stay current, book mark my site (or subscribe to the RSS feed, either way).

  4. Eneko Alonso says:

    You bet! I have already subscribed 🙂 I have to say you are doing a great job!

    I got MySQL working tonight, it turned out to be a problem with my.conf file. I had another one in a different folder before when I had installed mysql 5.0.27 usign the binaries from mysql.com. The I realized I had to install the mysql rpm's, including the devel one in orther to have PHP with mysql. So finding your blog and your manuals was great!

    Thanks a lot.

  5. Denis F. Latypoff says:

    I've never used mysql binary packages and don't want to do that. I tried to install 5.0.37 to all my centos'es from sources and startups are failed on all servers, I went back use 5.0.33.
    New strace says that mysql hangs on rt_sigsuspend([HUP INT QUIT PIPE ALRM TERM TSTP]... :

    070312 20:56:11 InnoDB: Setting file /var/lib/mysql/ibdata3 size to 1024 MB
    InnoDB: Database physically writes the file full: wait...
    InnoDB: Progress in MB: 100 200 300 400 500 600 700 800 900 1000
    070312 20:56:49 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile0 size to 64 MB
    InnoDB: Database physically writes the file full: wait...
    070312 20:56:52 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
    InnoDB: Setting log file ./ib_logfile1 size to 64 MB
    InnoDB: Database physically writes the file full: wait...

    and nothing.. no mysql.sock created, no pidfile created.
    5.0.33 continued to run with the following log:

    InnoDB: Doublewrite buffer not found: creating new
    InnoDB: Doublewrite buffer created
    InnoDB: Creating foreign key constraint system tables
    InnoDB: Foreign key constraint system tables created
    070312 20:56:55 InnoDB: Started; log sequence number 0 0
    070312 20:56:55 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.33-c2' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

    Linux c2 2.6.9-42.0.10.EL #1 Tue Feb 27 09:24:42 EST 2007 i686 i686 i386 GNU/Linux
    I don't need help, I just reported bug 😉

  6. Jason says:

    Are you using the same config file for both versions? Where did you get 5.0.33? Was it from my site?

  7. Denis F. Latypoff says:

    "Are you using the same config file for both versions?" -yes
    "Where did you get 5.0.33?" -dev.mysql.com
    "Was it from my site?" -nope
    😉

  8. Denis F. Latypoff says:

    my configure args are (for both 33 and 37):

    CC="gcc" \
    CFLAGS="-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W \
    -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare \
    -Wwrite-strings -Wunused -O2 -fno-omit-frame-pointer -g \
    -march=pentium4 -mtune=pentium4" \
    CXX="gcc" \
    CXXFLAGS="-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W \
    -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare \
    -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder \
    -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors \
    -fno-exceptions -fno-rtti -O2 -fno-omit-frame-pointer -g \
    -march=pentium4 -mtune=pentium4" \
    ./configure \
    --build=i686-pc-linux-gnu \
    --host=i686-pc-linux-gnu \
    \
    --prefix=/usr \
    --localstatedir=/var/lib/mysql \
    --infodir=/usr/share/info \
    --mandir=/usr/share/man \
    --sysconfdir=/etc \
    \
    --enable-assembler \
    --disable-shared \
    --with-mysqld-ldflags="-all-static" \
    --with-client-ldflags="-all-static" \
    \
    --without-bench \
    --without-docs \
    --without-extra-tools \
    --without-debug \
    \
    --with-charset=utf8 \
    --with-collation=utf8_general_ci \
    --with-extra-charsets=none \
    \
    --enable-thread-safe-client \
    --with-mysqld-user=mysql \
    \
    --with-innodb \
    --enable-local-infile \
    --with-server-suffix="-c2" \
    --with-unix-socket-path=/var/lib/mysql/mysql.sock

  9. Jason says:

    Well, I really can't provide much info on that if you're not using my src.rpm to compile or my binary RPMs. There are just too many things that could be different, sorry. Good luck with getting it running though.

  10. Erwin says:

    hi
    i'm really new in this area..
    I download Mysql 5.0 RPM i try to installed on my server RHEL 5.0

    #rmp -ivh Mysq......rpm
    I get the message: Packge Mysq.... is already installed

    But i don't find the file mysqladmin also I can't login with mysql

    I write this: /etc/init.d/mysql start and it send this msg:
    Starting MySQL [ok]

    I don't know what to do now...
    Someone can help me /???/ 🙁

  11. Jason says:

    @Erwin,

    You cannot use "rpm -ivh" unless the package is not currently installed on your system. I would recommend using "rpm -Uvh" as that will upgrade the existing packages.

    One thing, this post is more than a year old and I do have newer versions of MySQL available (up through 5.0.58 as of now). I'd suggest that you build the source rpm from one of those newer posts or that you configure your system for my yum repository so you can receive updates automatically.

    http://www.jasonlitka.com/yum-repository/

This site is no longer updated. If you have a need for RHEL/CentOS LAMP Stack updates outside the normal channels, I recommend ART. https://updates.atomicorp.com/channels/