在查询期间，mysql工作台失去与mysql的连接 [英] Lost connection to mysql during query, mysql workbench

问题描述

我有同样的问题，这当我想索引一个非唯一的列是一个整数的非常大的表，我尝试所有的解决方案，在该文章中至少有一个投票。我仍然无法解决它。任何其他想法？

I have the same problem as this when I want to index a very large table on one of its non-unique columns which is an integer, and I tried all the solutions that are proposed in that post that has at least one vote up. I still couldn't fix it. Any other ideas?

我有足够的记忆：

max_allowed_pa​​cket：2G，
innodb_buffer_pool_size：9G

max_allowed_packet: 2G, innodb_buffer_pool_size: 9G

此帖和这里设置为比默认值高得多的数字。

All the time out settings mentioned in this post and here are set to much higher numbers than the default.

推荐答案

没有必要的答案，在mysql workbench失去连接它是一个解决方法。当谈到在mysql workbench长时间运行查询，即使一个更改mysql工作台参数，似乎有一个连接time_out问题仍然发生。所以，从mysql命令行运行查询，看看它是否工作。如果它运行从mysql命令行而不是从工作台，你知道它只是一个mysql工作台问题，而不是一些其他问题。

While this is not necessary an answer for loosing connection in mysql workbench it is a workaround. When it comes to long running queries in mysql workbench, even if one changes the mysql workbench parameters, there seems to be a connection time_out issue still occuring. So, run the query from mysql command line and see if it works. If it works when you run from the mysql command line and not from workbench, you know its just a mysql workbench issue and not some other issue.

这篇关于在查询期间，mysql工作台失去与mysql的连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！