# Test case details: # Benchmark run on a virtual host under Xen with 512 MB and 4 GB disk total. Only mysql has been started. # I think disk is pretty slow. While running the mysql process grew to about 85MB, the perl process to # about 40 MB and memcached never exceeded 32MB, while it's configured with a limit of 64MB # WG stats # Assets: 3533 # Packages: 62 # Templates: 578 # Users: 72885 # Groups: 2286 # mysql> select count(*) from users; +----------+ | count(*) | +----------+ | 72885 | +----------+ 1 row in set (0.00 sec) # mysql> select count(*) from groupings; +----------+ | count(*) | +----------+ | 209560 | +----------+ 1 row in set (0.00 sec) # Table sizes # userProfileData: # # martin@martin-xml:~$ ls -lhS /data/wre/var/mysqldata/dev/userProfileData.* # -rw-r----- 1 martin martin 347M 2009-12-09 09:34 /data/wre/var/mysqldata/dev/userProfileData.MYD # -rw-r----- 1 martin martin 94M 2009-12-09 09:32 /data/wre/var/mysqldata/dev/userProfileData.MYI # -rw-r----- 1 martin martin 70K 2009-12-09 09:33 /data/wre/var/mysqldata/dev/userProfileData.frm # group* martin@martin-xml:~$ ls -lhS /data/wre/var/mysqldata/dev/group* -rw-r----- 1 martin martin 16M 2009-12-09 09:32 /data/wre/var/mysqldata/dev/groupings.MYI -rw-r----- 1 martin martin 9.6M 2009-12-09 09:34 /data/wre/var/mysqldata/dev/groupings.MYD -rw-r----- 1 martin martin 358K 2009-12-09 09:34 /data/wre/var/mysqldata/dev/groups.MYD -rw-r----- 1 martin martin 160K 2009-12-09 09:32 /data/wre/var/mysqldata/dev/groups.MYI -rw-r----- 1 martin martin 14K 2009-12-09 09:34 /data/wre/var/mysqldata/dev/groups.frm -rw-r----- 1 martin martin 8.5K 2009-12-09 09:32 /data/wre/var/mysqldata/dev/groupings.frm -rw-r----- 1 martin martin 8.5K 2009-12-09 09:32 /data/wre/var/mysqldata/dev/groupGroupings.frm -rw-r----- 1 martin martin 1.8K 2009-12-09 09:34 /data/wre/var/mysqldata/dev/groupGroupings.MYD -rw-r----- 1 martin martin 1.0K 2009-12-09 09:32 /data/wre/var/mysqldata/dev/groupGroupings.MYI # Results # $repeats = 100 martin@martin-xml:/data/webgui/sbin$ perl benchCache.pl --configFile=... Starting... 1: WebGUI DB 1: CHI Memcached 1: WebGUI File 1: WebGUI Memcached 1: CHI Null 1: CHI FastMmap Rate WebGUI Memcached WebGUI File CHI Null CHI Memcached CHI FastMmap WebGUI DB WebGUI Memcached 11.4/s -- -4% -9% -23% -41% -49% WebGUI File 11.9/s 4% -- -5% -20% -39% -47% CHI Null 12.6/s 10% 6% -- -16% -36% -43% CHI Memcached 14.9/s 30% 25% 19% -- -24% -33% CHI FastMmap 19.5/s 71% 64% 55% 31% -- -12% WebGUI DB 22.3/s 95% 87% 77% 49% 14% -- 2: WebGUI DB 2: CHI Memcached 2: WebGUI File 2: WebGUI Memcached 2: CHI Null 2: CHI FastMmap s/iter CHI Null WebGUI Memcached CHI FastMmap WebGUI File CHI Memcached WebGUI DB CHI Null 2.81 -- -17% -36% -50% -53% -60% WebGUI Memcached 2.35 20% -- -24% -41% -44% -52% CHI FastMmap 1.79 57% 31% -- -22% -26% -37% WebGUI File 1.40 101% 68% 28% -- -5% -19% CHI Memcached 1.32 112% 77% 35% 6% -- -14% WebGUI DB 1.13 148% 107% 58% 23% 17% -- # $repeats = 2000 martin@martin-xml:/data/webgui/sbin$ perl benchCache.pl --configFile=... Starting... 1: WebGUI DB 1: CHI Memcached 1: WebGUI File 1: WebGUI Memcached 1: CHI Null 1: CHI FastMmap Rate WebGUI Memcached WebGUI File CHI Null WebGUI DB CHI Memcached CHI FastMmap WebGUI Memcached 11.7/s -- -7% -8% -13% -16% -43% WebGUI File 12.5/s 7% -- -2% -7% -10% -39% CHI Null 12.7/s 9% 2% -- -5% -8% -38% WebGUI DB 13.4/s 15% 8% 6% -- -3% -34% CHI Memcached 13.9/s 19% 11% 9% 3% -- -32% CHI FastMmap 20.5/s 76% 64% 61% 52% 48% -- 2: WebGUI DB 2: CHI Memcached 2: WebGUI File 2: WebGUI Memcached 2: CHI Null 2: CHI FastMmap Rate CHI Null WebGUI Memcached CHI Memcached WebGUI File CHI FastMmap WebGUI DB CHI Null 0.712/s -- -19% -30% -31% -40% -45% WebGUI Memcached 0.873/s 23% -- -15% -15% -27% -33% CHI Memcached 1.02/s 44% 17% -- -1% -14% -21% WebGUI File 1.03/s 45% 18% 1% -- -13% -20% CHI FastMmap 1.19/s 67% 36% 16% 15% -- -8% WebGUI DB 1.30/s 83% 49% 27% 26% 9% --