[TYPO3-Performance] MySQL connection slow?

[Dan Osipov]

Yes, its slow when connecting from the command line as well. The 
connection is by IP (10.0.0.*)
MySQL shows lots of slow queries and other problems, but nothing 
regarding connections.

Dan Osipov
Calkins Media
http://danosipov.com/blog/

Steffen Gebert wrote:
> Hi Dan,
> 
> Dan Osipov wrote:
>> I'm having a serious problem, where a connection to mySQL DB (residing
>> on a separate server) takes on average 2.5 seconds. This is the longest
>> task in page generation, and is unacceptable.
>>
>> I don't know where to begin to determine the cause of the problem. Both
>> servers are on a LAN. It could be a network issue, MySQL configuration,
>> OS configuration, or anything in between... Suggestions on where I
>> should look?
>>
> 
> Is it the same with mysql command line client? Have you tried to use the IP as server address (DNS problems?).
> Does it work well directly on the MySQL-Server?
> 
> Do you have default MySQL configuration or the same on other servers? Anything in Mysql log files?
> 
> Regards
> Steffen