setup mysql for event subsystem

CRB

Hi,
i never cared about what event subsystem is doing, as long as it is running for ts search, but yesterday i went through the trouble of Configuring The Interwoven Event Subsystem To Use MySQL As The Backend Repository. now i check the databased tables and idont see any significant info, except the table messages has some data, but it is not readable, even though i set up the character set to utf8 by default.

but my question here is: what are the benefits of having event subsystem store date in a database? and if that data is useful to troubleshoout, how do you get out in readable format?

Migrateduser

The advantage of having event subsystem persisting its data to an rdbms instead of the default flat file implementation is purely for performance and reliability reasons. The default database should only be used for demo purposes and should not be used for production purposes.

With regards to viewing the data, it is not possible to see the actual contents of the message but there is other useful info, such as how many messages are being sent, how many have been received by the consumers etc.