I am biased, but you should look into a logging system like splunk. You shouldn't be using an RDBMS for your logs. Your logs don't have a schema. With splunk,

I am biased, but you should look into a logging system like splunk. You shouldn't be using an RDBMS for your logs. Your logs don't have a schema. With splunk, you just output your logs in this format: <timestamp> key1=value key2=value key3=value install splunk agent on your machines, and splunk takes care of everything from there. You can search, filter, graph, create alerts etc... Splunk indexer allows you to age your logs, and keeps the newer ones in hot buckets for fast access.