blocks|key|2991336|text|没有，没有内置的MySQL命令。有各种各样的工具和脚本支持它，你可以手动终止一些连接或重新启动服务器(但这样会更慢)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2991337|使用SHOW+PROCESSLIST查看所有连接，然后使用KILL命令删除要终止的进程ID。|offset|length|style|CODE|2991338|您可以编辑超时设置，让MySQL守护进程自行终止非活动进程，或者增加连接计数。您甚至可以对每个用户名的连接数量进行限制，这样，如果进程继续行为不佳，唯一受影响的进程就是该进程本身，并且数据库上的其他客户端也不会被锁定。|BOLD|2991339|如果您不能再连接到服务器，您应该知道MySQL总是为具有SUPER+privilege的用户保留一个额外的连接。除非您的违规进程出于某种原因使用了具有该权限的用户名...|2991340|然后，在你可以再次访问你的数据库之后，你应该修复产生那么多连接的进程(网站)。|2991341|entityMap^0|0|2|G|T|4|0|1L|1G|0|0|X|Y|1F|S|5|0|0|13|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@$D|S|E|T|F|G]|$D|U|E|V|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@$D|X|E|Y|F|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|Z|8|@$D|10|E|11|F|J]|$D|12|E|13|F|J]|$D|14|E|15|F|G]]|9|@]|A|$]]|$1|M|3|N|5|6|7|16|8|@$D|17|E|18|F|J]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|P|$]]

No, there is no built-in MySQL command for that. There are various tools and scripts that support it, you can kill some connections manually or restart the server (but that will be slower).

Use <code>SHOW PROCESSLIST</code> to view all connections, and <code>KILL</code> the process ID's you want to kill.

You could edit the timeout setting to have the MySQL daemon kill the inactive processes itself, or raise the connection count. You can even limit the amount of connections per username, so that if the process keeps misbehaving, the only affected process is the process itself and no other clients on your database get locked out.

If you can't connect yourself anymore to the server, you should know that MySQL always reserves 1 extra connection for a user with the <code>SUPER</code> privilege. Unless your offending process is for some reason using a username with that privilege...

Then after you can access your database again, you should fix the process (website) that's spawning that many connections.

blocks|key|282524|text|如上所述，没有特殊的命令可以做到这一点。但是，如果所有这些连接都是非活动，则使用“flush+tables；”能够释放所有那些非活动的连接。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|282525|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

As above mentioned, there is no special command to do it. However, if all those connection are inactive, using 'flush tables;' is able to release all those connection which are not active.

blocks|key|282532|text|mysql>+SHOW+PROCESSLIST;
%2B-----%2B------%2B-----------------%2B------%2B---------%2B------%2B-------%2B---------------%2B
%7C+Id++%7C+User+%7C+Host++++++++++++%7C+db+++%7C+Command+%7C+Time+%7C+State+%7C+Info++++++%7C
%2B-----%2B------%2B-----------------%2B------%2B---------%2B------%2B-------%2B----------------%2B
%7C+143+%7C+root+%7C+localhost:61179+%7C+cds++%7C+Query+++%7C++++0+%7C+init++%7C+SHOW+PROCESSLIST+%7C
%7C+192+%7C+root+%7C+localhost:53793+%7C+cds++%7C+Sleep+++%7C++++4+%7C+++++++%7C+NULL++++++%7C
%2B-----%2B------%2B-----------------%2B------%2B---------%2B------%2B-------%2B----------------%2B
2+rows+in+set+(0.00+sec)

mysql>+KILL+192;
Query+OK,+0+rows+affected+(0.00+sec)|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|282533|用户192+:|unstyled|offset|length|style|BOLD|282534|mysql>+SELECT+*+FROM+exept;
%2B----%2B
%7C+id+%7C
%2B----%2B
%7C++1+%7C
%2B----%2B
1+row+in+set+(0.00+sec)

mysql>+SELECT+*+FROM+exept;
ERROR+2013+(HY000):+Lost+connection+to+MySQL+server+during+query|282535|entityMap^0|0|0|7|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|P|8|@$G|Q|H|R|I|J]]|9|@]|A|$]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$B|C]]|$1|M|3|-4|5|F|7|T|8|@]|9|@]|A|$]]]|N|$]]

blocks|key|280939|text|我建议检查连接，以显示最大线程连接数为|type|unstyled|depth|inlineStyleRanges|entityRanges|data|280940|show+variables+like+"max_connections";|code-block|syntax|javascript|280941|示例|280942|%2B-----------------%2B-------%2B
%7C+Variable_name+++%7C+Value+%7C
%2B-----------------%2B-------%2B
%7C+max_connections+%7C+13++%7C
%2B-----------------%2B-------%2B
1+row+in+set|280943|然后通过示例增加它|280944|set+global+max_connections+=+500;|280945|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

I would recommend checking the connections to show the maximum thread connection is

<pre><code>show variables like "max_connections";
</code></pre>

sample 

<pre><code>+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| max_connections | 13 |
+-----------------+-------+
1 row in set
</code></pre>

Then increase it by example

<pre><code>set global max_connections = 500;
</code></pre>

blocks|key|3205117|text|在MySQL工作台中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3205118|左侧导航器>管理>客户端连接|3205119|它为您提供了终止查询和连接的选项。|3205120|注意:这并不像OP所要求的那样是错误的，但是像我这样的MySQL工作台用户可能会在这里结束|3205121|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

In MySQL Workbench:

Left-hand side navigator > Management > Client Connections

It gives you the option to kill queries and connections.

Note: this is not TOAD like the OP asked, but MySQL Workbench users like me may end up here

blocks|key|2991453|text|虽然你不能用一条命令杀死所有打开的连接，但如果有太多的手工操作，你可以创建一组查询来帮你做这件事。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2991454|此示例将为所有从192.168.1.1到my_db的some_user连接创建一系列KILL+<pid>;查询。|offset|length|style|CODE|2991455|SELECT+
CONCAT('KILL+',+id,+';')+
FROM+INFORMATION_SCHEMA.PROCESSLIST+
WHERE+`User`+=+'some_user'+
AND+`Host`+=+'192.168.1.1'
AND+`db`+=+'my_db';|code-block|syntax|javascript|2991456|entityMap^0|0|8|B|K|5|Q|9|16|B|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|P|8|@$D|Q|E|R|F|G]|$D|S|E|T|F|G]|$D|U|E|V|F|G]|$D|W|E|X|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|Y|8|@]|9|@]|A|$K|L]]|$1|M|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|N|$]]

While you can't kill all open connections with a single command, you can create a set of queries to do that for you if there are too many to do by hand.
This example will create a series of <code>KILL &lt;pid&gt;;</code> queries for all <code>some_user</code>'s connections from <code>192.168.1.1</code> to <code>my_db</code>.
<pre class="lang-sql prettyprint-override"><code>SELECT 
CONCAT('KILL ', id, ';') 
FROM INFORMATION_SCHEMA.PROCESSLIST 
WHERE `User` = 'some_user' 
AND `Host` = '192.168.1.1'
AND `db` = 'my_db';
</code></pre>

I'm building a website with MySQL. I'm using TOAD for MySQL and suddenly I can't connect to the database as I'm getting an error:

<blockquote>
 "Too many connections"
</blockquote>

Is there any way in Toad for MySQL to view existing connections to be able to kill them or simple close all connections all together?

How to kill MySQL connections

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在和MySQL一起建一个网站。我正在使用TOAD for MySQL，突然我无法连接到数据库，因为我收到了一个错误： "Too many“在Toad for MySQL中，有没有什么方法可以查看现有的连接，从而能够终止它们或简单地将所有连接一起关闭？

问如何终止MySQL连接
EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何终止MySQL连接EN

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何终止MySQL连接
EN