On Sun, Aug 02, 2009 at 11:18:38PM +0200, MPrik wrote: > Hi, > I have problem with connection to MySQL server running on Sun Netra X1. > Connecting to MySQL server takes average around 20 second, but it's > variable. After connect to the server, SQL queries are fast. Problem is > only with connection and it doesn't matter if I connecting through mysql > socket, localhost or client from LAN. The delay is same. I don't know > what is wrong, but it's very annoying and makes web pages which uses DB > very slow. The MySQL server is from package mysql-server-5.0.51a.tgz with > common my.cnf (sample my-small.cnf) configuration and running on OpenBSD > 4.3 GENERIC#1555 sparc64. I tried compile MySQL 4.1.22 from source but > problem is same. There's propably something wrong only with sparc64 > distribution because I have same configuration on OpenBSD 4.3 GENERIC#698 > i386 and without this problem. > After some attempts to find a solution to the problem I found technique > which make connection faster, but I don't know what that implies. If I > connect to the MySQL and at the same time execute something on server > into which I connecting, the connection accomplish immediately. If I > execute infinity loop like this "while true; do uptime; done;" connection > to MySQL afterwards isn't longer than 1 second. > > Can anybody help me how fix this problem?
Check your mysql logs. There may be a clue there. How is DNS on this machine? Does it resolve the machines trying to connect to it? -- Darrin Chandler | Phoenix BSD User Group | MetaBUG dwchand...@stilyagin.com | http://phxbug.org/ | http://metabug.org/ http://www.stilyagin.com/ | Daemons in the Desert | Global BUG Federation
