| 1 |
Hello |
| 2 |
|
| 3 |
Could someone help me concerning mysql. |
| 4 |
|
| 5 |
My servers (both laptop hosted mysql and server hosted) are buggy. Every time I restart them through the |
| 6 |
init script, it crash ! : |
| 7 |
|
| 8 |
18:15:06 root@einstein:~ # rc-service mysql restart |
| 9 |
pdns | * Stopping PowerDNS (default) ... |
| 10 |
mediatomb | * Stopping MediaTomb ... [ ok ] |
| 11 |
mysql | * Stopping ... |
| 12 |
mysql | * Stopping mysqld (0) [ ok ] |
| 13 |
mysql | * Starting ... |
| 14 |
mysql | * Starting (/etc/mysql/my.cnf) |
| 15 |
mysql | * MySQL NOT started (0) [ !! ] |
| 16 |
mysql | * ERROR: mysql failed to start |
| 17 |
18:15:44 root@einstein:~ # ps -A|grep mys |
| 18 |
2333 ? 00:00:00 mysqld |
| 19 |
18:15:56 root@einstein:~ # killall mysqld |
| 20 |
18:17:37 root@einstein:~ # rc-service mysql zap |
| 21 |
mysql | * Manually resetting mysql to stopped state |
| 22 |
18:17:44 root@einstein:~ # rc-service mysql start |
| 23 |
mysql | * Starting ... |
| 24 |
mysql | * Starting (/etc/mysql/my.cnf) |
| 25 |
mysql | * MySQL NOT started (0) [ !! ] |
| 26 |
mysql | * ERROR: mysql failed to start |
| 27 |
18:17:53 root@einstein:~ # ps -A|grep mys |
| 28 |
2628 ? 00:00:00 mysqld |
| 29 |
|
| 30 |
Of course, it crashs also on boot process, whereas at least two services (pdns and mediatomb) need it ! |
| 31 |
|
| 32 |
========================== |
| 33 |
|
| 34 |
Here is the end of emerge --info mysql for the server hosted, which is the most problematic : |
| 35 |
|
| 36 |
dev-db/mysql-5.1.46 was built with the following: |
| 37 |
USE="community debug latin1 (multilib) perl -big-tables -cluster -embedded -extraengine -max-idx-128 - |
| 38 |
minimal -pbxt -profiling (-selinux) -ssl -static -test -xtradb" |
| 39 |
CFLAGS="-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-strict-aliasing" |
| 40 |
CXXFLAGS="-march=native -O3 -pipe -fomit-frame-pointer -DHAVE_ERRNO_AS_DEFINE=1 -fno-exceptions - |
| 41 |
fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing" |
| 42 |
|
| 43 |
========================== |
| 44 |
|
| 45 |
I think I have read carefully the doc concerning mysql : http://www.gentoo.org/doc/fr/mysql-howto.xml. |
| 46 |
|
| 47 |
What can I do ? |
| 48 |
|
| 49 |
Thanks |
| 50 |
|
| 51 |
-- |
| 52 |
Stéphane Guedon |
| 53 |
page web : http://www.22decembre.eu/ |
| 54 |
carte de visite : http://www.22decembre.eu/downloads/Stephane-Guedon.vcf |
| 55 |
clé publique gpg : http://www.22decembre.eu/downloads/Stephane-Guedon.asc |
Archives