List:General Discussion« Previous MessageNext Message »
From:Adam Douglas Date:August 13 2001 9:21pm
Subject:MySQL Lost Connection...
View as plain text  
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...

Warning: MySQL Connection Failed: Lost connection to MySQL server during
query...

I'm assuming this is a MySQL issue since everything worked fine before the
upgrade from MySQL 3.32.22 to MySQL 3.23.37.

I'm doing very simple query to see if it works and no success. Even code
that worked before I upgraded doesn't work anymore. Here's the test query I
made... (BTW, the below query works fine via MySQL/MySQL GUI Client)

$szQuery = "SELECT * FROM People WHERE First_Name='adouglas'";
$dbconnection = mysql_connect("207.195.58.33","webuser","adamacc226");
mysql_select_db("venmar", $dbConnection) or die("could not connect to venmar
for security authentication.");
$saResults = mysql_query($szQuery, $dbConnection) or die ("2could not query
venmar for security authentication.");
$obResults = mysql_fetch_row($saResults)

echo "$obResults[0], $obResults[1], $obResults[2], $obResults[3],
$obResults[4], $obResults[5]";


The MySQL Database has it's own dedicated machine running on OpenBSD 2.9.
The web server accessing the MySQL Database is on it's own machine with
Apache 1.3.12 and OpenBSD 2.9. Any other details needed let me know.

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_clients          | 0     |
| Aborted_connects         | 6     |
| Bytes_received           | 4125  |
| Bytes_sent               | 45247 |
| Connections              | 15    |
| Created_tmp_disk_tables  | 0     |
| Created_tmp_tables       | 0     |
| Created_tmp_files        | 0     |
| Delayed_insert_threads   | 0     |
| Delayed_writes           | 0     |
| Delayed_errors           | 0     |
| Flush_commands           | 1     |
| Handler_delete           | 4     |
| Handler_read_first       | 7     |
| Handler_read_key         | 16    |
| Handler_read_next        | 2     |
| Handler_read_prev        | 0     |
| Handler_read_rnd         | 0     |
| Handler_read_rnd_next    | 2597  |
| Handler_update           | 1     |
| Handler_write            | 4     |
| Key_blocks_used          | 4     |
| Key_read_requests        | 28    |
| Key_reads                | 4     |
| Key_write_requests       | 18    |
| Key_writes               | 12    |
| Max_used_connections     | 1     |
| Not_flushed_key_blocks   | 0     |
| Not_flushed_delayed_rows | 0     |
| Open_tables              | 22    |
| Open_files               | 44    |
| Open_streams             | 0     |
| Opened_tables            | 38    |
| Questions                | 135   |
| Select_full_join         | 0     |
| Select_full_range_join   | 0     |
| Select_range             | 0     |
| Select_range_check       | 0     |
| Select_scan              | 15    |
| Slave_running            | OFF   |
| Slave_open_temp_tables   | 0     |
| Slow_launch_threads      | 0     |
| Slow_queries             | 0     |
| Sort_merge_passes        | 0     |
| Sort_range               | 0     |
| Sort_rows                | 0     |
| Sort_scan                | 0     |
| Table_locks_immediate    | 52    |
| Table_locks_waited       | 0     |
| Threads_cached           | 0     |
| Threads_created          | 14    |
| Threads_connected        | 1     |
| Threads_running          | 1     |
| Uptime                   | 7235  |
+--------------------------+-------+

+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
--------------------------------------+
| Variable_name                   | Value
|
+---------------------------------+-----------------------------------------
----------------------------------------------------------------------------
--------------------------------------+
| ansi_mode                       | OFF
|
| back_log                        | 50
|
| basedir                         | /usr/local/
|
| binlog_cache_size               | 32768
|
| character_set                   | latin1
|
| character_sets                  | latin1 dec8 dos german1 hp8 koi8_ru
latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr
win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert               | ON
|
| connect_timeout                 | 5
|
| datadir                         | /var/mysql/
|
| delay_key_write                 | ON
|
| delayed_insert_limit            | 100
|
| delayed_insert_timeout          | 300
|
| delayed_queue_size              | 1000
|
| flush                           | OFF
|
| flush_time                      | 0
|
| have_bdb                        | NO
|
| have_gemini                     | NO
|
| have_innodb                     | NO
|
| have_isam                       | YES
|
| have_raid                       | NO
|
| have_ssl                        | NO
|
| init_file                       |
|
| interactive_timeout             | 28800
|
| join_buffer_size                | 131072
|
| key_buffer_size                 | 8388600
|
| language                        | /usr/local/share/mysql/english/
|
| large_files_support             | ON
|
| locked_in_memory                | OFF
|
| log                             | OFF
|
| log_update                      | OFF
|
| log_bin                         | OFF
|
| log_slave_updates               | OFF
|
| long_query_time                 | 10
|
| low_priority_updates            | OFF
|
| lower_case_table_names          | 0
|
| max_allowed_packet              | 1048576
|
| max_binlog_cache_size           | 4294967295
|
| max_binlog_size                 | 1073741824
|
| max_connections                 | 100
|
| max_connect_errors              | 10
|
| max_delayed_threads             | 20
|
| max_heap_table_size             | 16777216
|
| max_join_size                   | 4294967295
|
| max_sort_length                 | 1024
|
| max_user_connections            | 0
|
| max_tmp_tables                  | 32
|
| max_write_lock_count            | 4294967295
|
| myisam_recover_options          | OFF
|
| myisam_max_extra_sort_file_size | 256
|
| myisam_max_sort_file_size       | 2047
|
| myisam_sort_buffer_size         | 8388608
|
| net_buffer_length               | 16384
|
| net_read_timeout                | 30
|
| net_retry_count                 | 10
|
| net_write_timeout               | 60
|
| open_files_limit                | 0
|
| pid_file                        | /var/mysql/centauri.pid
|
| port                            | 3306
|
| protocol_version                | 9
|
| record_buffer                   | 131072
|
| query_buffer_size               | 0
|
| safe_show_database              | OFF
|
| server_id                       | 0
|
| skip_locking                    | OFF
|
| skip_networking                 | OFF
|
| skip_show_database              | OFF
|
| slow_launch_time                | 2
|
| socket                          | /var/mysql/mysql.sock
|
| sort_buffer                     | 2097144
|
| table_cache                     | 64
|
| table_type                      | MYISAM
|
| thread_cache_size               | 0
|
| thread_stack                    | 65536
|
| transaction_isolation           | READ-COMMITTED
|
| timezone                        | CST
|
| tmp_table_size                  | 1048576
|
| tmpdir                          | /tmp/
|
| version                         | 3.23.37
|
| wait_timeout                    | 28800
|
+---------------------------------+-
Thread
MySQL Lost Connection...Adam Douglas13 Aug
  • Re: MySQL Lost Connection...Irmund Thum14 Aug