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