Re: Barnyard2 problems with reputation preproc rules

[Dave Corsello <snort-users () wintertreemedia com>]

elz,

I ran your script against the database.  Here are the results:

Query OK, 933 rows affected (6.88 sec)

mysql> call fixsigs(101,@a);
Query OK, 933 rows affected (2.41 sec)

mysql> call fixsigs(102,@a);
Query OK, 933 rows affected (17.02 sec)

mysql> call fixsigs(103,@a);
Query OK, 933 rows affected (6.91 sec)

mysql> call fixsigs(104,@a);
Query OK, 933 rows affected (6.09 sec)

mysql> call fixsigs(105,@a);
Query OK, 933 rows affected (8.91 sec)

mysql> call fixsigs(106,@a);
Query OK, 933 rows affected (12.23 sec)

mysql> call fixsigs(110,@a);
Query OK, 933 rows affected (12.71 sec)

mysql> call fixsigs(111,@a);
Query OK, 933 rows affected (58.40 sec)

mysql> call fixsigs(112,@a);
Query OK, 933 rows affected (13.30 sec)

mysql> call fixsigs(113,@a);
Query OK, 933 rows affected (27.55 sec)

mysql> call fixsigs(114,@a);
Query OK, 933 rows affected (8.60 sec)

mysql> call fixsigs(115,@a);
Query OK, 933 rows affected (14.34 sec)

mysql> call fixsigs(116,@a);
Query OK, 1 row affected (9 min 47.49 sec)

mysql> call fixsigs(117,@a);
Query OK, 1 row affected (1.27 sec)

mysql> call fixsigs(118,@a);
Query OK, 1 row affected (1.23 sec)

mysql> call fixsigs(119,@a);
Query OK, 1 row affected (1 min 15.60 sec)

mysql> call fixsigs(120,@a);
Query OK, 933 rows affected (16.84 sec)

mysql> call fixsigs(121,@a);
Query OK, 933 rows affected (9.60 sec)

mysql> call fixsigs(122,@a);
Query OK, 933 rows affected (47.91 sec)

mysql> call fixsigs(123,@a);
Query OK, 933 rows affected (22.52 sec)

mysql> call fixsigs(124,@a);
Query OK, 933 rows affected (21.65 sec)

mysql> call fixsigs(125,@a);
Query OK, 933 rows affected (13.86 sec)

mysql> call fixsigs(126,@a);
Query OK, 933 rows affected (5.78 sec)

mysql> call fixsigs(128,@a);
Query OK, 933 rows affected (8.74 sec)

mysql> call fixsigs(129,@a);
Query OK, 0 rows affected (25.71 sec)

mysql> call fixsigs(130,@a);
Query OK, 933 rows affected (2.88 sec)

mysql> call fixsigs(131,@a);
Query OK, 933 rows affected (5.65 sec)

mysql> call fixsigs(133,@a);
Query OK, 933 rows affected (1 min 0.10 sec)

mysql> call fixsigs(134,@a);
Query OK, 0 rows affected (2.00 sec)

mysql> call fixsigs(135,@a);
Query OK, 933 rows affected (2.82 sec)

mysql> call fixsigs(136,@a);
Query OK, 933 rows affected (2.79 sec)

mysql> call fixsigs(137,@a);
Query OK, 933 rows affected (2.65 sec)

mysql> call fixsigs(138,@a);
Query OK, 933 rows affected (3.20 sec)

mysql> call fixsigs(139,@a);
Query OK, 933 rows affected (0.72 sec)

mysql> call fixsigs(140,@a);
Query OK, 933 rows affected (17.86 sec)

mysql> call fixsigs(141,@a);
Query OK, 933 rows affected (3.29 sec)

mysql> call fixsigs(142,@a);
Query OK, 933 rows affected (4.08 sec)

mysql> call fixsigs(143,@a);
Query OK, 933 rows affected (2.48 sec)

mysql> call fixsigs(144,@a);
Query OK, 933 rows affected (1.11 sec)

mysql> call fixsigs(145,@a);
Query OK, 933 rows affected (2.05 sec)

mysql> call fixsigs(2,@a);
Query OK, 933 rows affected (0.35 sec)

mysql> call fixsigs(3,@a);
Query OK, 0 rows affected (0.00 sec)

------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://sourceforge.net/mailarchive/forum.php?forum_name=snort-users

Please visit http://blog.snort.org to stay current on all the latest Snort news!