Upgrading to MySQL 5.0.37 on RHEL and CentOS
March 9, 2007 by Jason · 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.
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.
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.
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).
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.
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 😉
Are you using the same config file for both versions? Where did you get 5.0.33? Was it from my site?
"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
😉
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
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.
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 /???/ 🙁
@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/