Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options. I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z. Cheers, -.mag
On Mon, Feb 07, 2005 at 09:59:14AM -0800, Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
Debian issues are off topic on this list. -Andi
Andi Kleen wrote:
On Mon, Feb 07, 2005 at 09:59:14AM -0800, Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
Debian issues are off topic on this list.
He is asking about MySQL on SUSE BECAUSE of problems with it on Debian. That is not unreasonable. Personally I'd say ditch MySQL and put on a decent database like Firebird with its native amd64 build that works out of the box on SUSE ;) -- Lester Caine ----------------------------- L.S.Caine Electronic Services
On Monday 07 February 2005 18:55, Lester Caine wrote:
Andi Kleen wrote:
On Mon, Feb 07, 2005 at 09:59:14AM -0800, Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
Debian issues are off topic on this list.
He is asking about MySQL on SUSE BECAUSE of problems with it on Debian. That is not unreasonable.
Personally I'd say ditch MySQL and put on a decent database like Firebird with its native amd64 build that works out of the box on SUSE ;)
Well, MySQL works out of the box very well on SuSE AMD 64, too. However, I am wondering why we need to install the mysql-MAX package before we can gain access to InnoDB tables in SUSE Professional 9.2? This has confused quite a few users that I know of, since: A) if it is unable to create InnoDB tables, MySQL fails to do so silently B) MySQL's own literature all states that MySQL 4+ supports InnoDB by default (which it normally does) C) Attempting to activate InnoDB support via the my.cnf file without first installing mysql-MAX causes the basic mysql daemon to fail to start D) the package name "mysql-MAX" is very easy to confuse with MySQL's own MaxDB product I appologise if this question has been asked before, but am I missing something about the version(s) of MySQL that ship with SuSE Pro?
Lester Caine wrote:
Andi Kleen wrote:
On Mon, Feb 07, 2005 at 09:59:14AM -0800, Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
Debian issues are off topic on this list.
He is asking about MySQL on SUSE BECAUSE of problems with it on Debian. That is not unreasonable.
Personally I'd say ditch MySQL and put on a decent database like Firebird with its native amd64 build that works out of the box on SUSE ;)
I was reading about firebird, but it's not encouraging when you see a news snippet like this on firebirds site: ###### 19-Jan-2005 AMD64 Builds of Firebird 1.5.2 are recalled Because some potential corruption problems have shown up with pre-existing databases on the AMD64 Linux installations of Firebird 1.5.2, the kits have been recalled to the pre-release area for further testing. ###### What version is in the 9.2 out of the box? -.mag
I was reading about firebird, but it's not encouraging when you see a news snippet like this on firebirds site:
###### 19-Jan-2005 AMD64 Builds of Firebird 1.5.2 are recalled Because some potential corruption problems have shown up with pre-existing databases on the AMD64 Linux installations of Firebird 1.5.2, the kits have been recalled to the pre-release area for further testing. ######
What version is in the 9.2 out of the box?
SUSE doesn't ship Firebird. Only postgres/mysql/sleepycat db/gdbm. Older versions also included sapdb (aka MaxDB now), but that has been dropped some time ago. -Andi
Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
64bit Mysql works great under suse linux. I've used it without a single problem on suse 9.0, 9.1, and 9.2. Its a nice performance increase over the 32-bit version too. I had no problems installing or configuring it. I've been running 64bit mysql on my dual opteron with Suse linux for a little over a year. I started out on the mysql 4.0.x version but now run the 4.1.x version (for no reason other than I wanted to use the features of 4.1.x). Mark
Mark Horton wrote:
Mark A. Garcia wrote:
Can anyone tell me stories about marrying mysql and suse-amd64? It'd be great to hear in some areas where folks have successfully used mysql binary distro or home-grown compiled versions of mysql, along with the hardware they have it running on. I'm not looking for performance touting. More over if anyone has a preferred ./configure options.
I'm having a pickle of a time to get the mysql amd64 version to run stable on a debian pure64 install. My next venture is to see how well mysql on a suse-amd64 install runs. My hardware consists of dual opteron 250 8GB - sunfire v20z.
64bit Mysql works great under suse linux. I've used it without a single problem on suse 9.0, 9.1, and 9.2. Its a nice performance increase over the 32-bit version too. I had no problems installing or configuring it.
I've been running 64bit mysql on my dual opteron with Suse linux for a little over a year. I started out on the mysql 4.0.x version but now run the 4.1.x version (for no reason other than I wanted to use the features of 4.1.x).
Mark
I'll assume that you are using the mysql-standard x86_64 binary distro? Have you tinkered with compiling mysql from source? Has anyone gotten mysql compile from source on suse-amd64? Has anyone used UDF's on the mysql-max distro? Any success stories on compiling them on the suse-amd64? A more generic question, does suse use LinuxThreads or NPTL? Cheers, -.mag
I'll assume that you are using the mysql-standard x86_64 binary distro? Have you tinkered with compiling mysql from source? Has anyone gotten mysql compile from source on suse-amd64?
I usually use the binary distro. I typically use the tar.gz file simply because its easier for my setup. I've compiled it without a problem too. Heres the configure line I used for 4.1.8: CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/mysql/mysql-4.1.8 --with-mysqld-ldflags=-all-static --enable-thread-safe-client --with-extra-charsets=complex --enable-local-infile Mark
Has anyone used UDF's on the mysql-max distro? Any success stories on compiling them on the suse-amd64?
A more generic question, does suse use LinuxThreads or NPTL?
Cheers, -.mag
participants (5)
-
Andi Kleen
-
daniel@kettonlane.me.uk
-
Lester Caine
-
Mark A. Garcia
-
Mark Horton