Thanks Tom and Michael,
I got rid of all of the indexes except the one marked PRIMARY and a
new one that I made like this:
ALTER TABLE logs ADD unique (host,date,time,priority,facility,seq);
I see quite an improvement from what I was seeing before. The one
thing that I didn't realize is that
Please be gentle, I have nearly no experience with SQL databases. I am
not subscribed to the list so please cc me on replies.
Because my email client probably did horrable things to this post you
can find the text here also:
http://nolab.org/scratch/mysql-index-oddness.html
I use syslog-ng