php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #62688 no common cache for httpd-workers?
Submitted: 2012-07-29 14:16 UTC Modified: 2017-10-26 17:06 UTC
From: spam2 at rhsoft dot net Assigned:
Status: Closed Package: mysqlnd_qc (PECL)
PHP Version: 5.3.15 OS: Linux
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: spam2 at rhsoft dot net
New email:
PHP Version: OS:

 

 [2012-07-29 14:16 UTC] spam2 at rhsoft dot net
Description:
------------
as far as i can see in the hit-stats it seems that mysqlnd_qc has not a common cache for a query - each httpd-worker has it's own non-shared cache

this is a design mistake

1. you do not benfit from the cache at all if there a 400 workers
2. you are wasting memory by have 400 copies of the same result

on high traffic websites mysqlnd_qc would be a hughe improvement with a cache time of 2-4 seconds for conent-queries when you have hundrets of requests per second, but if you have some hundret active workers with a non-shared cache this does not help much

the cache should work like APC with a mmap'ed common storage


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2017-10-24 23:21 UTC] kalle@php.net
-Status: Open +Status: Suspended
 [2017-10-24 23:21 UTC] kalle@php.net
The mysqlnd_qc package have not had a release for 4 years, so its safe to say that there is no longer any activity for this, if development picks back up then this report should be re-opened.
 [2017-10-26 17:06 UTC] spam2 at rhsoft dot net
-Status: Suspended +Status: Closed
 [2017-10-26 17:06 UTC] spam2 at rhsoft dot net
foregt it, as most pecl extensions this never made it to a useable state or later went to bitrot while pecl.php.net even don't show a warning for extensions abandoned a decade ago like https://pecl.php.net/package/GDChart which makes pecl with very few exceptions a red line for me when you need to smell if some peice of code will ever get security fixes or work with the next php version
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun Dec 22 09:01:29 2024 UTC