from http://dev.mysql.com/doc/refman/5.1/en/connecting.html
On Unix, MySQL programs treat the hostname |localhost| specially, in a
way that is likely different from what you expect compared to other
network-based programs. For connections to |localhost|, MySQL programs
attempt to connect to th
Presently, I'm only using localhost for MySQL database user
privileges, e.g., :
[EMAIL PROTECTED] -- for all privileges on all databases
Do I need to change the above if I add skip-name-resolve to my.cnf?
(Since localhost is, I thought, not really part of DNS but just an
alias for
So with skip-name-resolve in my.cnf (and MySQL restarted), it should
be okay to have [EMAIL PROTECTED] in the GRANT table since localhost
resolves without DNS lookup? Or do I need to specify [EMAIL PROTECTED]
Sorry, just need to clarify this bit before changing a few things.
Thanks again.
Hi Rene,
(Note I have updated my reply address to my current company name).
Yes, you can still use a hostname in the connection string, that's not
what mysql uses it for, that hostname gets you from the client to the
server. If you use GRANT to permit access from certain hosts IE 'grant
a
distribution to any party other than intended recipient. Sender does
not necessarily endorse content contained within this transmission.
> CC: [EMAIL PROTECTED]; mysql@lists.mysql.com
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Re: Ancient, unsolved high-CPU probl
Thanks. I've read those links, and they sound like my problem.
On each connection, MySQL calls gethostbyname() to resolve the
hostname in the connection string into 127.0.0.1 -- e.g.,
mysql_connect("localhost", "user", "password") -> 127.0.0.1. Because
FreeBSD 4.0's (and Mac OS X's) DNS l
Hi Rene,
This smells like an old freebsd issue with a non thread safe
get-host-by-name issue and possibly other thread issues. Since Mac
OS/X/Darwin is a freebsd 4 branch it is a good bet they are the same.
Is it possible for you to try adding "skip-name-resolve" to my.cnf.
Alternatively you
In case a bit more data might help, here's what the server looks like
right now, while experiencing the strange high-CPU load:
VM_STAT sayeth:
Mach Virtual Memory Statistics: (page size of 4096 bytes)
Pages free: 534327.
Pages active: 331233.
Pages inactive:
