2 messages in com.mysql.lists.mysqlRe: Authentication slow down?
FromSent OnAttachments
DSel...@microcast.net08 Aug 2000 13:59 
sin...@mysql.com09 Aug 2000 04:57 
Subject:Re: Authentication slow down?
From:sin...@mysql.com (sin@mysql.com)
Date:08/09/2000 04:57:32 AM
List:com.mysql.lists.mysql

DSel@microcast.net writes:

I'm having a peculiar problem which I can't seem to solve. I have a MySQL database set up to serve information to my company's very distributed network. This works very well for most of the ~300 servers on our network, but some of the servers have a hard time connecting to the mysql database. They connect and then hang... When I do a 'mysqladmin processlist' durring a hang, it shows:

ID: 2 User: unauthenticated user Host: 63.162.6.5 db: Command: Connect Time: State: login Info:

I tried starting mysqld with: mysqld -u mysql -O connect_timeout=1 -O interactive_timeout=1 -O wait_timeout=1 but that doesn't seem to help...

I'm running MySQL Version 2.23.21 Beta Installed from a binary RPM

Thanks In Advance...

Dave Seltzer

Hi!

You probably have permissions problems or problems with too many file descriptors and running processes. Check it out.

In order to avoid the above hanging, you should also set net_read and write timeouts.

Regards,

Sinisa

+----------------------------------------------------------------------+ | ____ __ _____ _____ ___ == MySQL AB | | /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic | | /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sin@mysql.com | | /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus | | /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ | | ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ | | /*/ \*\ Developers Team | +----------------------------------------------------------------------+