MySQL Workbench 6.3(Mac)挂在简单查询上 [英] MySQL Workbench 6.3 (Mac) hangs on simple queries

问题描述

我在装有OS X Yosemite 10.10.5的Mac上使用MySQL Workbench 6.3.7 build 1199 CE(64位).我正在连接到Amazon RDS MySQL实例.

I am using MySQL Workbench 6.3.7 build 1199 CE (64 bits) on a Mac with OS X Yosemite 10.10.5. I am connecting to an Amazon RDS MySQL instance.

当我输入一个简单的查询时，例如

When I enter a simple query such as

select * from `devices`;

，然后单击带光标的闪电图标，查询开始，在下面的屏幕快照中，由启动器激活，位于"SQL File 4"选项卡旁边.但是，查询未完成，只是挂起.白色的红色停止标志图标已禁用.

and click the lightning-bolt-with-cursor icon, the query starts, indicated by the spinner activating next to the "SQL File 4" tab in the following screenshot. However, the query doesn't complete and it just hangs. The white-hand-in-red-stop-sign icon is disabled.

从现在开始，我只能强制退出MySQL Workbench.如果我尝试定期退出，则什么也不会发生.

I can only force quit MySQL Workbench from this point on. If I try to do a regular quit, nothing happens.

如何在数据库中持续运行简单查询?有时它可以工作(也许有10％的时间)，但是它大部分只是挂起.

How can I consistently run a simple query on my database? Sometimes it works (maybe 10% of the time), but it mostly just hangs.

推荐答案

为解决此问题，我将MySQL Workbench降级为6.1.现在，我可以运行查询了，并且它不会挂起.

To resolve this issue, I downgraded MySQL Workbench to 6.1. Now I am able to run my query and it doesn't hang.

这篇关于MySQL Workbench 6.3(Mac)挂在简单查询上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！