Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:128867
Message-ID: <3d5daf7d-450c-43c6-ab4f-c886863894a1@bastelstu.be>
Date: Sun, 19 Oct 2025 21:06:25 +0200
Precedence: list
MIME-Version: 1.0
Subject: Re: [PHP-DEV] [Discuss] Add PDO disconnect() and isConnected()
To: AllenJB <php.lists@allenjb.me.uk>, Kamil Tekiela <tekiela246@gmail.com>,
 Robert Wolf <rposky@gmail.com>
Cc: Claude Pache <claude.pache@gmail.com>,
 PHP internals <internals@lists.php.net>
References: <CANdUeaZhn-8b2+LZDV3UnT1sx+BVFcz=m7neQHyv7huGega+_Q@mail.gmail.com>
 <CE73D727-9546-469F-A723-FE667CA4061D@gmail.com>
 <CANdUeaZ0u-BmdUuX9XD--H2CA0zys+J8j5Cem4YQd2Q555m9Vw@mail.gmail.com>
 <CAGBsUrftu_-XfQQhKpBM_YJp_VOJJ1FyWNi+1wqZ+77q4LQSiQ@mail.gmail.com>
 <7b1f853f-1bb0-4d84-975b-164a71e092cc@allenjb.me.uk>
Content-Language: en-US
In-Reply-To: <7b1f853f-1bb0-4d84-975b-164a71e092cc@allenjb.me.uk>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
From: tim@bastelstu.be (=?UTF-8?Q?Tim_D=C3=BCsterhus?=)

Hi

On 10/1/25 16:45, AllenJB wrote:
> As I understand it, at least in the case of MySQL, the state of
> persistent connections is not managed by MySQL, but by the client (PHP).
> This means that it's (at least theoretically) possible for a connection
> to end up in an undesirable state, in which case there should be a way
> to close it so it's not reused.

I have filed https://github.com/php/php-src/issues/20225. I am not 
sufficiently knowledgeable about PDO, MySQLnd and MySQL itself to 
implement it myself, but it should not be particularly hard and I think 
it would greatly improve safety of using persistent connections with MySQL.

Best regards
Tim Düsterhus