How to manage MySQL connections within MySQL?

Question

Wehn I test the following PDO code, I could view the connections to MySQL in MySQL with show processlist, but how could I cut off one connection? Is there any other power tool for managing MySQL connection/etc other than command line?

<?php $dbh = new PDO('mysql:host=localhost;dbname=test', $user, $pass, array(PDO::ATTR_PERSISTENT => true)); // use the connection here // and now we're done; close it $dbh = null; ?>

Community · Accepted Answer · 2020-06-20 09:12:55Z

I've never worked with it, but there's KILL that looks like what you're looking for.

Each connection to mysqld runs in a separate thread. You can see which threads are running with the SHOW PROCESSLIST statement and kill a thread with the KILL thread_id statement.

In MySQL 5.0.0, KILL permits an optional CONNECTION or QUERY modifier:

Collectives™ on Stack Overflow

How to manage MySQL connections within MySQL?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related