mysqlnd query cache plugin benchmark report
TRANSCRIPT
MySQL native driver for PHP:Query cache pluginbenchmark impressions
mysqlnd_qc:
Benchmark impressions
Ulf Wendel, Andrey HristovMySQL Connectors TeamSun Microsystems
Table of Contents
Setup and WarningHardware
Software
Oxid eShopSingle machine
Two machines
Artificial testsqc_load.php, mysqlnd_qc_perf.phpt
Conclusions
Performance art
Performance by number of columns and result set size
Hardware / Software
Box A: Intel Core 2 Duo E6750 @ 2.66 GHzRAID-0, 4 GM RAM
Apache 2.2.6 (MPM = prefork = default)
PHP 5.3.3-dev
MySQL 5.1.39-debug Source
APC 3.1.3p1
Memcache 1.4.3
libmemcached 0.37
Hardware / Software
Box B: Athlon 64 X2 Dual Core 5000+MySQL 5.1.25-rc Source
1 GBit network
Runs ouf of RAM
Single machine setupBox A running PHP, Apache, MySQL, Memcache
Two machines setupBox A running PHP, Apache, Memcache
Box B running MySQL
Oxid eShop 4.2.0
Price winning PHP web shopCommunity Edition 4.2.0
Generates high CPU and DB loadObject-oriented design, many layers
ADOdb Lite, ext/mysql
Smarty
Demo shop frontpage: ~150 database queries
Real-life shop frontpages: >>1k database queries
No practical value?
ab -n -c /oxid/index.phpFront page only
No browsing
No ordering
Assumption: all queries can be cached
Theoretical not practical resultsRun your own tests!
We show theoretical maximum, only!
bench/qc_load.php
Run queries for secondsfetch rows per query
No practical meaningStorage handler stress testing, only!
tests/mysqlnd_qc_perf.php
Run times SELECT to fetch one row columns
bytes total per row
No practical meaningStorage handler stress testing, only!
Table of Contents
Setup and WarningHardware
Software
Oxid eShopSingle machine
Two machines
Artificial testsqc_load.php, mysqlnd_qc_perf.phpt
Conclusions
Oxid, 1 box: PHP/Apache/MySQL
CPU bound from 2 clients on, MySQL Server QC wins
Oxid, 1 box: 1 vs. 10 clients absolut
Higher impact once CPU bound, MySQL Server QC wins
Oxid, 1 box: 1 vs. 10 clients relative
Relative: 200% 400%, MySQL Server QC wins
MySQLnd QC Plugin vs. Server QC
MySQLnd QC Plugin is insecureCan serve stale data
No knowledge of transactions
No knowledge of temporary tables
No knowledge of user variables
No knowledge of MERGE and stuff
No authentification
No protection of cache entries
Server QC can cache moreFor benchmarks set: cache_no_table = 1
Oxid, 1 box: theoretical maximum
Tuned with cache_no_table = 1, PHP QC w. APC wins
Thoughts on tuning
CPU bound from 2 clients onMySQL eats 1 out of 2 cores
PHP tuning irrelevant, if MySQL eats 1 core
Cache tuning is irrelevant
Goal #1: kick out MySQL!cache all queries!
cache_no_table = 1
cache_no_table = 1 = MySQL Server QC
Oxid, 1 box: 1 vs. 10 clients tuned
Tuned with cache_no_table = 1, PHP QC w. APC wins
How important is byte code caching?
Irrelevant... if your application is CPU bound
and, if you are CPU bound because of MySQL
if your application is I/O bound
and, if your are I/O bound because of MySQL
if
But you still want to use it together with QC!
Oxid, 1 box: PHP byte code caching
Byte code caching is nothing without query caching
Oxid, 1 box: BC gains (1 client)
With/without BC compared: 20% - 60% win
Oxid, 1 box: QC gains (1 client)
Without BC, with/without QC compared: 3% - 75% win
Oxid, 1 box: BC + QC gains (1 client)
With BC and QC: 3% - 120% win
Oxid, 1 box: Use QC and BC together
10 clients: performance improvements up to 180%
Query caching and your CPU
Turn on central heating in the winter
Turn off fans in summer
Oxid, 1 box: CPU bound workload
Lower MySQL CPU time in favour of PHP CPU time!
Oxid, 1 box: MySQL CPU usage
Share cache contents between PHP worker processes
Oxid, 1 box: MySQL CPU usage
Tuned (cache_no_table=1) to eliminate MySQL usage
Oxid, 1 box: goal #1 is fewer queries!
Monitor MySQLs' Com_select and Queries statistics
Oxid, 2 boxes: PHP/Apache + MySQL
PHP QC and MySQL Server QC about equal fast
Oxid, 2 boxes: 1 vs. 10 clients
Relative: 130 200%, CPU bound on PHP/Apache box
Oxid, 2 boxes: PHP/Apache + MySQL
Tuning (cache_no_table=1), theoretical maximum
Is Memcache storage slow?
Invalid benchmark setup!CPU bound: Memcache eats PHP resources
Why Memcache if using only one PHP machine?
Needs to be benchmarked with 3+ boxes
Table of Contents
Setup and WarningHardware
Software
Oxid eShopSingle machine
Two machines
Artificial testsqc_load.php, mysqlnd_qc_perf.phpt
Conclusions
Performance degration with QC?
Rather not - difference is less than 1%
Which handler is best?
Check the basicsWhat is available?
Share contents among processes?
Share contents among machines?
Handler specific features, e.g. statistics
All handler seem to scale about equally well if you consider their general properties
qc_load.php, 1 box: 20s, 100 rows
Significant performance differences
qc_load.php, 1 box: 20s, 100 rows
1 vs. 10 clients, CPU bound from 2 clients on
qc_load.php, 1 box: 20s, 100 rows
Handler scalability by number of clients
mysqlnd_qc_perf.phpt, Memcache
Average speedup: 1.40
mysqlnd_qc_perf.phpt, User handler
Average speedup: 1.41
mysqlnd_qc_perf.phpt, APC
Average speedup: 1.48
mysqlnd_qc_perf.phpt, Default
Average speedup: 1.55
Observations
CPU boundless MySQL means more PHP
MySQL % CPU can be reduced by factor 30!
cache as much as you can!
cache handler: start with default
cache handler: step up to APC/Memcache
Network boundclient cache outperforms server cache
The End
Feedback: [email protected]
The End
Feedback:
[email protected],
[email protected]
Oxid eShop 4.2 Community EditionSingle machine, APC Byte Code cache on/offRequests/s1 client1 client (BC)2 clients2 clients (BC)10 clients10 clients (BC)
Out-of-the-box2.222.763.133.662.532.77
PHP QC, user handler2.372.823.463.912.93.2
PHP QC, default3.545.015.948.395.477.08
PHP QC, Memcache3.545.166.268.91.#NAN8.22
MySQL Server Query Cache, 5.13.926.287.0211.16.6510.53
Oxid eShop 4.2 Community EditionSingle machine, tuned: cache_no_table=1Requests/s1 client10 clients
Out-of-the-box (BC on)2.762.77
PHP QC, user handler3.013.21
PHP QC, Memcache5.6910.13
PHP QC, default5.88.57
MySQL Server Query Cache, 5.16.2810.53
PHP QC, APC6.3311.45
Oxid eShop 4.2 Community EditionSingle machine: Byte code and Query cachingRelative performance % (Req/s)1client2 clients10 clients
Out-of-the-box (without BC)100100100
Out-of-the-box (with BC)124.324324324324116.932907348243109.486166007905
PHP QC, default (without BC)159.459459459459189.776357827476216.205533596838
PHP QC, default (with BC)225.675675675676268.051118210863279.841897233202
Oxid eShop 4.2 Community EditionSingle box, without BC, MySQL % CPUMySQL % CPU (approx.)1 client2 clients10 clients
Out-of-the-box509080
PHP QC, default153540
Oxid eShop 4.2 Community EditionSingle box, with BC, MySQL % CPUMySQL % CPU (approx.)1 client2 clients10 clients
Out-of-the-box (with BC)6010090
PHP QC, default (with BC)254560
PHP QC, APC (with BC)153535
Sun Microsystems, Inc.
Page
Click to edit the title text format
Click to edit the outline text formatSecond Outline Level
Click to edit the notes format
Page
Click to edit the title text format
Presenters NamePresenters TitlePresenters Company
Click to edit the notes format
Page
Oxid eShop 4.2 Community EditionSing box, with BC, MySQL % CPU, tunedMySQL % CPU (approx.)1 client2 clients10 clients
Out-of-the-box 6010090
PHP QC, default254560
PHP QC, default (cache_no_table=1)32025
PHP QC, APC153535
PHP QC, APC (cache_no_table=1)377
Oxid eShop 4.2 Community EditionSingle box, Com_select after test runCom_select (abs.)1 client2 clients10 clients
Out-of-the-box 880008800088000
PHP QC, default173721650621008
PHP QC, APC115431152111505
PHP QC, APC (cache_no_table=1)944811891
Oxid eShop 4.2 Community Edition2 boxes, relative performance gainsPerformance % (Req./s)1 client10 clients
Out-of-the-box (without BC)100100
Out-of-the-box134.256055363322153.116147308782
PHP QC, user146.712802768166148.441926345609
MySQL Server Query Cache, 5.1178.200692041523154.957507082153
PHP QC, default183.044982698962164.589235127479
PHP QC, Memcache185.121107266436143.626062322946
PHP QC, APC194.809688581315163.314447592068
Oxid eShop 4.2 Community Edition2 boxes, tuned: cache_no_table=1Requests/s1 client2 clients10 clients20 clients40 clients
Out-of-the-box (without BC)2.894.897.067.067.04
Out-of-the-box3.887.0610.8110.8510.81
PHP QC, user4.147.1210.461.#NAN1.#NAN
MySQL Server Query Cache, 5.15.158.410.9410.8411.05
PHP QC, default5.8811.1611.8811.8211.82
PHP QC, Memcache5.8311.0910.0210.0710.07
PHP QC, APC6.3311.5711.8511.8611.89
qc_load.php: run 4 queries for 20s, 100 rowsSingle box, performance in relation to number of clientsPerformance % (Queries)40 clients20 clients10 clients2 clients1 client
No caching1.854725564389274.353556396411729.674333574252876.0639428595723100
PHP QC, APC15.121164784106426.226067451734420.63846831691188.3685812705279100
PHP QC, Memcache25.493357956623824.909223920277629.829867337562190.8465594304526100
PHP QC, user8.4408689235642413.55803322354825.898229637228699.7126385064401100
PHP QC, default8.5764932636402516.657173217944124.597525640289299.4375729958452100
mysqlnd_qc_perf.phptDefault, average speedup: 1.55Speedup compared to uncached query128 (541) bytes256 (671) bytes384 (796) bytes512 (926) bytes640 (1056) bytes768 (1181) bytes896 (1311) bytes1024 (1438) bytes1152 (1568) bytes1280 (1708) bytes1408 (1833) bytes1536 (1963) bytes1664 (2088) bytes1792 (2218) bytes1920 (2348) bytes2048 (2473) bytes2176 (2603) bytes2304 (2728) bytes2432 (2858) bytes2560 (2988) bytes2688 (3113) bytes2816 (3243) bytes2944 (3368) bytes3072 (3498) bytes3200 (3628) bytes3328 (3753) bytes3456 (3883) bytes3584 (4008) bytes3712 (4138) bytes3840 (4268) bytes3968 (4393) bytes4096 (4523) bytes4224 (4648) bytes4352 (4778) bytes4480 (4908) bytes4608 (5033) bytes4736 (5163) bytes4864 (5288) bytes4992 (5418) bytes5120 (5548) bytes5248 (5673) bytes5376 (5803) bytes5504 (5928) bytes5632 (6058) bytes5760 (6188) bytes5888 (6313) bytes6016 (6443) bytes6144 (6568) bytes6272 (6698) bytes6400 (6828) bytes
5 columns1.#NAN1.#NAN1.#NAN1.9561.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.992.0512.0061.8571.9522.1912.0642.0531.7781.9141.5611.9371.7141.8132.1122.152.1552.3992.1362.112.2672.0792.0342.1562.0092.0262.122.3632.1592.4612.22.2892.0862.1022.0212.1872.0262.0942.1071.9761.962
10 columns1.#NAN1.#NAN1.#NAN1.8881.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.6731.8651.5631.7762.391.9621.9551.9011.6231.7341.91.9431.681.7662.1181.7771.7631.4752.6811.9231.6631.6881.6111.9241.6681.6121.7991.6911.7931.5231.7131.5851.5481.7081.6761.8381.7731.5441.6691.7941.549
15 columns1.#NAN1.#NAN1.#NAN1.7541.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.7071.9521.9972.0921.9472.1551.8482.0582.0151.8531.6591.9081.7711.8461.7981.6691.9261.5632.1011.8681.9221.6811.8941.882.2412.062.161.9282.1461.8621.8011.6361.9291.8951.8841.7881.7151.7691.6811.6611.686
20 columns1.#NAN1.#NAN1.#NAN1.911.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.91.8841.7781.7591.7652.051.8821.7491.7382.4721.9931.7741.7741.9351.6081.8661.821.7112.3031.9361.8631.7011.7631.9171.6672.1861.6821.8282.1691.6271.7491.8331.7311.6811.8221.8961.7731.8731.6191.6661.566
25 columns1.#NAN1.#NAN1.#NAN2.0011.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4861.781.6411.5141.4391.5021.471.6411.8361.5651.4841.7721.5821.4891.4551.5451.6131.6541.5171.4461.6821.5341.491.5081.4121.6591.5341.4821.6521.5561.561.5881.3831.5741.6341.4471.4321.5871.3351.4971.549
30 columns1.#NAN1.#NAN1.#NAN1.5831.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5551.6781.4291.3131.4971.6271.7231.5591.3561.4731.7371.7911.6651.4581.4251.6031.6421.4241.4281.5281.5581.4321.3311.6281.6141.6711.6561.7281.6521.4391.8321.4581.4011.3651.6751.551.3741.4631.2921.4711.665
35 columns1.#NAN1.#NAN1.#NAN1.3861.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5431.461.331.4751.6241.3721.411.391.641.5151.3791.4841.3621.4361.3711.4611.4661.561.551.382.0891.5751.6331.4331.3631.3241.5081.4731.4751.5461.4841.5241.4861.4361.421.7121.7311.5331.6391.6681.605
40 columns1.#NAN1.#NAN1.#NAN1.7231.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.6561.6591.4881.5451.5661.6061.5151.5661.611.531.5071.7321.6181.6241.5591.441.5611.661.4911.5131.5781.4231.4931.3511.3331.4321.5631.4051.591.4061.641.5041.541.4641.531.5271.5361.6131.4351.5381.547
45 columns1.#NAN1.#NAN1.#NAN1.751.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5581.4351.4551.5391.6121.3981.5061.4621.4081.5031.4521.5231.4681.5661.3771.5161.4641.5491.3321.4581.4741.751.6751.3381.5741.3171.4861.4641.3891.5041.4131.5521.4111.4751.691.4461.5571.4121.4291.4891.329
50 columns1.#NAN1.#NAN1.#NAN1.4181.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3981.4371.3211.4421.5261.4161.4821.3921.5321.3812.0211.4931.4661.6251.4411.4451.4411.5291.4531.5571.4411.7151.5261.4531.7761.5941.5531.3181.3861.5151.4181.4691.3531.6281.5341.2251.3961.4341.3941.5451.441
55 columns1.#NAN1.#NAN1.#NAN1.4181.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.6171.5561.4221.4291.5411.4561.3981.6051.3821.6431.5881.3551.4531.3821.5661.4661.3271.5831.341.4041.5711.4881.3441.6141.4931.3261.4131.4581.3591.3171.4431.3111.3321.4391.5161.3791.3431.4261.5161.3371.406
60 columns1.#NAN1.#NAN1.#NAN1.5571.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5561.4331.4011.5321.3631.4471.4151.4721.5141.3891.5211.4561.3981.5811.461.5771.3871.4511.3721.5921.4511.5611.4581.4541.4091.4341.5371.451.4181.4621.491.4121.4981.9681.5291.3451.4391.5221.3381.7231.395
65 columns1.#NAN1.#NAN1.#NAN1.3921.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4531.5391.3481.5211.4171.4341.5221.3721.4341.3991.5131.3631.4811.5751.5541.4831.6091.4871.5971.4091.5651.431.4351.431.4221.7121.3881.5561.431.4821.451.5651.3841.5041.4261.4991.4531.4421.3741.4331.456
70 columns1.#NAN1.#NAN1.#NAN1.4511.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5161.5951.4021.5211.4171.3851.3481.4181.6721.3441.3391.4191.3961.4091.4121.3741.5081.4261.3761.3281.4321.491.3441.2911.3631.5431.531.541.4731.4471.5541.4571.6261.2881.451.4611.4671.4441.3841.3711.295
75 columns1.#NAN1.#NAN1.#NAN1.3391.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5111.4671.5691.461.581.4571.6171.4321.3911.5741.5311.4821.5151.5911.3241.3681.4911.5031.3791.3081.411.3551.3341.5111.4281.4851.3651.3571.4181.4131.4111.5361.541.4361.3631.3711.4831.3411.4351.3831.467
80 columns1.#NAN1.#NAN1.#NAN1.3171.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4331.3451.4351.3531.3641.6641.4861.3381.3621.3471.4111.3991.4021.3591.4041.2961.3861.491.3591.3571.4111.3791.4071.3871.3251.3041.3851.3841.4791.3711.4451.4451.3811.4751.2921.4091.6461.4071.6131.5531.434
85 columns1.#NAN1.#NAN1.#NAN1.3221.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4641.5951.5481.4871.6171.4471.5981.4321.4611.6011.5041.521.6041.431.4171.4551.5411.3271.5571.6361.3811.5251.4781.3321.3521.4291.2991.3591.3741.3681.3731.4271.3931.4851.3061.3311.3491.3521.421.4151.371
90 columns1.#NAN1.#NAN1.#NAN1.4861.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4261.5541.4271.3551.3911.4881.4191.3231.3711.3461.3471.4341.3481.3341.4491.311.281.3981.3111.3041.4571.3481.3631.461.3071.3921.4671.4151.3321.4771.4261.291.4981.4051.3741.4211.3161.3731.3661.4411.381
95 columns1.#NAN1.#NAN1.#NAN1.41.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5281.4571.4861.521.5011.4241.4111.4731.4421.3471.4161.5261.6431.4061.4971.5741.4331.4711.5181.4461.3311.4521.4081.4421.3531.3611.341.4181.381.3611.4051.4121.3751.2571.3071.3291.3771.5061.4481.4061.429
100 columns1.#NAN1.#NAN1.#NAN1.4351.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4751.4941.471.4691.4781.5661.5451.4021.4591.4581.4531.3241.3071.3551.3281.4231.4011.441.2981.261.3251.3241.4561.4541.4551.421.3341.4111.3281.3191.2711.3261.5491.4471.3511.4061.4861.3581.4121.3311.455
mysqlnd_qc_perf.phptUser handler, average speedup: 1.41xSpeedup compared to uncached query128 (541) bytes256 (671) bytes384 (796) bytes512 (926) bytes640 (1056) bytes768 (1181) bytes896 (1311) bytes1024 (1438) bytes1152 (1568) bytes1280 (1708) bytes1408 (1833) bytes1536 (1963) bytes1664 (2088) bytes1792 (2218) bytes1920 (2348) bytes2048 (2473) bytes2176 (2603) bytes2304 (2728) bytes2432 (2858) bytes2560 (2988) bytes2688 (3113) bytes2816 (3243) bytes2944 (3368) bytes3072 (3498) bytes3200 (3628) bytes3328 (3753) bytes3456 (3883) bytes3584 (4008) bytes3712 (4138) bytes3840 (4268) bytes3968 (4393) bytes4096 (4523) bytes4224 (4648) bytes4352 (4778) bytes4480 (4908) bytes4608 (5033) bytes4736 (5163) bytes4864 (5288) bytes4992 (5418) bytes5120 (5548) bytes5248 (5673) bytes5376 (5803) bytes5504 (5928) bytes5632 (6058) bytes5760 (6188) bytes5888 (6313) bytes6016 (6443) bytes6144 (6568) bytes6272 (6698) bytes6400 (6828) bytes
5 columns1.#NAN1.#NAN1.#NAN1.6281.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.8181.5721.7121.5651.5772.1972.0831.971.8231.8111.8341.8351.581.5471.9071.8922.0251.9021.8791.7632.9371.8752.0021.9771.7431.6861.7141.8381.9131.6591.671.7771.7641.5541.7411.8682.0041.7461.6321.9511.917
10 columns1.#NAN1.#NAN1.#NAN1.3791.#NAN1.#NAN1.#NAN1.#NAN1.#NAN2.2171.6331.7241.6271.5181.6091.4141.4961.4881.6271.7041.5941.7171.3981.6081.4681.4141.5881.3981.5611.8381.5581.4611.4731.3561.7311.5561.6611.541.5491.6821.6591.6611.5651.6451.6261.5511.6491.531.531.534
15 columns1.#NAN1.#NAN1.#NAN1.6291.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5581.511.4751.5561.4361.6181.4841.3981.4751.4591.5031.5061.6341.4741.3921.4641.3161.3581.3621.2251.3431.5381.4441.3751.3691.4871.3511.3461.4521.3091.8191.31.4061.3291.3981.3991.331.4861.3691.4711.333
20 columns1.#NAN1.#NAN1.#NAN1.4241.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5191.5851.4421.6761.5521.4371.5751.7151.441.6481.5621.4931.7081.4831.4191.6961.6151.6121.541.4761.5851.5221.6111.5181.5811.5191.521.4441.4141.761.4921.5951.3551.4721.4641.5931.5331.451.4541.4411.597
25 columns1.#NAN1.#NAN1.#NAN1.461.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5881.3781.3151.4981.3061.4461.4251.4121.4791.5071.4851.3761.3581.5661.481.4821.4841.4791.3541.4721.4161.4551.3421.461.3991.2641.5191.3991.4541.3981.4591.4561.3271.4451.3311.3821.511.3061.3871.3661.565
30 columns1.#NAN1.#NAN1.#NAN1.5441.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3871.3741.4761.4841.5521.3221.3771.4411.3181.6431.4461.4461.4111.4981.4181.3631.3911.4031.2481.9471.461.3361.41.2721.4731.341.3961.3351.4741.4251.371.361.5271.5181.351.3961.3481.3951.2411.3981.507
35 columns1.#NAN1.#NAN1.#NAN1.5751.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.5771.3371.3931.3711.4511.491.3711.4631.3841.4741.3791.5831.4161.4061.2581.4761.4181.31.331.4211.3661.291.3351.4261.4721.4291.4091.331.3681.4691.3611.4161.3551.3071.5471.311.3491.3451.4791.3481.401
40 columns1.#NAN1.#NAN1.#NAN1.3561.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3181.3591.4581.3051.5051.4351.4931.2331.5991.451.5241.3961.3831.291.2111.2851.4461.4471.3511.4281.3741.4161.3171.3751.2611.5511.4551.3111.4911.481.4791.3531.3751.371.4741.4221.3331.4751.3861.3681.376
45 columns1.#NAN1.#NAN1.#NAN1.651.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3271.4231.3291.4071.3641.4131.3681.4851.431.4871.3461.3741.4021.3941.3881.2541.3411.5161.4191.5121.3081.3381.4061.4081.3121.5441.3621.2771.4331.3421.3541.3831.3841.4591.3851.3831.3811.4141.3791.3691.367
50 columns1.#NAN1.#NAN1.#NAN1.3671.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3551.3621.3381.4691.341.4341.2651.2991.341.3661.4461.3271.3911.371.431.4551.3661.3271.3351.3341.3261.4121.2391.3541.2451.1891.4261.251.4671.2971.5771.2121.2581.4061.251.3211.3271.321.3591.3541.2
55 columns1.#NAN1.#NAN1.#NAN1.2911.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3561.2851.281.3431.3381.3891.3831.3331.4311.3361.3671.7291.4491.4961.3711.4551.4351.5531.2851.3231.3581.3541.4021.31.3791.4221.3571.3131.2211.3321.3291.3661.2931.3991.4311.3991.3111.3351.3531.3391.467
60 columns1.#NAN1.#NAN1.#NAN1.4721.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4041.3441.3371.2861.3461.3741.3691.3311.3051.5291.3051.321.3161.4381.4381.3651.3471.4841.4091.3531.4261.4411.311.321.2741.3171.4571.3111.3841.3191.4371.4591.4591.3851.4911.2851.3581.3521.3811.321.45
65 columns1.#NAN1.#NAN1.#NAN1.3541.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3051.281.2871.3371.3041.2951.3661.2981.3231.3391.5041.4721.5041.3761.4091.6311.2531.3381.2961.6581.3571.2411.4151.4111.2641.2851.3991.4051.3821.2561.2941.4521.4481.3081.2751.3961.4641.3321.2991.1971.536
70 columns1.#NAN1.#NAN1.#NAN1.5131.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3981.3491.4241.4341.4631.3791.4311.3551.361.3251.3521.2721.3151.3731.3211.391.4121.3921.2121.2741.2681.4111.2821.3861.4091.3491.4031.3421.3831.451.2241.2691.3021.3261.3211.2911.3831.3561.3061.3211.328
75 columns1.#NAN1.#NAN1.#NAN1.421.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.581.3631.2981.4521.3841.361.411.3631.3271.3341.3291.3271.3861.4161.381.281.2831.2811.2941.3591.6921.4011.3411.3461.2821.2461.4371.0081.4341.4141.4461.3911.331.391.2681.2131.2631.4131.3151.2481.379
80 columns1.#NAN1.#NAN1.#NAN1.4171.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.321.3631.3511.3311.3531.2711.4511.2321.2571.2261.2261.3081.2611.3741.2521.3151.3181.2511.3981.281.3141.3461.2811.3941.3921.4511.2911.4271.2811.4511.3891.3231.2871.2441.4671.5391.3651.4521.3071.2751.274
85 columns1.#NAN1.#NAN1.#NAN1.3691.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3411.4321.3181.2781.3741.3711.3261.2981.2611.2061.3511.3221.3731.2931.3711.3751.2821.5521.3591.3731.2591.3741.2971.3551.4421.2791.2341.3011.3851.5181.361.3291.3811.4641.3491.3821.4061.3431.2841.3111.254
90 columns1.#NAN1.#NAN1.#NAN1.3121.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.4331.3231.3171.3021.3131.3491.3371.3151.2661.2621.2561.2881.3911.3971.4111.3321.2821.3081.3541.4181.431.2671.31.2341.3011.3691.2811.3091.2811.3191.3611.3671.2871.231.3691.4491.3761.2541.3051.3081.35
95 columns1.#NAN1.#NAN1.#NAN1.251.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3721.3731.3661.3721.3191.2881.3771.3081.591.3181.2621.331.3311.3261.3321.3181.2991.3551.3171.4091.421.4531.3541.3751.2511.2531.2091.2281.2571.3131.3421.3371.3421.2971.2161.2881.3961.221.3111.2941.264
100 columns1.#NAN1.#NAN1.#NAN1.3831.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.2821.2881.311.2921.331.3491.2841.2811.3421.3221.1891.241.3361.3341.3521.3271.3271.3771.351.3491.3451.3721.3971.2741.3721.3221.3451.2761.361.331.3471.4011.3431.331.2821.4521.4151.2671.3751.2971.376
mysqlnd_qc_per.phptMemcache, average speedup: 1.40xSpeedup compared to uncached query128 (541) bytes256 (671) bytes384 (796) bytes512 (926) bytes640 (1056) bytes768 (1181) bytes896 (1311) bytes1024 (1438) bytes1152 (1568) bytes1280 (1708) bytes1408 (1833) bytes1536 (1963) bytes1664 (2088) bytes1792 (2218) bytes1920 (2348) bytes2048 (2473) bytes2176 (2603) bytes2304 (2728) bytes2432 (2858) bytes2560 (2988) bytes2688 (3113) bytes2816 (3243) bytes2944 (3368) bytes3072 (3498) bytes3200 (3628) bytes3328 (3753) bytes3456 (3883) bytes3584 (4008) bytes3712 (4138) bytes3840 (4268) bytes3968 (4393) bytes4096 (4523) bytes4224 (4648) bytes4352 (4778) bytes4480 (4908) bytes4608 (5033) bytes4736 (5163) bytes4864 (5288) bytes4992 (5418) bytes5120 (5548) bytes5248 (5673) bytes5376 (5803) bytes5504 (5928) bytes5632 (6058) bytes5760 (6188) bytes5888 (6313) bytes6016 (6443) bytes6144 (6568) bytes6272 (6698) bytes6400 (6828) bytes
5 columns1.8211.9372.0042.5541.5531.5611.7651.9481.8931.8741.7342.0281.4741.7281.562.151.6951.7441.5471.6921.6291.6141.5771.5621.5181.7271.6951.6031.751.6591.6841.4231.4941.6891.5021.4241.6591.7441.7582.041.7231.7761.7712.0721.8961.6231.6061.7851.5771.589
10 columns1.7991.7691.7551.6581.6761.6721.7681.7421.7371.8521.7261.751.6281.6431.5171.7181.6011.61.4731.5491.6471.4541.6161.6991.491.5871.7161.6211.7831.6071.4891.6011.4011.5031.4911.4461.4611.4521.551.6381.631.4361.531.4121.5891.5841.5891.5561.5481.635
15 columns1.4561.6211.411.3131.3581.4651.4821.781.4881.6751.5461.5331.6361.3161.9161.6491.6711.4761.5861.321.4491.5771.4251.7061.4341.4361.4291.3851.4421.4581.3681.6051.5191.5251.8661.4971.4891.7761.8361.661.6211.6021.4591.541.5921.5141.6071.4511.4841.432
20 columns1.6731.5221.6621.6691.5141.5461.5551.5071.5221.4741.4911.7831.5021.4611.3291.6461.6491.3771.4541.4531.4351.4771.3811.4441.4281.4711.5011.6091.5141.4341.4361.3141.3641.4831.3971.3351.3421.4861.2841.2911.4481.4031.2691.1741.3121.5611.4431.2031.2471.388
25 columns1.5551.4361.2941.3521.5071.2991.4791.4351.4561.5711.4771.2942.3231.3921.4241.3691.471.451.621.6071.5891.5931.6621.4821.4181.4261.3661.391.3141.4951.2681.4051.4181.5341.3761.3711.4331.3481.2141.4821.3461.2741.3741.3891.4021.6461.6881.4481.371.312
30 columns1.5471.4871.731.5381.6431.4761.2951.361.3881.5831.5411.4151.4231.4241.4241.4331.3091.3821.3271.2571.4741.5651.5741.4131.4811.4221.3281.381.3931.6461.4081.3121.4871.581.4911.4521.3321.2851.4611.341.4181.3991.3691.2851.411.3461.4041.3261.3741.438
35 columns1.5531.4731.8671.4821.7871.4721.6361.4231.4321.4671.4261.4771.6031.3671.4121.5261.3991.4241.4721.4041.3871.3841.3071.3191.4891.3831.4711.411.2661.4361.3131.4141.3271.3721.4261.4691.4171.3381.3971.291.461.2931.4341.3811.331.3161.3281.5031.3211.332
40 columns1.4271.2871.3781.3671.3851.3871.3841.5041.481.4451.5091.5371.5021.3741.4081.3951.2531.5291.2021.2761.4271.3861.4871.5071.4991.521.4431.2531.4541.4691.3191.341.4441.4031.2621.171.4461.2461.4721.3991.4111.3081.4121.4591.2911.4251.3491.3651.3591.236
45 columns1.4571.3761.3581.4471.3891.4261.4461.4561.4541.4061.4111.4631.4071.2931.2821.4451.4661.2271.2621.2911.2771.5371.3731.4351.5061.3341.4621.3741.3731.5531.4641.331.3851.3231.3511.3581.4041.4311.381.3911.3971.3521.2931.4061.3511.221.451.3461.2591.357
50 columns1.4291.6121.4461.5531.511.5141.4581.41.4031.4711.3181.4311.3731.3061.3391.3511.4691.3861.2631.4281.7011.4281.3741.31.4741.4971.4551.271.3221.2421.4431.221.391.2731.4631.2431.2731.4291.2591.2871.391.3531.3981.3851.461.3391.2591.3731.5221.297
55 columns1.4241.4151.4141.4511.4041.3731.41.3741.2421.3931.3821.3141.2931.4551.3531.341.3031.3941.2161.3621.3511.3531.2381.4211.3191.341.2751.3141.4331.4071.4071.5251.481.2131.3361.351.4581.3781.1961.3731.3721.3121.1691.2161.3051.241.7131.2891.2061.225
60 columns1.2561.3681.4851.3371.3761.4171.381.4391.3461.4331.2871.4021.3181.391.4281.3791.4141.3431.381.3351.4221.2771.3591.4211.3041.3611.2651.2761.2921.2461.431.4351.2631.2251.3531.3651.3281.2781.4181.3251.3421.3241.261.2451.3641.1841.2851.3581.2931.301
65 columns1.3421.3041.4231.3961.3351.2081.4061.3291.3871.291.4041.4291.3361.2871.2871.3781.2971.3511.351.2821.3581.8951.3221.4131.2041.261.2391.4111.4591.2891.3621.311.3071.1941.3011.271.3091.2711.3081.2851.2831.3451.2681.2071.2761.251.2541.3151.3331.264
70 columns1.3181.2771.1991.381.2421.4291.2691.4061.3131.4351.2921.3111.2451.3991.2521.331.3531.2921.3111.3631.221.2481.3461.3641.3181.3151.3131.2831.2541.1981.2481.271.3261.2731.4391.3581.4251.4221.3811.291.2981.3051.3391.3010.9811.3651.1771.3731.3851.315
75 columns1.3441.2961.2371.3871.2661.3041.3151.3861.2311.261.3121.291.3561.3771.2591.2851.261.3241.3271.2661.2891.31.2261.2831.4191.3561.2851.3221.2671.2331.2951.2171.2931.3081.3371.3151.3581.3861.4121.3061.3171.3191.3351.2491.4051.3421.2591.3351.2591.38
80 columns1.4031.2411.241.3461.2251.3561.3581.3781.4661.2411.3791.4381.2941.2891.2841.3381.2621.191.2521.3261.3051.3121.2861.2631.2691.3571.4381.4711.4771.2761.3221.2821.341.2861.361.341.2881.3131.2471.3341.3971.3961.2951.3461.3011.3611.331.2751.3341.209
85 columns1.3731.3281.3741.381.3541.2871.3181.3161.3151.4131.4661.2861.281.2541.3311.2781.1851.2911.3321.2491.321.2371.2691.2621.31.2911.2621.3251.3111.3221.3771.211.2211.1751.2371.2171.3861.381.2241.31.3571.3691.3051.2441.3041.2881.3371.3951.241.308
90 columns1.2091.3791.3811.3311.2681.3621.3561.4061.4351.3391.2831.2861.2891.2341.341.2881.2761.3061.3071.2361.1971.2961.3351.331.3051.2831.3171.2991.2441.3311.3221.2981.3261.2211.3041.3121.3511.2691.1941.2031.6271.2771.3091.5221.4491.2311.2891.281.331.22
95 columns1.3051.3581.2811.2651.2911.2991.3521.331.3731.4031.2551.271.3091.2731.3191.351.3781.3531.3351.2981.321.2481.2311.3231.2321.271.3621.3361.3351.2861.2931.3141.2641.2761.2621.3421.2771.2971.2091.2691.3091.3371.3151.3711.3291.421.3181.3561.3791.379
100 columns1.#NAN1.#NAN1.#NAN1.3491.#NAN1.#NAN1.#NAN1.#NAN1.#NAN1.3881.4221.3821.3751.3681.3581.3111.3051.2681.2471.3841.4071.3181.3481.4231.3351.2551.2961.3221.3291.3711.3371.2641.3171.3071.2411.3121.2941.3151.1831.2241.4151.2241.2581.2221.2671.4871.2351.5041.311.393
qc_load.php, 20s, 100 rowsPHP with and without QC enabled comparedRelative performance (%)1 client2 clients10 clients20 clients40 clients
QC disabled (with /*qc=1*/ SQL hint)100.43713971308399.757230630900799.2291762540267100.60547348026299.1705867789057
QC disabled (no /*qc=1*/ SQL hint)100100100100100
QC enabled (no /*qc=1*/ SQL hint)99.265039928119399.160797242619599.0450989415555100.24218939210599.9504827927705
Oxid eShop 4.2 Community EditionSingle machine, APC Byte code cache on/offRelative performance with/without BC % (Req./s)1 client1 client (BC)
Out-of-the-box100124.324324324324
PHP QC, user handler100118.987341772152
PHP QC, default100141.525423728814
PHP QC, Memcache100145.762711864407
MySQL Server Query Cache, 5.1100160.204081632653
Oxid eShop 4.2 Community EditionSingle machine, without APC byte code cachingRealtive performance % (Req./s)1 client
Out-of-the-box100
PHP QC, user handler106.756756756757
PHP QC, default159.459459459459
PHP QC, Memcache159.459459459459
MySQL Server Query Cache, 5.1176.576576576577
mysqlnd_qc_perf.phptAPC, average speedup: 1.48xSpeedup compared to uncached query128 (541) bytes256 (671) bytes384 (796) bytes512 (926) bytes640 (1056) bytes768 (1181) bytes896 (1311) bytes1024 (1438) bytes1152 (1568) bytes1280 (1708) bytes1408 (1833) bytes1536 (1963) bytes1664 (2088) bytes1792 (2218) bytes1920 (2348) bytes2048 (2473) bytes2176 (2603) bytes2304 (2728) bytes2432 (2858) bytes2560 (2988) bytes2688 (3113) bytes2816 (3243) bytes2944 (3368) bytes3072 (3498) bytes3200 (3628) bytes3328 (3753) bytes3456 (3883) bytes3584 (4008) bytes3712 (4138) bytes3840 (4268) bytes3968 (4393) bytes4096 (4523) bytes4224 (4648) bytes4352 (4778) bytes4480 (4908) bytes4608 (5033) bytes4736 (5163) bytes4864 (5288) bytes4992 (5418) bytes5120 (5548) bytes5248 (5673) bytes5376 (5803) bytes5504 (5928) bytes5632 (6058) bytes5760 (6188) bytes5888 (6313) bytes6016 (6443) bytes6144 (6568) bytes6272 (6698) bytes6400 (6828) bytes
5 columns2.2041.8991.8912.0771.6741.7851.7731.6471.9751.9581.8451.962.0811.811.6922.2462.2021.8971.991.8862.2151.8792.192.0392.0062.2061.8271.8081.6572.0141.8781.8972.0841.8631.8462.1061.8031.8211.692.2242.0011.8141.62.0031.911.7892.0111.8792.0011.875
10 columns1.8921.8851.7641.9711.741.8552.0451.9441.8571.9141.8971.9161.9591.7471.6561.6422.0351.8371.7441.8472.1081.7961.9181.6651.8791.7731.7541.7351.4631.5441.6681.5631.7341.5571.5551.6431.6631.7271.5461.4321.6181.6871.9841.7931.5871.6671.581.7621.4531.631
15 columns1.6721.6091.3721.4541.5451.4471.7381.3752.1071.5641.5761.6261.6131.4561.4121.5091.5971.5061.571.5921.5891.5871.5581.6281.4551.6941.4311.421.6081.5041.5791.4981.5342.1211.5491.541.5451.4971.4711.4831.5611.4851.6121.421.6441.6171.5921.4441.5141.572
20 columns1.5531.6571.4441.6981.5551.4881.6431.6621.4241.4831.6461.5171.5691.4211.3421.4871.4981.4041.5271.6361.4611.4751.4821.621.4561.5251.5351.581.5611.4651.5411.3971.4321.3831.5451.4811.661.4561.7271.3731.4581.591.4451.3261.4121.4961.4791.4831.561.644
25 columns1.4341.6371.5641.3561.4791.3441.4781.5851.4691.541.4571.4421.4921.5271.5051.4531.6471.4531.5371.3711.5271.4611.4611.4141.3251.5631.471.5561.5411.6611.4491.5081.3721.511.4351.5641.4191.6141.4831.6121.5291.8041.4771.5981.5721.6021.6581.5921.631.884
30 columns1.5771.8051.6611.8051.8351.7331.6071.7061.5961.7111.7211.5282.0191.9381.6911.6291.571.6241.5411.6281.4581.6391.6211.5341.4881.6541.4061.5851.5481.521.4541.4041.5681.741.6321.8031.4971.4931.4671.6371.6131.3611.4531.5391.5111.51.4261.6711.4661.595
35 columns1.5431.3761.4981.4241.4041.5961.5661.5281.5041.6241.5571.5521.6331.5091.4811.4911.7041.5421.6131.5411.3751.5691.4831.6031.4981.5321.3751.5291.2661.4471.4841.5551.4181.5121.3661.3381.6741.5071.3941.5051.3161.3171.4681.3581.451.3511.4091.5021.2951.384
40 columns1.4761.4791.541.3171.451.3511.4621.4041.4131.3351.4091.4331.4981.4861.4171.3991.3531.3261.3821.5371.5221.3661.421.4281.3791.3741.561.4211.3041.3751.4551.8771.4591.3631.3891.3381.3821.4981.3331.4561.6121.5751.5771.4731.4981.4991.4351.3831.4111.395
45 columns1.4981.5071.1671.541.6021.5351.351.4841.4291.3851.3961.431.5151.4241.3841.5041.3991.6111.5331.5561.5131.5491.4461.4851.4931.5161.4151.4411.3221.4971.4361.3851.4241.4621.5011.4331.3461.381.3771.4381.3791.3451.3741.3341.3481.3421.4321.4531.4941.389
50 columns1.3191.4731.4381.41.4061.4651.4381.3821.3811.5831.2521.3651.4621.3861.5081.5341.4181.4071.3941.3621.4271.4431.3541.3191.5181.4731.4291.4351.431.4041.5251.3981.3491.3931.3291.4261.461.4261.3821.5511.6991.5261.4911.4541.4321.4781.4371.5341.551.281
55 columns1.3191.3871.4621.421.4961.3461.371.4131.4461.3371.4851.351.3691.3541.3691.421.3451.3911.3851.3361.4521.3231.3031.3061.4261.491.5221.4561.4491.4521.4481.291.4111.3281.3271.4571.2541.3321.4671.3651.4671.4151.3891.3541.2671.3121.2591.3011.3671.351
60 columns1.3461.4081.3261.4241.4941.3811.4591.4511.4261.5881.6061.3651.2791.3661.4351.451.4021.4051.3951.4591.5371.5051.3881.5221.3381.2971.3591.4311.431.4051.3731.3411.481.31.271.2551.4761.3291.4061.5321.3681.741.4331.4181.3931.3831.4471.3841.2351.56
65 columns1.271.2781.3311.3011.4381.3971.3191.4741.3931.471.4351.3831.351.3921.311.3951.3471.4741.4531.3131.3541.4551.5091.3981.4461.3041.3811.351.391.3451.3811.4651.4311.3641.3681.4411.3031.3761.3661.331.311.4051.4221.3631.3771.4141.3571.3171.3631.427
70 columns1.421.421.3971.3221.2951.4961.4451.3631.3781.3451.3571.3881.3811.3841.41.3941.3291.3971.3621.4151.4231.4341.3651.4121.421.3211.3691.431.5011.361.3531.4551.4871.3931.361.7971.3291.3521.4221.3771.4431.3461.3851.431.3611.3651.4031.441.3491.451
75 columns1.2441.3591.3561.3521.3851.3391.3241.3061.3891.3491.3481.351.321.3311.2691.3961.3191.4351.3271.2921.371.4161.4181.4121.391.3771.3841.3071.3411.3591.3211.3371.3821.4091.3541.4531.4141.4671.3911.2391.441.3151.4031.4341.5051.3491.4861.4311.361.402
80 columns1.4541.4851.5071.3951.3841.2661.3931.4431.4441.3561.4231.3381.3781.4611.4271.3481.2971.4141.3191.361.4061.3581.4321.4011.4571.6431.3991.3791.3621.2911.441.3741.251.4541.4921.4791.4821.2881.4071.4261.3751.2991.3941.2921.4391.3271.3291.4091.3671.33
85 columns1.2541.3391.4311.3431.4741.4391.3461.2881.3181.3071.3971.4051.4621.4371.3931.3621.3251.4141.4111.3541.3931.3221.4571.3751.2891.311.4221.4011.3221.381.3131.2661.4821.421.3711.3391.3721.3921.4491.3691.371.3881.4531.3671.2881.331.3991.4411.3061.288
90 columns1.3711.3821.4991.3941.3971.3051.4831.3371.3651.3721.4271.5711.3841.3331.4441.4361.361.3561.3391.4781.4721.2861.4791.3131.3331.3681.3851.3761.3871.351.2881.2491.2711.2551.3431.3671.2881.3581.4591.4261.351.3951.3021.451.3471.4391.3111.391.3141.395
95 columns1.3411.421.431.4081.4721.3921.3851.3331.4091.5171.3131.3151.3871.4191.371.5141.4221.3071.3811.3861.4771.3761.3541.4821.2921.3381.421.4041.411.5531.3421.3621.3461.3951.3751.3241.3991.41.41.4411.3761.4231.3881.3941.4481.3791.3661.3281.4011.366
100 columns1.3861.4711.4931.4661.4321.3461.3351.3831.4281.3371.3741.3561.3261.4351.4151.4331.3141.3761.5361.3331.3141.3351.4011.3141.4481.2961.3911.4231.381.3811.2991.2991.3361.431.3551.3471.2921.3011.2951.3521.3221.4071.3531.3721.3421.3841.4311.1661.4531.399
Oxid eShop 4.2 Community EditionSingle machineRequests/s1 client10 clients
Out-of-the-box (BC off)2.222.53
Out-of-the-box (BC on)2.762.77
PHP QC, user handler2.823.2
PHP QC, default5.017.08
PHP QC, Memcache5.168.22
PHP QC, APC5.549.28
MySQL Server Query Cache, 5.16.2810.53
Oxid eShop 4.2 Community EditionSingle machineRequests/s1 client2 clients10 clients20 clients40 clients
Out-of-the-box (BC off)2.223.132.532.281.83
Out-of-the-box (BC on)2.763.662.772.451.93
PHP QC, user handler2.823.913.22.842.25
PHP QC, default5.018.397.086.353.81
PHP QC, Memcache5.168.98.228.087.44
PHP QC, APC5.549.489.289.028.37
MySQL Server Query Cache, 5.16.2811.110.5310.1610.19
Oxid eShop 4.2 Community EditionMachine 1: PHP/Apache, Machine 2: MySQLRequests/s1 client2 clients10 clients20 clients40 clients
Out-of-the-box (without BC)2.894.897.067.067.04
Out-of-the-box3.887.0610.8110.8510.81
PHP QC, user4.247.2910.4810.5110.52
MySQL Server Query Cache, 5.15.158.410.9410.8411.05
PHP QC, default5.299.7111.6211.5711.57
PHP QC, Memcache5.359.4710.1410.0210.12
PHP QC, APC5.6310.2211.5311.5811.52
qc_load.php: run 4 queries for 20s, 100 rowsSingle box, average number of queries per runQueries40 clients20 clients10 clients2 clients1 client
No caching1745409691027156494084
PHP QC, APC75503130952103052441242499320
PHP QC, Memcache114301111682133744407316448356
PHP QC, user5628090399172678664840666756
PHP QC, default10750620879730832912464461253496
Oxid eShop 4.2 Community EditionSingle machine, tuned: cache_no_table=11 client1 client (tuned)10 clients10 clients (tuned)
Out-of-the-box (BC on)2.762.762.772.77
PHP QC, user handler2.823.013.23.21
PHP QC, default5.015.87.088.57
PHP QC, Memcache5.165.698.2210.13
PHP QC, APC5.546.339.2811.45
MySQL Server Query Cache, 5.16.286.2810.5310.53
qc_load.php: run 4 queries for 20s, 100 rowsSingle box, average number of queries per runQueries10 clients1 client
No caching910294084
PHP QC, APC103052499320
PHP QC, Memcache133744448356
PHP QC, user172678666756
PHP QC, default3083291253496
Oxid eShop 4.2 Community EditionSingle machine, with APC byte code cachingRelative performance % (Req./s)1 client (BC)
Out-of-the-box100
PHP QC, user handler102.173913043478
PHP QC, default181.521739130435
PHP QC, Memcache186.95652173913
MySQL Server Query Cache, 5.1227.536231884058
Oxid eShop 4.2 Community EditionSingle machine, relative performancePerformance % (Req/s)1 client10 clients
Out-of-the-box (BC off)100100
Out-of-the-box (BC on)124.324324324324109.486166007905
PHP QC, user handler127.027027027027126.482213438735
PHP QC, default225.675675675676279.841897233202
PHP QC, Memcache232.432432432432324.901185770751
PHP QC, APC249.54954954955366.798418972332
MySQL Server Query Cache, 5.1282.882882882883416.205533596838