In this blog entry I’d like to describe how you might be able to
improve how MySQL performs on Windows by ensuring that you take
advantage of a Windows specific configuration setting.
On Unix systems, MySQL programs treat the localhost host
name specially. For connections to localhost, MySQL
programs attempt to connect to the local server by using a Unix
socket file, which has some performance advantages over a TCP/IP
connection. Windows does not support Unix sockets, however, and
hence does not benefit from this optimisation.
However, the use of … [Read more...]