mysql.sock verschwindet ab und zu

[Coolwater]

Hallo,

vielleicht hat ja hier einer nen kleinen Tip:

Auf einem Vserver, wo nur ein phpbb 2.0.17 liegt verschwindet in unregelm�ssigen Abst�ndien die mysql.sock.

Dadurcj funktioniert nat�rlich auch der SQL-Server nicht, mit der typischen Fehlermeldung im Board (cant' connenct through Database).

Ok, also dann mittels SSH aufden Server und dann starte ich den mysql-Server �ber "safe_mysqld & " wieder neu .

Aber das kann es ja nun nciht sein oder .

Manchmal l�uft tat�chlich der Server auch noch (zumindest bekomme ich �ber ps -ax den entsprechendne Prozess zu sehen, den ich dann auch noch �ber kill Prozessnummer erstmal sterben lassen muss). Manchmal l�uft der Server auch �berhaupt nicht.

Hier mal der Auszug aus dem Logfile:

Code: Alles auswählen

Number of processes running now: 1
mysqld process hanging, pid 28488 - killed
050828 14:53:04  mysqld restarted
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

Number of processes running now: 2
050828 14:53:06  mysqld restarted
050828 14:53:06  Can't start server: Bind on TCP/IP port: Address already in use
050828 14:53:06  Do you already have another mysqld server running on port: 3306 ?
050828 14:53:06  Aborting

050828 14:53:06  /usr/libexec/mysqld: Shutdown Complete

050828 14:53:06  mysqld ended

050828 15:02:08  mysqld started
050828 15:02:08  Can't start server: Bind on TCP/IP port: Address already in use
050828 15:02:08  Do you already have another mysqld server running on port: 3306 ?
050828 15:02:08  Aborting

050828 15:02:08  /usr/libexec/mysqld: Shutdown Complete

050828 15:02:08  mysqld ended

Hat wer ne Idee ?

Danke

[Blutgerinsel]

Config ?
Logfile nachdem Neustart?

[Coolwater]

Hier die my.cnf:

Code: Alles auswählen

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
     
[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

und das Log :

Code: Alles auswählen

050831 08:13:30  mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

Status information:

Current dir: /var/lib/mysql/
Current locks:
lock: 83f8a2c:

lock: 83f7564:

lock: 83ed924:

lock: 83eb914:

lock: 83ea3bc:

lock: 83e8d04:

lock: 83e6e04:

lock: 83e45d4:

lock: 83e243c:

lock: 83df124:

lock: 83dd60c:

lock: 83db534:

lock: 83d1474:

key_cache status:
blocks used:        37
not flushed:         0
w_requests:         15
writes:              6
r_requests:        218
reads:              36

handler status:
read_key:           67
read_next:         184
read_rnd            72
read_first:          3
write:              66
delete               0
update:              1

Table status:
Opened tables:         21
Open tables:           15
Open files:            28
Open streams:           0

Hoffe hilft dir weiter, denn ich weiss solangsam nicht mehr woran es liegen kann.

Falls es für dich noch von Belang ist:

Version des Boards: 2.0.17
Version von PHP: 4.2.2
Version von MySQL: 3.23.54

Danke

[Blutgerinsel]

Was soll ich sagen deine Config ist mal sehr kurz, besonders vermisse ich eine Zeile:

Hier mal meine komplette Standardkonfig:

Code: Alles auswählen

[mysqld_safe]
socket          = /var/run/mysqld/mysqld.sock
nice            = 0

[mysqld]
#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
#
# * Query Cache Configuration
#
query_cache_limit       = 1048576
query_cache_size        = 16777216
query_cache_type        = 1
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log            = /var/log/mysql.log
#log            = /var/log/mysql/mysql.log

# Here you can see queries with especially long duration
#log-slow-queries       = /var/log/mysql/mysql-slow.log
#
# The following can be used as easy to replay backup logs or for replication.
#server-id              = 1
log-bin                 = /var/log/mysql/mysql-bin.log
# See /etc/mysql/debian-log-rotate.conf for the number of files kept.
max_binlog_size         = 104857600
#binlog-do-db           = include_database_name
#binlog-ignore-db       = include_database_name
#
# * BerkeleyDB
#
# The use of BerkeleyDB is now discouraged and support for it will probably
# cease in the next versions.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
#

# * Security Feature
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# If you want to enable SSL support (recommended) read the manual or my
# HOWTO in /usr/share/doc/mysql-server/SSL-MINI-HOWTO.txt.gz
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem

[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 16M