This can be a serious issue, maybe a sign of some kind of data corruption.
If you lost the connection, probably the server is restarting (you can
check that on the error log), do this happen only with this table ?
Carlos
krishna chandra prajapati wrote:
Hi All,
I have connect to mysql-server using client. When i run the query it give
message lost connection to mysql. The details is as below.
mysql> select user_id, user_name from user_info;
ERROR 2013 (HY000): Lost connection to MySQL server during query.
System configuration is
Pentium 2.6 Ghz
Ram 1 GB
My.cnf
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
max_connections = 50
#table_cache = 64
#thread_concurrency = 10
sort_buffer_size = 1M
innodb_buffer_pool_size = 70M
innodb_log_buffer_size = 2M
innodb_additional_mem_pool_size = 8M
table_cache = 64
thread_cache_size = 8
read_buffer_size = 1M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 4M
#
# * Query Cache Configuration
#
query_cache_limit = 1M
query_cache_size = 16M
I don't understand why the connection get lost during simplest query
also.
Regards,
Krishna
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
