MySQL Crash alle paar stunden

MySQL, PostgreSQL, SQLite
comby
Posts: 23
Joined: 2004-02-25 13:12

MySQL Crash alle paar stunden

Post by comby » 2004-02-25 13:18

Hallo,

Ich habe seit einigen wochen ziemliche Probleme mit dem MYSQL Server. Alle paar stunden (random) geht er einfach down, ich hab die config 1000 mal geändert, alles möglich probiert und auch schon gegooglet. Aber nichts richtiges gefunden .. nun meine letzte hoffnung, hier mal die mysql.err log vom letzten shutdown:

Code: Select all

mysqld process hanging, pid 22747 - killed
mysqld process hanging, pid 22747 - killed
mysqld process hanging, pid 22747 - killed
040225 12:53:38  mysqld restarted
Warning: Ignoring user change to 'mysql' because the user was set to 'mysql' earlier on the command line
040225 12:53:38  Can't start server: Bind on TCP/IP port: Address already in use
040225 12:53:38  Do you already have another mysqld server running on port: 3306 ?
040225 12:53:38  Aborting

040225 12:53:38  /usr/sbin/mysqld: Shutdown Complete

040225 12:53:38  mysqld ended
Hier die my.cnf (mysql config)

Code: Select all

[client]
#password       = my_password
port            = 3306
socket          = /var/run/mysqld/mysqld.sock

[safe_mysqld]
err-log         = /var/log/mysql/mysql.err

[mysqld]
skip-innodb
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock

basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = thread_stack=128K
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
set-variable    = query_cache_size=12M
set-variable    = max_connections=400
set-variable    = wait_timeout=90
set-variable    = interactive_timeout=90
set-variable    = max_connect_errors=999999
set-variable    = max_delayed_threads=999999

# keep secure by default!
bind-address    = 127.0.0.1
port            = 3306
# this can make it even more secure:
#skip-networking

[mysqldump]
quick
set-variable    = max_allowed_packet=1M

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

[isamchk]
set-variable    = key_buffer=16M
Für sämtliche Ideen bin ich offen, vielen dank!

captaincrunch
Userprojekt
Userprojekt
Posts: 7066
Joined: 2002-10-09 14:30
Location: Dorsten

Re: MySQL Crash alle paar stunden

Post by captaincrunch » 2004-02-25 13:22

-> DB-Forum
DebianHowTo
echo "[q]sa[ln0=aln256%Pln256/snlbx]sb729901041524823122snlbxq"|dc