> " intermittent connection problems (error 2013)"
>
> Look at SHOW PROCESSLIST; when you're having a connection problem. If you
> see lots of "unathenticated user" in the list, then it means you're having
> DNS problems.
>
> Typically the best way to handle this is to set skip-name-resolve, and using
> ip addresses instead of hostnames in your mysql users for authentication.
Or fix your DNS, if it's under your control.
If you have a named(8) running on your LAN, you should not have DNS timeouts.
It doesn't have to be authoritative -- set up a caching server on the same
machine that runs mysql and talk to it via localhost.
Take it from someone who just had to change all my static IPs -- keep IPs out
of your database connection code! ("Oh, THAT won't happen to me!" And then, it
does...)-:
----------------
Some of the current attempts at energy accounting, like the triple bottom line,
are an absolute a joke. They're an insult to children even in terms of their
intellectual content, because they try and compare vague abstractions of social
and environmental values — just dot pointed — against a completely econometric
financial accounting system of an organization which is actually doing the
work. -- David Holmgren
:::: Jan Steinman, EcoReality Co-op ::::
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
