RE: Snort, ACID, MySQL performance optimizations

[roman () danyliw com]

"desc <tablename>" does not display indexes in the MySQL client.
Rather you want to use "SHOW INDEX FROM <tablename>".

e.g. SHOW INDEX FROM tcphdr;

cheers,
Roman

> I did this.  But a "describe tcphdr" command before and after shows
> no difference.  Is this to be expected?  Is there any way of seeing
> which fields are indexed?
>
> Thanks.
>
> Benny
>
> -----Original Message-----
> From: roman () danyliw com [mailto:roman () danyliw com]
> Sent: Thursday, July 26, 2001 5:21 AM
> To: Chris Schuler
> Cc: snort-users () lists sourceforge net
> Subject: Re: [Snort-users] Snort, ACID, MySQL performance optimizations
>
>
> http://www.mysql.com/doc/C/R/CREATE_INDEX.html
>
>
> CREATE INDEX tcp_sport_index ON tcphdr (tcp_sport);
> CREATE INDEX tcp_dport_index ON tcphdr (tcp_dport);
> CREATE INDEX acid_ag_alert_sid_cid_index ON acid_ag_alert (ag_sid, ag_cid);
>
> cheers,
> Roman
>
> > I was reading the ACID FAQ, and came across some MySQL performance
> > optimizations....
> >
> > Creating indexes
> > Some of the required indexes are not created in initial MySQL creation
> > script. The following indexes can be added to significantly improve
> > performance: 
> > tcphdr.tcp_sport 
> > tcphdr.tcp_dport 
> > acid_ag_alert.ag_sid + acid_ag_alert.ag_cid 
> >
> > I'm pretty new to MySQL, and I need some help.  Could someone point help
> me
> > out in creating these indexes?
> >
> > thanks,
> > Chris
> >
> > _______________________________________________
> > Snort-users mailing list
> > Snort-users () lists sourceforge net
> > Go to this URL to change user options or unsubscribe:
> > http://lists.sourceforge.net/lists/listinfo/snort-users
> > Snort-users list archive:
> > http://www.geocrawler.com/redir-sf.php3?list=snort-users
>
>
>
> ---------------------------------------------
> This message was sent using Voicenet WebMail.
>       http://www.voicenet.com/webmail/
>
>
>
> _______________________________________________
> Snort-users mailing list
> Snort-users () lists sourceforge net
> Go to this URL to change user options or unsubscribe:
> http://lists.sourceforge.net/lists/listinfo/snort-users
> Snort-users list archive:
> http://www.geocrawler.com/redir-sf.php3?list=snort-users



---------------------------------------------
This message was sent using Voicenet WebMail.
      http://www.voicenet.com/webmail/



_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
http://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users