php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #31838 enable mysql transactions per session instead per script
Submitted: 2005-02-04 00:56 UTC Modified: 2010-12-22 03:27 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:0 (0.0%)
Same OS:0 (0.0%)
From: php at zion-it dot com Assigned:
Status: Not a bug Package: *General Issues
PHP Version: 4.3.10 OS: redhat
Private report: No CVE-ID: None
 [2005-02-04 00:56 UTC] php at zion-it dot com
Description:
------------
You should be able to keep a database connection open (like persistent connections) and execute transactions for mysql in another script for that specific mysql user and ip address.

At the moment might apache create a new child process for a new http request and that makes it impossible to reuse the open database connection, because this new apache child process creates also a new database connection.

The idea is that you can insert/delete/update in the mysql database and check the consequences in related scripts. When you do not like that, then you should be able to rollback and otherwise commit.

Expected result:
----------------
Full control of keeping database connections open and reuse them.


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2010-12-22 03:27 UTC] johannes@php.net
-Status: Open +Status: Bogus -Package: Feature/Change Request +Package: *General Issues
 [2010-12-22 03:27 UTC] johannes@php.net
This would at first be a feature request for the MySQL server to be ale to use a transaction with different connections as there is no way for PHP to guarantee that you hit the same web server child with the same connection again.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Mon Jul 21 22:00:03 2025 UTC