MySQL Bugs: #7102: Unable to connect to MySQL server

Bug #7102	Unable to connect to MySQL server
Submitted:	8 Dec 2004 12:28	Modified:	20 Dec 2004 5:59
Reporter:	Krok Void	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.22	OS:	FreeBSD (FreeBSD 5.2.1)
Assigned to:	Lachlan Mulcahy	CPU Architecture:	Any

Description:
MySQL server installed from FreeBSD ports collection works fine for some time (from several hours to several days) but then it's unable to conncet to MySQL server :
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

But server is still running. Process's state is biord. And truss -p <pid> doesn't show anything.

Can anybody explain me where is the problem - OS or MySQL server ?

There is Apache 1.3.31 + PHP 4.3.9 using MySQL, processing about 150 mysql queries per second to 15 databases (each databases is about 20-40 tables. Some tables contain more then 500'000 rows.) 

How to repeat:
Can't repeat

BTW, here is /etc/my.cnf :

[mysqld]
port            = 3306
socket          = /tmp/mysql.sock
skip-bdb
skip_networking
skip_show_database
skip-locking

set-variable    = thread_cache=8
set-variable    = max_connections=1000
set-variable    = key_buffer=128M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=1024
set-variable    = sort_buffer_size=1M
set-variable    = read_buffer_size=256K
set-variable    = read_rnd_buffer_size=512K
set-variable    = myisam_sort_buffer_size=32M
set-variable    = net_buffer_length=16K
set-variable    = back_log=10
set-variable    = tmp_table_size=32M
set-variable    = wait_timeout=3600

set-variable    = max_user_connections=990

set-variable    = log_error=/var/db/mysql.log

set-variable    = query_cache_type=1
set-variable    = query_cache_limit=1M
set-variable    = query_cache_size=32M

# Try number of CPU's*2 for thread_concurrency
set-variable    = thread_concurrency=4
#log-bin
#server-id      = 1

# Point the following paths to different dedicated disks
#tmpdir         = /tmp/
#log-update     = /path-to-dedicated-directory/hostname
log-slow-queries= /var/db/mysql/slow.log
#log            = /var/db/mysql/query.log

Hi Krok,

Unfortunately we're unable to provide you with any general support through the bugs channel. 

I would recommend trying our official FreeBSD binaries available at http://dev.mysql.com/
downloads and if you still have further problems I have no doubt you will find the assistance you 
need either on our mailing lists or our public IRC channel (which is frequented by many MySQL 
employees).

Details on the lists are available here: http://lists.mysql.com

The public IRC channel is on the FreeNode IRC network: irc.freenode.net as #mysql.

If you do reach a point where you are confident that something is a bug please feel free to raise 
a new bug report.

I appreciate you taking the time to lodge a bug report.

Thanks for your interest in MySQL. 

Kind Regards,
Lachlan Mulcahy