Snort mailing list archives
Re: Speeding up mysql
From: quentyn () fotango com
Date: Fri, 19 Oct 2001 18:23:54 +0100
Kevin Brown wrote: What schema are you using? What version of Mysql? I'm using schema 104, Mysql 3.23.43 and according to the mysql manual (looking at mysql.com) it says that indexes are automatically made on Primary keynames. So doing a "show index from <tbl_name>" shows that each of the tables that contain a CID column are indexed already. Same thing with signature in the event table and sig_id in the signature table.-----Original Message----- From: quentyn () fotango com [mailto:quentyn () fotango com] Sent: Friday, October 19, 2001 09:42 To: snort-users () lists sourceforge net Subject: [Snort-users] Speeding up mysql
it is the way mysql indexing works these are answers from 2 different people the primary key covers 2 fields, however the join refers to the 2ndary field and in the current indexing structure of MYSQL it would appear that this prevents the index being used, hence the queries performing a table scan (which takes ages). By adding a non unique index on the 2nd field you see a performance increase in multi column indexes mysql doesn't no use the index if you haven't referenced the 1st column of the index. or something or other..... Q -- ##################### Quentyn Taylor Sysadmin - Fotango ##################### "The way NT mounts filesystems is something I'd expect to find in a barnyard or on a stock-breeding farm." Mike Andrews, ASR _______________________________________________ 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://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- Speeding up mysql quentyn (Oct 19)
- <Possible follow-ups>
- RE: Speeding up mysql Kevin Brown (Oct 19)
- Re: Speeding up mysql quentyn (Oct 19)
- RE: Speeding up mysql Hutchinson, Andrew (Oct 19)