Is it possible to use a hierarchical database such BDB for Rsyslog messages?

I am currently using PostgreSQL in order to store Rsyslog messages. The problem is that querying the messages from the Syslog database in the PostgreSQL backend gets too slow as the number of messages increases.

I know that a hierarchical database performs much faster than a relational database. So my question is if it is possible to use one such database backend (BDB or hdb for example) for Rsyslog messages? I did not find anything on the Internet. What about LDAP (relying on BDB)?

If not, do you have any other suggestion to improve the performance of my system?

Details: OS: Ubuntu: Ubuntu Server 12.04 PostgreSQL: 9.1 Rsyslog: rsyslogd 5.8.6

View the original article here

Optimising MySQL Database Indexes InnoDB

I have been Googleling for hours now and I haven't quite figured out how indexes work, because there are so many mixed answers available.

Let's say I have an query 1:

SELECT subid, subid2 FROM clicks WHERE wid=100 AND uid=123 AND time >= 1387886885

And a query 2:

SELECT subid, subid2 FROM clicks WHERE fid=100 AND time >= 1387886885 AND uid=123

1) How should I place indexes here? Should I use multi column index or single column indexes?

2) I found an answer on stackoverflow that suggested adding indexes to subid and subid2 also, should I do that?

View the original article here