From : Christopher Aker Subject : Mysql's run-all-tests benchmark Date : 2004-05-27 Patches : http://perso.wanadoo.fr/laurent.vivier/UML/ Author : Laurent Vivier Host : 2.6.7-rc1+skas+sysemu The number of loops was reduced in the test scripts to avoid taking an age. The results were quite impressive. ########################### ## No sysemu patch: ########################### Linux li7-3 2.4.26-linode28-1um #1 Tue May 18 16:32:46 EDT 2004 i686 i686 i386 GNU/Linux Benchmark DBD suite: 2.14 Date of test: 2004-05-27 23:38:05 Running tests on: Linux 2.4.26-linode28-1um i686 Arguments: Comments: Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 249 wallclock secs ( 0.38 usr 0.41 sys + 0.00 cusr 0.00 csys = 0.79 CPU) ATIS: Total time: 128 wallclock secs (21.57 usr 59.10 sys + 0.00 cusr 0.00 csys = 80.67 CPU) big-tables: Total time: 163 wallclock secs (17.27 usr 129.50 sys + 0.00 cusr 0.00 csys = 146.77 CPU) connect: Total time: 72 wallclock secs ( 5.66 usr 7.37 sys + 0.00 cusr 0.00 csys = 13.03 CPU) create: Total time: 17 wallclock secs ( 0.78 usr 1.50 sys + 0.00 cusr 0.00 csys = 2.28 CPU) insert: Total time: 369 wallclock secs (90.76 usr 137.46 sys + 0.00 cusr 0.00 csys = 228.22 CPU) select: Total time: 64 wallclock secs (11.55 usr 10.49 sys + 0.00 cusr 0.00 csys = 22.04 CPU) wisconsin: Total time: 54 wallclock secs ( 6.79 usr 16.36 sys + 0.00 cusr 0.00 csys = 23.15 CPU) All 8 test executed successfully real 18m38.329s user 2m37.370s sys 6m3.040s ########################### ## With sysemu patch: ########################### Linux li7-3 2.4.26-linode29-1um #1 Thu May 27 18:21:21 EDT 2004 i686 i686 i386 GNU/Linux Benchmark DBD suite: 2.14 Date of test: 2004-05-28 0:04:24 Running tests on: Linux 2.4.26-linode29-1um i686 Arguments: Comments: Limits from: Server version: MySQL 3.23.58 alter-table: Total time: 210 wallclock secs ( 0.39 usr 0.36 sys + 0.00 cusr 0.00 csys = 0.75 CPU) ATIS: Total time: 93 wallclock secs (18.15 usr 38.73 sys + 0.00 cusr 0.00 csys = 56.88 CPU) big-tables: Total time: 115 wallclock secs (16.92 usr 85.25 sys + 0.00 cusr 0.00 csys = 102.17 CPU) connect: Total time: 46 wallclock secs ( 4.99 usr 3.10 sys + 0.00 cusr 0.00 csys = 8.09 CPU) create: Total time: 13 wallclock secs ( 0.78 usr 0.75 sys + 0.00 cusr 0.00 csys = 1.53 CPU) insert: Total time: 268 wallclock secs (78.21 usr 86.18 sys + 0.00 cusr 0.00 csys = 164.39 CPU) select: Total time: 49 wallclock secs ( 9.63 usr 6.84 sys + 0.00 cusr 0.00 csys = 16.47 CPU) wisconsin: Total time: 39 wallclock secs ( 5.83 usr 12.35 sys + 0.00 cusr 0.00 csys = 18.18 CPU) All 8 test executed successfully real 13m57.353s user 2m17.370s sys 3m54.310s ########################### ## Results ########################### 1118 seconds without sysemu 837 seconds with sysemu A UML with the sysemu patches (and the host) is 33.5% faster than a UML without with this mysql test... Not bad! -Chris