Hi list and thanks to read me. Since december, I've got aborted_clients and aborted_connects to my mysql server ...
Clients that connected to this server have errors like : Failed to connect to database: Error: Access denied for user: '[EMAIL PROTECTED]' to database 'mydb' MySQL server has gone away Server is : 2 * Intel PIII 1GB ram RAID 5 scsi disk Linux Red Hat Linux sql1.jeuxvideo.com 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown Here's the my.cnf : port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve skip-host-cache set-variable = key_buffer=256M set-variable = back_log=150 set-variable = record_buffer=2M set-variable = sort_buffer=2M set-variable = max_allowed_packet=1M set-variable = thread_stack=128K set-variable = max_connections=700 set-variable = max_connect_errors=100 set-variable = table_cache=512 set-variable = net_read_timeout=180 set-variable = net_write_timeout=180 set-variable = wait_timeout=3600 set-variable = thread_concurrency=4 The network is a 100Mb private LAN. All ethernet cards on the network are fixed to 100Mb full duplex. Error log of mysql didn't show anything : 030116 08:54:47 mysqld started /usr/local/mysql/bin/mysqld: ready for connections and that's all ... Logging queries didn't help me to find me problem ... Here's some stats : mysql> status; -------------- ./mysql Ver 11.18 Distrib 3.23.54, for pc-linux (i686) Connection id: 337007 Current database: Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.54 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 1 day 8 min 49 sec Threads: 2 Questions: 833840 Slow queries: 28 Opens: 97 Flush tables: 1 Open tables: 72 Queries per second avg: 9.592 Extract of show table status : Aborted_clients 1032 Aborted_connects 1380 Bytes_received 89271244 Bytes_sent 2877636797 I try to upgrade kernel to 2.4.18 but all was the same so i came back to default kernel. I change mysql server from 3.23.53a to 3.23.54a but didn't solve anything ... I check all table with "CHECK TABLE mytable EXTENDED" and all are ok ... Please, i'm going mad, i didn't find the problem ... Rgds David --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
