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
 [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: Fri Mar 29 13:01:29 2024 UTC