Web Analytics Made Easy -
StatCounter mysql crash IMPORTANT - CodingForum

Announcement

Collapse
No announcement yet.

mysql crash IMPORTANT

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • mysql crash IMPORTANT

    hello,

    I have a big problem, all few hours my mysql daemon crashs. Its totally random. I already changed alot in the config, but it cant be fixed so far

    here the mysqld.err log


    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
    Here my mysql config (my.cnf)

    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
    I am open for everything, please reply if you have ANY idea.

    thanks alot
Working...
X