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
Here my mysql config (my.cnf)
I am open for everything, please reply if you have ANY idea.
thanks alot
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
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
thanks alot