# PAINFULLY slow authentication

**URL:** <https://forums.percona.com/t/painfully-slow-authentication/3622>\
**Category:** Other MySQL® Questions\
**Created:** [July 17, 2014, 10:43am UTC](https://forums.percona.com/t/painfully-slow-authentication/3622 "2014-07-17T10:43:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lkrueger](https://avatars.discourse-cdn.com/v4/letter/l/f04885/32.png) [@lkrueger](https://forums.percona.com/u/lkrueger)\
**Post date:** [July 17, 2014, 10:43am UTC](https://forums.percona.com/t/painfully-slow-authentication/3622/1 "2014-07-17T10:43:17Z")

</div>

Hi All~ I am running Percona Cluster 5.6 for my C# web application and am experiencing ridiculously slow connection times to mysql. Around 15 to 20 seconds!  
While testing, I’m looking at the client connections in MySQL workbench and can see the connections come in, but they sit in the unauthenticated state for the aforementioned time period.  
Anyone else experience something similar? I’ve also tried it on a standalone Percona Server with the same results  
I’m using the MySQL session state provider, my Global.asax writes to a login log, and my index page grabs a value from the db (so, 3 connections initially).  
Here are some of the settings in my.cnf:  
skip-name-resolve  
max\_connections = 1000  
max\_connect\_errors = 100  
max\_allowed\_packet = 32M  
max-heap-table-size = 32M  
tmp-table-size = 32M  
thread\_cache\_size = 2000  
open-files-limit = 65535  
innodb\_buffer\_pool\_size = 5G  
Percona Cluster is on a Ubuntu 14.04 trusty installation running 8GB memory and a Intel Core i3. My webcode is on a Windows 2012 server using IIS8  
Any ideas? Any thoughts would be much appreciated!

---

<div class="post-metadata">

**Author:** ![taka-h](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/taka-h/32/1023_2.png) [@taka-h](https://forums.percona.com/u/taka-h)\
**Post date:** [July 17, 2014, 5:23pm UTC](https://forums.percona.com/t/painfully-slow-authentication/3622/2 "2014-07-17T17:23:27Z")

</div>

hi. how about skip-name-resolve setting? [url][http://bobbyallen.wordpress.com/2007/11/02/slow-connections-on-remote-mysql-servers/[/url]](http://bobbyallen.wordpress.com/2007/11/02/slow-connections-on-remote-mysql-servers/%5B/url%5D)

---

<div class="post-metadata">

**Author:** ![lkrueger](https://avatars.discourse-cdn.com/v4/letter/l/f04885/32.png) [@lkrueger](https://forums.percona.com/u/lkrueger)\
**Post date:** [July 18, 2014, 10:55am UTC](https://forums.percona.com/t/painfully-slow-authentication/3622/3 "2014-07-18T10:55:42Z")

</div>

Yep, that’s already in my config file. No luck ☹