即使使用"MySQL 5.6 Command Line Client"，MySQL 5.6仍需要花费很长时间进行连接. [英] MySQL 5.6 takes long time to connect, even with the "MySQL 5.6 Command Line Client"

问题描述

我有MySQL 5.6.16，并且工作正常，突然之间MySQL连接变得如此缓慢(20-21秒)，我什至完全删除了它，即使有数据表，也下载并安装了ver. 5.6.19使用全新的安装，但这并不能解决长时间的连接，即使与MySQL Command Line Client保持长时间连接也需要20秒才能返回"mysql>".

I have had MySQL 5.6.16 and was working perfect suddenly the MySQL connection become so slow to connect (20 - 21 seconds) I have removed it completely even with the data tables and downloaded and installed ver. 5.6.19 with a fresh and new installation, but this didn't fix the long time connection EVEN with the MySQL Command Line Client it takes 20 seconds to return the "mysql>".

任何具有mysql查询连接的基于Web的php代码都需要20秒才能获取数据页面.

Also any web-based php code with mysql query connection takes 20 sec to get the data page.

我还尝试启用skip_name_resolve/connect_timeout = 10/wait_timeout = 50，但这都不起作用.

I also tried enabling skip_name_resolve / connect_timeout = 10 / wait_timeout = 50 but non of this did anything.

我有: Windows 7家庭高级版SP1 x64 MySQL 5.6.19-企业级-商业级 Apache 2.4.9(Win64)OpenSSL 1.0.1f PHP 5.5.10 MySQL全局状态: https://www.dropbox.com/s/gz44pvtomwbncog/MYSQL_GLOBAL_STATUS.txt

I have: Windows 7 Home Premium SP1 x64 MySQL 5.6.19-enterprise-commercial-advanced Apache 2.4.9 (Win64) OpenSSL 1.0.1f PHP 5.5.10 MySQL Global Status: https://www.dropbox.com/s/gz44pvtomwbncog/MYSQL_GLOBAL_STATUS.txt

推荐答案

无论如何，还是由于Windows的原因，我弄清楚了这个问题，我使用了一个修复工具:"Tweaking.com-Windows修复"并将其修复.这个问题...

Thanks anyway, I have figured out that this issue because of the windows, I have used a repair tool: "Tweaking.com - Windows Repair" and it fixed this issue...

这篇关于即使使用"MySQL 5.6 Command Line Client"，MySQL 5.6仍需要花费很长时间进行连接.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！