http://issues.apache.org/SpamAssassin/show_bug.cgi?id=5659
Summary: Unneeded index on bayes_mysql.sql example
Product: Spamassassin
Version: 3.2.3
Platform: Other
OS/Version: other
Status: NEW
Severity: normal
Priority: P3
Component: Documentation
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Isn't bayes_token_idx1 unneeded, since (id, token) is already indexed? All the
clauses that I found define ID=? AND TOKEN=? ...
CREATE TABLE bayes_token (
id int(11) NOT NULL default '0',
token char(5) NOT NULL default '',
spam_count int(11) NOT NULL default '0',
ham_count int(11) NOT NULL default '0',
atime int(11) NOT NULL default '0',
PRIMARY KEY (id, token),
INDEX bayes_token_idx1 (token),
INDEX bayes_token_idx2 (id, atime)
) TYPE=MyISAM;
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.
