Hi,
perhaps somebody coul help me by this problem.
I start mysql with "/etc/init.d/mysql start", this failed, but there are
active mysqld processes after this.
The problem is, that this problem starts after a reboot. Before was all
right (I'm installing that machine now) and I had tested with some
daemon restart commands. So I don't understand, what is happend.
--- SNIP ---
# /etc/init.d/mysql start
* ...
* Starting mysql (/etc/mysql/my.cnf)
* MySQL NOT started (0)
# cat /var/log/mysql/mysqld.err
060719 19:31:20 InnoDB: Started; log sequence number 0 43655
060719 19:31:23 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0
Gentoo Linux mysql-5.0.22
060719 19:34:11 [Note] /usr/sbin/mysqld: Normal shutdown
060719 19:34:11 InnoDB: Starting shutdown...
060719 19:34:19 InnoDB: Shutdown completed; log sequence number 0 43655
060719 19:34:19 [Note] /usr/sbin/mysqld: Shutdown complete
060719 19:34:54 InnoDB: Started; log sequence number 0 43655
060719 19:34:57 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.22-log' socket: '/var/run/mysqld/mysqld.sock' port: 0
Gentoo Linux mysql-5.0.22
# ps -Al | grep mysql
4 S 60 10819 1 0 77 0 - 26428 - ? 00:00:00 mysqld
1 S 60 10822 10819 0 76 0 - 26428 - ? 00:00:00 mysqld
1 S 60 10823 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10824 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10825 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10826 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10879 10822 0 76 0 - 26428 - ? 00:00:00 mysqld
1 S 60 10880 10822 0 76 0 - 26428 - ? 00:00:00 mysqld
1 S 60 10881 10822 0 76 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10882 10822 0 78 0 - 26428 rt_sig ? 00:00:00 mysqld
1 S 60 10883 10822 0 80 0 - 26428 rt_sig ? 00:00:00 mysqld
# cat /etc/mysql/my.cnf
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock
[mysql]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqladmin]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlcheck]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqldump]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlimport]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[mysqlshow]
character-sets-dir=/usr/share/mysql/charsets
default-character-set=utf8
[myisamchk]
character-sets-dir=/usr/share/mysql/charsets
[myisampack]
character-sets-dir=/usr/share/mysql/charsets
[mysqld_safe]
err-log = /var/log/mysql/mysql.err
[mysqld]
character-set-server = utf8
default-character-set = utf8
user = mysql
port = 3306
socket =
/var/run/mysqld/mysqld.sock
pid-file = /var/run/mysqld/mysqld.pid
log-error = /var/log/mysql/mysqld.err
basedir = /usr
datadir = /var/lib/mysql
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
language = /usr/share/mysql/english
skip-networking
bind-address = 127.0.0.1
set-variable=local-infile=0
log-bin = gentoo-04-bin
server-id = 1
tmpdir = /tmp/
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
set-variable = innodb_log_files_in_group=2
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
--- SNAP ---
Thanks a lot,
Michael Decker
--
Michael Decker [EMAIL PROTECTED]
TESIS SYSware GmbH http://www.tesis.de
Baierbrunnerstr. 15 * 81379 Muenchen * Tel. +49 89 747377-0
--
[email protected] mailing list
