| 1 |
Hi, |
| 2 |
|
| 3 |
perhaps somebody coul help me by this problem. |
| 4 |
|
| 5 |
I start mysql with "/etc/init.d/mysql start", this failed, but there are |
| 6 |
active mysqld processes after this. |
| 7 |
|
| 8 |
The problem is, that this problem starts after a reboot. Before was all |
| 9 |
right (I'm installing that machine now) and I had tested with some |
| 10 |
daemon restart commands. So I don't understand, what is happend. |
| 11 |
|
| 12 |
--- SNIP --- |
| 13 |
# /etc/init.d/mysql start |
| 14 |
* ... |
| 15 |
* Starting mysql (/etc/mysql/my.cnf) |
| 16 |
* MySQL NOT started (0) |
| 17 |
|
| 18 |
# cat /var/log/mysql/mysqld.err |
| 19 |
060719 19:31:20 InnoDB: Started; log sequence number 0 43655 |
| 20 |
060719 19:31:23 [Note] /usr/sbin/mysqld: ready for connections. |
| 21 |
Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 |
| 22 |
Gentoo Linux mysql-5.0.22 |
| 23 |
060719 19:34:11 [Note] /usr/sbin/mysqld: Normal shutdown |
| 24 |
|
| 25 |
060719 19:34:11 InnoDB: Starting shutdown... |
| 26 |
060719 19:34:19 InnoDB: Shutdown completed; log sequence number 0 43655 |
| 27 |
060719 19:34:19 [Note] /usr/sbin/mysqld: Shutdown complete |
| 28 |
|
| 29 |
060719 19:34:54 InnoDB: Started; log sequence number 0 43655 |
| 30 |
060719 19:34:57 [Note] /usr/sbin/mysqld: ready for connections. |
| 31 |
Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0 |
| 32 |
Gentoo Linux mysql-5.0.22 |
| 33 |
|
| 34 |
# ps -Al | grep mysql |
| 35 |
4 S 60 10819 1 0 77 0 - 26428 - ? 00:00:00 mysqld |
| 36 |
1 S 60 10822 10819 0 76 0 - 26428 - ? 00:00:00 mysqld |
| 37 |
1 S 60 10823 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 38 |
1 S 60 10824 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 39 |
1 S 60 10825 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 40 |
1 S 60 10826 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 41 |
1 S 60 10879 10822 0 76 0 - 26428 - ? 00:00:00 mysqld |
| 42 |
1 S 60 10880 10822 0 76 0 - 26428 - ? 00:00:00 mysqld |
| 43 |
1 S 60 10881 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 44 |
1 S 60 10882 10822 0 78 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 45 |
1 S 60 10883 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld |
| 46 |
|
| 47 |
# cat /etc/mysql/my.cnf |
| 48 |
[client] |
| 49 |
port = 3306 |
| 50 |
socket = /var/run/mysqld/mysqld.sock |
| 51 |
[mysql] |
| 52 |
character-sets-dir=/usr/share/mysql/charsets |
| 53 |
default-character-set=utf8 |
| 54 |
[mysqladmin] |
| 55 |
character-sets-dir=/usr/share/mysql/charsets |
| 56 |
default-character-set=utf8 |
| 57 |
[mysqlcheck] |
| 58 |
character-sets-dir=/usr/share/mysql/charsets |
| 59 |
default-character-set=utf8 |
| 60 |
[mysqldump] |
| 61 |
character-sets-dir=/usr/share/mysql/charsets |
| 62 |
default-character-set=utf8 |
| 63 |
[mysqlimport] |
| 64 |
character-sets-dir=/usr/share/mysql/charsets |
| 65 |
default-character-set=utf8 |
| 66 |
[mysqlshow] |
| 67 |
character-sets-dir=/usr/share/mysql/charsets |
| 68 |
default-character-set=utf8 |
| 69 |
[myisamchk] |
| 70 |
character-sets-dir=/usr/share/mysql/charsets |
| 71 |
[myisampack] |
| 72 |
character-sets-dir=/usr/share/mysql/charsets |
| 73 |
[mysqld_safe] |
| 74 |
err-log = /var/log/mysql/mysql.err |
| 75 |
[mysqld] |
| 76 |
character-set-server = utf8 |
| 77 |
default-character-set = utf8 |
| 78 |
user = mysql |
| 79 |
port = 3306 |
| 80 |
socket = |
| 81 |
/var/run/mysqld/mysqld.sock |
| 82 |
pid-file = /var/run/mysqld/mysqld.pid |
| 83 |
log-error = /var/log/mysql/mysqld.err |
| 84 |
basedir = /usr |
| 85 |
datadir = /var/lib/mysql |
| 86 |
skip-locking |
| 87 |
key_buffer = 16M |
| 88 |
max_allowed_packet = 1M |
| 89 |
table_cache = 64 |
| 90 |
sort_buffer_size = 512K |
| 91 |
net_buffer_length = 8K |
| 92 |
read_buffer_size = 256K |
| 93 |
read_rnd_buffer_size = 512K |
| 94 |
myisam_sort_buffer_size = 8M |
| 95 |
language = /usr/share/mysql/english |
| 96 |
skip-networking |
| 97 |
bind-address = 127.0.0.1 |
| 98 |
set-variable=local-infile=0 |
| 99 |
log-bin = gentoo-04-bin |
| 100 |
server-id = 1 |
| 101 |
tmpdir = /tmp/ |
| 102 |
innodb_buffer_pool_size = 16M |
| 103 |
innodb_additional_mem_pool_size = 2M |
| 104 |
innodb_log_file_size = 5M |
| 105 |
innodb_log_buffer_size = 8M |
| 106 |
set-variable = innodb_log_files_in_group=2 |
| 107 |
innodb_flush_log_at_trx_commit = 1 |
| 108 |
innodb_lock_wait_timeout = 50 |
| 109 |
[mysqldump] |
| 110 |
quick |
| 111 |
max_allowed_packet = 16M |
| 112 |
[mysql] |
| 113 |
[isamchk] |
| 114 |
key_buffer = 20M |
| 115 |
sort_buffer_size = 20M |
| 116 |
read_buffer = 2M |
| 117 |
write_buffer = 2M |
| 118 |
[myisamchk] |
| 119 |
key_buffer = 20M |
| 120 |
sort_buffer_size = 20M |
| 121 |
read_buffer = 2M |
| 122 |
write_buffer = 2M |
| 123 |
[mysqlhotcopy] |
| 124 |
interactive-timeout |
| 125 |
--- SNAP --- |
| 126 |
|
| 127 |
Thanks a lot, |
| 128 |
Michael Decker |
| 129 |
-- |
| 130 |
Michael Decker Michael.Decker@×××××.de |
| 131 |
TESIS SYSware GmbH http://www.tesis.de |
| 132 |
Baierbrunnerstr. 15 * 81379 Muenchen * Tel. +49 89 747377-0 |
| 133 |
|
| 134 |
-- |
| 135 |
gentoo-server@g.o mailing list |
Archives