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_connects374
Bytes_received332129641
Bytes_sent 1691254415
[...]
Created_tmp_disk_tables 0
Created_tmp_tables211
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
