- Katılım
- 8 Mart 2006
- Mesajlar
- 176
- Reaction score
- 0
Warning: Host 'xxxxxxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /usr/share/php/db_mysql.inc on line 31
Warning: MySQL Connection Failed: Host 'xxxxxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in
bu sorunu nasıl aşabilirim .
My.cnf ayarlarım :
[mysqld]
set-variable = max_connections=50000
set-variable = max_connect_errors=100000
safe-show-database
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-locking
safe-show-database
max_connections = 10000
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1500
thread_cache_size = 256
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 32M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/mysql-slow
Yardımcı olan olursa çok sevinirim .
Warning: MySQL Connection Failed: Host 'xxxxxx' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in
bu sorunu nasıl aşabilirim .
My.cnf ayarlarım :
[mysqld]
set-variable = max_connections=50000
set-variable = max_connect_errors=100000
safe-show-database
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb
skip-locking
safe-show-database
max_connections = 10000
key_buffer = 16M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1500
thread_cache_size = 256
wait_timeout = 180
connect_timeout = 10
tmp_table_size = 32M
max_allowed_packet = 32M
max_connect_errors = 10
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 16384
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
open_files_limit = 8192
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/mysql-slow
Yardımcı olan olursa çok sevinirim .