The problem was nearly the same as described in bug #110560.
My CFLAGS var was set to "-march=pentium4 -O3 -pipe -fomit-frame-pointer -mmmx -m3dnow -msse -msse2" (no comments on the non-sense of it, please :-)
The result was that mysql (and mysql-administrator) crashed.
I tried different versions of mysql, even the 5.1_alpha. All with the same result. For me it seemed that gcc-3.4.4 + mysql + CFLAGS="-O3 -march=pentium4 -fomit-frame-pointer" could be a problem.
So I did: 'CFLAGS="-O2" emerge mysql' and now it works.
need to comment the nonsense ;-)
MySQL AB build and test it's binaryes with "-O3" so I strongly doubt that it is the cause (expecially with gcc-3.4).
try CFLAGS="-O3" emerge mysql , it should work fine.
instead, you could define "mmm" "sse" "sse2" "3dnow" as USE flags _not_ in CFLAGS.
The supported ebuild will compile with the cpu optimizations you want leaving untouched the others ebuild.
I don't think I completely understood, what you wanted to tell me.
Therefore I did some testing...
As you wrote, mysql works perfectly, when I set CFLAGS="-march=pentium4 -fomit-frame-pointer -pipe -O3"
But it crashes, when I add "-mmmx -msse -msse2 -m3dnow".
Since no other software on this machine (which is completely compiled with the mentioned CFLAGS), I think that's a problem with mysql (and probably gcc). Could you please explain to me, why you think it's not?
Well, did another test. Removing "3dnow" from the CFLAGS did resolve it. I don't think, that this will give the slightest performance, so...
you can close this bug :-)
mmh, try to explain:
it's a question of "real life" versus "perfect world", sure it's mysql or gcc that fail with those optimization but because the gain using them is not huge and the dificult to debug and keep stable is great, noone will fix the problem ;-) .
Also it's gentoo policy to close bugs depending on non standard CFLAGS.
P.S. If no other software has problem you're lucky ;-)