On Thu, 2005-06-16 at 21:06, Richard Dale wrote:
> > So we have recently started stress testing Mysql on an Opteron dual
> CPU
> > machine running Ubuntu Hoary. We are using the 64-bit GCC
> > 4.0.24-standard binary from mysql. The stress test that I'm currently
> > running on it involves inserting a large database (from a mysqldump)
> > ...
>
> Which linux kernel are you running?
2.6.10, specifically the ubuntu compile:
2.6.10-5-amd64-k8-smp
> Why not consider MySQL 4.1? It's now a stable production release.
Unfortunately when we tried to run our application on MySQL 4.1, we
were bit by a number of "features" of MySQL 4.1. MySQL 4.1 now silently
returns Long objects instead of Integers for most functions (COUNT),
causing class cast exceptions in Java... Also a number of our queries
which used to compare binary and non-binary fields, now nolonger cast
automatically... Requiring some additional SQL which our database
abstraction layer is not aware of needing. A lengthy porting process
ensued... and has been completed, but our application is still quite a
ways from being fully certified to run on MySQL 4.1. :( The MySQL 4.1
upgrade was 10x nastier than our 3.23->4.0 upgrade.
> Also, consider visiting:
> http://hashmysql.org/index.php?title=Opteron_HOWTO
> We would welcome a section on there about Ubuntu and x86-64.
Yes, I will be updating that wiki once I've got it running stably. I
ran into some libc issues with Ubuntu already, as seen here:
http://bugzilla.ubuntu.com/show_bug.cgi?id=11730
However I've compiled my own replacement libc with patches applied to
fix the issues, which I will make available to all. Except for this
memory problem, the machine is ready for our burnin testing.
-Joe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
