Hello everybody,
We have a similar posting on the german part of the board:
viewtopic.php?f=4&t=50971 (last 3 entrys)
There are hints, that this speed issue maybe only occurs on 64Bit machines with mysqli. I haven't tested this yet, because i don't have a physical 32Bit Windows 7 machine i can use for.
JonB wrote:I think #3 is not correct at all - % is a potential security risk, it means ANY host can connect. They are actually two different users as far as MySQL is concerned AFAIK (they can have different privileges, and have unique rows)
I totally agree with this. Any host (%) can be a huge security issue if your mysql-server is accessible from a bigger Network. if you want to switch off the name resolution for mysql, you simply need another mysql user entry for host 127.0.0.1. And AFAIK it is correct, that each mysql user entry with the same name but from different hosts is fully unique and independent from other users with the same name.
JonB wrote:I don't think there is an external lookup on localhost.
unfortunately i can't find any official Microsoft information on this. I have had a conversation with my external Windows Guru some weeks ago if the localhost lookup is a true lookup (The TCP Stack is sending an internal lookup requests and getting an answer on it) or a simple mapping implemented in the TCP Stack. Because of some problems with the IP Stack on Windows with localhost it normally can only be the first opinion.
I guess this will not make any differnece because all the problems with the IP Stack could not be solved with this entry on the HOSTS file, but i really don't know.
It can't hurt, so i think adding this entry in the HOSTS file is worth to test it.
JonB wrote:I do not know if this is true: (Altrea could better judge) I don't think it makes any difference - but that is a guess.
4. In your PHP application, ensure it is connecting to MySQL via 127.0.0.1 instead of 'localhost'. This eliminates the DNS lookup.
I don't think if the lookup will be eliminated, but it definitely makes a difference if you use localhost or 127.0.0.1 in a connection string of that php application. I have had some Joomla problems on one of my client VMs with an early beta of XAMPP 1.7.4 i think where localhost connections wasn't successful but 127.0.0.1 was.
best wishes,
Altrea