Hallo Liste,

ich bekomme seit ein paar tagen ab und an folgende Errormeldung: mysql 11 "Can't create a new thread" kann mir einer mal einen Tip geben warum der Fehler auftritt?

TIA

Schmitti

Redhat Enterprise 3 Kernel 2.4.21-37.ELsmp glibc glibc-2.3.2-95.37 Mysql Ver 11.18 Distrib 3.23.58, for pc-linux (i686)

--Hardware------------------------------------------------------------- dual Xeon 3.06, Raid5 12GB RAM

--my.cnf--------------------------------------------------------------- [mysqld] pid-file=/var/run/mysql/mysqld.pid skip-innodb skip-locking skip-name-resolve

set-variable = key_buffer=800M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = net_buffer_length=2M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 set-variable = max_connections=800 set-variable = wait_timeout=315360000 set-variable = thread_concurrency=4

log-slow-queries=/var/log/mysql/slow-queries.log

log-bin binlog-do-db=shop2 server-id=1

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

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

[mysql] no-auto-rehash

[isamchk] set-variable = key_buffer = 256M set-variable = sort_buffer_size = 256M set-variable = read_buffer = 2M set-variable = write_buffer = 2M

[myisamchk] set-variable = key_buffer = 256M set-variable = sort_buffer_size = 256M set-variable = read_buffer = 2M set-variable = write_buffer = 2M

[mysqlhotcopy] interactive-timeout

-status---------------------------------------------

+--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Aborted_clients | 5 | | Aborted_connects | 1 | | Bytes_received | 14047434 | | Bytes_sent | 1167455303 | | Com_admin_commands | 75681 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 403 | | Com_change_master | 0 | | Com_check | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 7 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_insert | 71 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 79946 | | Com_set_option | 594 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 0 | | Com_show_fields | 0 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 54 | | Com_show_slave_status | 0 | | Com_show_status | 63 | | Com_show_innodb_status | 0 | | Com_show_tables | 0 | | Com_show_variables | 404 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 95 | | Connections | 226 | | Created_tmp_disk_tables | 204 | | Created_tmp_tables | 204 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 2 | | Handler_read_first | 20372 | | Handler_read_key | 32399 | | Handler_read_next | 38397156 | | Handler_read_prev | 0 | | Handler_read_rnd | 63511 | | Handler_read_rnd_next | 49826783 | | Handler_update | 92 | | Handler_write | 267 | | Key_blocks_used | 2105 | | Key_read_requests | 2131703 | | Key_reads | 2076 | | Key_write_requests | 313 | | Key_writes | 312 | | Max_used_connections | 210 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 179 | | Open_files | 324 | | Open_streams | 0 | | Opened_tables | 185 | | Questions | 81642 | | Select_full_join | 192 | | Select_full_range_join | 0 | | Select_range | 724 | | Select_range_check | 0 | | Select_scan | 49218 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 0 | | Sort_merge_passes | 0 | | Sort_range | 5724 | | Sort_rows | 63511 | | Sort_scan | 18145 | | Table_locks_immediate | 80838 | | Table_locks_waited | 2 | | Threads_cached | 0 | | Threads_created | 211 | | Threads_connected | 211 | | Threads_running | 4 | | Uptime | 593 | +--------------------------+------------+