MySQL Crash alle paar stunden

Einklappen
X
 
  • Filter
  • Zeit
  • Anzeigen
Alles löschen
neue Beiträge

  • MySQL Crash alle paar stunden

    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:
    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:
    [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!
Lädt...
X