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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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: Wed Apr 24 15:01:30 2024 UTC