今天进入数据库总是报这个错误,不知道是怎么回事
ERROR 1135 (00000): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
ERROR 1135 (00000): Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock# Here follows entries for some specific programs# The MySQL server
[mysqld_safe]open-files-limit=10240[mysqld]
port = 3306
socket = /tmp/mysql.sock
back_log = 384
skip-lockingkey_buffer_size = 256M
max_allowed_packet = 4M
table_cache = 1024K
thread_stack=256K
record_buffer=2M
thread_cache=8
sort_buffer=2M
net_buffer_length=2Kmax_connections=100000
tmp_table_size=128M
log-binserver-id = 1[mysqldump]
quick
max_allowed_packet = 16M[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M[mysqlhotcopy]
interactive-timeout
max_connections=100000
tmp_table_size=128M
减小这两个参数的值。
增大table_cache