hi, I always have my problem and i didn't find any solution pour the moment. Please, if somone have an idea ... :(
Thanks David Subject: [Error] Mysql server has gone away && 3.23.53a Date: Thu, 19 Dec 2002 17:23:31 +0100 I've some problem with my Mysql servers since the beginning of this week. I've got plenty of error like this : Failed to connect to database: Error: Access denied for user: ´[EMAIL PROTECTED]´ to database ´DB1´ MySQL server has gone away Error Nø1, please contact webmaster ... In fact, clients are C cgi compiled with libmysql ( in this package MySQL-devel-3.23.49-1.i386.rpm ) The Cgi is ok and have worked well since several mounths. Error Nø1 : connection mysql ok, can't execute my query It seems that mysql disconnect me before i can execute my query. But query is just after the connection in the code ... :( Mysql server is always up and didn't gone away any more ... Server : Linux Redhat 2 * PIII 1 Ghz 1Go ram Scsi raid 5 mysql-3.23.53a-pc-linux-gnu-i686.tar.gz ( binary ) As you can see, i connect to my server via a 100Mb LAN. The LAN is ok, all ethernet card are 100Mb Full Duplex without any collision or packet dropped. Exemple : RX packets:259950587 errors:0 dropped:0 overruns:0 frame:0 TX packets:1809122347 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 lg file transmission:100 RX bytes:3130833186 (2985.7 Mb) TX bytes:1637489037 (1561.6 Mb) Here's the my.cnf : # The MySQL server [mysqld] port = 3306 socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable = key_buffer=256M set-variable = back_log=150 set-variable = record_buffer=1M set-variable = sort_buffer=1M 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 I can't see anything in the error log. Mysqld is still alive and still responding 99% of the time. Status : Threads: 3 Questions: 3065350 Slow queries: 46 Opens: 91 Flush tables: 1 Open tables: 66 Queries per second avg: 9.052 Show Status : Aborted_clients 4401 Aborted_connects 374 Bytes_received 332129641 Bytes_sent 1691254415 [...] Created_tmp_disk_tables 0 Created_tmp_tables 211 Created_tmp_files 1290 Handler_delete | 11135 | Handler_read_first | 226 | Handler_read_key | 2005755 | Handler_read_next | 1714626349 | Handler_read_prev | 0 | Handler_read_rnd | 2613047 | Handler_read_rnd_next | 62634691 | Handler_update | 357300 | Handler_write | 304440 | Key_blocks_used | 62869 | Key_read_requests | 97082717 | Key_reads | 60114 | Key_write_requests | 487582 | Key_writes | 392106 | Max_used_connections | 23 | Not_flushed_key_blocks | 0 | Not_flushed_delayed_rows | 0 | Open_tables | 66 | Open_files | 102 | Open_streams | 0 | Opened_tables | 91 Questions | 3065612 | Select_full_join | 0 | Select_full_range_join | 0 | Select_range | 600 | Select_range_check | 0 | Select_scan | 51701 | Slave_running | OFF | Slave_open_temp_tables | 0 | Slow_launch_threads | 0 | Slow_queries | 46 | Sort_merge_passes | 645 | Sort_range | 99887 | Sort_rows | 2613047 | Sort_scan | 20030 | Table_locks_immediate | 1841001 | Table_locks_waited | 1977 | Threads_cached | 0 | Threads_created | 1226346 | Threads_connected | 2 | Threads_running | 1 | Uptime | 338664 Extract of the mysql.db table : 192.168.10.4 | DB1 | JForvC15 | Y ( select priv ... ) --------------------------------------------------------------------- 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
