Mailing List Archive

[Spamassassin Wiki] Update of "BayesBenchmarkResults" by MichaelParker
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.

The following page has been changed by MichaelParker:
http://wiki.apache.org/spamassassin/BayesBenchmarkResults

------------------------------------------------------------------------------
- For the moment, this is just a dump of some BayesBenchmark results. Eventually, I'd like to fix up this page so others can easily add their benchmark results for different setups and backends.
+ For the moment, this is just a dump of some BayesBenchmark results. Eventually, I'd like to fix up this page so others can easily add their benchmark resu\
+ lts for different setups and backends.
+
+
+ All numbers are the average for three runs of the benchmark. All times are in seconds.
+
+ Here is a test run, with 2000 msgs per bucket (1000 in the forget buckets).
+
+ System is SUSE Linux 9.2, 2.8 P4 (!HyperThread) 512MB RAM w/ Perl v5.8.5
+ * Berkeley DB - 4.3.x
+ * MySQL - 5.0.10
+ * PostgreSQL - 8.0.3 (with pg_autovacuum running every 60 seconds)
+ Everything ran local to the box
+
+ * Run using Mail-SpamAssassin 3.1.0-RC1 release
+
+ || Phase || SDBM.pm || DBM (Berkeley DB/DB_File) || SQL.pm[[BR]]MySQL MyISAM || MySQL.pm[[BR]]MyISAM || MySQL.pm[[BR]]InnoDB || PgSQL.pm[[BR]]fsync=fa\
+ lse || PgSQL.pm[[BR]]fsync=true ||
+ || 1a ||<)> 86.12 ||<)> 124.94 ||<)> 375.97 ||<)> 163.92 ||<)> 184.65 ||<)> 164.23 ||<)> 222.54 ||
+ || 1b ||<)> 87.68 ||<)> 142.01 ||<)> 352.76 ||<)> 159.77 ||<)> 170.67 ||<)> 154.03 ||<)> 211.93 ||
+ || 2 ||<)> 530.39 ||<)> 1555.36 ||<)> 872.14 ||<)> 663.12 ||<)> 682.71 ||<)> 929.31 ||<)> 1149.92 ||
+ || 3 ||<)> 18.38 ||<)> 49.47 ||<)> 9.18 ||<)> 9.34 ||<)> 9.78 ||<)> 6.79 ||<)> 8.69 ||
+ || 4a ||<)> 36.82 ||<)> 61.56 ||<)> 218.99 ||<)> 146.36 ||<)> 377.80 ||<)> 202.19 ||<)> 253.36 ||
+ || 4b ||<)> 37.14 ||<)> 60.23 ||<)> 201.49 ||<)> 146.36 ||<)> 381.26 ||<)> 196.09 ||<)> 242.49 ||
+ || 5a ||<)> 273.90 ||<)> 902.26 ||<)> 547.98 ||<)> 364.13 ||<)> 380.06 ||<)> 507.15 ||<)> 710.41 ||
+ || 5b ||<)> 193.95 ||<)> 443.86 ||<)> 284.70 ||<)> 228.32 ||<)> 233.19 ||<)> 316.11 ||<)> 432.08 ||
+ || total ||<)>1264.39 ||<)> 3339.70 ||<)> 2862.54 ||<)> 1881.10 ||<)> 2420.13 ||<)> 2475.91 ||<)> 3231.41 ||
+

-
- All numbers are the average for three runs of the benchmark (except the PostgreSQL fsync=false run, it took too long in the first place). All times are in seconds.
-
- Here is a test run, with 2000 msgs per bucket (1000 in the forget buckets).
-
- System is SUSE Linux 9.2, 2.8 P4 (!HyperThread) 512MB RAM w/ Perl v5.8.5
- * Berkeley DB - 4.3.x
- * MySQL - 4.1.7
- * PostgreSQL - 8.0.1 (with pg_autovacuum running)
- Everything ran local to the box
-
- * SDBM numbers are from using the following configuration setting with SA 3.1.0 (as yet unreleased):
-
- {{{
- bayes_store_module Mail::SpamAssassin::BayesStore::SDBM
- }}}
-
-
-
- || Phase || SDBM || Berkeley DBM || MySQL[[BR]]MyISAM || MySQL[[BR]]InnoDB || PostgreSQL[[BR]]fsync=false || PostgreSQL[[BR]]fsync=true ||
- || 1a ||<)> 82.88 ||<)> 120.10 ||<)> 399.55 ||<)> 429.00 ||<)> 1229.08 ||<)> 4445 ||
- || 1b ||<)> 65.83 ||<)> 98.41 ||<)> 261.20 ||<)> 279.71 ||<)> 919.98 ||<)> 3051.50 ||
- || 2 ||<)> 497.33 ||<)> 1151.58 ||<)> 743.53 ||<)> 784.08 ||<)> 1357.86 ||<)> 5664 ||
- || 3 ||<)> 14.03 ||<)> 40.03 ||<)> 9.23 ||<)> 6.74 ||<)> 6.42 ||<)> 9.10 ||
- || 4a ||<)> 35.25 ||<)> 65.06 ||<)> 288.81 ||<)> 369.57 ||<)> 429.12 ||<)> 2082.32 ||
- || 4b ||<)> 28.27 ||<)> 46.61 ||<)> 241.51 ||<)> 301.66 ||<)> 343.07 ||<)> 1122.40 ||
- || 5a ||<)> 261.14 ||<)> 803.19 ||<)> 481.69 ||<)> 517.21 ||<)> 948.10 ||<)> 4304 ||
- || 5b ||<)> 174.01 ||<)> 358.67 ||<)> 222.93 ||<)> 232.79 ||<)> 420.74 ||<)> 1128.28 ||
- || total ||<)>1158.75 ||<)> 2683.66 ||<)> 2648.45 ||<)> 2920.76 ||<)> 5654.37 ||<)> 21806.60 ||
-
[Spamassassin Wiki] Update of "BayesBenchmarkResults" by MichaelParker [ In reply to ]
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.

The following page has been changed by MichaelParker:
http://wiki.apache.org/spamassassin/BayesBenchmarkResults

------------------------------------------------------------------------------

* Run using Mail-SpamAssassin 3.1.0-RC1 release

- || Phase || SDBM.pm || DBM (Berkeley DB/DB_File) || SQL.pm[[BR]]MySQL MyISAM || MySQL.pm[[BR]]MyISAM || MySQL.pm[[BR]]InnoDB || PgSQL.pm[[BR]]fsync=fa\
+ || Phase || SDBM.pm || DBM (Berkeley DB/DB_File) || SQL.pm[[BR]]MySQL MyISAM || MySQL.pm[[BR]]MyISAM || MySQL.pm[[BR]]InnoDB || PgSQL.pm[[BR]]fsync=false || PgSQL.pm[[BR]]fsync=true ||
- lse || PgSQL.pm[[BR]]fsync=true ||
|| 1a ||<)> 86.12 ||<)> 124.94 ||<)> 375.97 ||<)> 163.92 ||<)> 184.65 ||<)> 164.23 ||<)> 222.54 ||
|| 1b ||<)> 87.68 ||<)> 142.01 ||<)> 352.76 ||<)> 159.77 ||<)> 170.67 ||<)> 154.03 ||<)> 211.93 ||
|| 2 ||<)> 530.39 ||<)> 1555.36 ||<)> 872.14 ||<)> 663.12 ||<)> 682.71 ||<)> 929.31 ||<)> 1149.92 ||
[Spamassassin Wiki] Update of "BayesBenchmarkResults" by MichaelParker [ In reply to ]
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Spamassassin Wiki" for change notification.

The following page has been changed by MichaelParker:
http://wiki.apache.org/spamassassin/BayesBenchmarkResults

------------------------------------------------------------------------------
Everything ran local to the box

* Run using Mail-SpamAssassin 3.1.0-RC1 release
-
+
+
+
- || Phase || SDBM.pm || DBM (Berkeley DB/DB_File) || SQL.pm[[BR]]MySQL MyISAM || MySQL.pm[[BR]]MyISAM || MySQL.pm[[BR]]InnoDB || PgSQL.pm[[BR]]fsync=false || PgSQL.pm[[BR]]fsync=true ||
+ || Phase || SDBM.pm || DBM[[BR]](Berkeley DB/DB_File) || SQL.pm[[BR]]MySQL MyISAM || MySQL.pm[[BR]]MyISAM || MySQL.pm[[BR]]InnoDB || PgSQL.pm[[BR]]fsync=false || PgSQL.pm[[BR]]fsync=true ||
- || 1a ||<)> 86.12 ||<)> 124.94 ||<)> 375.97 ||<)> 163.92 ||<)> 184.65 ||<)> 164.23 ||<)> 222.54 ||
+ || 1a ||<)> 86.12 ||<)> 124.94 ||<)> 375.97 ||<)> 163.92 ||<)> 184.65 ||<)> 164.23 ||<)> 222.54 ||
- || 1b ||<)> 87.68 ||<)> 142.01 ||<)> 352.76 ||<)> 159.77 ||<)> 170.67 ||<)> 154.03 ||<)> 211.93 ||
+ || 1b ||<)> 87.68 ||<)> 142.01 ||<)> 352.76 ||<)> 159.77 ||<)> 170.67 ||<)> 154.03 ||<)> 211.93 ||
- || 2 ||<)> 530.39 ||<)> 1555.36 ||<)> 872.14 ||<)> 663.12 ||<)> 682.71 ||<)> 929.31 ||<)> 1149.92 ||
+ || 2 ||<)> 530.39 ||<)> 1555.36 ||<)> 872.14 ||<)> 663.12 ||<)> 682.71 ||<)> 929.31 ||<)> 1149.92 ||
- || 3 ||<)> 18.38 ||<)> 49.47 ||<)> 9.18 ||<)> 9.34 ||<)> 9.78 ||<)> 6.79 ||<)> 8.69 ||
+ || 3 ||<)> 18.38 ||<)> 49.47 ||<)> 9.18 ||<)> 9.34 ||<)> 9.78 ||<)> 6.79 ||<)> 8.69 ||
- || 4a ||<)> 36.82 ||<)> 61.56 ||<)> 218.99 ||<)> 146.36 ||<)> 377.80 ||<)> 202.19 ||<)> 253.36 ||
+ || 4a ||<)> 36.82 ||<)> 61.56 ||<)> 218.99 ||<)> 146.36 ||<)> 377.80 ||<)> 202.19 ||<)> 253.36 ||
- || 4b ||<)> 37.14 ||<)> 60.23 ||<)> 201.49 ||<)> 146.36 ||<)> 381.26 ||<)> 196.09 ||<)> 242.49 ||
+ || 4b ||<)> 37.14 ||<)> 60.23 ||<)> 201.49 ||<)> 146.36 ||<)> 381.26 ||<)> 196.09 ||<)> 242.49 ||
- || 5a ||<)> 273.90 ||<)> 902.26 ||<)> 547.98 ||<)> 364.13 ||<)> 380.06 ||<)> 507.15 ||<)> 710.41 ||
+ || 5a ||<)> 273.90 ||<)> 902.26 ||<)> 547.98 ||<)> 364.13 ||<)> 380.06 ||<)> 507.15 ||<)> 710.41 ||
- || 5b ||<)> 193.95 ||<)> 443.86 ||<)> 284.70 ||<)> 228.32 ||<)> 233.19 ||<)> 316.11 ||<)> 432.08 ||
+ || 5b ||<)> 193.95 ||<)> 443.86 ||<)> 284.70 ||<)> 228.32 ||<)> 233.19 ||<)> 316.11 ||<)> 432.08 ||
- || total ||<)>1264.39 ||<)> 3339.70 ||<)> 2862.54 ||<)> 1881.10 ||<)> 2420.13 ||<)> 2475.91 ||<)> 3231.41 ||
+ || total ||<)>1264.39 ||<)> 3339.70 ||<)> 2862.54 ||<)> 1881.10 ||<)> 2420.13 ||<)> 2475.91 ||<)> 3231.41 ||