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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: php at zion-it dot com
New email:
PHP Version: OS:

 

 [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 17:00:03 2025 UTC