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?
