[TYPO3-Performance] MySQL connection slow?

[Steffen Gebert]

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