MySQL Bugs: #36554: per session persistent connection for MySQL connectors

Bug #36554	per session persistent connection for MySQL connectors
Submitted:	7 May 2008 9:40	Modified:	15 Feb 2009 22:23
Reporter:	Sebastian Mendel (Basic Quality Contributor)	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Connectors: mysqlnd ( PHP )	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	qc

Description:
wouldn't it be very helpful if mysql connectors support some sort of per session persistent connection?

this would save a lot of queries in many apps, for example SET NAMES, setting variables, creating temporary tables

or are there any other methods i am not aware of to achieve this?

How to repeat:
?

Hi Sebastian and thanks for your report.

It is not clear from the way you presented it what you're actually asking for. Maybe you should check php@lists.mysql.com or, at least, send us an example or use case.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Sebastian, mysqlnd has persistent connections. They are per process. If your deployment models lets a PHP process serve multiple requests all the requests served by the process can reuse a persistent connection. And that persistent connection would have maintained its state (incl. temporary tables), if you do not reset the connection using change user, which is the default. As a power user have a look at ext/mysqli/mysqli_nonapi.c and search for "MYSQLI_NO_CHANGE_USER_ON_PCONNECT". As a feature for the masses, sorry, no idea how to do it in a reasonable easy to use way...