[gentoo-server] mysql

["Stéphane Guedon" <stephane@22decembre.eu>]

[-- Attachment #1: Type: Text/Plain, Size: 2604 bytes --]

Hello

Could someone help me concerning mysql.

My servers (both laptop hosted mysql and server hosted) are buggy. Every time I restart them through the 
init script, it crash ! :

18:15:06 root@einstein:~ # rc-service mysql restart
pdns              | * Stopping PowerDNS (default) ...
mediatomb         | * Stopping MediaTomb ...                                  [ ok ]
mysql             | * Stopping  ...
mysql             | * Stopping mysqld (0)                                             [ ok ]
mysql             | * Starting  ...
mysql             | * Starting  (/etc/mysql/my.cnf)
mysql             | * MySQL NOT started (0)                                         [ !! ]
mysql             | * ERROR: mysql failed to start
18:15:44 root@einstein:~ # ps -A|grep mys
 2333 ?        00:00:00 mysqld
18:15:56 root@einstein:~ # killall mysqld
18:17:37 root@einstein:~ # rc-service mysql zap    
mysql             | * Manually resetting mysql to stopped state
18:17:44 root@einstein:~ # rc-service mysql start
mysql             | * Starting  ...
mysql             | * Starting  (/etc/mysql/my.cnf)
mysql             | * MySQL NOT started (0)                                         [ !! ]
mysql             | * ERROR: mysql failed to start
18:17:53 root@einstein:~ # ps -A|grep mys                                                                                                                                
 2628 ?        00:00:00 mysqld

Of course, it crashs also on boot process, whereas at least two services (pdns and mediatomb) need it !

==========================

Here is the end of emerge --info mysql for the server hosted, which is the most problematic :

dev-db/mysql-5.1.46 was built with the following:
USE="community debug latin1 (multilib) perl -big-tables -cluster -embedded -extraengine -max-idx-128 -
minimal -pbxt -profiling (-selinux) -ssl -static -test -xtradb" 
CFLAGS="-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing"
CXXFLAGS="-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions -
fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing"

==========================

I think I have read carefully the doc concerning mysql : http://www.gentoo.org/doc/fr/mysql-howto.xml.

What can I do ?

Thanks

-- 
Stéphane Guedon
page web : http://www.22decembre.eu/
carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf
clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 198 bytes --]