I've look a bit around google for theese errors - but i can't find any useful answers to my problem.
My setup is;
web frontend running apache/php for dynamic page creation (p4 - 2,4 Ghz - 1Gb - ide)
sql backend running mysql 4.0.12-log (p3 - 1 Ghz - ide)
both machines running debian gnu/linux 2.4 linux kernels - alle software installed from debian packages.
the web frontend are serving 1,4 mill dynamic pages / day (access file recording)
the sql server says:
Connection: majeskuel via TCP/IP
Uptime: 3 hours 53 min 36 sec
Threads: 226 Questions: 1616956 Slow queries: 79 Opens: 467 Flush tables: 1 Open tables: 461 Queries per second avg: 115.365
Essentials from my.conf;
set-variable = key_buffer=384M
set-variable = max_allowed_packet=1M
set-variable = table_cache=512
set-variable = sort_buffer=2M
set-variable = record_buffer=2M
set-variable = long_query_time=2
set-variable = max_connections=525
set-variable = thread_cache=8
set-variable = thread_concurrency=2
set-variable = myisam_sort_buffer_size=64M
set-variable = query_cache_size=64M
My Problem is...
I restarted my mysql server last nite - and suddenly this afternoon my error reporting system flushed me with theese 2 errors happining at connect time:
2013: Lost connection to MySQL server during query
1129: Host 'webfrontend' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts'
(both php scripts and some cron job are sending theese errors)
it's coming in periods of cuple of minutes up til 14 minutes.. It stops by it self sometimes and other times i've tried with shutting down the services and started them agian. (and flush-hosts also stop it)
...and...
I've checked for code changes in the web application. Somebody says its tcp/ip stack problem - but no packets are dropped on the ethernenet layer. Nothing in the mysql err log either..
*looking kinda desperate ;)*
Stefan
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
