duanke9540
2012-07-10 23:41
浏览 64
已采纳

XAMPP BETA 13:缓慢的mysql连接

I just installed a fresh xampp beta 13 installation however I noticed in my zend application profiler that connect to mysql database is so slow. I have refreshed many times but same slow result.

1020.84ms   connect
0.39ms  SELECT `tipo_usuario`.* FROM `tipo_usuario`
0.40ms  SELECT `palestra`.* FROM `palestra` ORDER BY `hora_inicio_prevista` asc

One friend has tested same application on other machine and It is normal, connect in less than 50 ms. I am using pdo mysql dll driver version 5.4.4.0, Client API version mysqlnd 5.0.10 - 20111026.

My environment: Apache/2.4.2 (Win32) OpenSSL/1.0.1c PHP/5.4.4

Any idea why connecting is slow?

图片转代码服务由CSDN问答提供 功能建议

我刚刚安装了一个全新的xampp beta 13安装但是我注意到在我的zend应用程序分析器中连接到mysql数据库是这样的 慢。 我刷新了很多次,但速度相同。

  1020.84ms connect 
0.39ms SELECT`tipo_usuario`。* FROM`tipo_usuario` 
0.40ms SELECT`parastra`。  *来自`palestra`ORDER BY`hora_inicio_prevista`asc 
   
 
 

一位朋友在其他机器上测试了相同的应用程序,这是正常的,连接时间不到50毫秒。 我正在使用pdo mysql dll驱动程序版本5.4.4.0,客户端API版本mysqlnd 5.0.10 - 20111026。

我的环境:Apache / 2.4.2(Win32)OpenSSL / 1.0.1c PHP /5.4.4

nn

想知道连接速度慢的原因吗?

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • doubei8541 2012-07-12 22:13
    已采纳

    As discussed in the comments: changing localhost to 127.0.0.1 in the connection function often solves connection issues with PDO. Here is a thread that covers this topic on more detail.

    点赞 打赏 评论

相关推荐 更多相似问题